Senior Database Administrator - PostgreSQL

ABOUT US:

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

JOB DESCRIPTION:

We are looking for a Senior PostgreSQL Database Administrator to join our Global IT Operations team in Carmel, Indiana. You will be one of the senior technical owners of the PostgreSQL platform that our fund administration and reporting applications run on — responsible for its availability, performance, recoverability and security, and for the standards the rest of the organization builds against.

This is a hands-on role with real design authority, not a ticket-queue position.

THE ENVIRONMENTPostgreSQL across AWS (RDS and Aurora), Microsoft Azure Database for PostgreSQL, and self-managed instances on Linux in our Chicago and Luxembourg data centers.

A global platform supporting business-critical fund administration, accounting and reporting applications, used across our offices worldwide.

A database team you will work within and help shape, alongside infrastructure, cloud, network, security, application and third-party vendor teams.

A regulated environment with formal change management, production control and disaster recovery programs — and the audit and regulatory reporting that comes with them.

WHAT YOU WILL DORun the platform

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 , logical replication and dump/restore.

Take database changes through our change management and CAB process with reviewed scripts, tested rollback and clear release documentation.

Performance and scale

Diagnose and resolve performance problems using EXPLAIN / EXPLAIN ANALYZE, _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, IOPS, storage, WAL growth and connection limits, and flag what needs investment before it becomes an incident.

Build monitoring and alerting that catches problems before users report them, using Cloud Watch, Performance Insights, Prometheus/Grafana, pg Badger and PostgreSQL logs.

Resilience and recovery

Design, operate and prove backup and recovery using pgBackRest, , logical dumps and cloud snapshots — with automated restore testing, not assumed-good backups.

Build and operate high availability using streaming and logical replication, and automated failover where the workload justifies it.

Own the database side of our disaster recovery program: define and document RPO/RTO, configure cross-region replication, and take part in scheduled DR tests…