Cloud DBA Lead at NTT DATA

Guanajuato City, Guanajuato, Mexico -

Full Time

Start Date

Immediate

Expiry Date

02 Mar, 26

Salary

0.0

Posted On

02 Dec, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Postgresql, MongoDB, RedisDB, GCP, AWS RDS, Azure SQL, SQL Queries, Database Security, Performance Tuning, Backup and Recovery, Disaster Recovery, Monitoring Tools, Shell Scripting, Technical Mentorship, Customer Service, Problem Management

Industry

IT Services and IT Consulting

Description

"* 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 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." " 6+ years of GCP experience as a cloud DBA (Postgresql/Mongo DB/Reddisdb) 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, 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) 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 python / powershell scripting - preferred Installation, configuration and upgrading of postgresql server software and related products " Google Cloud Associate Engineer - REQUIRED B.Tech/BE/MCA in Information Technology degree or equivalent experience

Responsibilities

The Cloud DBA Lead will manage and optimize PostgreSQL and MongoDB databases in public cloud environments, ensuring high availability and performance. The role includes providing 24/7 support, mentoring team members, and collaborating with stakeholders.