MySQL DBA

SQL / MySQL Database Administration:

• Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability.
• Implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability.
• Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning.
• Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management.
• Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance.
• Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption.
• Collaborate with application developers to troubleshoot database-related issues and optimize database queries for improved application performance.
• Provide expert support for Applications databases in the development and test environments.
• Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications.
• Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.
• Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements.
• Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities.
• Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes.
• Perform production database recovery when necessary.

Qualifications:

- Bachelor's degree in computer science, Information Technology, or a related field.

- Minimum of 5 years of hands-on experience in SQL/MySQL database administration.

- Strong analytical and problem-solving skills, with the ability to think critically and strategically.

- Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.