Lead Cloud DBA - MySQL & AWS

$109,600 - $158,950/Yr

Empower Company S.R.O. - Chandler, AZ

Full-time - Senior

Remote - Chandler, AZ

Amusement, Gambling, and Recreation Industries

About the position

We are seeking a skilled and experienced Lead Database Administrator with expertise in MySQL, MySQL Aurora, Redshift, AWS Cloud Services, and experience in database sharding. The ideal candidate will manage various database systems in production environments, implement sharding strategies, and provide leadership to the database administration team.

Responsibilities

• Design, implement, and maintain MySQL, MySQL Aurora, Redshift, PostgreSQL, and DynamoDB database schemas, tables, indexes, and relationships.
• Deploy and manage MySQL Aurora instances, RedShift, PostgreSQL instances, and DynamoDB tables for high availability, scalability, and performance.
• Configure and optimize Redshift clusters for data warehousing and analytics workloads.
• Implement database sharding strategies to horizontally partition data across multiple shards.
• Develop and implement backup and recovery strategies for various databases.
• Manage user access, permissions, and security policies for different databases.
• Design and implement high availability and disaster recovery solutions using AWS services.
• Lead and mentor a team of database administrators.
• Collaborate with cross-functional teams to design and optimize database solutions.
• Stay up-to-date with database technologies and industry trends.
• Document database configurations, procedures, and troubleshooting guides.

Requirements

• Minimum of 8 years of experience as a Database Administrator, with expertise in MySQL, MySQL Aurora, and Redshift.
• In-depth knowledge of database architectures, replication, clustering, and performance optimization techniques.
• Hands-on experience with AWS Cloud services such as RDS, Aurora, Redshift, DynamoDB, EC2, S3, IAM, and CloudWatch.
• Experience implementing database sharding techniques for horizontal partitioning of data.
• Strong understanding of database security concepts including authentication, authorization, encryption, and compliance.
• Excellent troubleshooting skills with the ability to diagnose and resolve complex database issues.
• Experience leading and mentoring a team of DBAs.
• Strong communication and interpersonal skills.

Nice-to-haves

• Relevant certifications (e.g., AWS Certified Database - Specialty) are a plus.
• Experience with NoSQL, PostgreSQL, and AWS Cloud services.

Benefits

• Medical, dental, vision and life insurance
• 401(k) plan with generous company matching contributions (up to 6%)
• Tuition reimbursement up to $5,250/year
• Business-casual environment
• Generous paid time off including ten paid company holidays and three floating holidays
• Paid volunteer time - 16 hours per calendar year
• Leave of absence programs including paid parental leave and Family and Medical Leave (FMLA)