Description

Manage the installation, configuration, and maintenance of MySQL and MariaDB databases across production and non-production environments.

Responsibilities

• Provision MySQL instances in clustered and non-clustered configurations.
• Execute database upgrades, patching, migrations, and storage engine optimizations for InnoDB and MyISAM.
• Manage backup and recovery processes using Percona backup tools and MySQLdump.
• Perform performance tuning, SQL statement optimization, and server parameter tweaking.
• Troubleshoot deadlocks, binary logs, and application-related database issues.

Required Skills

• 5+ years of experience in Oracle and MySQL administration or support.
• Hands-on experience with MySQL Workbench, MySQL Client, and MySQLdump.
• Proficiency in replication configuration and MySQL features like the event scheduler.
• Strong knowledge of Linux basics and shell scripting.
• Experience managing RDBMS, including InnoDB and MyISAM storage engines.
• Ability to handle database refreshes, archiving, and recompiling invalid objects.
• Working knowledge of Unix and Oracle environments.
• Competency in writing and optimizing complex SQL statements.

Preferred Skills

• Experience with MongoDB, Cassandra, or PostgreSQL.

Key Skills

Education

Any Graduate