Cloud & AWS
AWS RDS (MySQL) Must Have
AWS CloudWatch – Must Have
AWS Redshift – Must Have (or similar)
Performance Optimization
Query pattern analysis – Must Have
Schema design optimization – Must Have
Indexing strategies – Must Have
Resolution of performance bottlenecks – Must Have
Monitoring & Alerting Tools
AWS CloudWatch – Must Have
Database Performance Monitoring solutions – Must Have
SQL Sentry, xMatters, SolarWinds – Acceptable with similar
Database Platforms
Amazon RDS (MySQL) – Must Have
Microsoft SQL Server (Physical/VM) – Acceptable with similar
Azure SQL Database (PaaS/Serverless) – Acceptable with similar
Amazon Redshift – Acceptable with similar
ETL & Data Pipeline Development
Data pipeline development – Nice to Have
ETL tools – Nice to Have