Senior MySQL DBA​/Database Administrator Lead

Position: Senior MySQL DBA/ Database Administrator Lead
Database Administrator Lead ( Need only visa independent consultants - Citizen, Green Card , EAD , H4)

Most Preferred:
Pittsburgh, PA - Two PNC Plaza, 620 Liberty Ave, Pittsburgh, PA

Second Preferred:
Cleveland, OH - Strongsville Technology Center, 8100 Mohawk Dr., Strongsville, OH 44136

Second Preferred:
Cleveland, OH - Strongsville Technology Center, 8100 Mohawk Dr., Strongsville, OH 44136

Ability to Work Remote:
Hybrid, 3/2 schedule Travel:
Very limited

Days of the Week:
Monday-Friday, on-call rotation Working Hours (Flexible): 8-5 pm, 40 hours

Intended Length of Assignment: 6 months

• Complete Understanding of MySQL's underlying storage engines
• Knowledge of Automated Failover Solutions for MySQL
• 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
• Knowledge of TDE (At Rest Encryption)
• MYSQL
• Significant Automation experience with 'shell' and 'SQL' scripting
• Significant Knowledge of MySQL version 8.x and new features
• Strong knowledge of ODBC/JDBC client/server communication

Conversion to Full-Time:
This position is contract with the right to hire if a need becomes available.

Manager will only consider candidates open to converting to full-time PNC employee.

PNC will not sponsor work visas if the decision is made to hire the contingent worker.

Function of the Group:
Platform Support Current Initiatives/Projects:
Platform support for Infrastructure group Industry Background:
Banking or Financial experience is preferred, not required

Team Dynamic: 6-member team, daily interaction

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 (versions 8.0.x, 8.4.x migrating to 8.0.42, 8.4.5) Innovate and implement Innodb clustering across multi-data centers Troubleshoot critical performance bottlenecks Review and assess database design changes.

Collaborate with IT teams and vendors Represent database group in projects Monitor, maintain, backup databases Manage database security per PNC policy Review stress testing results Automate tasks and streamline processes

Experience with automated installation and patching is a plus Mentor and support team members

Technical Skills (6+ years):
Deep understanding of MySQL storage engines Strong knowledge of MySQL 8.x and new features Automated Failover Solutions TDE (At Rest Encryption) MySQL best practices and standards Workarounds for MySQL limitations ODBC/JDBC client/server communication

Shell and SQL scripting automation

Flex

Skills:

N/A

Soft Skills:

Analytical troubleshooting Strong verbal and written communication Results-oriented, individual contributor Excellent customer service Effective interpersonal skills Consistent, high-quality service delivery Degrees/

Certifications:

Bachelor's in IT-related field Certifications are a big plus