MYSQL DBA

Systech International Limited - Princeton, NJ

Full-time

Princeton, NJ

Professional, Scientific, and Technical Services

About the position

The Level 2 MySQL Administrator is responsible for overseeing the administration tasks associated with MySQL database systems. This role is critical in ensuring the performance, reliability, and security of both production and development environments. The administrator will work closely with application developers and technical leadership to ensure that the database systems adhere to industry standards and best practices. Strong problem-solving skills are essential, as the administrator will be tasked with troubleshooting and optimizing database performance. Expertise in both Windows Server and MySQL administration is a must, as the role requires a deep understanding of the underlying technologies that support the database systems. Key responsibilities include deploying, configuring, and managing MySQL database servers in high availability environments. The administrator will implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability. Additionally, they will develop and maintain robust backup and recovery procedures, ensuring that data is protected and can be restored in the event of a failure. Performance tuning and optimization are also critical components of the role, requiring the administrator to monitor database health, identify bottlenecks, and implement corrective actions as needed. Security is another vital aspect of the position, with the administrator responsible for implementing and managing database security measures, including user access controls and data encryption. Collaboration with application developers is essential, as the administrator will troubleshoot database-related issues and optimize queries to improve application performance. The role also involves creating complex new databases and application database objects, as well as coordinating production database deployments to support application requirements. Overall, the Level 2 MySQL Administrator plays a key role in ensuring the smooth operation and performance of MySQL database systems within the organization.

Responsibilities

• 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, optimize performance, and efficiently utilize disk space.
• Create complex new databases and Application database objects, and update data structures/objects in existing databases as requirements change.
• Coordinate production database deployment including tasks to promote database objects between environments in support of Application requirements.
• Provide technical leadership to Application developers in database capabilities and features, build efficient queries, and resolve Application database problems.

Requirements

• 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.