TRM Labs
Senior Software Engineer, Data Infrastructure (RDBMS)
$200K–$220K
North America +1 · Remote · Senior · Full-time · Posted Sep 22, 2026
- Location
- North America
United States - Experience
- 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres).
About the job
Develop, operate, and scale TRM’s relational database serving layer, optimizing performance, cost, availability, and data integrity across petabyte-scale systems.
What you'll do
- Tune queries, indexes, and schemas to keep customer-facing APIs fast and available.
- Automate database operations and validate changes before production; manage CDC pipelines and troubleshoot replication.
- Reduce storage and compute costs, migrate workloads, and prototype next-generation data stores using AI-assisted workflows.
What they ask for
- 5–8 years building and operating production PostgreSQL or equivalent distributed Postgres.
- Deep SQL optimization skills, including Explain Plans, CTEs, window functions, partitioning, index design, and distributed query-planner behavior.
- Hands-on CDC-tool experience and fluency with database profiling tools; use AI tooling to analyze performance and debug replication.
- Production automation experience in Python or Go, daily use of AI coding tools, and a track record of AI-assisted production cost or performance improvements.
Nice to have
- Postgres extension development.
Pay
$200,000 - $220,000 USD base salary
Tools
PostgreSQL, Citus, Aurora, AlloyDB, pganalyze, Claude, Python, Go
AI focus
Uses AI-assisted analysis and coding, agentic automation, LLM performance summaries, and AI tooling to improve database cost, performance, operations, and replication troubleshooting.
Model-written summary · the original posting is authoritative