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
-
1 week agoShareSarasota, FL 34243
-
1 week agoShareArlington, VA 22201+79 locations
-
16-01-2023ShareWashington State
-
15-01-2023ShareLaurens, SC 29360+52 locations
-
10-01-2023Share+1 locationRemote