- Company Name
- Mastech Digital
- Job Title
- Database Consultant
- Job Description
-
**Job Title:** Database Consultant
**Role Summary:**
Responsible for the full lifecycle management of MySQL databases (8.0.x, 8.4.x) in a mission‑critical environment, including installation, configuration, tuning, maintenance, performance optimization, and automation. Leads design and implementation of InnoDB clustering across multiple data centers, ensures high availability, data security, and regulatory compliance, and mentors junior DBAs.
**Expectations:**
- Demonstrate 6+ years of hands‑on MySQL DBA experience.
- Exhibit strong analytical, troubleshooting, and stakeholder communication skills.
- Operate independently, deliver high‑quality service, and proactively improve processes.
- Manage security, backup, recovery, and disaster‑recovery tasks in line with organizational policies.
**Key Responsibilities:**
- Install, patch, upgrade, configure, tune, and maintain MySQL 8.x databases.
- Design, deploy, and manage InnoDB clusters across multiple data centers.
- Investigate and resolve complex performance bottlenecks and system issues.
- Evaluate database design changes for performance, compliance, and security.
- Collaborate with cross‑functional IT teams and vendors on platform initiatives.
- Represent the database group in infrastructure and development projects.
- Monitor, backup, recover, and restore databases; validate disaster‑recovery procedures.
- Enforce database security policies, including Transparent Data Encryption (TDE).
- Review and incorporate stress‑testing results to ensure system availability.
- Automate routine DBA tasks to streamline operations.
- Mentor and provide technical guidance to junior team members.
**Required Skills:**
- Deep knowledge of MySQL storage engines, architecture, and latest features.
- Expertise in Automated Failover solutions, InnoDB clustering, and MySQL 8.x tuning.
- Proficiency with TDE, database security, and compliance best practices.
- Strong Shell scripting and SQL programming for automation.
- Experience with ODBC/JDBC client‑server communications.
- Familiarity with automated installation and patching tools (preferred).
- Excellent analytical, troubleshooting, and communication abilities.
**Required Education & Certifications:**
- Bachelor’s degree in Information Technology, Computer Science, or a related field.
- Professional certifications in MySQL or Database Administration (e.g., MySQL Certified DBA, Microsoft Certified: Azure Database Administrator Associate, Red Hat Certified Engineer (Databases)) are a plus.
Pittsburgh, United states
Hybrid
03-11-2025