PostgreSQL Database Administrator – L3

Experience

2-10 Years

Location

Mumbai, Pune, Delhi, Chennai, Bengaluru, Hyderabad

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