Azure PostgreSQL DBA: Cloud, Automation & HA

CapTech Consulting; Atlanta (GA); On-site; USD 125,000 - 190,000; Full time

Benefits offered by this job

Learning & Development

Modern Health

Carrot Fertility

Fringe Benefits

Employee Resource Groups

Philanthropy Partnerships

401(k) Matching

Job summary

CapTech Consulting seeks an experienced Azure PostgreSQL DBA to join our consulting practice. You will own production stability, performance tuning, and cloud-native data solutions for client environments.

Collaborating with engineers and client stakeholders, you will implement automation, security controls, and DR architectures using Terraform, Azure, and GitHub Actions, delivering scalable data platforms and reliable services.

Qualifications

• Five or more years administering PostgreSQL in production, including tuning, upgrades, backup and recovery, replication, and incident response.

Responsibilities

• Administer PostgreSQL environments across development, test, and production, including Azure Database for PostgreSQL Flexible Server and self-managed instances on Azure virtual machines or AKS.
• Own performance tuning end to end: analyze execution plans, design indexing and partitioning strategies, tune autovacuum and server parameters, and resolve bloat, lock contention, and connection saturation.
• Design and test high availability and disaster recovery configurations, including read replicas, zone-redundant deployments, point-in-time restore, and documented failover runbooks with defined RPO and RTO targets.
• Automate provisioning and configuration of database infrastructure using Terraform or Bicep, and deliver schema changes through Azure Pipelines or GitHub Actions with tools such as Flyway or Liquibase.
• Implement database security and compliance controls, including Microsoft Entra ID authentication, role and privilege design, row-level security, encryption at rest and in transit, private endpoints, and Key Vault secret rotation.
• Build observability into the data tier with Azure Monitor, Log Analytics, and Query Store, and define the alerting thresholds that catch problems before clients notice them.
• Manage capacity and cost, right-sizing compute and storage tiers and advising clients on reserved capacity and scaling strategy.
• Partner with application engineers on data modeling, query design, and connection pooling through PgBouncer or the built-in pooler.
• Produce runbooks, standards, and knowledge transfer materials that leave client teams able to operate the platform after the engagement ends.
• Participate in an on-call rotation for production support where the engagement requires it.

Skills

PostgreSQL Administration

SQL

Azure Cloud

Communication

Agile/Waterfall

Tools

Terraform

Bicep

ARM Templates

Azure Pipelines

GitHub Actions

Flyway

Liquibase

PgBouncer

Job description

CapTech Consulting seeks an experienced Azure PostgreSQL DBA to join our consulting practice. You will own production stability, performance tuning, and cloud-native data solutions for client environments.

Collaborating with engineers and client stakeholders, you will implement automation, security controls, and DR architectures using Terraform, Azure, and GitHub Actions, delivering scalable data platforms and reliable services.