MySQL Database Administrator

You are an experienced MySQL Database Administrator (DBA) responsible for ensuring the Performance, Database Tuning, Database Clean-up, Database Migration, Database Availability, and Security of Clusters of MySQL Instances. Your role involves Orchestrating Upgrades, Backups, and Provisioning of Database Instances in both Clustered and Non-Clustered Configurations. You will work in collaboration with other teams, documentation, and specifications as required. **Key Responsibilities:** - Provision MySQL instances in Clustered and Non-Clustered Configurations - Ensure Performance, Database Tuning, Database Availability, and Security of MySQL Instances - Develop Database Schema and Entity-Relationship Diagram (ERD) - Identify the Root Cause of Database related issues and perform Database Clean-up - Migrate Data from Customer Database to Serosoft Product Database - Prepare Documentation and Specifications - Handle common database procedures such as upgrade, backup, recovery, and migration - Profile server resource usage, optimize, and tweak as necessary - Collaborate with team members and stakeholders **Skills and Qualifications:** - Strong proficiency in MySQL database management - Decent experience with recent versions of MySQL - Understanding of MySQL's underlying storage engines (e.g., InnoDB, MyISAM) - Experience with replication configuration in MySQL - Proficient in Database Clean-up and Migrations - Knowledge of De-Facto Standards and Best Practices in MySQL - Proficient in Writing and Optimizing SQL statements - Familiar with Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc. - Ability to decide when to create Views (Standard Views, Indexed views, and Partitioned views) - Knowledge of MySQL features such as its Event Scheduler - Ability to plan Resource requirements from High-Level Specifications - Familiarity with other SQL/NoSQL databases (e.g., PostgreSQL, MongoDB) - Understanding of limitations in MySQL and their workarounds compared to other relational databases - Proficient with code versioning tools like SVN/Git - DBA Certification would be an added advantage,