SRE - Database Reliability (All Levels)

Location: New York, San Francisco

Department: Engineering

Location Type: HYBRID

Employment Type: FULL_TIME

Location(s)

About the Role

What You'll Do

• Aurora PostgreSQL in production: availability, performance, capacity planning and major-version upgrades.
• Backups and restores: backup policy, point-in-time recovery, and scheduled restore tests with
• measured recovery time and data-loss targets.
• The DynamoDB migration, from the data side: access-pattern and data-model review, backfill
• and dual-write plans, validation, cutover and rollback.
• Database access and security: least-privilege roles, credential rotation, audit logging and
• encryption, in line with PCI DSS and SOC 2.
• Data-layer observability: slow queries, connection saturation, replication lag and storage
• growth, with alerting in Datadog.
• On-call for data-layer incidents: response, follow-through and written post-incident reviews.
• Runbooks clear enough that the rest of engineering can operate the databases without you.

What You’ve Done

• You've run PostgreSQL in production and been the person accountable when it broke.
• You have deep PostgreSQL skills: query planning, indexing, vacuum and bloat, connection pooling, replication and major-version upgrades.
• You've done real backup and restore work: point-in-time recovery, restore drills and measured recovery times.
• You know data stores on AWS, including Aurora PostgreSQL (Serverless v2) and DynamoDB data modeling (access patterns, key design, capacity).
• You're comfortable with Terraform or OpenTofu, CI pipelines and scripting in Python, Go or Bash.
• You've worked under PCI DSS, SOC 2 or a similar regime, or you're ready to.
• You write clearly: runbooks, migration plans and incident reviews that other people can act on.

Nice to Have

• TimescaleDB in production
• A completed migration from a relational database to DynamoDB
• Datadog database monitoring
• Experience in payments, banking, or another fintech setting