Senior PostgreSQL DBA

Role Overview
We are looking for an experienced Senior PostgreSQL DBA to manage and optimize large scale PostgreSQL environments hosted on Azure PaaS (Azure Database for PostgreSQL – Flexible Server). The ideal candidate will have strong expertise in PostgreSQL internals, performance tuning, HA/DR, and automation, with additional experience in Azure DevOps and GitHub workflows.
Key Responsibilities
• Administer, maintain, and optimize PostgreSQL databases across Dev/UAT/Prod environments.
• Perform routine maintenance: VACUUM, ANALYZE, REINDEX, bloat management, autovacuum tuning, and partition maintenance.
• Implement and support high availability solutions (Streaming Replication, Logical Replication, PgBouncer, etc.).
• Troubleshoot performance issues: slow queries, locks, deadlocks, replication lag, and resource bottlenecks.
• Design and implement backup/restore strategies including PITR, WAL archiving, and DR planning.
• Support database upgrades, migrations.
• Collaborate with developers to optimize SQL queries, indexing strategies, and schema design.
• Monitor database health using pg_stat_statements, pg_stat_activity, Prometheus/Grafana, and Azure monitoring tools.
• Automate operational tasks using Shell/Python scripting and CI/CD pipelines.
• Ensure database security, auditing, access control, and compliance.
• Document database standards and best practices.
?• 5+ years of hands on experience as a PostgreSQL DBA.
• Strong understanding of PostgreSQL internals, query planner, indexing, and performance tuning.
• Experience with logical & physical replication, failover, and HA architectures.
• Expertise in backup/restore, PITR, WAL management, and DR planning.
• Strong SQL skills and experience optimizing complex queries.
• Hands on experience with Azure Database for PostgreSQL – Flexible Server.
• Experience with monitoring tools (pgBadger, Prometheus, Grafana, Azure Monitor).
• Scripting experience (Bash, Python) for automation.?
?• Hands on experience with Azure Database for PostgreSQL – Flexible Server provisioning, scaling, storage tuning, and maintenance windows.
• Strong understanding of Azure PaaS architecture, including compute tiers, IOPS, storage auto grow, and zone redundant HA.
• Experience with Azure Monitor, Log Analytics, Query Performance Insight, and alerting for PostgreSQL performance troubleshooting.
• Expertise in tuning Azure PostgreSQL parameters: autovacuum settings, work_mem, shared_buffers, WAL settings, and connection pooling.
• Experience with Azure PostgreSQL backup/restore, PITR, retention policies, and cross region restore.
• Knowledge of Azure networking: Private Endpoints, VNet integration, firewall rules, and secure connectivity.
• Experience building CI/CD pipelines in Azure DevOps for schema deployments, migration scripts, and automated validation.
• Strong GitHub experience: GitHub Actions, branching strategies, code reviews, and DB version control.
• Experience with Infrastructure as Code (Terraform, ARM/Bicep) for PostgreSQL deployments.
• Understanding of connection pooling and scaling using PgBouncer or Azure connection pooling.
• Knowledge of Azure security: RBAC, managed identities, encryption, auditing, and compliance.
• Experience supporting production workloads on Azure PaaS PostgreSQL with performance tuning and incident resolution.