DBA-MySQL Admin

Key Responsibilities:

• Administer and manage MySQL databases in AWS, ensuring performance, security, and uptime.
• Perform SQL query analysis and tuning to improve response time and reduce resource usage.
• Configure and maintain backups, replication, and disaster recovery plans.
• Monitor database health using CloudWatch, performance schema, or other monitoring tools.
• Collaborate with developers to optimize schema designs, indexes, and query plans.
• Work with AWS services like RDS, EC2, S3, and optionally AWS Glue for ETL/data processing tasks.
• Automate routine administrative tasks via scripts (Python, Bash) or AWS tools.
• Ensure database compliance with internal and external security policies.

 
Required Skills & Experience:

• 5+ years of MySQL administration experience, with at least 3+ years on AWS (RDS or EC2-based MySQL).
• Strong experience with SQL tuning, query optimization, and performance troubleshooting.
• Familiarity with AWS services such as RDS, CloudWatch, IAM, and S3.
• Experience in backup/restore, high availability configurations, and replication.
• Proficient with tools like MySQL Workbench, Percona Toolkit, or similar.
• Knowledge of Linux-based systems for database administration.

 
Preferred Qualifications:

• Experience or exposure to AWS Glue.
• Basic understanding of AWS Lambda, Athena, and Redshift.
• Scripting experience (e.g., Python, Bash) for automation tasks.
• AWS certification (e.g., AWS Certified Database – Specialty or AWS Solutions Architect – Associate) is a plus