Senior Database Reliability Engineer

Stack

Responsibilities

• ▹Own the reliability, performance and availability of all production databases (Aurora MySQL on AWS) across the 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 is currently executing on any instance
• ▹Author and maintain database runbooks so 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 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 the 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
• ▹Handle protected health information (PHI) responsibly within a HIPAA-compliant environment

Requirements

• ▹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

Nice to have

• ▹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

Soft skills

What we offer

• ▹Competitive salaries
• ▹Remote/hybrid environment
• ▹Potential equity compensation for outstanding performance
• ▹Flexible PTO
• ▹Company-wide sponsored lunches
• ▹Company-paid disability and life insurance benefits
• ▹Company-paid family and medical leave
• ▹Medical, dental and vision insurance benefits
• ▹Discounted pet insurance
• ▹FSA/DCA and commuter benefits
• ▹401k
• ▹Credits for online fitness classes and gym memberships
• ▹Recovery suite at HQ with a cold plunge, sauna and shower

About the company

Prompt Health delivers highly automated, modern B2B enterprise software to rehab therapy businesses, the teams within and the patients they serve. It has become the go-to platform in the space and is rapidly growing its market share.