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.