Senior Software Engineer Data Infrastructure RDBMS LATAM
Blockchain intelligence company providing tools to detect, investigate, and manage crypto-related fraud, financial crime, and compliance for institutions and government agencies.
Funding history
Investors
About TRM Labs
TRM Labs provides blockchain intelligence for investigations and compliance, offering products such as forensics, wallet screening, entity screening, transaction monitoring, and APIs. It serves financial institutions, crypto businesses, and public sector agencies to trace funds, assess risk, and build cases across digital assets.
Skills
Candidate Availability
Required and preferred rules are kept separate and reflect the wording in the original posting.
About the Role
You will own relational database serving infrastructure end to end, including query performance, availability, cost, indexing, schemas, CDC pipelines, and production automation. You will build database tooling, validate changes, troubleshoot replication, migrate infrastructure, prototype data stores, and participate in an on-call rotation and periodic work weeks.
Requirements
- 5–8 years of experience building and operating production PostgreSQL or distributed PostgreSQL
- Deep SQL optimization skills, including explain plans, CTEs, window functions, partitioning, index design, and query-planner behavior
- Experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
- Experience with database profiling tools such as pganalyze
- Production automation experience in Python or Go
- Daily use of AI coding tools such as Claude or Copilot
- Experience using AI-assisted analysis to improve database cost or performance
Responsibilities
- Tune queries, design indexes, and optimize schemas
- Use database analysis to identify compression and data-model opportunities
- Build automation for database operations
- Validate database changes before production
- Manage CDC pipelines and troubleshoot replication failures
- Migrate workloads and prototype data stores
- Create reusable runbooks and internal tooling
- Participate in an on-call rotation
- Participate in in-person R&D work weeks
Benefits
- Approved travel, lodging, and workspace coverage for work weeks
Hiring Process
Recruiter intro → hiring manager interview → 1–2 first-round interviews → panel-style hands-on case study final round → references → offer.
