MySQL DBA

Required Skills
· MySQL (required) - version 5.7.23-8.0.28 and some older versions at < 5.7.18
· MySQL 5.7.x and 8.0.x Enterprise Edition MySQL
· Complex P1/P2 Incident Management
· Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.
· Strong knowledge of ODBC/JDBC client/server communication
Preferred/nice to have
· Ansible
· Automation experience with ‘shell’ and ‘SQL’ scripting
· Detail-oriented, strong communication, self-starter

Day to Day Responsibilities:

• Install, patch, upgrade, configure, tune, and maintain MySQL databases (current version 5.7.23-8.0.28 and some older versions at < 5.7.18)
• Troubleshoot critical performance bottlenecks for 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 PNC’s security policy
• Review stress testing results and provide recommendations to development teams
• Automate management tasks, streamline processes, and perform standard administrative functions
• Mentor, assist, encourage, and serve as a backup to other team members
• Assist in Production releases for Critical Production Applications
• Assist for Complex P1/P2 Incident Management as required (24x7 On-Call)
• Understanding of MySQL’s underlying storage engines and ability to learn new architectures
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Analytical skills necessary to perform troubleshooting of errors and performance issues
• Strong verbal and written communication skills
• Results-oriented and able to work across the organization as an individual contributor
• Ability to work in a rapidly transforming organization
• Excellent customer service skills
• Interpersonal skills to deal effectively with all business contacts
• Technically proficient in assigned IT discipline(s)
• Ability to deliver consistent, high-quality, cost-effective service by handling routine, as well as some non-routine, systems issues

Qualification:
· HS Diploma w/certification is ok
· Bachelor's preferred (software engineering, computer science, and/or related field)
· Emphasis on work experience - 8+ years minimum regardless of education

Job Type: Full-time

Pay: $60.00 - $70.00 per hour

Benefits:

• 401(k)
• Health insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Application Question(s):

• What is the most recent version of MySQL you have used?
• How many years of troubleshooting experience you have with MySQL?
• Production support experience?
• Would be comfortable working on W2

Experience:

• MySQL: 5 years (Required)
• Ansible: 3 years (Required)

Work Location: Remote