What are the responsibilities and job description for the MYSQL DBA W2 Paid Position position at Consulting Solutions LLC?
Job Details
MYSQL DBA
Hybrid
Contract
Screening Questions:
- Please provide a detailed example of when you used a large platform in your previous employment? (production support, life cycle)
Position Title: Database Administrator Lead (MySQL DBA)
Position Location: Hybrid 3 days in office, 2 remote
- Most preferred - Pittsburgh, PA 15222
- Second preferred - Strongsville, OH 44136
- All other locations - Birmingham, AL 35233; Farmers Branch, TX 75234; Phoenix AZ 85016.
Roles and Responsibilities:
- The Senior MySQL DBA will have responsibility primarily for MySQL database technologies.
- 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 PNC s 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 MySQL s 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
Soft Skills:
- 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
- Excellent customer service skills
- Interpersonal skills to deal effectively with all business contacts
- Ability to deliver consistent, high quality, cost effective service by handling routine, as well as some non-routine, systems issues
Consulting Solutions and its family of companies is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at: