MySQL DBA

Veterans Sourcing Group - Holmdel, NJ

Full-time - Mid Level

Holmdel, NJ

Administrative and Support Services

About the position

The Database Service team is seeking a passionate and driven Senior Database Engineer to provide operational support for Client Database Systems. This role involves designing and building database systems using automation in both data center and cloud platforms. The successful candidate will be responsible for identifying build defects and creating self-healing routines to enhance system reliability. The position operates on a hybrid model, requiring two days onsite and three days remote work each week, with a standard work schedule from Monday to Friday, 8:00 AM ET to 5:00 PM ET. Additionally, the candidate will participate in an on-call rotation, providing 24x7x365 incident and outage response, including handling non-business hours changes. The ideal candidate will have over 10 years of MySQL DBA experience, with a strong background in MySQL replication, SQL coding and tuning, and shell scripting. Experience with MySQL Enterprise Manager and AWS/Cloud Services, including EC2, RDS, and Aurora, is essential. The role requires hands-on experience in large and dynamic environments, with a commitment to following SDLC and Change-Management principles. Strong troubleshooting and performance tuning skills are necessary, along with the ability to assess and improve SQL performance. The candidate should also be adept at handling common database procedures such as upgrades, backups, recovery, and migration, while profiling server resource usage and optimizing as needed. In addition to technical skills, the candidate must possess strong communication skills, both oral and written, and be able to work independently with minimal supervision. The role also involves documenting steps taken to resolve incidents and fulfilling catalog requests within ServiceNow tickets, as well as developing and updating standard operating procedures and knowledgebase articles. Participation in skills enhancement sessions and training courses is expected, along with leading and participating in various projects related to cloud migration, lifecycle management, and performance optimization.

Responsibilities

• Provide operational support for Client Database Systems.
• Design and build database systems using automation in data center and cloud platforms.
• Identify build defects and create self-healing routines.
• Participate in an on-call rotation providing 24x7x365 incident and outage response.
• Perform initial investigation and troubleshooting of database issues to resolve issues and determine root causes.
• Process all support requests within SLA by following procedural requirements.
• Escalate to vendors as necessary to ensure timely resolution.
• Document steps taken to resolve incidents and fulfill catalog requests within ServiceNow tickets.
• Develop, document, and update standard operating procedures and knowledgebase articles.
• Identify, address, and resolve repeating alert trends to improve stability and performance.
• Suggest defects and product/infrastructure enhancements to improve stability and automation.
• Lead and participate in various projects such as cloud migration and performance optimization.

Requirements

• 10+ years of MySQL DBA experience.
• MySQL replication experience.
• SQL coding and tuning experience.
• Shell scripting and automation experience.
• MySQL Enterprise Manager experience.
• AWS/Cloud Services experience: EC2, RDS, and Aurora.
• Cloud deployments experience: Jenkins, Bitbucket, Terraform.
• Hands-on, technically adept DBA capable of performing required DB tasks.
• Strong troubleshooting/performance tuning skills.
• Ability to assess and improve SQL performance.
• Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM.
• Ability to handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Expert level MySQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills in large and dynamic environments.
• Strong commitment to following SDLC/Change-Management principles.
• Self-starter with minimal supervisory direction.
• Knowledge of data quality, data management, and data testing strategies and practices.
• Strong communication skills, both oral and written.
• Experience working with ticketing tools such as ServiceNow, Zenoss, or other monitoring tools.

Nice-to-haves

• Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
• Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.
• Experience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB, and/or Cassandra is a plus.
• Experience with configuration management tools: SCCM; Puppet; or Ansible.
• Development or enhancement of training and upskilling programs.