Position Title: Senior Database Administrator

Location: Calgary ,Canada

Job Type: Contract

Job Summary:

We are seeking a skilled and experienced Database Administrator to work on data migration project. The successful candidate will have a strong background in database administration, particularly with MySQL ad Redshift databases, and extensive experience with data migration, consolidation, and optimization processes. This role requires a meticulous attention to detail, strong problem-solving skills, and the ability to collaborate effectively with cross-functional teams.

Candidate Requirements:

• Hands-on experience with AWS MySQL Aurora 5.7 or above, including 24x7 production support and on-call troubleshooting.
• Experience with database migrations, and agile development methodology.
• Self-motivated, able to work independently, and collaborate effectively with developers during software deployments and data migrations.
• Excellent written and verbal communication skills for a collaborative, cross-functional environment.

Minimum Skills and Experience:

• Bachelor of Science degree in Computer Science or equivalent.
• 8+ years as a MySQL, Redshift DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning.
• Strong understanding of database consolidation techniques and best practices.
• Experience with data migration tools and techniques, such as AWS Database Migration Service (DMS) or similar.
• Proficiency in SQL and database performance tuning.
• Develop a comprehensive strategy for merging the two databases into a single Aurora MySQL database while minimizing downtime and ensuring data integrity.
• Experience with 24x7 support, troubleshooting, and managing databases in cloud environments (AWS).
• Experience with cloud-based services (AWS Cloudwatch, DataDog, Percona Monitoring Management PMM).
• Expertise in high-availability database features, replication, disaster recovery, and live production schema changes.
• Proficiency with cloud-specific technologies (S3, Route 53, CloudFormation), version control tools (GitHub), and database life-cycle management.
• Knowledge of database security, backup retention policies, and scaling databases.
• Experience with managing the full life cycle of database schema design and implementation, which includes script management from development through production releases.
• Experience implementing database schema changes in a live production environment requiring minimal downtime and zero performance impact.