Senior Database Engineer

Software Engineering

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.