Senior Software Engineer, Data Infrastructure (RDBMS)

The posting, as TRM Labs wrote it

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 a

[…]
privacy-policy.

We collect the information you provide (such as your resume, work history, and contact details) solely for the purpose of evaluating your candidacy for current and future roles at TRM.

Because our hiring cycles for certain positions may span 24 to 36 months, we retain your personal information for up to 36 months from the date of your application. After that period, your data is deleted unless a different retention period is required or permitted by law.

If you are located in the European Economic Area, the United Kingdom, or another jurisdiction with applicable data protection laws, you have the right to access, correct, or request deletion of your personal data at any time before that period ends. To exercise any of these rights, contact us at privacy@trmlabs.com.

To notify TRM Labs that you believe this job posting is non-compliant, please submit a report through this form https://docs.google.com/forms/d/e/1FAIpQLSc6e8jRCl2cQwgIzXLpIGQXtwvMQh__TcokvO2toAAkT44A6Q/viewform?usp=dialog. No response will be provided to inquiries unrelated to job posting compliance.

The use of AI tools of any kind (including but not limited to notetakers, interview assistants, and real-time coaching tools such as Otter.ai, Fireflies, Fathom, Cluey, or similar) during TRM interviews is not permitted without prior approval from TRM. TRM uses its own internal tools for note-taking to ensure a consistent and confidential experience for all candidates.

We are committed to providing reasonable accommodations to applicants with disabilities, and requests can be made via this form https://docs.google.com/forms/d/e/1FAIpQLSevmAzPxWOYm_7kMHb9lEJlX3tpdBeHvvvNWjsI_6xhUfnXjw/viewform?usp=dialog.

RECRUITMENT AGENCIES

TRM Labs does not accept unsolicited agency resumes. Please do not forward resumes to TRM employees. TRM Labs is not responsible for any fees related to unsolicited resumes and will not pay fees to any third-party agency or company without a signed agreement.