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.?

?• 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.

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