Senior or Staff Software Engineer, Database Infrastructure
- Remote •+1
- 6 years of exp
- Full Time
Not Available
Remote only
About the job
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 feedback from stakeholders after to identify more needs or bells and whistles to add to the dashboard
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 $200,000 - $255,000.
- Additionally, this role may be eligible to participate in TRM’s equity plan.