Platform Database Administrator DBA for Aurora/MySQL - LeanTaaS

We are a growth stage company that creates software solutions combining lean principles, predictive and prescriptive analytics, and machine learning to transform hospital and infusion center operations. More than 190 health systems and over 1,200 hospitals and centers across 49 states rely on our award-winning products and expert change management services to increase patient access, decrease wait times, and reduce healthcare delivery costs. We have raised more than $300 million from top-tier investors such as Bain Capital, Insight Partners, and Goldman Sachs. We have been named among the top 100 AI companies in the world.

Please note that while this role is listed as available for remote, we are currently employing in the following states: AK, AZ, CA, CO, CT, DC, FL, GA, IA, IL, IN, KS, LA, MA, MD, ME, MI, MO, MT, NC, NH, NJ, NV, NY, OH, OR, PA, SC, TN, TX, UT, VA, WA, WI, WV . If your state is not listed, we may not be able to proceed with your application. We have offices in Santa Clara, CA and Charlotte, NC for employees who prefer to work regularly or occasionally from an office.

ROLE OVERVIEW

As the Platform Database Administrator (DBA) for Aurora, you will serve as the architectural and operational anchor for our high-scale database environments. In this role, you will bridge the gap between technical data layers and production feature engineering, taking full ownership of database performance tuning, optimization strategies, and system reliability across our core software suites. This is a highly technical, hands-on infrastructure role focused on scaling multi-tenant database systems that process hundreds of millions of operational healthcare records daily.

WHAT YOU'LL DO

• Query Optimization & Indexing Strategy: Systematically triage slow database queries across hundreds of databases. Design robust composite indexes, rewrite inefficient subqueries, and actively eliminate full-table-scan patterns to address our primary performance gaps.
• Multi-Tenant Architecture at Scale: Sustain consistent system performance and reliability across 400+ database schemas, managing comprehensive schema migrations and tracking client-specific data growth metrics.
• Aurora Infrastructure Management: Supervise AWS Aurora-specific environments, orchestrating cluster endpoint routing configurations, managing failover behaviors, executing parameter tuning, and troubleshooting data warehouse / read replica lags.
• MySQL/InnoDB Internals Tuning: Apply deep knowledge of InnoDB core internals to manage lock behaviors, resolve complex lock contentions, adjust buffer pool parameters, and systematically reduce purge lags across write-heavy database clusters.
• ETL & Data Pipeline Tuning: Diagnose and optimize heavy database pipelines utilizing INSERT...SELECT queries and computed-table patterns. Deploy advanced temporary table strategies, batch write configurations, and parti