Job Summary
Owns PostgreSQL vulnerability remediation across SG\'s PCP estate. Range driven by underlying automation maturity; Phase 2 explicitly targets reducing the upper bound.
Key Responsibilities
■ Execute PostgreSQL minor-version and security patching cycles. ■ Coordinate with application owners on connection-pool, restart and validation windows. ■ Manage replication (streaming, logical) during patching. ■ Apply extensions and contrib-module updates as part of remediation. ■ Maintain and extend automation playbooks (Ansible / equivalent). ■ Produce evidence and contribute to Phase 2 automation.
Skill Requirements
■ PostgreSQL administration (12, 13, 14, 15, 16). ■ Familiarity with streaming and logical replication. ■ Configuration management — Ansible playbooks for PostgreSQL patching. ■ Performance and locking awareness during patching. PREFERRED / NICE TO HAVE ■ EDB / EnterpriseDB experience. ■ Patroni / repmgr / pgBackRest exposure. ■ Container-based PostgreSQL (Crunchy, Zalando) familiarity. EXPERIENCE & CERTIFICATIONS ■ 4+ years PostgreSQL DBA experience. ■ Certifications: EDB Certified Associate / Professional preferred. SOFT SKILLS ■ Detail-oriented. ■ Effective application-team coordinator. ■ Process discipline.
Other Requirements
■ PostgreSQL administration (12, 13, 14, 15, 16). ■ Familiarity with streaming and logical replication. ■ Configuration management — Ansible playbooks for PostgreSQL patching. ■ Performance and locking awareness during patching. PREFERRED / NICE TO HAVE ■ EDB / EnterpriseDB experience. ■ Patroni / repmgr / pgBackRest exposure. ■ Container-based PostgreSQL (Crunchy, Zalando) familiarity. EXPERIENCE & CERTIFICATIONS ■ 4+ years PostgreSQL DBA experience. ■ Certifications: EDB Certified Associate / Professional preferred. SOFT SKILLS ■ Detail-oriented. ■ Effective application-team coordinator. ■ Process discipline.