caferemote
PayNearMe

Senior Database Performance Engineer - Remote

Remote United States Full-time Senior $175K – $190K / year Posted yesterday
Apply now
Work from
United States
Contract
Full-time
Experience
Senior
Salary
$175K – $190K / year
Posted
19 November 2026
Apply by
2 December 2026

We’re looking for a Sr. In this role, you’ll take ownership of known database performance issues, use Datadog and other profiling tools to uncover high-impact optimization opportunities, and address underlying inefficiencies in query patterns or application logic. Over time, this position will expand to include performance and scalability work across other data systems such as TiDB, Elasticache, and Opensearch—directly improving user experience, enabling infrastructure efficiency, and reducing operational costs.

The Performance and Scale team ensures our systems remain fast, reliable, and efficient as we grow. Database Performance Engineer to identify and fix slow MySQL queries across our Rails monolith, improving application responsiveness and overall system performance.

We're looking for someone who has built highly performant OLTP systems, who fully understands the importance and impact of efficient MySQL at scale, and who knows how to identify and focus on the areas that will have the most impact. You should be a Rails wizard who understands all the subtleties of generating performant MySQL using ActiveRecord. You should have a passion for database efficiency!

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

Nice to have

  • 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 Success Looks Like

  • Methodically identify, fix, and validate known slow queries across the Rails monolith, demonstrating measurable performance improvements
  • Use Datadog to surface additional slow or inefficient queries, and partner with DBAs and the team to prioritize which to address next
  • Navigate performance work that overlaps with our ongoing TiDB implementation, balancing short-term optimizations with long-term architectural goals
  • In some cases, determine that issues are not query-related and instead require caching (Redis) or application logic changes, coordinating with code owners as needed
  • Demonstrate clear, data-driven improvements in overall database health and responsiveness during peak usage and high-load jobs

Location: Flexible/Remote (within the US)

Great compensation package plus extensive benefits, including

  • 100% Remote (must be in US)
  • Base salary per year (paid semi-monthly)
  • 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
  • 2x / year in-person team meet-ups (2-3 days, company paid)

Salary

$175,000 - 190,000

PayNearMe strives to create a workplace where all employees thrive. Our core values represent who we are today and we take pride in the way we work with each other as well as with our stakeholders.

We’re in this together to do the right thing. We deliver real results we are proud of while remaining respectful, transparent, and flexible.

PayNearMe is an equal opportunity employer. We are diligently and thoughtfully working towards cultivating a diverse workforce which in turn, enhances our products and services for the communities we serve. Applicants who represent all backgrounds are strongly encouraged to apply.

—

Candidate information will be treated in accordance with our job applicant privacy notice found at:

Assistance for Disabled Applicants

Alternative formats of this Notice are available to individuals with a disability. Please let us know if you need assistance.

All your information will be kept confidential according to EEO guidelines.

At PayNearMe, we’re on a mission to make paying and getting paid as simple as possible. We build innovative technology that transforms the way businesses and their customers experience payments. Our industry-leading platform, PayXM™, is the first of its kind—designed to manage the entire payment experience from start to finish. Every click, swipe or tap is seamless, fast and secure, helping non-commerce businesses boost customer satisfaction, accelerate payments, and reduce costs.

Our single platform handles it all: cards, ACH, digital wallets such as PayPal, Venmo, Cash App Pay, Apple Pay and Google Pay, and even cash at more than 62,000 retail locations nationwide. Today, thousands of businesses across consumer lending, iGaming and online sports betting, property management, and tolling trust PayNearMe to deliver a payment experience that drives real results.

In September 2025, we raised a $50 million Series E funding round to accelerate our growth.

We’re a team of 200+ employees across 41 states, headquartered in Silicon Valley with satellite offices in Dallas, TX and Holmdel, NJ.

Join us and be part of a team that’s shaping the future of payments—one experience at a time.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from PayNearMe

View company →

Product Marketing Manager

PayNearMe
Remote United States Full-time $120K – $150K / year

Company Description At PayNearMe , we’re on a mission to make paying and getting paid as simple as possible. We build innovative technology that transforms…

yesterday Sales and Marketing

Similar remote jobs

Browse all →

Senior AI Agent Engineer

Bonapolia
Remote Albania, Andorra, Armenia, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Georgia, Germany, Gibraltar, Greece, Guernsey, Holy See (Vatican City State), Hungary, Contract

We are looking for a Senior AI Agent Engineer: 🗣 Language Proficiency: Upper-Intermediate 🧾 Employment type: Full time 🌍 Candidate Location: Poland, other EU countries, Kazakhstan,…

5h ago Back-End Programming

Staff Software Engineer - Golang

Rapid7
Remote United States Full-time $164K – $222K / year

Rapid7 is seeking a Staff Software Engineer, AI-SOC to own the control plane and API server that expose our autonomous investigation platform to more than 10,000 customers. This role is for…

5h ago Back-End Programming

Cloud & Backend Software Engineer

UIC Alaska
Remote United States Full-time $110K – $130K / year

Overview CLOUD & BACKEND SOFTWARE ENGINEER (ERDC AI-DRIVEN ENGINEERING QA/QC): Bowhead is seeking a Cloud & Backend Software Engineer to support the development of an AI-driven Engineering…

7h ago Back-End Programming

Software Engineer III

MCCi
Remote United States Full-time

About Us: MCCi is a premier provider of intelligent business process automation solutions and a trusted partner to over 2,000 organizations across state and local government, education, and…

10h ago Back-End Programming

Backend Engineer

Domaine
Remote Canada Full-time

Meet Domaine , a global digital commerce and transformation partner for ambitious and beloved brands. We are the world’s largest independent Shopify partner. We are also a growing team of…

10h ago Back-End Programming

Senior Software Reliability Engineer – Splunk Framework & Runtime Services

Cisco
Remote United States Full-time $139K – $203K / year

The application window is expected to close on: 11/27/2026 Note: This role is Remote in the US with a strong preference for locations except CA, WA, DC, MD, NJ, NY, CT, MA, VA, AK. Meet the…

11h ago Back-End Programming

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.