Be an early applicantLess than 25 applicants

This job has closed.

Company

Original Job Post

TRM Labs · 2 days ago

Staff Engineer, Database Infrastructure

San Francisco, CA

Full-time

Onsite

Senior Level

$213K/yr - $230K/yr

6+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Big DataBlockchain

H1B Sponsorship

Comp. & Benefits

Insider Connection @TRM Labs

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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 that can 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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLProgramming LanguagesRDBMS ArchitecturesDatabase Profiling ToolsORM ToolsNormalizationDenormalization

Required

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

Company

TRM Labs

TRM helps financial institutions, crypto businesses and federal agencies detect and investigate crypto-related financial crimes.

Founded in 2018

San Francisco, California, USA

51-200 employees

https://trmlabs.com

H1B Sponsorship

TRM Labs has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (2)

2022 (3)

2021 (2)