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

S0dXUzB4Y0w0ay8yUEpvaTE4dWtlNFdaaVE9PQ==
  • 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

Dutch Miller Auto Group

Controller Job at Dutch Miller Auto Group

Controllers must have solid communication, technology, analytical and management skills. Candidates should possess knowledge of all aspects of generally accepted accounting principles (GAAP). * Planning, directing and coordinating all accounting operational functions... 

Go Intellects Inc

React Developer Job at Go Intellects Inc

 ...are seeking a candidate with 6-10 years of experience as a SME/Developer in complex enterprise-level projects. The role involves assessing...  ...4 years of experience developing, supporting, and maintaining React applications Strong teamwork and interpersonal skills... 

Hermitage Skilled Nursing

Certified Nursing Assistant (CNA) Job at Hermitage Skilled Nursing

 ...to schedule in advance Openings: Full-time and Part-time and PRN 7a-3p and 3p-11p! ~ Receive a call back within 48 hours ~...  ...company Core Values and more! Experience ~ Must be a licensed CNA in Pennsylvania Specific Requirements Must possess the... 

The Volume

Designer, Brand & Content Job at The Volume

 ...The Creative team shapes the visual identity for The Volume across shows, campaigns, events, and partnerships. We lead the design of show branding, key art, social content, and merchandise, along with high-impact sales and partnership decks. Our work builds systems that... 

Boston Medical Center

Medical Assistant - Dermatology Job at Boston Medical Center

 ...Boston Medical Center (BMC) is more than a hospital. It's a network of support and care that touches the lives of hundreds...  ...urban population in the world. Position: Medical Assistant Department: Dermatology Schedule: Full Time Position Summary: Performs...