Azure PostGres DBA

CapTech Consulting • Charlotte, NC

6d • Hybrid

About The Position

Azure PostgreSQL Database Administrators at CapTech own the health, performance, and security of the data platforms our clients depend on every day. This is a consulting role, so you will work alongside engineers, architects, analysts, and client stakeholders to stabilize what exists today and design what comes next. The work is hands-on and cloud-first. We are looking for a DBA who thinks like an engineer. You should be comfortable owning production incidents, but equally comfortable eliminating the conditions that caused them through automation, monitoring, and better design.

Requirements

• 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 rest of 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.

Nice To Haves

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

Benefits

• Generous PTO
• Health coverage
• Disability insurance
• Paid family leave
• Learning & Development Programs offering certification and tuition support, digital on-demand learning courses, mentorship, and skill development paths
• Modern Health –A mental health and well-being platform that provides 1:1 care, group support sessions, and self-serve resources to support employees and their families through life’s ups and downs
• Carrot Fertility –Inclusive fertility and family-forming coverage for all paths to parenthood – including adoption, surrogacy, fertility treatments, pregnancy, and more – and opportunities for employer-sponsored funds to help pay for care
• Fringe –A company paid stipend program for personalized lifestyle benefits, allowing employees to choose benefits that matter most to them – ranging from vendors like Netflix, Spotify, and GrubHub to services like student loan repayment, travel, fitness, and more
• Employee Resource Groups – Employee-led committees that embrace and incorporate diversity and inclusion into our day-to-day operations
• Philanthropic Partnerships – Opportunities to engage in partnerships and pro-bono projects that support our communities.
• 401(k) Matching – Generous matching and no vesting period to help you continue to build financial wellness

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed