If Interested ,please reply with updated Resume asap to neha21.singh@nttdata.com
Looking early joiners only .
If not interested please provide the references of interested candidature who worked on same skillsets
Rotational shift (sometimes night for 2 weeks in a month)
Primary Skill- PostgreSQL with any cloud (Azure /GCP /AWS )
Skill required-
Primary- PostgreSQL + Any cloud- Azure/ AWS /GCP
24*7 shift hours support-Hybrid
Shifts Morning /Evening /Night -IST
Preferred Experience:
- Ideal candidate has been supporting traditional server based relational database (Postgresql) for over 3+ years out of which last 2 years in any cloud AWS/azure/GCP.
• Hands-on experience with PostgreSQL/MongoDB, including installation, configuration, performance tuning, and troubleshooting. • Demonstrated expertise in managing PostgreSQL databases on AZURE, GCP and AWS RDS. • Experience with features such as automated backups, maintenance, and scaling - Postgresql • Ability to analyze and optimize complex SQL queries for performance improvement. • Proficiency in setting up and managing monitoring tools for PostgreSQL on GCP. • Experience with configuring alerts based on performance metrics. • Experience in implementing and testing backup and recovery strategies for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL. • Knowledge and experience in designing and implementing disaster recovery plans for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL. • Good Understanding of database security principles and best practices. • Proven ability to identify and resolve performance bottlenecks in PostgreSQL databases. • Experience in optimizing database configurations for better performance. • Able to provide 24*7 shift hours support at L2/L3 level • Experience in updating KB articles, Problem Management articles, and SOPs/runbooks • Passion for delivering timely and outstanding customer service • Great written and oral communication skills with internal and external customers • Strong ITIL foundation experience • Ability to work independently or no direct supervision. • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. • Work directly with end customer, business stakeholders as well as technical resources. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. • Work directly with end customer, business stakeholders as well as technical resources." Basic Qualifications " • 2+ years of overall operational experience • 1+ years of GCP experience as a cloud DBA (Postgresql/Mongo DB) • 2+ years of experience working in diverse cloud support database environments in a 24*7 production support model • Query fine tuning - MongoDB • Shell scripts for Monitoring like slow queries, replication lag, nodes fails, disk usage. etc • Backup and restores (Backups should be automated with shell scripts/Ops Manager) • Database Health check (Complete review of Database slow queries, fragmentation, index usage. etc) • Upgrades (Java version, Mongo version. etc) • Maintenance (Data Centre outages etc) • Architecture design as per the Application requirement • Writing best practices documents for shading, replication for Dev/App teams • Log rotation/ maintenance (mongos, mongodb, config etc) • Segregation of duties (User Management designing User roles and responsibilities) • Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable • Database Profiling, Locks, Memory Usage, No of connections, page fault etc., • Export and Import of Data to and From MongoDB, Run time configuration of MongoDB, • Data Managements in MongoDB Capped Collections Expired data from TTL, • Monitoring of Various issues related with Database, • Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB, • Database software Installation and Configuration in accordance with Client defined standards. • Database Migrations and Updates • Capacity management- MongoDB • Hands on experience in Server Performance tuning and Recommendations • High availability solutions and recommendations • Hands on experience in Root cause analysis for business impacting issues. • Experience with SQL,SQL Developer,TOAD,Pgadmin,mongo db atlas • Experience with python / powershell scripting - preferred • Secondary skill in MySQL/oracle - preferred • Installation, configuration and upgrading of postgresql server software and related products
"
Preferred Certifications Azure fundamentals certification (AZ-900) - REQUIRED Google Cloud Associate Engineer - REQUIRED Azure Database Certification (DP-300) - preferred AWS Certified Database Specialty - preferred Postgresql certification a plus MongoDB certification a plus