Source description
About the role
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.