Preferred experience
* ideal candidate has been supporting traditional server based relational databases (postgresql, redisdb and mongodb) for over 10+ years out of which last 6+ 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 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 without 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 and technical resources.
basic qualifications
* 10+ years of overall operational experience.
* 6+ years of gcp experience as a cloud dba (postgresql, mongodb, redisdb).
* 6+ 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, node failures, disk usage, etc.
* backup and restores (backs 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 per application requirement.
* writing best‑practice documents for sharding, 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, number of connections, page fault, etc.
* export and import of data to and from mongodb, runtime configuration of mongodb.
* data management 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 per 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, mongodb atlas.
* experience with python/powershell scripting – preferred.
* secondary skill in mysql/oracle – preferred.
* installation, configuration and upgrading of postgresql server software and related products.
* secondary skill – db2 is a plus.
preferred certifications
* azure fundamentals (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.
ntt data is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our eeo policy statement, please click here. If you’d like more information on your eeo rights under the law, please click here. For pay transparency information, please click here.
#j-18808-ljbffr