MySQL Database Administrator

IT & Security Overland Park, Kansas


Description

The MySQL DBA is responsible for the installation, configuration, security, and maintenance of the MySQL database environment.

Responsibilities

  • Perform as the Lead DBA for the MySQL practice at Tyler Technologies Digital Solutions
  • Installing and upgrading MySQL software (Percona/MariaDB)
  • Configuring and tuning the database for performance and scalability
  • Managing and monitoring database security
  • Creating and managing database user accounts and permissions
  • Backing up and restoring the database
  • Troubleshooting and resolving database issues
  • Monitoring and optimizing database performance
  • Implementing and maintaining database replication and clustering
  • Planning for and implementing database schema changes
  • Collaborating with development team to optimize database design and queries
  • Maintain and monitor replication technologies.
  • Create basic automation scripts (Shell, Perl or Python), Jenkins experience a plus.
  • Other Responsibilities Assigned by Manager
  • Some Travel May be Required

Qualifications

  • 5+ Years supporting, maintain, administering MySQL in an environment of 30 or more databases.
  • Must be able to participate in on-call rotation.
  • Should have experience in a 24x7x365 enterprise environment meeting uptime SLA’s of 99.99% or greater.
  • Strong experience with Linux (RedHat/CentOS/Rocky)
  • Strong experience with MySQL 5.7-8.0
  • Intermediate experience writing Shell, Perl or Python
  • Experience performing system and/or storage administration and patching.