Platform Database Administrator, Aurora/MySQL
Job Description:
- As the Platform Database Administrator (DBA) for Aurora, serve as the architectural and operational anchor for high-scale database environments.
- Bridge the gap between technical data layers and production feature engineering.
- Take full ownership of database performance tuning, optimization strategies, and system reliability across core software suites.
- Sustain consistent system performance and reliability across 400+ database schemas, managing comprehensive schema migrations and tracking client-specific data growth metrics.
- Supervise AWS Aurora-specific environments, orchestrating cluster endpoint routing configurations, managing failover behaviors, executing parameter tuning, and troubleshooting data warehouse / read replica lags.
- 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.
- Diagnose and optimize heavy database pipelines utilizing INSERT...SELECT queries and computed-table patterns.
- Analyze Aurora instance utilization models against pricing factors to right-size compute resources and minimize I/O waste stemming from unoptimized queries.
Requirements:
- 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.
Benefits:
- 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
Apply tot his job Apply To this Job