Job title: MySQL DBA

Location: Hybrid_ Holmdel, NJ OR Bethlehem, PA

Duration: 24 months

Skills: MySQL replication, AWS, Aurora

Job Description:

Must have skills:

• 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 experience
• Strong troubleshooting/performance tuning skills
• Ability to assess and improve SQL performance
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Strong commitment to following SDLC/Change-Management principles
• Self-starter and be able to perform work with minimal supervisory direction
• Knowledge of data quality, data management, and data testing strategies and practices

Desired skills:

• 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 plus

You will:

• Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes
• Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause
• Process all support requests within SLA by following procedural requirements
• Escalate to vendors, where necessary, to ensure timely resolution
• Thoroughly document steps taken to resolve incidents and fulfil 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