Back to Jobs
System One

Database Consultant Lead - Sr. at System One

System One Pittsburgh, Pennsylvania

Job Description

Job Title: Database Consultant Lead - Sr. Location - Pittsburgh, PA/Cleveland, OH/Dallas, TX/Birmingham, AL/Phoenix, AZ 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

Resume Suggestions

Highlight relevant experience and skills that match the job requirements to demonstrate your qualifications.

Quantify your achievements with specific metrics and results whenever possible to show impact.

Emphasize your proficiency in relevant technologies and tools mentioned in the job description.

Showcase your communication and collaboration skills through examples of successful projects and teamwork.

Explore More Opportunities