MYSQL Database Administrator Lead

MySQL Database Administrator Lead (Level 4)

Provide locations/flexible work by preference:
Most preferred - Pittsburgh, PA 15222,
Second preferred - Strongsville, OH 44136,
Third - Phoenix AZ 85016.
Fourth - Birmingham, AL 35233 / Farmers Branch, TX 75234
Hybrid, 3 days onsite

Days of the week: M-F, on-call rotation
Working Hours (Flexible): 8-5 pm, 40 hours
Acceptable time zone(s): EST hours

Length of Assignment: 6 months with Possible Conversion

Function of the group: Platform Support
Current initiatives/project(s) that this resource will be impacting: Platform support for Infrastructure group
Industry background: Banking or Financial experience is preferred, not required

Roles and Responsibilities:
The Senior MySQL DBA will have responsibility primarily for MySQL database technologies.
Typical work-related activities include:
Install, patch, upgrade, configure, tune, and maintain MySQL databases (current versions 8.0.x, 8.4.x being migrated to newer versions 8.0.42, 8.4.5)
Identify, Innovate, Develop, and Deliver latest capabilities for MySQL such as Innodb clustering implementation to multi-data centers.
Troubleshoot critical performance bottlenecks for Production MySQL databases
Review and assess the impact of database design changes prior to their implementation
Collaborate with other IT teams and Vendors to resolve complex and multi-disciplinary issues
Work independently and represent database group in various projects
Ensure that databases are monitored, maintained, backed up, and available as appropriate.
Manage database security with an adherence to security policy
Review stress testing results and provide recommendations to development teams
Automate management tasks, streamline processes, and perform standard administrative functions
Automated installation and patching experience are a big plus
Mentor, assist, encourage, and serve as a backup to other team members

Technical Skills: (6+ years)
Complete Understanding of MySQLs underlying storage engines
Significant Knowledge of MySQL version 8.x and new features
Knowledge of Automated Failover Solutions for MySQL
Knowledge of TDE (At Rest Encryption)
Knowledge of de-facto standards and best practices in MySQL
Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
Strong knowledge of ODBC/JDBC client/server communication
Significant Automation experience with shell and SQL scripting

Degrees/Certifications:
Bachelors - IT based studies
Certifications are a big plus

Pre-Screening Questions:
1. Please provide a detailed example of when you used a large platform in your previous employment? (production support, life cycle)

Interview Process:
1. Video Call - technical assessment with Manager (1 hour)
2. Video Call - personality match with Manager (30 minutes)