Senior Software Engineer, Data Infrastructure (RDBMS)

North America, Remote. Posted a month ago

The role

You will develop, operate, and scale relational database systems that serve data at petabyte scale. You will own the serving layer end to end, including query performance, cost, and availability.

What you will do

Own query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus
Use AI-assisted analysis to detect compression and data-model opportunities to cut costs
Build agentic automation for routine database operations like pgbouncer provisioning and disk scaling
Drive agentic validation of database changes
Manage CDC pipelines using PeerDB, Fivetran, Debezium
Migrate workloads off first-gen infrastructure and prototype new data stores
Codify workflows into AI-native runbooks and internal tooling

Required qualifications

5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres)
Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior)
Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte)
Fluency with database profiling (pganalyze or equivalent)
Production automation experience in Python or Go
Daily use of AI coding tools (Claude, Copilot)
Track record of using AI-assisted analysis to drive measurable cost or performance improvements

Nice to have

Postgres extension development

Benefits

TRM coordinates and covers approved travel, lodging, and workspace for R&D work weeks
Accommodations available for legitimate caregiving, health, immigration, and similar constraints

Before you apply

On-call rotation is pending regional compliance review
Interview process includes a case study, an AI skills assessment, and a Leadership Principles interview
Use of AI tools during interviews is not permitted without prior approval

About the company

TRM Labs provides AI-powered intelligence solutions that help public and private sector agencies investigate and disrupt crime. The company is a Series C company with $220M in total funding.