Sr / Lead MySql Database Administrator -Sr MySql DBA, Sr DBA, AWS, MySql, Redshift, DBA

Securitas - Denver, CO

Full-time - Senior

Remote - Denver, CO

Administrative and Support Services

About the position

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

Responsibilities

• Provide 24x7 production support and on-call troubleshooting for AWS MySQL Aurora databases.
• Manage database migrations and implement agile development methodologies.
• Collaborate effectively with developers during software deployments and data migrations.
• Develop a comprehensive strategy for merging two databases into a single Aurora MySQL database while minimizing downtime and ensuring data integrity.
• Implement database schema changes in a live production environment with minimal downtime and zero performance impact.
• Monitor and optimize database performance, including backup, recovery, and performance tuning.

Requirements

• Bachelor of Science degree in Computer Science or equivalent.
• 8+ years of experience as a MySQL and 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).
• Proficiency in SQL and database performance tuning.
• Experience with cloud environments (AWS) and cloud-based services (AWS Cloudwatch, DataDog, Percona Monitoring Management PMM).
• Expertise in high-availability database features, replication, disaster recovery, and live production schema changes.

Nice-to-haves

• Knowledge of database security and backup retention policies.
• Experience with cloud-specific technologies (S3, Route 53, CloudFormation) and version control tools (GitHub).

Benefits

• Group medical, dental, and vision insurance
• Life insurance
• Long-term and short-term disability insurance
• 21 days of accrued paid time off
• 401k
• Tuition reimbursement
• Performance bonuses
• Paid overtime