Postgre SQL DBA

Sutherland Global; Hyderabad; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Sutherland Hyderabad seeks an experienced Enterprise Database Administrator specializing in PostgreSQL to own HA/DR architectures and lifecycle management for mission-critical environments.

You will design and implement Patroni/etcd streaming replication, Pacemaker-based clusters, and robust backup strategies while driving automation, testing, and documentation to ensure uptime and resilience.

Qualifications

• 6-8 years of proven experience as an Enterprise Database Administrator with extensive PostgreSQL expertise.
• Hands-on engineering with shared-storage clusters (Pacemaker, Corosync, STONITH) and streaming replication HA (Patroni, etcd).
• Strong bash scripting to navigate deployment flows and modify installer frameworks.
• Working knowledge of SAN/NAS shared storage, multipathing (MPIO), WWID tracking, and out-of-band server management (IPMI, iLO, iDRAC).
• Deep understanding of MVCC, VACUUM, and WAL management; able to justify design decisions with cross-functional teams.

Responsibilities

• Manage full database lifecycle: installation, upgrades, patching, and secure configuration management.
• Optimize performance with query tuning, indexing, and partitioning strategies for large datasets.
• Develop robust backup/recovery strategies aligned to RPO/RTO SLAs.
• Collaborate with RHEL infra teams on storage provisioning and OS-level troubleshooting.
• Design and implement HA/DR architectures (Patroni/etcd, Pacemaker/Corosync) across single and multi-site deployments.
• Author comprehensive Low-Level Design (HLD) docs and secure stakeholder sign-off.
• Create installers and deployment scripts for HA environments; automate cluster networking and storage provisioning.
• Configure and monitor HA telemetry: replication lag, cluster health, fencing reachability; run failover drills.

Skills

PostgreSQL

Bash scripting

RHEL administration

MVCC

HLD documentation

DB2/LUW or Oracle (advantage)

Tools

Pacemaker

Corosync

STONITH

Patroni

etcd

LVM

IPMI

iLO

iDRAC

Job description

Company Description:

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.

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.

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.