MySQL DBA

Job Title: MySQL Database Administrator

Location: Pittsburgh, PA or Strongsville, Ohio
Job Type: W2, Hybrid

Job Summary:
We are seeking a highly skilled and experienced MySQL Database Administrator to join our team. This role is responsible for the full lifecycle management of MySQL databases, including installation, configuration, performance tuning, and security. The ideal candidate will have deep technical expertise in MySQL 8.x, a strong automation mindset, and the ability to work independently while collaborating across teams.

Key Responsibilities:

• Install, patch, upgrade, configure, and maintain MySQL databases (currently migrating from 8.0.x and 8.4.x to 8.0.42 and 8.4.5).
• Design and implement advanced MySQL capabilities, including InnoDB clustering across multiple data centers.
• Troubleshoot and resolve critical performance issues in production environments.
• Evaluate and review database design changes for performance and scalability impacts.
• Collaborate with cross-functional IT teams and vendors to resolve complex technical issues.
• Represent the database team in enterprise-wide projects and initiatives.
• Ensure database availability, backup, monitoring, and maintenance in accordance with best practices.
• Manage database security in compliance with internal security policies.
• Analyze stress testing results and provide performance recommendations to development teams.
• Automate routine database administration tasks and streamline operational processes.
• Provide mentorship and serve as a backup to other team members.

Technical Skills (6+ years):

• In-depth understanding of MySQL storage engines and architecture.
• Extensive experience with MySQL 8.x and its latest features.
• Familiarity with automated failover solutions and high availability configurations.
• Knowledge of Transparent Data Encryption (TDE) and data-at-rest security.
• Strong grasp of MySQL best practices and common limitations.
• Proficiency in ODBC/JDBC client-server communication.
• Advanced scripting skills in Shell and SQL for automation.

Soft Skills:

• Strong analytical and troubleshooting abilities.
• Excellent verbal and written communication skills.
• Self-motivated and results-driven with the ability to work independently.
• Strong customer service orientation and interpersonal skills.
• Ability to manage both routine and non-routine system issues effectively.