Azure PostgreSQL DBA: Cloud, Automation & HA

CapTech Consulting; Reston (VA); Hybrid; USD 140,000 - 200,000; Full time

Benefits offered by this job

Learning & Development

Modern Health

Carrot Fertility

Fringe

Employee Resource Groups

Philanthropic Partnerships

401(k) Matching

Job summary

CapTech Consulting seeks a seasoned Azure PostgreSQL DBA to own data platform health, performance, and security for client engagements. You will work hands-on in a cloud-first environment, stabilizing current systems and designing the next generation with automation and monitoring.

Responsibilities include administering PostgreSQL in multi-environments, tuning performance, implementing HA/DR, automating provisioning with Terraform/Bicep, and enforcing security controls across Azure services.

Qualifications

• Five or more years administering PostgreSQL in production with tuning, backups, replication and incident response.
• Two+ years in Microsoft Azure with Azure Database for PostgreSQL Flexible Server.
• Strong SQL/PLpgSQL skills including EXPLAIN ANALYZE and diagnostics toolkit.
• Experience with IaC (Terraform, Bicep, or ARM) and CI/CD pipelines on Git-based VCS.
• Scripting proficiency in Python, Bash, or PowerShell for automation.
• Understanding of Azure networking and identity fundamentals (VNETs, private endpoints, Key Vault, Entra ID).

Responsibilities

• Administer PostgreSQL across development, test, and production, including Azure PostgreSQL Flexible Server and self-managed instances.
• Own end-to-end performance tuning: indexing, partitioning, autovacuum, and server parameters.
• Design and test high availability and disaster recovery configurations with RPO/RTO targets.
• Automate provisioning/config of DB infra using Terraform or Bicep; apply schema changes via CI/CD tools.
• Implement database security controls (Entra ID, encryption, private endpoints, Key Vault).
• Build observability with Azure Monitor, Log Analytics, and Query Store; set alert thresholds.
• Manage capacity and cost; advise on reserved capacity and scaling.
• Collaborate with application engineers on data modeling, query design, and pooling (PgBouncer).
• Produce runbooks and knowledge transfer materials for client handover.
• Participate in on-call rotation for production support.

Skills

PostgreSQL administration

Azure Cloud

SQL/PLpgSQL

CI/CD

Python/bash/powerShell

Tools

Terraform

Bicep

ARM templates

Azure Pipelines

GitHub Actions

Flyway

Liquibase

Job description

CapTech Consulting seeks a seasoned Azure PostgreSQL DBA to own data platform health, performance, and security for client engagements. You will work hands-on in a cloud-first environment, stabilizing current systems and designing the next generation with automation and monitoring.

Responsibilities include administering PostgreSQL in multi-environments, tuning performance, implementing HA/DR, automating provisioning with Terraform/Bicep, and enforcing security controls across Azure services.