Azure PostgresSQL DBA

Posted Yesterday
Be an Early Applicant
Philadelphia, PA, USA
Hybrid
Senior level
Information Technology • Consulting
The Role
Administer and optimize PostgreSQL databases across Azure and self-managed environments. Responsibilities include performance tuning, high availability, disaster recovery, security, infrastructure automation, CI/CD schema delivery, monitoring, capacity planning, application collaboration, documentation, knowledge transfer, and production on-call support. The role requires client-facing consulting, technical communication, and hands-on expertise with Azure PostgreSQL, PostgreSQL diagnostics, infrastructure as code, scripting, networking, and identity controls.
Summary Generated by Built In
Company Description

CapTech is a technology consulting firm dedicated to helping clients achieve their business objectives through innovative technology solutions. With a commitment to excellence and collaboration, CapTech partners with leading companies to deliver digital transformation, software development, and technology consulting services.

 

 

Job Description

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.  

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.  

 

 

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

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

 

 

 

Additional Information

We want everyone at CapTech to be able to envision a lasting and rewarding career here, which is why we offer a variety of career paths based on your skills and passions.  You decide where and how you want to develop, and we help get you there with customizable career progression and a comprehensive benefits package to support you along the way.  Alongside our suite of traditional benefits encompassing generous PTO, health coverage, disability insurance, paid family leave and more, we’ve launched extended benefits to help meet our employees’ needs. 

  • 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

CapTech is committed to providing a flexible work environment and helping our employees achieve a work-life balance that suits their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We allow CapTech employees to work remotely when compatible with CapTech and client needs. 

CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness — each foundational to our core values.  We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds and experiences to the workplace. As part of this commitment, CapTech will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment.

At this time, CapTech cannot transfer nor sponsor a work visa for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship.  

 

#LI-JB1

 

 

Skills Required

  • Five or more years administering PostgreSQL in production, including tuning, upgrades, backup and recovery, replication, and incident response
  • Two or more years of hands-on experience working in Microsoft Azure, including Azure Database for PostgreSQL Flexible Server
  • Strong SQL and PL/pgSQL skills, including EXPLAIN ANALYZE, pg_stat_statements, and PostgreSQL diagnostic tools
  • Working knowledge of infrastructure as code using Terraform, Bicep, or ARM templates
  • Experience with CI/CD pipelines and Git-based version control
  • Scripting proficiency in Python, Bash, or PowerShell
  • 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, including explaining risks and tradeoffs to client stakeholders
  • Consulting experience and familiarity with regulated environments such as financial services, healthcare, or the public sector
  • Azure certifications such as AZ-104 or AZ-305

CapTech Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CapTech and has not been reviewed or approved by CapTech.

  • Healthcare Strength Comprehensive medical, dental, and vision coverage is paired with HSA/FSA options and dedicated mental-health support offering 1:1 care, group sessions, and self-serve resources. This breadth positions core health benefits as a strong element of the total package.
  • Parental & Family Support Inclusive fertility and family-forming coverage provides up to $25,000 in employer-sponsored funds alongside adoption assistance. Birth and family-bonding leave are highlighted as meaningful supports for growing families.
  • Leave & Time Off Breadth Paid time off starts around 28 days in the first year and accrues to about 30 days, with unused time paid out. This structure signals a generous approach to time away from work.

CapTech Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Richmond, VA
1,100 Employees
Year Founded: 1997

What We Do

CapTech is a national consulting firm that helps clients grow efficient, successful businesses. We do so by bringing the data, systems, and ingenuity organizations need to stay ahead and transform what’s possible in a changing world. We are master builders, creators, and problem solvers who find inspiration in the unknown and enjoy getting our hands dirty as we design solutions for each client. Across industries and business goals, we fuse technical depth and analytical prowess with creative savvy to ignite innovation and move business forward.

Similar Jobs

General Motors Logo General Motors

Sales Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
106K-141K Annually

General Motors Logo General Motors

Sales Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
81K-109K Annually

DFIN Logo DFIN

Account Executive

Fintech • Software
Remote or Hybrid
United States
1750 Employees

Cox Enterprises Logo Cox Enterprises

Customer Care Specialist (Cox Automotive Fleet Client Solutions Delivery)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Remote or Hybrid
United States
30000 Employees
18-27 Hourly

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account