Senior Software Engineer, Data Infrastructure (RDBMS) (LATAM)

As a Senior Software Engineer on Data Infrastructure at TRM Labs, you build and operate the relational database systems that serve data at petabyte scale for the company's AI-powered intelligence platforms. You own the serving layer end to end, from query performance to cost to availability, on infrastructure that product teams depend on every day to help investigators trace illicit activity and disrupt crime.

What you'll do

• Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres and Citus, directly determining whether product teams can serve data in real time
• Cut storage and compute costs materially by using AI-assisted analysis with 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 using PeerDB, Fivetran, and 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 you bring

• 5-8 years building and operating production PostgreSQL, including Citus, Aurora, AlloyDB, or equivalent distributed Postgres systems
• Deep SQL optimization skills including Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments, increasingly paired with AI-assisted query analysis
• Hands-on experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, and Airbyte, and comfort using AI tooling to debug replication failure modes
• Fluency with database profiling tools like pganalyze 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
• Daily use of AI coding tools such as Claude and Copilot to accelerate development and produce higher-quality output faster, with the judgment to know when to trust or reject AI output
• A track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems

What we offer

• Participation in on-call rotation approximately once every 15 days (each shift is a 24-hour window across 2 days; on-call for United States is confirmed, Canada portion pending regional compliance review)
• Participation in in-person R&D work weeks, typically 1-2 times per quarter at a TRM hub or designated location, with travel, lodging, and workspace covered by TRM
• Distributed work across US and Canada timezones with async-first operations and intentional synchronous touchpoints when speed demands it
• A written-first culture where technical specs and decision docs drive alignment before code

About TRM Labs

TRM Labs is a Series C company with $220M in total funding backed by Goldman Sachs, Bessemer, Y Combinator, Thoma Bravo, and others. TRM provides AI-powered intelligence solutions that help public and private sector agencies investigate and disrupt crime. Headquartered in San Francisco, TRM operates as a distributed-first company with hubs in Los Angeles, San Francisco, New York, Washington D.C., London, and Singapore.