Senior Software Engineer, Database Engineer

TRM Labs

. Develop, operate, and scale relational database systems serving data at petabyte scale .

Posted 9/23/2026full-timeRemote • United States, CanadaSenior💰 $200,000 - $220,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and operating production PostgreSQL systems, with a strong focus on SQL optimization, automation, and AI-assisted analysis to enhance performance and cost efficiency. Proficient in managing complex database operations and collaborating across teams to ensure seamless integration and deployment.

Highest-signal resume keywords

PostgreSQL Database ManagementSQL OptimizationCDC Tools ExperienceProduction Automation in Python or GoAI-Assisted Analysis

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

PostgreSQLCitusSQL OptimizationQuery Performance TuningIndex DesignCDC ToolsAI Coding ToolsDatabase ProfilingAutomation ScriptingData Migration

Soft Skills

CollaborationProblem-SolvingCommunication

Tools & Technologies

PeerDBFivetranDebeziumPganalyzePgbouncer

Industry Keywords

Petabyte ScaleDistributed DatabasesData ModelingBlue-Green DeploymentsOn-Call Rotation

Tech Stack

Tools & technologies

PostgresPythonSQLGo

About the role

Key responsibilities & impact

Develop, operate, and scale relational database systems serving data at petabyte scale
Own the database serving layer end to end, including query performance, cost, and availability
Tune queries, design indexes, and optimize schemas for petabyte-scale Postgres/Citus
Use AI-assisted analysis to identify compression and data-model opportunities and ship validated production changes
Build agentic automation for database operations such as pgbouncer provisioning, disk scaling, and blue-green deployments
Validate database changes before production deployment
Manage CDC pipelines using PeerDB, Fivetran, and Debezium and debug replication failures
Migrate workloads from first-generation infrastructure and prototype new data stores
Create AI-native runbooks and internal tooling
Collaborate asynchronously across US and Canada working hours
Coordinate schema changes across multiple product-engineering teams
Participate in an on-call rotation

Requirements

What you’ll need

5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres)
Deep SQL optimization skills, including Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments
Hands-on experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
Fluency with database profiling using pganalyze or equivalent
Production automation experience in Python or Go
Daily use of AI coding tools such as Claude or Copilot
Track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems
Ability to participate in an on-call rotation approximately once every 15 days, subject to regional compliance review

Benefits

Comp & perks

Equity plan eligibility
AI coding tools and AI-native internal tooling
Distributed remote work across US and Canada working hours
Async-first, written-first work culture
Minimal, purposeful meetings
Professional growth through coaching and collaboration
Reasonable accommodations for applicants with disabilities