Staff Software Engineer, Databases

Harvey Harvey · AI Frontier · San Francisco, CA · Engineering

Staff Database Engineer responsible for defining and evolving the database infrastructure for a legal AI platform. This includes owning the technical strategy for a global fleet of PostgreSQL databases, setting migration governance standards, driving architecture decisions for multi-region scaling, and establishing operational practices for reliability and performance.

What you'd actually do

  1. Own the migration governance framework end-to-end—design the review workflow, CI gate checks, automated rollback procedures, and fleet-wide deployment sequencing that makes safe migrations the default across the org
  2. Drive the technical strategy for Harvey’s global database fleet—multi-region replication design, capacity planning, sharding and partitioning approaches, and fleet-wide observability as we scale into new markets
  3. Own database reliability and performance at the fleet level—monitoring replication health, optimizing query performance, tuning vacuum and connection management, and building the alerting that gives us confidence across all production environments
  4. Build self-service tooling and developer guardrails—migration dry-runs, schema diff previews, automated health checks, performance regression detection—so engineering teams can move fast without bottlenecking on a single DBA
  5. Lead database incident response and drive systemic improvements—triage production issues, run post-incident reviews, and turn lessons learned into durable process and tooling fixes

Skills

Required

  • PostgreSQL
  • database administration
  • database reliability engineering
  • infrastructure engineering
  • migration governance
  • multi-region scaling
  • observability
  • incident response
  • cloud database services (Azure Database for PostgreSQL, GCP Cloud SQL, or AWS RDS/Aurora)
  • infrastructure-as-code (Terraform, Pulumi)

Nice to have

  • SOC 2
  • GDPR
  • data residency requirements
  • vendor evaluations
  • build-vs-buy decisions
  • team building
  • mentoring engineers

What the JD emphasized

  • PostgreSQL is our core database and deep fluency is non-negotiable
  • 10+ years of hands-on experience in database administration, database reliability engineering, or infrastructure engineering with PostgreSQL as your primary database, with demonstrated staff-level scope—you’ve set standards across teams, not just operated within one
  • Expert-level PostgreSQL knowledge (required)