Database Developer Associate

Requirements

- 5+ years of hands-on PostgreSQL experience in a production or production-adjacent context

- Strong SQL skills, including joins, aggregation, common table expressions, window functions, upserts, and DDL

- Ability to read execution plans and use a systematic approach to diagnose and rewrite slow SQL statements

- Practical understanding of transactions, isolation levels, locking, and MVCC

- Experience with physical database design, including tables, keys, constraints, indexes, and partitioning

- Practical experience with data migrations, including bulk or incremental loads, cutovers, and validation - Practical backup and restore experience, including retention, point-in-time recovery, or restore testing

- Ability to write reliable operational scripts and idempotent reconciliation or backfill processes

- Basic Python experience for data loading and operational scripting.

Nice to have

- Experience with a schema migration tool such as Alembic, Flyway, or Liquibase

- Experience managing declarative partitioning at scale

- Experience with managed cloud PostgreSQL

- Experience tuning PostgreSQL statistics, autovacuum, bloat, and lock contention