DBA

Following is the requirement for DBA

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

Nice to Have

• Snowflake
• Python (scripting & automation)
• VMware
• Scripting
• Backup experience