Postgre SQL DBA

Job description

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. About Sutherland Artificial Intelligence. Automation. Cloud engineering. Advanced analytics. For business leaders, these are key factors of success. For us, they’re our core expertise. We work with iconic brands worldwide. We bring them a unique value proposition through market-leading technology and business process excellence. We’ve created over 200 unique inventions under several patents across AI and other critical technologies. Leveraging our advanced products and platforms, we drive digital transformation, optimize critical business operations, reinvent experiences, and pioneer new solutions, all provided through a seamless “as a service” model. For each company, we provide new keys for their businesses, the people they work with, and the customers they serve. We tailor proven and rapid formulas, to fit their unique DNA. We bring together human expertise and artificial intelligence to develop digital chemistry. This unlocks new possibilities, transformative outcomes and enduring relationships. Sutherland Unlocking digital performance. Delivering measurable results.