Description

You will manage database operations, serving as the technical focal point for new initiatives and the primary escalation point for critical application outages.

Responsibilities

• Perform strategic analysis of database infrastructure to recommend improvements and capacity planning.
• Manage system backups, restorations, and disaster recovery (DR) preparation and testing.
• Lead troubleshooting for P1/P2/P3 issues and guide the team through proper escalation matrices.
• Monitor database efficiency, production logs, and client connectivity via pg_hba.conf.
• Produce root cause analysis documents, change assessments, and updated SOPs.
• Provide 24x7 support, including weekend coverage, as required.

Required Skills

• 10+ years of experience as an Open Source DBA or in a similar role.
• Expertise in PostgreSQL (versions 10, 11, 13, 14).
• Expertise in MySQL (versions 5.5, 5.6, 5.7, and 8).
• Expertise in MongoDB (versions 3, 4, and 6).
• Experience managing heavy databases exceeding 100+ TB.
• Proficiency in physical database design, partitioning, and indexing (local and global).
• Hands-on experience with logical and physical backups, replication, and point-in-time recovery.
• Strong knowledge of Unix (RHEL) operating systems.
• Ability to perform database tuning, performance monitoring, and patch management.
• PostgreSQL, MySQL, or MongoDB professional certification.

Preferred Skills

• Experience implementing database security through user, role, and privilege management.

Key Skills

Education

Any Graduate