Drimva

TRM Labs

Senior Software Engineer, Database Engineer

$200K–$220K

North America +1 · Remote · Senior · Full-time · Posted Sep 23, 2026

Location
North America
United States
Experience
5–8 years building and operating production PostgreSQL.

About the job

Develops and operates TRM’s petabyte-scale relational database serving layer, improving query performance, availability, cost efficiency, and operational automation.

What you'll do

  • Tune queries, indexes, and schemas to keep customer-facing APIs fast and available.
  • Automate routine database operations and validate changes before production; manage CDC pipelines and debug replication issues.
  • Identify and deliver database cost and performance improvements, and help migrate workloads and prototype data stores.

What they ask for

  • 5–8 years building and operating production PostgreSQL, including Citus, Aurora, AlloyDB, or equivalent distributed Postgres.
  • Strong SQL optimization skills, including Explain Plans, CTEs, window functions, partitioning, index design, and distributed query-planner behavior.
  • Hands-on CDC experience and database profiling; production automation in Python or Go.
  • Daily use of AI coding tools and a track record of AI-assisted cost or performance improvements in production database systems.

Nice to have

  • Postgres extension development.

Pay

$200,000 - $220,000 USD base salary

Tools

PostgreSQL, Citus, Aurora, AlloyDB, PeerDB, Fivetran, Debezium, Python

AI focus

Uses AI-assisted analysis and coding tools to optimize database costs and performance, debug replication failures, automate operations, validate database changes, and build AI-native runbooks and tooling.

Model-written summary · the original posting is authoritative

First seen Oct 29, 2026 · Last verified Nov 4, 2026 (UTC)