Title: DBA + DevOps engineer
Location: Toronto, ON(Hybrid)
Duration: 6+ months
Key Responsibilities
• Database Reliability: Own the lifecycle of production MySQL instances (Aurora, RDS, or On-Prem), ensuring 99.99% availability, high performance, and security.
• Infrastructure as Code (IaC): Design and maintain cloud infrastructure using Terraform, CloudFormation, or Ansible to automate the deployment of database clusters and app environments.
• Python Automation: Develop sophisticated Python tooling for automated backups, failover orchestration, custom monitoring exporters, and self-service database provisioning.
• Performance Tuning: Perform deep-dive query optimization, index analysis, and engine-level tuning (InnoDB) to handle scaling bottlenecks.
• CI/CD Pipeline Integration: Integrate database schema changes (Liquidbase/Flyway) into Jenkins, GitLab CI, or GitHub Actions to enable seamless "Database-as-Code."
• Incident Response: Serve as the final escalation point for complex production issues, conducting Root Cause Analysis (RCA) and implementing preventative automation.
Required Skills & Qualifications
• The Database Core: 8–10 years of experience with MySQL. Expert knowledge of replication (Source/Replica, Group Replication), clustering, and backup/recovery strategies The DevOps Toolkit: Expert-level experience with Docker and Kubernetes (managing stateful sets). Mastery of Terraform or Ansible.
• The Python Expert: Advanced Python proficiency, specifically for system automation, interacting with Cloud APIs (Boto3), and data manipulation.
• Cloud Platforms: Extensive experience with AWS (specifically Aurora MySQL, RDS, and EC2 networking) or similar GCP/Azure services.
