TRM Labs
Senior Software Engineer Data Infrastructure RDBMS
North AmericaFull-timeGlobal
š° USD 200,000 - 220,000/yr
š Midš Remote
Job Description
[AI-summarized by JobStash]
You will design and maintain petabyte-scale, high-performance databases and data models to support real-time investigations and analytics. You will build and optimize production data pipelines (batch and streaming), diagnose and tune complex SQL queries under heavy load, and own infrastructure initiatives from query optimization and index strategy to storage optimization and system resilience. You will create self-serve automation for tasks like pgbouncer provisioning and cluster scaling, deliver fast observable solutions, and collaborate cross-functionally to deploy reliable end-to-end data workflows.
Requirements
- ā5+ years of experience in data engineering, analytics infrastructure, or backend systems with RDBMS depth
- āExperience implementing and maintaining database security measures including access control, encryption, and compliance with security frameworks and standards
- āProven expertise with at least one of Postgres, MySQL, or SQL Server at production scale
- āStrong command of SQL reasoning and the ability to debug, explain, and optimize queries
- āExperience designing and evolving data models (normalized and denormalized) for analytical or operational use cases
- āFamiliarity with data pipeline frameworks such as Airflow, DBT, or custom orchestration
- āSystems thinking and an ownership mindset for solving ambiguous, cross-functional problems end to end
Responsibilities
- āDesign and maintain petabyte-scale high-performance databases and data models
- āBuild and optimize production data pipelines for batch and streaming data
- āDiagnose, explain, and tune complex SQL queries under heavy load
- āOwn infrastructure initiatives including query optimization, index strategy, storage optimization, and system resilience
- āCollaborate cross-functionally to deliver reliable end-to-end data workflows
- āCreate self-serve automation for provisioning and scaling (e.g., pgbouncer, disk and cluster scaling)
- āDeliver quick, observable first versions of projects and iterate based on stakeholder feedback
Benefits & Perks
- āEquity plan
Tech Stack
MySQLAirflowbatch processingSQL Serverquery optimizationRDBMSIndexingdata modelautomationorchestration