Staff Database Administrator

Altruist

Los Angeles (CA)

Hybrid

USD 181,000 - 265,000

Full time

5 days ago
Be an early applicant
Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

Office spaces in Culver City / SF
Equity eligible
Premium health/dental/vision
401k with match
Parental leave
L&D budget
Perks program
Financial guidance
Work from anywhere (some restrictions)

Job summary

Altruist is hiring a Staff Database Administrator to own our multi-terabyte PostgreSQL estate and lead multi-region resilience for a high-volume brokerage platform. You will drive upgrades, data movement using Debezium, Kafka, and AWS DMS, and shape a domain-driven data architecture with read replicas and partitioned clusters.

You will partner with security, platform, data, and product teams, mentoring engineers and building AI-assisted tooling to automate routine work.

Qualifications

  • 8+ years operating production relational databases at scale.
  • Deep PostgreSQL expertise including partitioning, indexing, and replication.
  • Experience with Aurora or RDS at multi-terabyte scale and major-version upgrades.
  • Familiarity with SOC, security, and compliance considerations.

Responsibilities

  • Own production PostgreSQL estate end to end across multi-region workloads.
  • Lead multi-region resilience and disaster-recovery planning for data stores.
  • Partition domains and manage read paths to limit blast radius.
  • Architect capacity growth with sharding and partitioning strategies.
  • Plan and execute major-version upgrades with minimal downtime.
  • Oversee change data capture and data movement across systems.
  • Govern migrations with safeguards, tests, and automation.
  • Collaborate on encryption and least-privilege access controls.
  • Be a senior escalation point for database-driven incidents.
  • Build automation and AI-assisted tooling for self-serve DB tasks.

Skills

Relational databases
PostgreSQL expertise
Multi-region disaster recovery
Data movement & CDC
Terraform
CI/CD
Kubernetes
Schema migration tooling
Observability
Communication

Education

B.A./B.S. in Computer Science or related field

Tools

Aurora PostgreSQL
RDS
Flyway
Liquibase
Kafka
AWS DMS
Debezium
pg_stat_statements
Terraform
Kubernetes

Job description

Altruist is transforming the multi-trillion dollar wealth management industry by building an AI platform for wealth professionals. We partner with financial advisors nationwide, empowering them to grow, optimize time and resources, and deliver superior outcomes for their clients.

We're looking for exceptional talent to help us achieve our mission of making financial advice better, more affordable, and accessible to all. If you're passionate about challenging the status quo and want to do the most important work of your life, we'd love to meet you!

This role is hybrid, with three in-office days per week at our Culver City or San Francisco FiDi location.

The opportunity

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.

Your impact
  • 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.
What you bring
  • Experience - 8+ years operating production relational databases at scale, ideally at a B2B financial services, fintech, or SaaS organization handling regulated or transactional data.
  • Deep PostgreSQL expertise: query planning and optimization, indexing, partitioning, vacuum and bloat management, locking and concurrency, replication, and connection management.
  • Hands-on experience running Aurora or RDS at multi-terabyte scale, including major-version upgrades, blue/green cutovers, and parameter and storage tuning.
  • Proven multi-region disaster recovery design: defining and defending RTO and RPO targets, cross-region replication, promotion and failback mechanics, and validated backup and restore.
  • Practical experience with change data capture and data movement — Debezium, Kafka, or AWS DMS — and with diagnosing replication lag and correctness issues.
  • Comfort working as code: Terraform, CI/CD pipelines, Kubernetes, and version-controlled schema migration tooling such as Flyway or Liquibase.
  • Strong observability instincts — you reach for pg_stat_statements, wait events, and dashboards before you reach for a guess.
  • Education - Ideally a B.A. / B.S. in a relevant field such as Computer Science or a related discipline, but experience and understanding matter just as much.
  • Staff-level scope - You set technical direction beyond your own work, lead multi-quarter programs across teams, and influence without needing authority to do it.
  • Ownership - The pride you put into every aspect of your work is unparalleled and undeniable.
  • Superb communication - Intentional dialogue is a superpower. You listen as well as you share your perspective with others.
  • Resilience - We are inspired by your unwavering determination to achieve success, no matter the adversity you face along the way.
  • Assurance - Your confidence is brilliant, yet ego-less. You possess a strong knowledge base, the ability to discover the unknown, and are open to differing perspectives.
  • Creative problem solving - Identifying the problem is simply not enough. You are instinctually creative in your approach to finding solutions to roadblocks.
  • Expertise with AI (Claude) best practices, and an interest in building agentic automation for database operations.
  • Experience splitting a monolithic database into domain-owned clusters, or introducing sharding to a multi-tenant system already in production.
  • MySQL, Snowflake, ElastiCache/Redis, or OpenSearch operational experience alongside PostgreSQL.
  • Kafka or Amazon MSK operations, including connector fleets and upgrade planning.
  • Experience supporting a large-scale data migration or platform integration, including historic data conversion into a canonical model.
  • Familiarity with SOC 1, SOC 2, or similar audited control environments.
  • Knowledge of brokerage, clearing, or custody platforms and the financial services industry.
San Francisco, CA salary range

$181,000 - $265,000 USD

What we bring

Attracting and retaining top-tier talent is a priority. We are proud of the culture we’ve built and are cognizant of the ever-changing professional landscape. Our dynamic offering of perks and benefits are tailored for you to feel your best while doing your best.

  • Stunning, amenity-filled office spaces in Culver City, CA, San Francisco, CA, and Dallas, TX. Our offices are intentionally designed for comfort, collaboration, and productivity.
  • Competitive pay and equity for eligible positions.
  • Premium healthcare, dental, and vision insurance plans (HMO and PPO).
  • 401k savings plan with a 4% match and immediate vesting.
  • 16 week paid parental leave after one year of employment.
  • Professional growth and development opportunities including an employee mobility program and an annual L&D budget allocation for each employee.
  • Company perks program (includes discounts on pet insurance, fitness, cell phone plans, and travel, etc.).
  • Financial guidance program (includes counseling on navigating debt, tracking personal spend, saving and planning goals, home-purchasing preparedness, etc.).
  • One month work from anywhere policy (with the exception of a few countries).

Total compensation includes a competitive benefits package, along with a bonus program for eligible roles. For salaried positions, a salary offer will be determined by a number of factors including experience, skill level, internal pay equity, geographic location, and other relevant business considerations. We review all employee pay and compensation programs regularly to ensure fair, equitable, and competitive pay. At Altruist, we are committed to providing fair, equitable, and competitive compensation by leveraging market data to inform our pay bands. Base salaries will be reviewed at regular intervals throughout the year, typically in conjunction with performance review cycles. By evaluating compensation on a regular basis, we are able to reward high performance and ensure all employees have opportunities for growth.

Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Staff Database Administrator
Staff Database Administrator

Altruist • Culver City (CA)

Hybrid
USD 181,000 - 265,000
Hybrid work model
Office in Culver City/San Francisco
Career growth
Cloud Engineering Manager
Cloud Engineering Manager

Altruist • San Francisco (CA)

Hybrid
USD 203,000 - 275,000
Office spaces in SF/Culver City
Competitive benefits package
401k with match
+2
Staff Site Reliability Engineer
Staff Site Reliability Engineer

Altruist • Los Angeles (CA)

Hybrid
USD 181,000 - 265,000
Competitive pay and equity
Premium healthcare, dental, vision
401k with 4% match
+6
Senior Software Engineer, Cloud Infrastructure
Senior Software Engineer, Cloud Infrastructure

Altruist • San Francisco (CA)

Hybrid
USD 180,000 - 240,000
Premium healthcare
401k match
Parental leave
+1
Staff Back End Engineer
Staff Back End Engineer

Altruist • San Francisco (CA)

On-site
USD 203,000 - 275,000
Hybrid work schedule
Premium healthcare, dental, and vision insurance
401k savings plan with a 4% match
+3
Staff Site Reliability Engineer
Staff Site Reliability Engineer

altruist • San Francisco (CA)

On-site
USD 203,000 - 275,000
Health insurance
401k match
Parental leave
+1
Staff Back End Engineer, Trading
Staff Back End Engineer, Trading

Altruist • New York (NY)

On-site
USD 200,000 - 285,000
Hybrid work schedule
Premium healthcare, dental, and vision insurance
401k savings plan with a 4% match
+2
Staff Backend Engineer, Scalable Systems
Staff Backend Engineer, Scalable Systems

Altruist • San Francisco (CA)

Hybrid
USD 203,000 - 275,000
Hybrid work schedule
Premium healthcare, dental, and vision insurance
401k savings plan with a 4% match
+3
Relationship Manager
Relationship Manager

Altruist • Los Angeles (CA)

On-site
USD 96,000 - 141,000
Premium healthcare plans
401k with 4% match
16-week paid parental leave
Staff Back End Engineer, Platform
Staff Back End Engineer, Platform

altruist • San Francisco (CA)

On-site
USD 200,000 - 240,000
Office in SF & Culver City
Equity
Healthcare, dental, vision
+1