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
#J-18808-Ljbffr