Database Administrator - PostgreSQL / MySQL

Software Engineering Overland Park, Kansas


Description

Responsibilities

  • Act as first line of support for troubleshooting and resolving MySQL service and performance issues
  • Work with service consumers to coordinate periodic DB management operations and upgrades
  • Perform on call rotations, serving as MySQL SME and initial contact for other DB platforms
  • Monitoring of the MySQL footprint using Percona Monitoring
  • Install, configure, upgrade, and maintain/administer MySQL clusters
  • 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
  • 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
  • 2+ years supporting, maintaining MySQL databases in an enterprise environment
  • Experience with installing MySQL 5.7-8.0 and its derivatives
  • Experience with installing and maintaining PostgreSQL a plus
  • Experience with management of open-source database management technologies in a public cloud environment such as AWS is a plus
  • Operational experience with Linux operating system derivatives
  • Experience scripting in a Linux or open source-based technology such as 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.