Azure PostgreSQL DBA: Cloud DB Engineer & Automation

CapTech; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Flexible work environment

Health insurance

Tuition support

Job summary

CapTech is seeking an Azure PostgreSQL Database Administrator to own health, performance, and security of data platforms for client engagements. This hands-on, cloud-first consulting role will partner with engineers, architects, analysts, and stakeholders to stabilize current systems and design the next era of data platforms.

The ideal candidate combines engineering mindset with production incident ownership and a drive to automate and improve design, monitoring, and reliability across

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 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, contention, and connections.
• Design and test high availability and disaster recovery configurations, including read replicas, zone-redundant deployments, PITR, and runbooks with RPO/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: Entra ID authentication, role design, row-level security, encryption, private endpoints, and Key Vault rotation.
• Build observability with Azure Monitor, Log Analytics, and Query Store; define alerting thresholds to catch issues early.
• Manage capacity and cost, right-sizing compute/storage tiers and advising on reserved capacity and scaling.
• Partner with application engineers on data modeling, query design, and connection pooling via PgBouncer or built-in pooler.
• Produce runbooks, standards, and knowledge transfer materials to enable client teams to operate the platform after engagement ends.
• Participate in on-call rotation for production support when required.

Skills

PostgreSQL tuning

Azure PostgreSQL

Incident response

SQL/PLpgSQL

Automation scripting

Azure IAM networking

CI/CD

On-call support

Tools

Terraform

Bicep

ARM templates

Azure Pipelines

GitHub Actions

Flyway

Liquibase

PgBouncer

Job description

CapTech is seeking an Azure PostgreSQL Database Administrator to own health, performance, and security of data platforms for client engagements. This hands-on, cloud-first consulting role will partner with engineers, architects, analysts, and stakeholders to stabilize current systems and design the next era of data platforms.

The ideal candidate combines engineering mindset with production incident ownership and a drive to automate and improve design, monitoring, and reliability across