MySQL database administration - Chennai, India - TerraGiG
Description
We are looking for MySQL database Administration
Location: Remote
Experience:-4-7 Years
Educational Qualification: Bachelor / Master's degree in CS/ME/IT
About the role
We are seeking a skilled MySQL Database Specialist with expertise in database management and optimization, along with proficiency in cron job scheduling. The ideal candidate will have a strong background in MySQL database administration and experience with cron job scheduling. This role involves designing, implementing, and maintaining efficient databases, ensuring optimal performance, availability, and security.
Role & Responsibilities:
• Design, implement, and manage MySQL databases.
• Optimize database performance through query optimization, indexing, and other techniques.
• Troubleshoot database and application errors, and provide timely resolutions.
• Stay updated with the latest trends and technologies in MySQL, and database management.
• Document database designs, architecture, and processes.
• Design and implement cron jobs for automated tasks, such as database backups, data synchronization, and routine maintenance.
• Schedule cron jobs efficiently to minimize system impact and ensure smooth operation.
• Monitor cron job execution and troubleshoot any failures or errors.
• Optimize cron job performance and resource utilization.
Requirements:
• Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience as a MySQL Database Administrator or Developer.
• Strong proficiency in SQL and database management tools.
• Hands on Experience with database design, normalization, and optimization.
• Familiarity with MySQL replication, clustering, and high availability solutions.
• Experience with cron job scheduling on Unix/Linux systems.
• Proficiency in shell scripting and automation tools.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Ability to work effectively in a fast-paced environment and manage multiple tasks simultaneously.
• Attention to detail and a passion for ensuring data integrity and system reliability.
Preferred Qualifications:
• Experience with cloud-based database solutions (e.g., AWS RDS, Google Cloud SQL).
• Familiarity with version control systems (e.g., Git).
• Understanding of DevOps practices and methodologies.