Latest AI JobsBrowse Jobs
TRM Labs logo

Senior Software Engineer, Data Infrastructure (RDBMS)

TRM LabsNorth AmericaR&D
Apply on company site
Salary
$200K - $220K USD
Job type
Full-time
Work mode
Remote
Posted
22 Sept 2026
Status
Open · checked 7d ago

About this role

Role Overview

TRM Labs seeks a Senior Software Engineer for Data Infrastructure (RDBMS) to develop, operate, and scale relational database systems that serve petabyte-scale data. This fully remote position is based in North America and suits an experienced engineer who wants to build resilient financial and national security intelligence infrastructure.

Key Responsibilities

Maintain fast, highly available customer-facing APIs by managing query tuning, index design, and schema optimization on petabyte-scale Postgres and Citus environments.
Reduce storage and compute expenses by leveraging AI-assisted analysis via pganalyze and Claude to identify compression and data-model opportunities.
Develop agentic automation for standard database procedures like self-serve pgbouncer provisioning, disk scaling, and blue-green deployments to eliminate toil.
Ensure data integrity and optimal latency through agentic validation of database modifications prior to production releases.
Supervise change data capture (CDC) pipelines using tools such as PeerDB, Fivetran, and Debezium while utilizing AI solutions to resolve replication errors quickly.
Guide the next-gen platform evolution by transitioning workloads away from legacy infrastructure and prototyping new data stores through AI-accelerated spikes.
Scale team efficiency by documenting workflows into AI-native runbooks and internal tooling for shared use.

Requirements

Five to eight years of direct experience building and running production PostgreSQL systems, including Citus, Aurora, AlloyDB, or comparable distributed Postgres architectures.
Advanced SQL optimization capabilities encompassing Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed setups.
Practical background with CDC tools like PeerDB, Fivetran, Debezium, Datastream, or Airbyte, alongside familiarity using AI tooling to troubleshoot replication issues.
Proficiency in database profiling using pganalyze or similar platforms to interpret logs and metrics, including LLM-driven performance summaries.
Production automation fluency in Python or Go, featuring agentic automation for routine database maintenance.
Routine integration of AI coding assistants like Claude or Copilot to drive development velocity and output quality.
Demonstrated history of employing AI-assisted analysis to achieve measurable performance or cost gains in production database systems.

Skills and Tools

Python
SQL
PostgreSQL and Citus
PeerDB, Fivetran, Debezium
pganalyze
Claude and GitHub Copilot
Go

Salary and Benefits

Estimated US base salary range sits between $200,000 and $220,000.
Potential eligibility to participate in the company equity plan.
Compensation adjusted to account for geographic differences outside the United States.

About the Company

TRM Labs delivers AI-powered intelligence platforms that empower public and private sector organizations to investigate and disrupt illicit financial activity and threat networks. Headquartered in San Francisco with a distributed-first operational model across multiple international hubs, the company is backed by prominent investors including Goldman Sachs, Bessemer, Y Combinator, and Thoma Bravo.

How to Apply

Interested candidates should submit their application directly through the official TRM Labs careers page for review by the talent team.

Skills and tech stack

PythonSQL

Questions candidates ask

What is the primary focus of this role?

The role focuses on developing, operating, and scaling petabyte-scale relational database systems, managing the serving layer end-to-end from query performance to availability.

Is this position remote?

Yes, this role is remote with a location scope of North America, operating in an async-first distributed environment across US and Canada working hours.

What is the expected salary range for US candidates?

The estimated base salary range for US-based candidates is between $200,000 and $220,000, with potential eligibility for TRM's equity plan.

What specific technical background is required?

Candidates need 5 to 8 years of experience building and operating production PostgreSQL environments, deep SQL optimization skills, CDC tooling experience, and proficiency in Python or Go.

How does TRM Labs incorporate AI into daily work?

AI fluency is a baseline expectation at TRM Labs, with team members expected to use tools like Claude and Copilot for accelerating workflows, database profiling, query analysis, and automation.

Ready to apply?

The application is on the official TRM Labs careers page.

Apply on company site