Job Description:
The Level 2 MySQL Administrator oversees administration tasks for MySQL database systems. Responsibilities include optimizing performance, ensuring reliability, and providing expert support for both production and development environments. Collaboration with application developers, technical leadership, and adherence to industry standards are key aspects of this role. Strong problem-solving skills and expertise in both Windows Server and MySQL administration are essential.
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.
