Digital Technology : Lead Engineer

Req ID:
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward:thinking organization, apply now.
We are currently seeking a Digital Technology : Lead Engineer to join our team in Noida, Uttar Pradesh (IN:UP), India (IN).
Job Description
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 247 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 247 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 c
Job Type: Permanent