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. All your information will be kept confidential according to EEO guidelines.