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 – Versatile Server.

• Experience with monitoring tools (pgBadger, Prometheus, Grafana, Azure Monitor).

• Scripting experience (Bash, Python) for automation.?

?• Han

📌 Senior PostgreSQL DBA (India)
🏢 Trigent Software
📍 India