Senior Software Engineer, Database Engineer

Postgres
UNITED STATES
October 16, 2026
Full Time
Apply Now

Job Description

Company: TRM Labs
Location: United States
Workplace Type: Remote
Employment Type: Full-time
Pay / Compensation: $200,000 – $220,000

About the Role

TRM Labs provides AI-powered intelligence solutions to help public and private organizations investigate and disrupt financial crime. The Data Platform team builds and manages scalable data infrastructure. In this role, you will develop, operate, and scale relational database systems supporting petabyte-scale data, owning query performance, cost, and availability.

What You’ll Do / Key Responsibilities

  • Maintain customer-facing APIs at five-nines availability through query tuning, indexing, and schema optimization on Postgres/Citus.
  • Reduce storage and compute costs using profiling tools and AI-assisted analysis to identify optimizations.
  • Automate routine database operations including pgbouncer provisioning, disk scaling, and blue-green deployments.
  • Validate database changes to safeguard data integrity and low latency prior to production deployment.
  • Maintain and debug CDC data replication pipelines using tools such as PeerDB, Fivetran, and Debezium.
  • Assist in modernizing database infrastructure and prototyping next-generation datastores.
  • Document operational workflows into runbooks and internal tools for team reuse.
  • Participate in an on-call rotation to maintain database availability and resolve production incidents.

Requirements & Qualifications

  • 5 to 8 years of experience building and operating production PostgreSQL environments (Citus, Aurora, AlloyDB).
  • Advanced SQL optimization expertise including execution plans, window functions, partitioning, and indexing.
  • Experience managing change data capture (CDC) pipelines (PeerDB, Fivetran, Debezium, Datastream, Airbyte).
  • Proficiency with database performance profiling tools like pganalyze to interpret metrics and execution logs.
  • Experience automating database tasks using Python or Go.
  • Familiarity using AI-assisted coding tools to accelerate workflows and analyze performance data.

Preferred / Bonus Qualifications

  • Experience developing custom PostgreSQL extensions.
  • Proven track record optimizing storage costs and query efficiency in large-scale distributed databases.

Benefits & Perks

  • Competitive salary with equity plan participation.
  • Remote-first working environment with travel covered for quarterly team R&D work weeks.
  • Comprehensive health and employee support benefits.

Equal Opportunity Employer: TRM Labs considers all qualified applicants without discrimination. Accommodations are available upon request for applicants with disabilities.

Related Jobs