Senior Database Engineer - MySQL

Senior Database Engineer - MySQL

Location: Overland Park, Kansas

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 on-call 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