Description

You will manage and optimize PostgreSQL infrastructure across on-premises and AWS environments. This role is on-site.

Responsibilities

• Design, deploy, and maintain PostgreSQL clusters using Patroni for high availability and automatic failover.
• Configure and manage PgBouncer to handle connection pooling and load distribution.
• Implement replication, backup, and disaster recovery strategies to ensure data integrity.
• Monitor database health, capacity, and performance; execute regular tuning and optimization.
• Troubleshoot cluster issues, replication lags, and performance bottlenecks.

Required Skills

• 8+ years of hands-on experience as a PostgreSQL DBA.
• Deep expertise with Patroni for HA and automatic failover management.
• Strong proficiency in PgBouncer configuration and connection management.
• Experience deploying and managing PostgreSQL in AWS cloud environments.
• Proficiency in scripting with Python or Bash.
• Hands-on experience automating administrative tasks using Ansible.
• Ability to enforce database security, access control, and compliance standards.

Preferred Skills

• Experience with Python scripting for automation.
• Background in on-premises infrastructure management.

Key Skills

Education

Any Gradute