Senior Data Infrastructure Engineer – Postgres at Petabyte Scale

TRM Labs; United States; Remote; USD 140.000 - 210.000; Vollzeit

Zusammenfassung

TRM Labs is hiring a Senior Software Engineer for Data Infrastructure to scale petabyte-scale PostgreSQL systems and build AI-assisted optimization. You will own the serving layer from performance to availability, driving cost savings and reliability.

The role emphasizes automation and collaboration with product teams across the US and Canada. Ideal candidates have 5–8 years in production PostgreSQL, deep SQL skills, and hands-on experience with CDC tools and distributed data stores.

Qualifikationen

• 5–8 years building and operating production PostgreSQL in distributed environments.
• Strong SQL optimization, including Explain Plans, window functions, and partitioning.
• Hands-on with CDC tools and AI-assisted performance analysis.
• Production automation in Python or Go; SQL tooling experience a plus.

Aufgaben

• Own serving layer end-to-end, optimizing query performance and availability.
• Tune and design indexes, schemas, and data models for petabyte-scale data.
• Automate routine DB tasks and validate changes before production rollout.
• Collaborate across product teams to reduce costs and improve reliability.

Kenntnisse

PostgreSQL

SQL optimization

CDC tools

Python

Go

AI tooling

Distributed Postgres

Tools

pgbouncer

PeerDB

Fivetran

Debezium

Datastream

Airbyte

Jobbeschreibung

TRM Labs is hiring a Senior Software Engineer for Data Infrastructure to scale petabyte-scale PostgreSQL systems and build AI-assisted optimization. You will own the serving layer from performance to availability, driving cost savings and reliability.

The role emphasizes automation and collaboration with product teams across the US and Canada. Ideal candidates have 5–8 years in production PostgreSQL, deep SQL skills, and hands-on experience with CDC tools and distributed data stores.