PayNearMe

Compensation

Full Description

Job Description: • 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 Requirements: • 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 Benefits: • Competitive salary and benefits with growth-company options grant • Fast-paced and professional work culture • Stock options with standard startup vesting - 1 year cliff; 4 years total • $50 monthly communication expense stipend to go towards your phone/internet bill • $250 stipend to enhance your WFH setup • Reimbursement for peripheral equipment: monitor (up to $400), keyboard and mouse (up to $200) • Premium medical benefits including vision and dental (100% coverage for employees) • Company-sponsored life and disability insurance • Paid parental bonding leave • Paid sick leave, jury duty, bereavement • 401k plan • Flexible Time Off (our team members typically take off ~3-4 weeks per year) • Volunteer Time Off • 13 scheduled holidays