Skip to content
×

Senior PostgreSQL DBA - GD

Listing for: KBI Staffing
Full Time position Listed on 2026-11-22
Job specializations:
Salary/Wage Range or Industry Benchmark: 140000 - 190000 USD Yearly USD 140000.00 190000.00 YEAR

Job Description & How to Apply Below

Position: Senior PostgreSQL DBA - GD601
Job Description:

This position is classified as structured hybrid, with an expectation of three (3) days per week working in the office and flexibility to work remotely on the remaining days. On-site expectations may evolve over time to support business needs, with clear communication provided in advance.

The Senior PostgreSQL DBA owns the design, availability, performance, and security of our production PostgreSQL estate hosted in Microsoft Azure. The role covers both Azure Database for PostgreSQL (flexible server) and self-managed PostgreSQL on Azure virtual machines running Red Hat Enterprise Linux, CentOS Stream, and Windows Server.

This is a hands-on senior engineering role, not a supervisory one. The DBA is the final escalation point for database incidents, the architect of our high-availability and disaster-recovery topology (active-passive and active-active), and the person who keeps us current on PostgreSQL 17, 18, and the upcoming 19 release.

Key Responsibilities

Duties marked critical are the core of the role; a candidate who cannot demonstrate them should not advance past the technical screen.

1. High availability and disaster recovery (critical)
  • Design, deploy, and operate zone-redundant high availability on Azure Database for PostgreSQL flexible server: synchronous standby in a second availability zone, automatic failover in 60–120 seconds with zero data loss, and the 99.99% uptime SLA that configuration carries.
  • Decide between zone-redundant and same-zone (zonal) HA per workload based on latency tolerance and zone-failure risk, and document the trade-off.
  • Run and document planned, unplanned, and forced failover tests at least quarterly; measure downtime from the application side, not from the service side.
  • Size _slots and _senders correctly (four reserved for HA plus one per read replica and per logical slot) so failovers never fail for lack of slots.
  • Build equivalent active-passive clusters on self-managed Azure VMs using streaming replication with Patroni and etcd (Linux) or a supported cluster manager on Windows, fronted by HAProxy, PgBouncer, or an Azure internal load balancer.
  • Design cross-region disaster recovery: geo-redundant backups, cross-region read replicas, and promotion runbooks with tested RPO/RTO targets.
  • Preserve logical replication across failover: _slots on PostgreSQL 16 and earlier, native _slots = on with _feedback = on on PostgreSQL 17 and later.
Active-active (bi-directional / multi-master):
  • Design and operate active-active topologies across Azure regions using the pglogical extension or native logical replication, following Microsoft's published bi-directional replication guidance for Azure Database for PostgreSQL.
  • Define and enforce conflict-avoidance and conflict-resolution strategy: partitioned write ownership, non-overlapping sequence ranges or UUIDv7 keys, last-writer-wins rules where appropriate, and monitoring for conflict counts.
  • Manage DDL propagation across nodes (pglogical._command() or controlled DDL rollout for native replication) and sequence synchronization (PostgreSQL 19 adds native sequence replication via ALL SEQUENCES and REFRESH SEQUENCES).
  • Monitor replication lag, slot retention, and _tuples settings on every node; alert before WAL retention threatens primary disk.
  • Own the decision of when active-active is and is not appropriate, and push back on it where a well-run active-passive design meets the requirement at lower risk.
  • Provision and manage Azure Database for PostgreSQL flexible server via the portal, Azure CLI, Az.PostgreSQL Flexible

    Server Power Shell module, ARM/Bicep, Terraform, and REST API.
  • Configure networking: VNet integration, private endpoints, private DNS zones, firewall rules, and migration from VNet-injected to…

Position Requirements

10+ Years work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary