Responsibilities

Altruist is in the midst of an exceptional growth phase, and we are hiring a Staff Database Administrator to join our Cloud Infrastructure & Platform team. Our clearing and brokerage platform runs on a multi-terabyte Aurora PostgreSQL estate that is the system of record for hundreds of thousands of brokerage accounts, millions of positions, and hundreds of thousands of trades every day.
This role owns the reliability, performance, and resilience of that estate through its next order of magnitude. You will lead our multi-region disaster recovery program for data stores, break critical domains out of shared clusters into dedicated ones, and re-architect our replication and data movement layer so it keeps up as volumes multiply. You will be one of two staff-level database engineers, working directly with engineering leadership and partnering with platform, data, security, and product teams. The role carries a lot of autonomy for design and implementation, and real influence over where our data architecture goes next.
Own the production PostgreSQL estate end to end — multi-terabyte Aurora clusters across clearing, broker-dealer, and internal platform workloads — including capacity, performance, availability, and cost.
Lead multi-region resilience for data stores: convert production clusters to Aurora Global Database, instrument replication lag against tiered RTO and RPO commitments, and own documented failover, failback, and recurring recovery drills.
Drive database segmentation. Carve our most critical domains out of shared clusters into dedicated ones with their own read paths, so failover, upgrades, and blast radius are scoped per domain rather than per fleet.
Architect for an order-of-magnitude increase in accounts, positions, and daily transaction volume: capacity modeling, tenant-aware partitioning and sharding strategy, per-domain read replicas, continuous aggregates and materialized views, connection pooling, and load testing ahead of demand.
Own the upgrade program. Plan and execute major-version upgrades across the fleet with minimal downtime, and keep engine versions current enough that they never gate replication or recovery capability.
Own change data capture and data movement — Debezium, Kafka/MSK, and AWS DMS — for throughput, lag, and correctness, including re-architecting single-threaded vendor replication paths into parallel, partitioned pipelines.
Raise the bar on schema-change governance: review standards for migrations, index and locking review, and automated guardrails so unsafe changes are caught before they reach production rather than during market hours.
Partner with security and compliance on encryption, row-level security, least-privilege access, and the evidence our SOC 1 and regulatory obligations depend on.
Be a senior escalation point for database-driven incidents, and turn each one into a durable fix, a runbook, or an alert rather than a repeat.
Build automation and AI-assisted tooling that makes routine database work self-serve for product engineers, and mentor engineers across the org on data modeling, query design, and operating databases at scale.

Staff Database Administrator at Altruist · LumiJobs

Staff Database Administrator

Responsibilities

Qualification

Preferred

Benefits

Company

Altruist

More roles at Altruist