Azure PostgreSQL DBA: Performance, HA & Automation

CapTech Consulting; Charlotte (NC); Hybrid; USD 110,000 - 160,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 is a technology consulting firm partnering with leading companies to deliver digital transformation, software development, and technology consulting services. AzurePostgreSQL Database Administrators at CapTech own the health, performance, and security of data platforms for client engagements.

You will work with engineers, architects, analysts, and client stakeholders in a cloud-first environment to stabilize current systems and design the next generation.

Qualifications

• Five or more years administering PostgreSQL in production, including tuning, upgrades, backup and recovery, replication, and incident response.
• Two or more years working in Microsoft Azure, with hands-on experience running Azure Database for PostgreSQL Flexible Server.
• Strong SQL and PL/pgSQL skills, with fluency in EXPLAIN ANALYZE, pg_stat_statements, and the PostgreSQL diagnostic toolkit.
• Working knowledge of Infrastructure as Code with Terraform, Bicep, or ARM templates, and CI/CD pipelines on Git-based version control.
• Scripting proficiency in Python, Bash, or PowerShell for operational automation.
• Understanding of Azure networking and identity fundamentals, including virtual networks, private endpoints, Key Vault, and Microsoft Entra ID.
• Experience supporting applications through a full SDLC using Agile or Waterfall methodologies.
• Excellent written and verbal communication skills, with the confidence to explain risk and tradeoffs directly to client stakeholders.
• Consulting experience and familiarity with regulated environments such as financial services, healthcare, or the public sector are preferred.
• Azure certifications such as AZ-104 or AZ-305 are a plus.

Responsibilities

• Administer PostgreSQL environments across development, test, and production, including Azure Database for PostgreSQL Flexible Server and self-managed instances on Azure VMs 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 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

SQL

PL/pgSQL

Azure

Terraform

Bicep

Python

CI/CD pipelines

PostgreSQL performance tuning

Monitoring & observability

Communication skills

Tools

Azure Database for PostgreSQL

GitHub Actions

Flyway/Liquibase

PgBouncer

Job description

CapTech is a technology consulting firm partnering with leading companies to deliver digital transformation, software development, and technology consulting services. AzurePostgreSQL Database Administrators at CapTech own the health, performance, and security of data platforms for client engagements.

You will work with engineers, architects, analysts, and client stakeholders in a cloud-first environment to stabilize current systems and design the next generation.