Postgre SQL DBA Professional

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.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.