Senior Software Engineer, Data Infrastructure (RDBMS)

TRM Labs provides blockchain analytics and AI solutions to help various agencies and businesses combat crypto-related fraud and financial crime. The role involves developing and managing scalable database infrastructure to support TRM's products and services, enhancing the safety of financial systems.

Responsibilities:

• Design and maintain petabyte scale high-performance databases and data models that support real-time investigations and analytics use cases
• Build and optimize production data pipelines—batch and streaming—that transform large-scale blockchain datasets
• Diagnose and tune complex SQL queries under heavy load, working closely with product and research teams
• Own key infrastructure initiatives—from query optimization and index strategy to storage optimization and system resilience
• Collaborate cross-functionally to deliver reliable and impactful data workflows end-to-end

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 (e.g., TB-scale datasets, concurrency, replication, tuning)
• Strong command of SQL reasoning—you know how to debug, explain, and optimize queries, not just write them
• Experience designing and evolving data models (normalized and denormalized) to support analytical or operational use cases
• Familiarity with data pipeline frameworks (e.g., Airflow, DBT, custom orchestration)
• Systems thinking and ownership mindset—you're comfortable solving ambiguous, cross-functional problems from end to end