Senior Software Engineer, Database Engineer
TRM Labs · Remote · North America · United States ·
COMPENSATION
€•• – ••k
Listed on the employer's job board (Ashby)
- Senior level role
- Fully remote (US/Canada)
- PostgreSQL & Citus
- AI-driven optimization
- On-call rotation
Join the Data Platform team at TRM Labs to build and scale the relational database systems that power crime investigation tools. You will own the serving layer end-to-end, ensuring high availability and low latency for product teams handling illicit activity data.
The work involves deep technical challenges in query tuning, schema optimization, and CDC pipeline management. You will leverage AI tools to drive efficiency, automate routine tasks, and improve system reliability across a distributed engineering organization.
What you'll do
- Tune queries and design indexes for petabyte-scale Postgres/Citus systems
- Reduce storage and compute costs using AI-assisted data analysis
- Build agentic automation for routine database operations like scaling
- Manage CDC pipelines using tools like PeerDB, Fivetran, and Debezium
- Migrate workloads from legacy infrastructure to next-generation platforms
- Create AI-native runbooks and internal tooling for team efficiency
- Validate database changes before production to ensure data integrity
What you'll need
- 5–8 years of experience operating production PostgreSQL environments
- Deep expertise in SQL optimization and distributed query planning
- Hands-on experience with CDC tools such as Debezium or Fivetran
- Proficiency in Python or Go for production automation tasks
- Daily use of AI coding tools like Claude or Copilot for development
- Ability to interpret database profiling metrics and performance logs
- Track record of driving cost or performance improvements in production
Nice to have
- Experience developing PostgreSQL extensions
- Familiarity with AlloyDB or Aurora distributed Postgres variants
Stack
- PostgreSQL
- Citus
- Python
- Go
- Claude
- Copilot
- PeerDB
- Fivetran
- Debezium
- pganalyze
How you'll work
- Distributed team with async-first collaboration culture
- Primary timezone overlap required with US and Canada hours
- On-call rotation approximately once every 15 days
- In-person R&D work weeks 1–2 times per quarter
- Travel and lodging covered for required work weeks
What you get
- Base salary range between $200,000 and $220,000 USD
- Eligibility to participate in company equity plan
- Coverage for approved travel and accommodation costs
- Accommodations available for caregiving or health needs
Hiring process
- Recruiter intro to discuss qualifications and motivations
- Hiring manager interview focusing on relevant experience
- One or two technical rounds assessing critical skills
- Final round featuring a hands-on case study panel
- Reference checks with former colleagues
- Offer presentation and onboarding