Azure PostgresSQL DBA

Azure PostgreSQL Database Administrators atCapTechown 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 comfortableeliminatingthe 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 toend:analyze execution plans design indexing and partitioning strategies tuneautovacuumand 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 orBicep anddeliver 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-sizingcomputeand storage tiers and advising clients on reserved capacity and scaling strategy. 

• Partner with application engineers on data modeling query design and connection pooling throughPgBounceror the built-in pooler. 

• Produce runbooks standards and knowledge transfer materials that leave client teams able tooperatethe platform after the engagement ends. 

• Participate in an on-call rotation for production support where the engagement requires it. 

Qualifications :

• Five or moreyearsadministering 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/pgSQLskills with fluency in EXPLAIN ANALYZEpgstatstatements 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. 

• Scriptingproficiencyin Python Bash or PowerShell for operational automation. 

• Understanding ofAzure 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 weve 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 lifes 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

Remote Work :

No

Employment Type :

Full-time