Senior Software Engineer, Data Infrastructure (RDBMS)

TRM Labs
United States
Workplace: RemoteFull timeUSD 200,000 - 220,000 annuallyFunction: Software EngineeringExperience: 5-8 yearsSkills: ["Ownership","Operational excellence","Cross-team communication","Problem-solving","Judgment"]

Build and operate relational database systems that power TRM’s AI-powered data platform at petabyte scale. Own the serving layer end to end—query tuning, index design, schema optimization, and availability/cost tradeoffs—on distributed Postgres (e.g., Postgres/Citus, Aurora, AlloyDB). Use AI-assisted tools (pganalyze with Claude) for cost/performance improvements, automate routine DB operations, and manage CDC pipelines (PeerDB, Fivetran, Debezium) while improving reliability and latency.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
TRM Labs
TRM Labs
1 day ago

Senior Software Engineer, Data Infrastructure (RDBMS)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 36 minutes agoStatus: Live
Reposted: similar role first listed 2 years ago

Job Summary

Build and operate relational database systems that power TRM’s AI-powered data platform at petabyte scale. Own the serving layer end to end—query tuning, index design, schema optimization, and availability/cost tradeoffs—on distributed Postgres (e.g., Postgres/Citus, Aurora, AlloyDB). Use AI-assisted tools (pganalyze with Claude) for cost/performance improvements, automate routine DB operations, and manage CDC pipelines (PeerDB, Fivetran, Debezium) while improving reliability and latency.
Location: United States
Workplace: Remote
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Own the relational database serving layer end to end, ensuring customer-facing APIs are fast and highly available (five-nines) via query tuning, index design, and schema optimization.
  • •Reduce storage and compute costs by using AI-assisted analysis (pganalyze with Claude) to detect compression/data-model opportunities and shipping validated production changes.
  • •Remove engineering toil by building agentic automation for routine database operations like pgbouncer provisioning, disk scaling, and blue-green deployments.
  • •Protect data integrity and latency by driving agentic validation of database changes before production rollout.
  • •Manage CDC pipelines (PeerDB, Fivetran, Debezium) and use AI tooling to debug replication failures faster.

Pay and Benefits

Salary: USD 200,000 - 220,000 annually
Equity and Bonus:Equity

Key Requirements

  • •5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres).
  • •Deep SQL optimization skills, including Explain Plans and partitioning/index design for distributed query-planner behavior.
  • •Hands-on experience with CDC tools such as PeerDB, Fivetran, Debezium (and others listed), plus ability to debug replication failures.
  • •Fluency with database profiling using pganalyze (or equivalent) and using LLMs to summarize performance findings.
  • •Production automation experience in Python or Go, including agentic automation for routine database tasks (Postgres extension development is a plus).
Experience:5-8 yearsDistributed databasesProduction engineeringData infrastructureAI-assisted operationsCDC
Skills:OwnershipOperational excellenceCross-team communicationProblem-solvingJudgment
Tech Stack:PostgreSQLCitusAuroraAlloyDBSQLExplain PlansCTEsWindow functionsPartitioningIndex designQuery plannerPganalyzeClaudeCopilotPythonGoPostgres extensionCDCPeerDBFivetran

Company Brief

TRM Labs
Provides blockchain intelligence and crypto risk management solutions to help financial institutions, governments, and crypto firms detect fraud, trace illicit activity, and comply with regulatory requirements across digital asset ecosystems.
Industry: RegTech
Company Size: Large (251 to 1,000 employees)
Growth: Growth Stage Startup
Headquarters: San Francisco, United States
Founded: 2018
WebsiteLinkedIn