Senior Database Administrator - PostgreSQL
About the role
As a world leading provider of integrated solutions for the alternative investment industry, Alter Domus (meaning “The Other House” in Latin) is proud to be home to 90% of the top 30 asset managers in the private markets, and more than 6,000 professionals across 24 jurisdictions. With a deep understanding of what it takes to succeed in alternatives, we believe in being different in what we do, how we work, and most importantly in how we enable and develop our people. Invest yourself in the alternative, and join an organization where you progress on merit, where you can speak openly with whoever you are speaking to, and where you will be supported along whichever path you choose to take. Find out more about life at Alter Domus at careers.alterdomus.com
Responsibilities
- Own day-to-day administration of the PostgreSQL estate: provisioning, configuration, monitoring and lifecycle management across cloud and on‑premises instances.
- Act as senior escalation point for database incidents.
- Lead root‑cause analysis, drive permanent corrective actions rather than repeat workarounds, and write the post‑incident record.
- Plan and execute patching and major‑version upgrades with minimal or zero downtime, choosing appropriately between pg_upgrade, logical replication and dump/restore.
- Take database changes through our change management and CAB process with reviewed scripts, tested rollback and clear release documentation.
- Diagnose and resolve performance problems using EXPLAIN / EXPLAIN ANALYZE, pg_stat_statements, wait‑event analysis and planner statistics.
- Tune indexing, partitioning, connection pooling (PgBouncer) and workload‑specific configuration for our largest and busiest databases.
- Keep bloat and storage growth under control through autovacuum tuning and targeted VACUUM, ANALYZE and REINDEX operations.
- Plan capacity proactively across CPU, memory,