Senior Software Engineer, Data Infrastructure (RDBMS)

📋 Description

• Manage query tuning, index design, schema optimization on petabyte-scale Postgres/Citus.
• Use AI-assisted analysis (pganalyze, Claude) to find compression and cost opportunities.
• Build automation for pgbouncer provisioning, disk scaling, blue-green deployments.
• Validate database changes with agentic tools before production rollout.
• Operate CDC pipelines (PeerDB, Fivetran, Debezium) and debug replication issues.
• Migrate workloads to new data stores and codify workflows into AI-native runbooks.

🎯 Requirements

• 5-8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB).
• Deep SQL optimization skills: Explain Plans, CTEs, window functions, partitioning.
• Experience with CDC tools: PeerDB, Fivetran, Debezium, Datastream, Airbyte.
• Proficiency with database profiling (pganalyze or similar) and LLM analysis.
• Production automation with Python or Go, including agentic automation.
• Daily use of AI coding tools (Claude, Copilot) with judgment on AI output.

🎁 Benefits

• Equity plan participation.
• Distributed-first remote work across US and Canada time zones.
• Async-first culture with minimal meetings.
• On-call rotation every 15 days with 24-hour shifts.