Trm Labs
Senior Software Engineer, Data Infrastructure (RDBMS) (LATAM)
North America, Remote. Posted 23 days 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
- Drive agentic validation of database changes
- Manage CDC pipelines
- 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 in distributed environments)
- 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 is a plus
Benefits
- TRM coordinates and covers approved travel, lodging, and workspace for R&D work weeks
- Accommodations are available for legitimate caregiving, health, immigration, and similar constraints
Before you apply
- Most interview processes include a case study, an AI skills assessment, and a Leadership Principles interview
- Use of AI tools of any kind during TRM 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.