Postgre SQL DBA
Core
Primary subject matter expert for enterprise PostgreSQL infrastructure, specializing in designing and operating resilient High Availability (HA) and Disaster Recovery (DR) architectures.
Role type
Senior IC PostgreSQL Database Administrator (HA/DR Specialist)
Builds
Resilient shared-storage and streaming-replication HA/DR clusters for business-critical PostgreSQL environments
Domain
Enterprise Database Administration / High Availability Engineering
Required skills
PostgreSQL internals (MVCC, WAL, vacuuming), shared-storage clustering (Pacemaker, Corosync, STONITH), streaming replication (Patroni, etcd), Linux system administration (RHEL, LVM), Bash scripting, SAN/NAS storage architecture, quorum/witness management, HLD documentation
Preferred skills
DB2 LUW or Oracle experience
Technologies
PostgreSQL, Patroni, etcd, Pacemaker, Corosync, qdevice, RHEL, LVM, SAN/NAS, IPMI, iLO, iDRAC
Responsibilities
Manage complete database lifecycle (installations, upgrades, patching, configuration), optimize performance via query tuning and partitioning, design and implement HA/DR architectures (single- and cross-datacenter), author HLD documentation and secure stakeholder sign-off, develop automation scripts for cluster deployment and monitoring, execute failover drills and remediate post-failover issues
Seniority
Senior, hands-on IC
