Database Consultant Lead - Sr. Job at System One, Pittsburgh, PA

M3RFMWhyRmVpV3Y3UXVwb2svV01kejAvMlE9PQ==
  • System One
  • Pittsburgh, PA

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


System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Job Tags

Contract work, Local area,

Similar Jobs

Peters of Nashua

Automotive Porter/Valet Job at Peters of Nashua

Peters of Nashua is seeking Full-Time Automotive Porter/Valets to join our Honda Service department. This full-time position will consist of 5 days per week, including possible Saturday schedule. We are looking for self-motivated, quality-minded candidates who take... 

Bestica

TRAVEL - CT Tech (726) - PSL MC -Weekend Days - 7A-7P Job at Bestica

 ...Night Shift 1 night Patient Ratios 1:1- 2 x-ray techs on same shift for additional support if needed. Type of equipment GE EMR - Meditech Typical hiring profile Skill Set Most recruited for: (Travel RNs, local CNAs and sitters) Must have: candidates without these skills... 

Expert Technology Services

Telecom/Voice Engineer Job at Expert Technology Services

 ...handling all their calls. Genesys 5 yrs Required Skills : This position requires a strong understanding of telecommunications, Genesys Cloud CX, VoIP and associated contact center call flows. Basic Qualification : Additional Skills :... 

Puff 'N Stuff Catering

Sales Event Planner Job at Puff 'N Stuff Catering

 ...Primary Objective/Responsibilities: As a Special Events Planner ("SEP") at Puff 'n Stuff Catering, your guiding light is exceeding client expectations through meticulously planned and executed events. Using your passion for hospitality, sales acumen, and event planning... 

Professional Alternatives

Attorney Job at Professional Alternatives

 ...Job ID#: 26138 Tax Associate needed for AM200 firm Our client is seeking a new associate to join join the Tax Planning and Business Transactions section. Experience in drafting, research and writing skills, and the ability to manage multiple projects independently...