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.
 

Qualifications :

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.

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

No

Employment Type :

Full-time