Senior Software Engineer, Database Infrastructure

At TRM, we're on a mission to build trust in digital assets, because the promise of crypto is too valuable to be impeded by bad actors. We provide a blockchain intelligence platform to law enforcement, financial institutions, and crypto firms to assist in the detection and prevention of cryptocurrency fraud and financial crime. Our vision is to build a company that can sustainably deliver on our mission for decades to come, enabling consumers to transact safely and securely on the blockchain.

The Data Platform team collaborates with an experienced group of data scientists, engineers, and product managers to build highly available and scalable data infrastructure for TRM's products and services. As a Sr Database Infrastructure Engineer on the Data Platform team, you will be responsible for executing mission-critical systems and data services that analyze blockchain transaction activity at petabyte scale, and ultimately work to build a safer financial system for billions of people.

The impact you will have here

• Regularly review and analyze the current codebase to detect performance bottlenecks and anti-patterns that can hinder application scalability.
• Design and implement prototype solutions to address identified issues. These prototypes should be able to serve as benchmarks for broader application performance improvements.
• Work closely with the Data Product Team to share findings, solutions, and recommendations. Evangelize the importance of performance optimization within the team, ensuring alignment on best practices and solutions.
• Conduct performance experiments and benchmarks, using the results to guide the team and shape the future technical roadmap for the serving layer.
• Evaluate the current state of the petabyte scale Postgres Cluster, including configurations, data structures, and dependencies.
• Develop and establish a long-term technical roadmap, setting the direction for future infrastructure enhancements and innovations.

What we're looking for:

• Bachelor's degree (or equivalent) in Computer Science or related field;
• 8+ years of experience;
• Ability to write complex SQL queries;
• Strong skills in one or more programming languages;
• Knowledge of RDBMS Architectures;
• Familiarity with database profiling tools specific to the RDBMS (SQL Server Profiler, Oracle's AWR, or MySQL's Performance Schema);
• Experience with ORM tools (Hibernate, Entity Framework, or Sequelize);
• Knowledge of normalization and denormalization techniques.