Senior Database Reliability Engineer

Remotefull timeRemote

Apply on Employer Site

senior

$220k–$240k

H1B: no

Prompt Senior Database Reliability Engineer at Prompt owns the health, performance, and cost-efficiency of production databases powering EMR and related products. This role involves managing database alerting, optimizing queries, educating engineering teams, and shaping database architecture for scalability.

Responsibilities

Own the reliability, performance, and availability of all production databases (Aurora MySQL on AWS) across our EHR, Data, and AI teams.
Manage database alerting end to end – build and maintain the observability pipeline that feeds database metrics and alerts into Datadog, and fold after-hours database alerts into the DevOps on-call rotation.
Educate and train the various engineering teams about proper database hygiene and best-performing queries
Implement automated safeguards, including automatic termination of long-running and runaway queries, and fast, always-available visibility into what's currently executing on any instance.
Author and maintain database runbooks so that first responders can act on incidents quickly and consistently.
Dive deep into problematic queries – diagnose, optimize, and re-index – and drive down both latency and the load that forces us to scale out.
Review new EMR and application queries before release, acting as the performance gate that keeps inefficient queries out of production.
Architect and continuously right-size our Aurora reader topology and read-routing strategy, matching capacity to real workload and eliminating over-provisioning.
Own database cost efficiency: instance right-sizing, reserved-capacity/Savings Plan strategy, and storage tiering.
Manage replication health, backups, restore testing, failover, and disaster recovery.
Establish safe schema-change and migration practices across teams.
Partner with the Platform Architect to determine the best path forward for new and existing database workloads

Qualification

Hands-on experience operating large

Required

6+ years in database reliability engineering, database administration, or database engineering, including ownership of production systems at scale.
Deep MySQL expertise — query optimization, execution-plan analysis, indexing strategy, and replication. Aurora MySQL experience strongly preferred.
Hands-on experience operating large, multi-reader Aurora or RDS clusters at terabyte scale, including read-routing and connection management.
Strong command of database observability tooling (Datadog, Percona Monitoring and Management (PMM), Performance Insights, Prometheus/Grafana).
Proficiency in a scripting language (Python, Bash, or similar) for automation, and comfort with infrastructure-as-code (Terraform).
Solid AWS operational depth around RDS/Aurora, including cost optimization (instance sizing, reserved capacity, storage types).
Experience with on-call/incident response and authoring runbooks.
Excellent communication skills and the ability to collaborate across engineering teams.

Preferred

Experience standing up or operating a cloud data warehouse (Snowflake, Databricks, Redshift) and moving analytical workloads off OLTP databases.
Experience in a HIPAA-regulated or other compliance-heavy environment handling sensitive data.
Familiarity with query auto-remediation tooling (pt-kill / Percona Toolkit, statement timeouts, custom killers).
Application-side familiarity (PHP) to collaborate effectively on query review.
Knowledge of security best practices for database and cloud environments.
Previous experience with agile methodologies and working in fast-paced environments.

Benefits

Dental
Vision
401(k)
PTO
Equity/RSU
Life Insurance

Company

Prompt

View company page

Source: ashby

Active within the past hour

Remote-friendly

More roles at Prompt

Associate Director, Account Management

Remote

Senior Manager, Benefit Verification & Authorization Operations

Remote

EDI Team Lead

Remote

Billing Tech Support Specialist

Remote

Boost Your Interview Chances

Improve Resume Match Score

Free

Your Score

9.0

Strong Applicant

Must-Have Skills for This Role

Aurora MySQLAWSDatadogEMRdatabase alertingquery optimization

Optimize my Resume

Apply Faster with Autofill

Free

Save your profile once. LumiJobs pre-fills the employer's application form so you stop re-typing the same answers on every site.

Apply With Autofill

Or skip LumiJobs's tools and submit directly on the employer's career site.

Apply on Employer Site