LeanTaaS Logo

LeanTaaS

Platform Database Administrator (DBA) for Aurora/MySQL

Posted 8 Hours Ago
Be an Early Applicant
Remote
Hiring Remotely in USA
170K-200K Annually
Senior level
Remote
Hiring Remotely in USA
170K-200K Annually
Senior level
Own and optimize high-scale AWS Aurora/MySQL multi-tenant databases (400+ schemas). Tune queries, indexes, InnoDB internals, replica/cluster behavior, ETL pipelines, observability (Datadog, performance_schema), capacity/cost, and mentor engineers. Evaluate GenAI tooling to automate diagnostics and fleet management.
The summary above was generated by AI
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.

    Core Stack

    Amazon Web Services (AWS) Aurora, MySQL/InnoDB internals, Datadog Observability

    Platform Scale

    Multi-tenant infrastructure managing over 400 active database schemas with high availability

    Collaboration

    Cross-functional partnership across 4 core business products: Operating Rooms (OR), Inpatient Flow (IPF), Infusion Centers (INF), and Imaging

     

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 partition pruning techniques.
  • Observability and Diagnostics Mastery: Leverage performance_schema and sys schema mechanisms to ingest digest-level performance profiles, developing automated alerts, telemetry rules, and proactive intervention workflows.
  • Capacity and Cost Optimization: Analyze Aurora instance utilization models against pricing factors (instance-based + I/O consumption) to right-size compute resources and minimize I/O waste stemming from unoptimized queries.
  • Engineering Culture & Mentorship: Actively teach and guide software engineers on robust query design principles, providing architectural validation and reviews for staging tables and computed views.
  • GenAI-Assisted Tooling & Analysis: Evaluate and deploy GenAI-powered developer and administrative tooling (such as natural language database insights, automated code generation, and assistive diagnostics) to accelerate query profiling and simplify fleet manageability across multi-tenant clusters.

WHAT YOU'LL BRING

  • Bachelor’s degree in Computer Science, Computer Engineering, or a related quantitative field, or equivalent years of related practical enterprise experience.
  • Extensive experience administering AWS relational database environments, with specific knowledge of AWS Aurora architectures (read replica scaling, cluster topologies, and parameters).
  • A proactive automation mindset with experience scripting solutions for schema drift detection, slow-query automated alerts, or automated indexing recommendations across massive multi-database topologies.
  • Deep professional mastery of MySQL/InnoDB core behaviors—specifically buffer pool configuration, transaction isolation levels, lock mechanics, and Multi-Version Concurrency Control (MVCC).
  • Demonstrated expertise in system-level database performance profiling, query rewrites, and the engineering of advanced indexing strategies for large-scale applications.
  • Excellent communication and collaboration skills, with a track record of translating complex database concepts for software engineering teams and prioritizing work based on cross-product impact.

BONUS POINT IF YOU HAVE

  • Broad Database Proficiency: Experience managing and optimizing non-MySQL environments, specifically PostgreSQL, MongoDB (Atlas), and/or Google BigQuery. Includes designing schemas, optimizing query performance, and implementing advanced indexing or partition strategies.
  • Modern Tooling & Observability: Strong interest in leveraging GenAI/LLM-assisted analysis (e.g., automated diagnostics) to optimize DBA workflows, alongside familiarity with Datadog for real-time anomaly detection and dashboard creation.
  • Domain Expertise: Prior exposure to healthcare data standards or integration pipelines, such as those involving EHR systems like Epic or Cerner.

WHAT YOU'LL GET

  • Intellectual and emotional satisfaction of solving tough operational problems in healthcare while improving patient access and saving lives!
  • Competitive compensation package that includes base salary, target bonus, and stock options
  • 401(k) Match
  • Comprehensive healthcare benefits
  • Generous Paid Time Off and Parental Leave
  • Monthly reimbursement for Skill Building 
  • Monthly reimbursement for Wellness, Transportation, and/or Home Office
  • Education Reimbursement for select courses/programs

Candidates must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.

LeanTaaS is an equal opportunity employer committed to promoting an inclusive work environment free of discrimination and harassment. We value diversity, inclusion, and aim to provide a sense of belonging for everyone. All qualified applicants for employment will be considered without regard to race, color, sex, gender identity, gender expression, religion, age, national origin or ancestry, citizenship, physical or mental disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military or veteran status, or any other basis protected by federal, state or local laws. If you require assistance during the application process, please reach out to [email protected]. LeanTaaS will reasonably accommodate qualified individuals with disabilities to the extent required by applicable law.

Please note: LeanTaaS is not accepting agency resumes at this time, and we are not responsible for any fees related to unsolicited resumes. Thank you.

Similar Jobs

2 Hours Ago
Remote or Hybrid
43 Locations
122K-168K Annually
Mid level
122K-168K Annually
Mid level
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Manage and coordinate a portfolio of waste-reduction initiatives with initial focus on manufacturing waste, rework, and overweight-by-design. Translate strategy into roadmaps, drive cross-functional governance, track progress and value delivery, support pipeline development, provide project management for high-priority efforts, and report performance to senior leaders.
3 Hours Ago
Remote or Hybrid
United States
46K-46K Annually
Junior
46K-46K Annually
Junior
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Provide administrative support for group term life benefits: enter and maintain enrollment and portfolio data, troubleshoot systems, research escalations, handle referrals, support projects, and participate in customer meetings to resolve issues and explain procedures.
3 Hours Ago
Remote or Hybrid
110K-166K Annually
Senior level
110K-166K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
As an Audit Manager, you will manage audit engagements, assess risks, ensure GAAP compliance, lead teams, and develop client relationships.
Top Skills: Fasb Accounting Standard UpdatesGaap

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account