DB Reliability SRE — Aurora PostgreSQL & DynamoDB Expert

Casap; New York, San Francisco (NY, CA); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Casap is hiring an SRE to own our production databases end to end, with a strong emphasis on data-layer reliability. The role focuses on Aurora PostgreSQL, OpenSearch, TimescaleDB metrics, and migrations toward DynamoDB.

You will ensure backups, restores, security, and efficient data access in a regulated environment; Terraform/OpenTofu, Python/Go/Bash scripting, and AWS data stores are part of daily work. This is a hybrid role based in SF or NYC offices.

Qualifications

• 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.

Responsibilities

• 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.

Skills

PostgreSQL

Backups & restores

Terraform/OpenTofu

CI pipelines

Scripting (Python/Go/Bash)

AWS data stores

DynamoDB

Security & compliance

Tools

Aurora PostgreSQL

OpenSearch

TimescaleDB

Datadog

Terraform

Job description

Casap is hiring an SRE to own our production databases end to end, with a strong emphasis on data-layer reliability. The role focuses on Aurora PostgreSQL, OpenSearch, TimescaleDB metrics, and migrations toward DynamoDB.

You will ensure backups, restores, security, and efficient data access in a regulated environment; Terraform/OpenTofu, Python/Go/Bash scripting, and AWS data stores are part of daily work. This is a hybrid role based in SF or NYC offices.