Job
Description
Req ID: 327205 We are currently seeking a Lead Engineer to join our team in Noida, Uttar Pradesh (IN-UP), India (IN). Grade 8 At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company"™s growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring, the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here. Preferred Experience ""¢ Ideal candidate has been supporting traditional server based relational databases (Postgresql and MongoDB) for over 7+ years out of which last 4+ years in public cloud environments (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 " "¢ 7+ years of overall operational experience "¢ 4+ years of GCP experience as a cloud DBA (Postgresql/Mongo DB) "¢ 3+ 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 B.Tech/BE/MCA in Information Technology degree or equivalent experience