Senior Software Engineer – Data Infrastructure (RDBMS)

Postgres
UNITED STATES
October 25, 2026
Full Time
Apply Now

Job Description

Company: TRM Labs
Location: Remote (US/Canada)
Workplace Type: Remote
Employment Type: Full-time

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, on infrastructure that product teams depend on every day.

What You’ll Do / Key Responsibilities

  • Query and Schema Optimization: Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus.
  • Cost Reduction and Analysis: 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.
  • Change Management: Protect data integrity and latency by driving agentic validation of database changes before they reach production.
  • Replication Management: Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and debugging replication failures.

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.

Preferred / Bonus Qualifications (if applicable)

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

Benefits & Perks (if applicable)

  • Distributed-first working environment with intentional sync touchpoints.
  • Participation in in-person R&D work weeks 1–2 times per quarter at a TRM hub.
  • Comprehensive travel, lodging, and workspace coverage for official gatherings.

Related Jobs