13+ years of IT experience and minimum of 5+ years of experience on Azure Database Migration with technically guided, managed and governed the team. Willing to provide 24x7 support, flexible to work in the shifts.
Mandatory Technical skills required.
- Migrating on-premises MySQL workloads to Azure database for MySQL (single & flexible) servers
- Migrating Azure Database for MySQL (single server) to Azure Database for MySQL (flexible server)
- Security setup: Enabling & Configuring SSL Certificate Authentication to encrypt data transfer
- Day –to-day Oracle administration activities
Job Responsibilities
- Planning for Production Storage and Capacity Management.
- Create logical models and build physical models.
- Installing and Managing MySQL Clusters on Azure VMs, Provisioning Azure Database for MySQL (single & flexible) servers
- Migrating on-premises MySQL instances to Azure Database for MySQL
- Administer production and development databases, ensuring maximum availability.
- Installation and configuration of MySQL on Unix platforms
- Upgrading from MySQL 5.X to latest versions
- Applying Oracle Critical Patch Updates (CPU Patches) for MySQL
- Extensive working knowledge of utilities like mysqldump, MySQL, MySQL import, mysqldumpslow
- Demonstrable experience of working effectively with Clients, Internal teams to resolve issues.
- Good knowledge in UNIX and shell scripting
- Able to handle all MySQL Database DBA related daily maintenance tasks.
- Experience in Database/SQL Performance Tuning activities including configuring:
- innodb_log_buffer_size
- sort_buffer_size
- join_buffer_size!
- read_buffer_size.
- query_cache_type
- query_cache_size
- log_queries_not_using_indexes.
- slow_query_log
- Configuration and maintenance of backups
- Configuration of Replication
- Trouble shooting and resolving database issues.
- Conforming to client compliances and expectations.
- This role may entail after-hours support on an on-call basis.
- Trouble shooting and resolving database issues.
- Database Backup & recovery strategies
- Conforming to client compliances and expectations
- This role may entail shift & after-hours support on an on-call basis.
- Good working experiences all HA and DR solutions.
Good to have:
- Any of the following MySQL certificate:
- Database Administration
- Database Developer