MY SQL DBA

Key Responsibilities

• Install, configure, maintain, and manage MySQL database servers and instances.
• Manage database access, security, user accounts, and permissions.
• Perform database upgrades, patching, and migrations.
• Monitor database performance, identify bottlenecks, and perform performance tuning and query optimization.
• Implement and manage database replication, clustering, and high-availability solutions.
• Develop and implement reliable database backup and recovery strategies.
• Diagnose and resolve database-related issues, including performance problems, errors, and security incidents.
• Provide on-call and 24x7 support for critical production database issues.
• Develop and maintain scripts to automate routine database administration, monitoring, and maintenance tasks.
• Collaborate with development teams, system administrators, and other stakeholders to ensure database performance and availability meet application requirements.

Essential Skills

• Strong hands-on experience in MySQL database installation, configuration, administration, and maintenance.
• Expertise in database performance monitoring, tuning, and query optimization.
• Experience with database replication, clustering, and high-availability solutions.
• Knowledge of database backup, recovery, upgrades, patching, and migration.
• Strong understanding of database security, access management, and user permissions.
• Troubleshooting skills for production database issues.
• Experience in scripting and automation of database administration tasks.
• Ability to provide on-call and 24x7 production support.