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 Staff 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'll 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.
• Maintain detailed records of identified issues and solutions, creating a knowledge base that can assist current and future team members.
• Evaluate the current state of the Petabyte Scale Postgres on the EC2 Cluster, including configurations, data structures, and dependencies.

 

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.

 

About TRM's Engineering Levels:

 

 

Engineer: Responsible for helping to define project milestones and executing small decision decisions independently with the appropriate tradeoffs between simplicity, readability, and performance. Provides mentorship to junior engineers, and enhances operational excellence through tech debt reduction and knowledge sharing.

 

 

Senior Engineer: Successfully designs and documents system improvements and features for an OKR/project from the ground up. Consistently delivers efficient and reusable systems, optimizes team throughput with appropriate tradeoffs, mentors team members, and enhances cross-team collaboration through documentation and knowledge sharing.

 

 

Staff Engineer: Drives scoping and execution of one or more OKRs/projects that impact multiple teams. Partners with stakeholders to set the team vision and technical roadmaps for one or more products. Is a role model and mentor to the entire engineering organization. Ensures system health and quality with operational reviews, testing strategies, and monitoring rigor.

 

 

The following represents the expected range of compensation for this role:

 

• The estimated base salary range for this role is $213,000 - $230,000.
• Additionally, this role may be eligible to participate in TRM’s equity plan.

 

Please note – we factor in the different costs for geographies outside the United States.