Senior Software Engineer, Database Infrastructure

TRM is on a mission to build a safer financial system for billions of people. We deliver a blockchain intelligence data platform to financial institutions, crypto companies, and governments to fight cryptocurrency fraud and financial crime. We consider our business — and our profit — as a way to move towards our mission sustainably and at scale. 

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 Senior Database Engineer, you will be responsible for developing, managing, and scaling TRM’s robust database infrastructure that will ultimately help to build a safer financial system for billions of people.

The impact you will have here:

• Design, implement, and maintain Petabyte scale relational database systems with a focus on availability, security, performance, and scalability.
• Work closely with cross-functional teams to plan and execute database infrastructure build-outs, upgrades, and migrations.
• Serve as an expert in database performance, scalability, query tuning, monitoring, and incident response.
• Manage data replication in environments serving both batch and real-time use cases.
• Independently troubleshoot and resolve production and pre-production issues in a timely manner.
• Contribute to major system upgrades, deployment automation, monitoring enhancements, and production changes.
• Create operational playbooks, contribute to documentation, and gain domain expertise to drive changes within the team.
• Tune and configure databases, as well as build tools and scripts to monitor, troubleshoot, and automate our systems.

What we’re looking for:

• 5- 8 years of hands-on experience in database design, development, and enterprise-class operations with one or more of the following technologies: PostgreSQL, MySQL, Aurora PostgreSQL, Aurora MySQL.
• Experience managing a highly reliable database platform with a focus on security, performance, and scale to meet the requirements of enterprise customers.
• Experience migrating mission-critical database applications from on-premise to the cloud or managing a hybrid cloud environment for large enterprise applications.
• Proficient in data modeling for OLTP and OLAP workloads.
• Extensive experience in performance monitoring, troubleshooting, and performance tuning.
• Experience influencing product roadmap and strategy, and prioritizing existing database initiatives to drive business outcomes.
• Experience writing high-performance Postgres modules and extensions to optimize database performance.

About the Team:

• The Data Platform team is the funnel between all of TRM's data world and product world. We care about all layers of stack including petabyte of data stores, pipelines, and processes.
• We have quite a big scope as a the team with new and exciting projects every quarter. As a result, we collaborate across the board with most teams at TRM.
• We believe in async communication and are also not afraid to jump on a quick huddle if that helps to move things faster. We are both scrappy when the situation demands and also process-oriented when we need to achieve our OKRs.
• We are always looking for people who can elevate the quality our tech and our execution. If you enjoy a remote-first and async friendly environment to achieve efficacy and efficiency at petabyte scale, our team could be a great pick for you!
• Team members are based in the US across almost all timezones! Our on-call tends to be in EST/PST shift, whatever suits you the best.
• We do try to reserve some overlap in the day for meetings. Our north star - no IC spends more than 3-4 hours/week in meetings.

Learn about TRM Speed in this position:

• Build scalable engines to optimize routine scaling and maintenance tasks like create self-serve automation for creating new pgbouncer, scaling disks, scaling/updating of clusters, etc.
• Enable tasks to be faster next time and reducing dependency on a single person.
• Identify ways to compress timelines using 80/20 principle. For instance, what does it take to be operational in a new environment? Identify the must have and nice to haves that are need to deploy our stack to be fully operation. Focus on must haves first to get us operational and then use future milestones to harden for customer readiness. We think in terms of weeks and not months.
• Identify first version, a.k.a., "skateboards" for projects. For instance, build an observability dashboard within a week. Gather feedbac