If Interested ,Please reply to neha21.singh@nttdata.com with updated resume ASAP

Shift - 24*7 shift hours support- Hybrid- Mostly Remote

3 Shifts Morning /Evening /Night

Hybrid

Postgresql DBA (Must) with other Database MongoDB/Oracle.DB2/ms sql/mysql

6+ in Database & 3-4+ years in public cloud environments (Azure/AWS/GCP) , upgrades and patches. performance tuning, and troubleshooting. backups, maintenance, and scaling. managing monitoring tools , performance metrics. L3 level. Database software Installation. python / PowerShell scripting.

DR activities

Customer facing role

Lead position

MongoDB plus

Service Now /Helix Tool (Ticketing tool)

Preferred Experience:

• Ideal candidate has been supporting traditional server based relational databases (DB2,Postgresql and MongoDB) for over 6+ years out of which last 3+ years in public cloud environments (Azure/AWS/GCP)
• DB2-installation and maintenance of the databases. AWS/GCP
• DB2 upgrades and patches checkouts, performance and capacity monitoring & management, and security compliance. AWS/GCP
• Monitoring health check jobs like Image copy, Runstats, DDL$DML reports.
• Rebalancing of Partitions. AWS/GCP
• Space Management and Monitoring.
• Performed End-to-End Release activities.
• Creating and scheduling utilities like COPY, Reorg, RUNSTATS and QUIESCE.
• Running Adhoc Reorgs, Runstats and Rebinds in Productions Environment.
• Implementing and scheduling production DB2 jobs. - AWS/GCP
• Monitoring on daily, weekly and monthly batch cycles.
• Hands-on experience with PostgreSQL, 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 AWS/AZURE/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:

• 6+ years of overall operational experience
• 3+ years of Azure/AWS/GCP experience as a cloud DBA (DB2/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 (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) preferred
• Azure Database Certification (DP-300) preferred
• AWS Certified Database Specialty preferred
• DB2,Postgresql certification a plus
• Google Cloud Engineer - preferred

Four Year BS/BA in Information Technology degree or equivalent experience