Senior Database Performance Engineer

November 21

🏄 California – Remote

Although this job is listed in California, this company may be open to hiring remote in other states.

💵 $175k - $190k / year

⏰ Full Time

🟠 Senior

👷🏻‍♀️ Engineer

Apply Now

Receive Emails with Similar Jobs

PayNearMe

WebsiteLinkedInAll Job Openings

Finance • Fintech • B2B

PayNearMe is a company that develops technology to facilitate the end-to-end customer payment experience. Their modern and reliable platform is designed to help businesses easily accept, disburse, and manage payments while reducing costs, increasing acceptance rates, driving self-service, and simplifying exception management. PayNearMe offers solutions for industries such as auto and consumer lending, tolling, iGaming, and more, providing a flexible and comprehensive payment processing platform. They focus on improving user experience and operational efficiency by offering a wide range of payment options and automation tools.

51 - 200 employees

💸 Finance

💳 Fintech

🤝 B2B

💰 $12.5M Debt Financing on 2020-01

📋 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