About the role
You will own relational database serving infrastructure end to end, including query performance, availability, cost, indexing, schemas, CDC pipelines, and production automation. You will build database tooling, validate changes, troubleshoot replication, migrate infrastructure, prototype data stores, and participate in an on-call rotation and periodic work weeks.
Responsibilities
- Tune queries, design indexes, and optimize schemas
- Use database analysis to identify compression and data-model opportunities
- Build automation for database operations
- Validate database changes before production
- Manage CDC pipelines and troubleshoot replication failures
- Migrate workloads and prototype data stores
- Create reusable runbooks and internal tooling
- Participate in an on-call rotation
- Participate in in-person R&D work weeks
Requirements
- 5–8 years of experience building and operating production PostgreSQL or distributed PostgreSQL
- Deep SQL optimization skills, including explain plans, CTEs, window functions, partitioning, index design, and query-planner behavior
- Experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
- Experience with database profiling tools such as pganalyze
- Production automation experience in Python or Go
- Daily use of AI coding tools such as Claude or Copilot
- Experience using AI-assisted analysis to improve database cost or performance
Benefits
- Approved travel, lodging, and workspace coverage for work weeks
Requirements
- 5–8 years of experience building and operating production PostgreSQL or distributed PostgreSQL
- Deep SQL optimization skills, including explain plans, CTEs, window functions, partitioning, index design, and query-planner behavior
- Experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
- Experience with database profiling tools such as pganalyze
- Production automation experience in Python or Go
- Daily use of AI coding tools such as Claude or Copilot