DBA-MySQL Admin

W3Global


Date: 1 day ago
City: Mississauga, ON
Contract type: Contractor
Must

Database Administrator (DBA) with deep expertise in MySQL administration on AWS, advanced SQL query optimization, and exposure to AWS Glue for data integration tasks.

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.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume