PostgreSQL Database Administrator

As an experienced PostgreSQL Database Administrator, you will be responsible for managing, maintaining, and optimizing enterprise-scale PostgreSQL databases. Your expertise in database performance, availability, security, and automation will be crucial in supporting mission-critical applications in a regulated environment.

Key Responsibilities:

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Ensure high availability, disaster recovery, backup, and restore strategies.
• Monitor and tune database performance, queries, and indexing.
• Manage database security, access controls, and compliance requirements.
• Troubleshoot database issues and perform root cause analysis.
• Support production, UAT, and non-production environments.
• Automate routine DBA tasks and improve operational efficiency.
• Collaborate with application, DevOps, and infrastructure teams.

Qualifications Required:

• 8-12 years of experience as a Database Administrator.
• Strong hands-on expertise in PostgreSQL (performance tuning, replication, backup & recovery).
• Experience with HA/DR solutions (Streaming Replication, Patroni, etc.).
• Proficiency in SQL, PL/pgSQL, and query optimization.
• Experience with Linux/Unix environments.
• Exposure to monitoring tools and automation/scripting.

Additional Details:

The role may also involve working with cloud databases such as AWS RDS or Azure PostgreSQL, knowledge of DevOps practices, CI/CD integration, and experience in BFSI or other regulated domains is considered a good-to-have. As an experienced PostgreSQL Database Administrator, you will be responsible for managing, maintaining, and optimizing enterprise-scale PostgreSQL databases. Your expertise in database performance, availability, security, and automation will be crucial in supporting mission-critical applications in a regulated environment.

Key Responsibilities:

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Ensure high availability, disaster recovery, backup, and restore strategies.
• Monitor and tune database performance, queries, and indexing.
• Manage database security, access controls, and compliance requirements.
• Troubleshoot database issues and perform root cause analysis.
• Support production, UAT, and non-production environments.
• Automate routine DBA tasks and improve operational efficiency.
• Collaborate with application, DevOps, and infrastructure teams.

Qualifications Required:

• 8-12 years of experience as a Database Administrator.
• Strong hands-on expertise in PostgreSQL (performance tuning, replication, backup & recovery).
• Experience with HA/DR solutions (Streaming Replication, Patroni, etc.).
• Proficiency in SQL, PL/pgSQL, and query optimization.
• Experience with Linux/Unix environments.
• Exposure to monitoring tools and automation/scripting.

Additional Details:

The role may also involve working with cloud databases such as AWS RDS or Azure PostgreSQL, knowledge of DevOps practices, CI/CD integration, and experience in BFSI or other regulated domains is considered a good-to-have.