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