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