Full-Time Senior Database Performance Engineer - Remote

• Take ownership of known database performance issues.
• Use Datadog and other profiling tools to uncover high-impact optimization opportunities.
• Address underlying inefficiencies in query patterns or application logic.

Responsibilities

• Work hands-on to identify, analyze, and resolve slow ActiveRecord queries across the Rails monolith
• Optimize query performance through indexing, query rewriting, and schema improvements
• Collaborate with DBAs and other technical teams to diagnose and remediate database bottlenecks
• Validate all performance improvements through testing, and performance measurement at high load
• Use Datadog to analyze query performance and identify high-impact optimization opportunities
• Implement selective caching in Redis where appropriate to reduce database load
• Document findings and share best practices for performant query design
• Contribute to long-term performance and scalability efforts across MySQL, TiDB, Elasticache, and Opensearch

• Deep expertise with Ruby on Rails, able to craft elegant and minimal solutions to complex problems
• Deep expertise with ActiveRecord MySQL query optimization — must go way beyond standard ActiveRecord use
• Strong understanding of SQL execution and query optimization at the engine level
• 6–10+ years of professional experience (senior level)
• Proven ability to read, understand, and improve complex application code across large systems
• Experience tuning queries, adding indexes, and interpreting execution plans
• Comfortable partnering with DBAs and other technical teams to debug and resolve performance issues
• Clear communicator who’s unafraid to ask questions or seek domain input when needed
• Bachelor’s degree (BA or BS) or equivalent experience

• Familiarity with alternative database technologies such as TiDB, Elasticache, Opensearch, or DynamoDB
• Direct experience moving a Rails application to TiDB would be a huge plus
• Opinions and practical experience regarding when to choose one database technology over another
• Experience with query analysis and performance tooling (e.g., Datadog, Looker, K6)
• Experience with large-scale data migrations, and tools for doing this (e.g. gh-ost)
• Familiarity with the AWS ecosystem

What is the last date for applying to the job?

Which countries are accepted for this remote job?