Senior Database Administrator - PostgreSQL
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Overview:
Senior PostgreSQL DBA within the Global IT Operations team, accountable for the availability, performance, recoverability and security of the PostgreSQL estate across cloud and on-prem environments. You will co-own design authority and drive changes in a regulated, audit-driven setting. This hands-on role requires deep technical expertise, cross-team collaboration, and a focus on proactive resilience and capacity planning. You’ll shape best practices and contribute to global fund administration, accounting and reporting platforms. This is an opportunity to lead critical DB improvements in a global, regulated environment.
Compensation / Benefitsindustry-leading Alter Domus Academyprofessional accreditations supportflexible arrangements and holidaysbirthday day offmentoring and career progressionEmployee Share Plan
Responsibilities:
Administer the PostgreSQL estate across cloud and on-prem instances (provisioning, configuration, lifecycle management) Serve as senior escalation point for database incidents and drive root-cause analysisPlan and perform patching and major upgrades with minimal downtime using pg_upgrade, logical replication or dump/restoreMove changes through change management with tested rollback and release docsDiagnose performance issues using EXPLAIN, pg_stat_statements, wait-event analysis; tune indexing, partitioning, pooling, and workload configsMaintain capacity plans for CPU, memory, IOPS, storage, WAL growth; build proactive monitoring and alertsEnsure backup/recovery with pgBackRest, pg_basebackup, logical dumps; automate restore testingDesign and operate high availability via streaming/logical replication and automated failoverDefine DR program scope (RPO/RTO), cross-region replication, DR tests and failover/failbackManage security: least privilege, TLS, encryption at rest, auditing; maintain pg_hba.conf and related controlsProduce up-to-date runbooks, baseline configurations, and support documentationAutomate provisioning, patching, backups, and maintenance with Bash/Python; integrate schema changes into CI/CDReview architectures and provide feedback on scalability, resilience, security and supportabilityMentor other DBAs and drive improvements across the teamParticipate in on-call rotation with cross-time-zone coordinationCoordinate with vendors during planned maintenance and incident handling
Key requirements:
7+ years of production PostgreSQL administrationStrong understanding of PostgreSQL internals (MVCC, WAL, replication, query planning) Experience with PostgreSQL on AWS (RDS/Aurora) including sizing, parameter groups, upgradesHigh availability and disaster recovery design and validationStrong SQL performance tuning and workload analysisSolid Linux administration and scripting (Bash/Python) Experience in formal change management in regulated environmentsAbility to explain database risk and trade-offs to non-technical stakeholdersBachelor’s degree in computer science or related field, or equivalentEnglish fluency, US work authorizationcalm under pressureclear written communicationcollaboration across time zonesPostgreSQL internals (MVCC, vacuum, WAL)AWS RDS/Aurora PostgreSQLpgBackRest, pg_basebackup