Senior Database Engineer - MySQL

Software Engineering Overland Park, Kansas


Description

Responsibilities

  • Contribute to building architecture and lifecycle models and strategies for on-premise and AWS MySQL environments
  • Install, configure, upgrade, and maintain/administer MySQL clusters
  • Work with service consumers to coordinate periodic DB management operations and upgrades
  • Provide recommendations and execute planned adjustments for optimizing performance on all MySQL database instances
  • Manage monitoring of the MySQL footprint using Percona Monitoring
  • Manage replication administration and monitoring for the MySQL footprint
  • Act as subject matter expert for troubleshooting and resolving MySQL service and performance issues
  • Perform oncall rotations, serving as MySQL SME and initial contact for other DB platforms
  • Perform administrative tasks in the MySQL environment including but not limited to user administration, permissions, schema and instance creation, security adjustments, storage administration, backup/recovery, and service tickets
  • Collaborate with service consumers to optimize database design and queries
  • Create basic automation scripts (bash, perl, python)
  • Jenkins and GitHub experience is a plus
  • Additional responsibilities as assigned by Manager
  • Some travel may be required

Qualifications

  • Proactive and thorough communication skills with teammates, service consumers, and management are required to succeed in this role
  • 5+ years supporting, maintaining, and administering MySQL clusters in an environment of 30 or more databases
  • Strong experience with MySQL 5.7-8.0 and its derivatives
  • Strong experience with redHat Linux (or derivatives)
  • Intermediate experience scripting in bash, perl, and/or python
  • Must be able to participate in on-call rotation
  • Must have experience and be able to support operational tasks such as patching and administration that may be done outside of conventional business hours
  • Should have experience in a 24x7x365 enterprise environment meeting uptime SLAs of 99.99% or greater