PostgreSQL Database Administrator – L3

Job Summary:

We are looking for an experienced PostgreSQL Database Administrator (L3) to manage large-scale database environments, ensure high availability, and drive performance optimization. The role involves handling critical production systems, implementing disaster recovery strategies, and providing 24×7 support while mentoring junior DBAs and contributing to continuous improvement initiatives.

Key Responsibilities:

• Manage and administer large PostgreSQL database environments across on-premises and AWS (Aurora PostgreSQL).
• Design and implement high availability solutions including clustering, replication, and standby databases.
• Perform database installation, upgrades, migrations, refresh, and cloning activities.
• Handle database backup and recovery strategies using various tools and methodologies.
• Monitor database performance and perform tuning to ensure optimal performance.
• Diagnose and resolve database-related issues in production environments.
• Manage database security including user roles, authentication, and authorization.
• Execute patch management and maintain database compliance standards.
• Support disaster recovery (DR) setup, execution, and DR drills.
• Maintain database audit processes and support audit requirements.
• Perform capacity planning, reporting, and database housekeeping tasks.
• Configure and manage monitoring tools and ticketing systems (ServiceNow, Remedy, etc.).
• Automate routine DBA activities using shell scripting.
• Manage OEM/vendor interactions for critical database issues.
• Ensure certificate management and renewal processes.
• Create and maintain SOPs for all database activities.
• Provide 24×7 production support and on-call support with SLA adherence.
• Identify risks proactively and implement mitigation strategies.
• Mentor L1/L2 DBAs and provide technical guidance.
• Contribute to technical discussions, presentations, and adoption of new technologies.

Qualifications and Skills:

Educational Qualifications:

• B.E. / B.Sc. / Diploma in relevant field

Technical Skills (Must Have):

• Strong experience in PostgreSQL (9.x and above) administration and troubleshooting
• Hands-on experience with PostgreSQL and Aurora PostgreSQL in AWS
• Expertise in database upgrades, patching, and migrations
• Strong knowledge of high availability, replication, and DR strategies
• Experience in backup and recovery techniques
• Proficiency in performance tuning and monitoring tools
• Experience in provisioning and decommissioning database instances
• Hands-on experience with shell scripting for automation
• Experience working in global customer environments

Secondary Skills (Nice to Have):

• Experience with MySQL
• Knowledge of Unix/Linux/Solaris/AIX/HP-UX and Windows environments
• Familiarity with ITIL processes and ticketing tools (ServiceNow, Remedy, etc.)
• ITIL Foundation certification

Behavioral Skills:

• Strong communication and stakeholder management skills
• Ability to work in a 24×7 support model
• Team mentoring and leadership capabilities
• Proactive mindset with problem-solving attitude
• Willingness to learn and share knowledge