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

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

Futurex

UI/UX Designer Job at Futurex

 ...We are seeking a talented and experienced UI/UX Designer to join our dynamic team. As a UI/UX Designer, you will be responsible for creating visually appealing and user-friendly interfaces for our digital products. You will collaborate closely with cross-functional teams... 

Atlantic Technology Services

It Technical Support Specialist Job at Atlantic Technology Services

Were seeking a Level 1 Helpdesk Support Technician who excels in...  ...Qualifications: 1-3 years of experience in a related role Should possess...  ... Possession of at least one entry-level certification (such as...  ...(ATS), our mission is to help businesses and organizations of... 

Music Service

Retail Store Merchandiser Job at Music Service

 ...for dependable self-driven individual with desire to work in a retail setting. Must be able to stand for long periods of time. Main duties...  .... Must have reliable transportation as you will be required to travel throughout Black Hills and as far east as Pierre on a weekly... 

CHS Recruiting

Orthopedic Spine Surgeon (Physician) - Flexible Schedule Options Job at CHS Recruiting

OPEN POSITION: - Physician - Spine Surgery - Orthopedic Surgery - Interventional Pain Procedures SCHEDULE OPTIONS:- Full-Time - Part...  ...ankle and foot. POSITION DESCRIPTION: The new spine surgeon will see patients in an established office and surgery... 

Piedmont Healthcare Inc.

Surgical Tech - OR, Days Job at Piedmont Healthcare Inc.

 ...EDUCATION REQUIRED: High School graduate or GED. Graduate of a Surgical Technology program. MINIMUM EXPERIENCE REQUIRED: Certification as a Surgical Technologist or 3 years of surgical tech experience required. MINIMUM LICENSURE/CERTIFICATION REQUIRED BY LAW...