MySQL Database Administrator
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.