Senior Software Engineer, Data Infrastructure (RDBMS)

Postgres
UNITED STATES
October 25, 2026
Full Time
Apply Now

Job Description

Company: TRM Labs
Location: Remote (US and Canada)
Workplace Type: Remote
Employment Type: Full-time
Pay / Compensation: $200,000 – $220,000 USD base salary + equity

About the Role

TRM Labs provides AI-powered intelligence solutions that help public and private sector agencies investigate and disrupt crime. 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 owns the serving layer end to end, from query performance to cost to availability.

What You’ll Do / Key Responsibilities

  • Query & Schema Optimization: Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale PostgreSQL / Citus.
  • Cost & Performance Tuning: Cut storage and compute costs materially by using AI-assisted analysis (pganalyze paired with Claude) to detect compression and data-model opportunities.
  • Database Automation: Remove team toil by building agentic automation for routine database operations, such as self-serve pgbouncer provisioning, disk scaling, and blue-green deployments.
  • Replication & CDC Management: Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and using AI tooling to debug replication failures.
  • Platform Migration: Shape the next-generation platform by migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes.

Requirements & 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) to interpret metrics and logs.
  • Production automation experience in Python or Go, including agentic automation of routine database tasks.
  • Daily use of AI coding tools (Claude, Copilot) to accelerate development and operational workflows.

Preferred / Bonus Qualifications

  • Experience with Postgres extension development.
  • Track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems.

Benefits & Perks

  • Competitive base salary ranging from $200,000 to $220,000 (US base salary).
  • Participation in TRM’s equity plan.
  • Distributed-first work environment with async-first collaboration across US and Canada working hours.
  • Approved travel, lodging, and workspace coverage for quarterly in-person R&D work weeks.

Related Jobs