P

Prompt

College essay coaching and EdTech platform

Senior Database Reliability Engineer

Database AdministrationConfirmed live in the last 24 hours
Full-timeRemote in USARemote

About the Job

Requirements

  • At least 6 years in database reliability engineering, database administration, or database engineering, including ownership of production systems at scale.
  • Deep MySQL expertise, including query optimization, execution-plan analysis, indexing strategy, and replication.
  • 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, including Datadog, Percona Monitoring and Management, Performance Insights, and Prometheus/Grafana.
  • Proficiency in a scripting language such as Python or Bash for automation, and familiarity with infrastructure-as-code such as Terraform.
  • Solid AWS operational depth around RDS/Aurora, including cost optimization, instance sizing, reserved capacity, and storage types.
  • Experience with on-call incident response and authoring runbooks.
  • Ability to collaborate across engineering teams.
  • Handle protected health information responsibly in a HIPAA-compliant environment.

Responsibilities

  • Own the reliability, performance, and availability of production databases (Aurora MySQL on AWS) across the EHR, Data, and AI teams.
  • Manage database alerting end to end by building and maintaining the observability pipeline that feeds database metrics and alerts into Datadog, and incorporate after-hours database alerts into the DevOps on-call rotation.
  • Educate and train engineering teams on database hygiene and high-performing queries.
  • Implement automated safeguards, including terminating long-running and runaway queries and providing fast, continuously available visibility into queries executing on each instance.
  • Author and maintain database runbooks so first responders can act on incidents quickly and consistently.
  • Diagnose, optimize, and re-index problematic queries to reduce latency and the load that drives scaling.
  • Review new EMR and application queries before release to prevent inefficient queries from reaching production.
  • Architect and continuously right-size the Aurora reader topology and read-routing strategy to match capacity to workload and eliminate over-provisioning.
  • Own database cost efficiency through 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.

Desired Qualifications

  • Aurora MySQL experience.
  • Experience standing up or operating a cloud data warehouse such as Snowflake, Databricks, or 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 such as pt-kill/Percona Toolkit, statement timeouts, or custom query killers.
  • Application-side familiarity with PHP to collaborate effectively on query review.
  • Knowledge of security best practices for database and cloud environments.
  • Previous experience with agile methodologies.

About the Company

Prompt

College essay coaching and EdTech platform

Prompt.com provides writing education focused on college admissions essays, offering one-on-one coaching, detailed written feedback, and a software platform to manage the writing process. It serves two main groups: B2B partners (over 500 college admissions consultants and high schools) via white-labeled software and coaching services, and direct-to-consumer families purchasing coaching packages. Its coaches are drawn from the top 2% of instructors and deliver feedback via video or written guidance, complemented by a literacy curriculum called Pen for English language learners. The company distinguishes itself as the largest provider of college admissions essay coaching and combines scalable software with personalized coaching and an expanding EdTech curriculum, aiming to make high-quality writing instruction accessible and simplify the college application process worldwide.

Company size
51-200
Company stage
Seed
Total funding
$2.1M
Headquarters
New York City, New York
Founded
2017

Recently Posted Jobs

Explore more opportunities at Prompt

See more jobs