Postgre SQL DBA

You will serve as a primary subject matter expert for the enterprise database infrastructure, responsible for the end-to-end administration, performance, and lifecycle management of business-critical PostgreSQL environments. While this role encompasses comprehensive database management duties, a core specialization involves owning the design, implementation, and operation of resilient High Availability (HA) and Disaster Recovery (DR) architectures across shared-storage and streaming-replication models.
Primary Responsibilities
Database Administration & Engineering
* Manage the complete database lifecycle, including standard installations, version upgrades, patching, and secure configuration management.
* Optimize database performance through advanced query tuning, index optimization, and the implementation of declarative table partitioning strategies for large-scale datasets.
* Develop and maintain robust backup and recovery strategies to meet strict Recovery Point Objective (RPO) and Recovery Time Objective (RTO) SLAs.
* Collaborate closely with infrastructure teams on Red Hat Enterprise Linux (RHEL) system administration, focusing on storage provisioning, Logical Volume Manager (LVM) expansion, and general OS-level troubleshooting to ensure optimal database performance.
High Availability & DR Architecture (Specialization)
* Design and implement Patroni and etcd streaming-replication HA architectures for both single-datacenter (2-node plus witness) and cross-datacenter (multi-site plus arbiter) deployment models.
* Design and implement shared-storage Active-Passive clusters utilizing Pacemaker, Corosync, qdevice, and STONITH fencing mechanisms.
* Engineer robust quorum, witness, and arbiter layers customized for each architectural model, explicitly managing per-node versus per-site voting, majority logic, and split-brain prevention.
* Determine and justify the optimal replication mode (synchronous, asynchronous, or sync-with-degrade) and connection-routing strategy (VIP versus multi-host string) based on workload requirements.
* Independently author comprehensive High Level Design (HLD) documentation and successfully secure architecture sign-off from key stakeholders.
Automation & Operational Resilience
* Take full ownership of installer and deployment scripts for HA environments, managing cluster networking, shared storage provisioning, and automated database node setup.
* Apply infrastructure changes by following established design patterns: isolating new logic, documenting every modification, and preserving backward compatibility with existing automation frameworks.
* Configure and monitor critical HA telemetry signals, including replication lag, cluster health, fencing device reachability, and automated failover events.
* Execute rigorous verification tests and failover drills following every system change, investigate behavior post-failover, and remediate underlying issues to restore full architectural redundancy.
Required Qualifications
* 6-8 years of proven experience as an Enterprise Database Administrator (Extensive PostgreSQL expertise is required; supplementary experience with DB2 LUW or Oracle is highly advantageous).
* Demonstrated, hands-on engineering experience with both shared-storage clusters (Pacemaker, Corosync, STONITH) and streaming replication HA (Patroni and etcd for single- and multi-site environments).
* Strong bash scripting proficiency, demonstrating the capability to navigate existing deployment flows and comfortably modify installer frameworks without breaking dependent processes.
* Working technical knowledge of SAN/NAS shared storage architectures, MPIO multipathing, WWID tracking, and out-of-band server management (IPMI, iLO, iDRAC).
* Deep understanding of database internals, MVCC (Multi-Version Concurrency Control), vacuuming processes, and transaction log (WAL) management.
* Proven ability to independently author complex HLD documents, articulate technical strategies, and defend design decisions to cross-functional engineering teams.

Employment type
Full-time

Work arrangement
No