Responsibilities
Manage MySQL databases, including single instances and cluster configurations (InnoDB and NDB Cluster).
Ensure performance, security, and high availability of MySQL databases.
Identify and proactively resolve performance bottlenecks and database-related issues.
Optimize SQL queries for peak efficiency across all supported database systems.
Implement and maintain robust database backup and recovery strategies for MySQL.
Configure and enforce stringent security measures and access controls.
Monitor databases using state-of-the-art tools and respond swiftly to alerts.
Set up and manage database replication and clustering for high availability and failover.
Create and maintain comprehensive documentation of database configurations and procedures.
Develop automation scripts to streamline routine DB admin tasks.
Collaborate effectively with development and IT teams to troubleshoot and resolve issues.
Manage underlying operating systems (Linux, Windows, etc.) hosting the databases.
Develop shell scripts for automating tasks related to databases and operating systems.
Lead and manage a team responsible for data purging and retention policies.
Provide 24/7 support and resolution for production database issues.
Qualifications
Having Bachelor's degree in the relevant field.
4+ Years of Experience of Database Administration