T

TRM Labs

Blockchain analytics for financial crime

Senior Software Engineer - Data Infrastructure, RDBMS

Database AdministrationConfirmed live in the last 24 hours
Full-time

About the Job

Requirements

  • Have 5–8 years of experience building and operating production PostgreSQL, including Citus, Aurora, AlloyDB, or equivalent distributed PostgreSQL.
  • Have deep SQL optimization skills, including Explain Plans, common table expressions, window functions, partitioning, index design, and query-planner behavior in distributed environments, increasingly paired with AI-assisted query analysis.
  • Have hands-on experience with change data capture tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte, and use AI tooling to debug replication failure modes.
  • Be fluent with database profiling using pganalyze or an equivalent, interpreting metrics and logs, including using large language models to summarize performance findings.
  • Have production automation experience in Python or Go, including agentic automation of routine database tasks.
  • Use AI coding tools such as Claude or Copilot daily to accelerate development and produce higher-quality output, exercising judgment about when to trust or reject AI output.
  • Have a track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems.
  • Use AI to accelerate repeatable workflows, structure and solve problems, improve output quality, and increase speed and leverage; applied AI fluency will be evaluated during interviews.

Responsibilities

  • Develop, operate, and scale relational database systems serving data at petabyte scale.
  • Own the database serving layer end to end, including query performance, cost, and availability.
  • Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus.
  • Use AI-assisted analysis with pganalyze and Claude to identify compression and data-model opportunities, then ship validated changes to production to reduce storage and compute costs.
  • Build agentic automation for routine database operations, including self-serve pgbouncer provisioning, disk scaling, and blue-green deployments, enabling engineers to run them safely.
  • Drive agentic validation of database changes before they reach production to protect data integrity and latency.
  • Manage change data capture pipelines using PeerDB, Fivetran, and Debezium, and use AI tooling to debug replication failures.
  • Migrate workloads off first-generation infrastructure and prototype new data stores using AI-accelerated spikes.
  • Codify workflows into AI-native runbooks and internal tooling for teammates to reuse.
  • Coordinate schema changes across three product-engineering teams in parallel and deliver platform changes ahead of product deadlines.
  • Participate in an on-call rotation approximately once every 15 days, with each shift a 24-hour window across two days.
  • Participate in in-person R&D work weeks, typically one to two times per quarter, at a TRM hub or other designated location; additional travel may be required based on team and cross-functional needs.

Desired Qualifications

  • PostgreSQL extension development experience.

About the Company

TRM Labs

Blockchain analytics for financial crime

TRM Labs provides blockchain intelligence tools for financial institutions, crypto businesses, and government agencies to detect and investigate crypto-related financial crime and fraud. It analyzes blockchain activity using data engineering, data science, and threat intelligence to surface risk signals, enable investigations, and support compliance workflows. Its products combine on-chain and off-chain data, risk scoring, and case management through subscription services and customized solutions. Compared to others, TRM Labs serves a diverse client base (banks, exchanges, regulators) and emphasizes end-to-end investigative capabilities and tailored risk insights rather than generic analytics. The company’s goal is to improve the security and integrity of the global financial system by reducing illicit activity in the crypto space.

Company size
201-500
Company stage
Series C
Total funding
$220M
Headquarters
San Francisco, CA
Founded
2018

Recently Posted Jobs

Explore more opportunities at TRM Labs

See more jobs