Lead Engineer

Job Description:

Qualifications:

Must have skills:
•    7+ 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
•    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 with hands-on experience in -large and very dynamic environments
•    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
•    Strong communication skills, both oral and written
•    Strong experience working with ticketing tools such as ServiceNow, Zenoss or any other monitoring tool, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool)
•    Strong problem-solving and troubleshooting skills
•    Keen analytical and structured approach to problem solving
•    Ability to accommodate flexible work schedules

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 is plus 
•    Experience with configuration management tools: SCCM; Puppet; or Ansible.
•    Development or enhancement of training and upskilling programs
•    Bachelor’s Degree or similar required

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
•    Suggest defects and product/infrastructure enhancements to improve stability and automation
•    Participation in periodic skills enhancement sessions and training courses
•    Be a project lead, as well as a project participant for various activities: cloud migration, lifecycle management, application modernization, capacity planning, financial optimization, performance, and stability optimization, build and design state configuration automation, etc. 

Location:

This position can be based in any of the following locations:

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday