Senior Software Engineer, Data Infrastructure (RDBMS)

North America, United States

Build a Safer World.

TRM Labs provides AI-powered intelligence solutions that help public and private sector agencies investigate and disrupt crime. TRM's platforms enable investigators to trace illicit activity, build cases, and construct operating pictures of threat networks. Leading agencies and businesses worldwide rely on TRM to make the world safer and more secure.

The Data Platform team builds and owns highly available, scalable data infrastructure for TRM's products and services. As a Senior Software Engineer on Data Infrastructure (RDBMS), you will develop, operate, and scale the relational database systems that serve data at petabyte scale, helping build a safer financial system for billions of people. This role is uniquely broad at TRM: you own the serving layer end to end, from query performance to cost to availability, on infrastructure that product teams depend on every day.

The impact you will have:

• Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus, directly determining whether product teams can serve data in real time

• Cut storage and compute costs materially by using AI-assisted analysis (pganalyze paired with Claude) to detect compression and data-model opportunities, then shipping validated changes to production

• Remove team toil by building agentic automation for routine database operations, such as self-serve pgbouncer provisioning, disk scaling, and blue-green deployments, so any engineer can run them safely

• Protect data integrity and latency by driving agentic validation of database changes before they reach production

• Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and using AI tooling to debug replication failures faster

• Shape the next-generation platform by migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes

• Raise the whole team's leverage by codifying your workflows into AI-native runbooks and internal tooling that teammates reuse

What we're looking for:

• 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), increasingly paired with AI-assisted query analysis

• Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte) and comfort using AI tooling to debug replication failure modes

• Fluency with database profiling (pganalyze or equivalent) to interpret metrics and logs, including using LLMs to summarize performance findings

• Production automation experience in Python or Go, including agentic automation of routine database tasks; Postgres extension development is a plus

• Daily use of AI coding tools (Claude, Copilot) to accelerate development and produce higher-quality output faster, with the judgment to know when to trust or reject AI output

• A track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems

About the Team:

• The Data Platform team is distributed, not distant. We operate async-first across US and Canada working hours with intentional synchronous touchpoints when speed demands it

• We own the petabyte-scale data infrastructure that powers TRM's products. The scope is large, the mission is real, and the work is technically demanding

• Team culture is product-focused, customer-focused, coaching-oriented, scrappy when needed, and process-oriented when executing against OKRs

• You will work alongside senior engineers who care deeply about their craft and hold high standards for code quality, operational excellence, and cross-team communication

Team Operating Rhythms:

• Distributed, not distant: most collaboration happens async in Slack, Notion, and GitHub, and meetings are purposeful and minimal

• Primary timezone overlap across US and Canada working hours; our north star is no IC spending more than 3–4 hours per week in meetings

• Written-first culture: technical specs and decision docs drive alignment before code

Work Week Travel: This role requires participation in in-person R&D work weeks, typically 1–2 times per quarter, at a TRM hub or other designated location. Work weeks may be scheduled with as little as 14 days’ notice, and some roles may require additional travel based on team and cross-functional needs. TRM coordinates and covers approved travel, lodging, and workspace. Accommodations are available for legitimate caregiving, health, immigration, and similar constraints.

Life at TRM

We are building a safer world. That promise shows up in how we work every day.

TRM moves FAST. We are a high-velocity, high-ownership team that expects clarity, follow-through, and impact. People who thrive here are energized by hard problems, experimentation, and continuous feedback. If something takes months elsewhere, it will ship here in days.

Our work sits at the intersection of AI, national security, and fighting crime. The problems are complex, the stakes are real, and the environment evolves quickly. The pace and intensity of the work reflect the importance of the mission. As a result, the way we operate requires a high level of ownership, adaptability, collaboration, and creative problem-solving.

At TRM, you should expect:

• Priorities and targets to change quickly

• Operating with a high degree of autonomy and accountability

• A focus on impact, collaboration, and learning

• An emphasis on continuous feedback and improvement

• A culture that values inclusivity, curiosity, and ethical responsibility

If you’re excited by the challenge of building scalable data infrastructure at petabyte scale and collaborating with a team that values craftsmanship, apply to join TRM and help us build a safer world.