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

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

Health in Balance Chiropractic & Natural Medicine

Case Manager Job at Health in Balance Chiropractic & Natural Medicine

 ...obstacles to most patients' health care, which are time and money. The Care Coordinator works hand-in-hand with the doctors to manage each patients case. The Care Coordinator develops a very close relationship with patients and must have incredible communication skills.... 

Hayman Daugherty Associates

Locums/Radiology/Job/Florida Job at Hayman Daugherty Associates

 ...candidate must have an active FL medical license and DEA. MQSA required. The Radiologist must be proficient in all areas of diagnostic radiology to include, CT, Ultrasound, MRI, fluoroscopy. Must be able to read mammography to include stereotactic biopsies, needle... 

YMCA of Lincoln

Yoga/Mind/Body Instructor Job at YMCA of Lincoln

 ...OUR JOBS MEAN MORE YMCA Group Exercise Instructor's play a critical role at the YMCA. They teach youth and adults exercise techniques...  ...respect the Y build your resume CLASS FORMATS Yoga Pilates Meditation Tai Chi TRX Suspension Training... 

Grand Teton Lodge Company

Self Serv Laundry Attendant Job at Grand Teton Lodge Company

 ...review the Benefits Eligibility Summary Job Summary: Provide friendly guest service at Colter Bay Village by assisting with laundry and shower facilities, handling payments, and maintaining clean, safe spaces. Must be able to work weekends and evenings and perform...