Senior PostgreSQL Data Infrastructure Engineer

TRM Labs; Oregon; Hybrid; USD 180,000 - 230,000; Full time

Job summary

TRM Labs is hiring a Senior Software Engineer on the Data Platform team. You will own the relational data infrastructure at petabyte scale, focusing on serving layer, performance, and reliability.

You'll optimize PostgreSQL deployments (Citus/ Aurora-like) and automate common database operations using Python/Go, guided by AI-assisted analysis to reduce costs and improve throughput. This role supports a distributed-first, async-friendly workflow with occasional on-site weeks.

Qualifications

• 5-8 years building and operating production PostgreSQL (distributed Postgres) systems.
• Strong SQL optimization skills and understanding of query plans.
• Experience with CDC tools and data pipelines.

Responsibilities

• Own serving layer end-to-end for relational data at scale, balancing performance, cost, and availability.
• Tune queries, design indexes, and optimize schemas for petabyte-scale workloads.
• Automate routine database tasks and improve data-platform reliability with AI-assisted tooling.

Skills

PostgreSQL

SQL optimization

AI-assisted analysis

Python

Go

Tools

PeerDB

Fivetran

Debezium

Datastream

Airbyte

pgbouncer

Job description

TRM Labs is hiring a Senior Software Engineer on the Data Platform team. You will own the relational data infrastructure at petabyte scale, focusing on serving layer, performance, and reliability.

You'll optimize PostgreSQL deployments (Citus/ Aurora-like) and automate common database operations using Python/Go, guided by AI-assisted analysis to reduce costs and improve throughput. This role supports a distributed-first, async-friendly workflow with occasional on-site weeks.