MYSQL DBA

Role MYSQL DBA

Skill MYSQL with Azure

Work Location PAN India

Experience 10 years

Immediate joiner preferred.

Summery:

Hands on experience on Azure Database Migration with technically guided managed and governed the team. Willing to provide 24x7 support flexible to work in the shifts.

KEY RESPONSIBILITIES

MySQL:

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 onpremise MySQL instances to Azure Database for MySQL.

Monitor & support production and development databases ensuring maximum availability after the migration for a brief period.

Installation and configuration of MySQL on Unix platforms.

Upgrading from MySQL 5.X to latest versions.

Extensive working knowledge of utilities like MySQL dump MySQL MySQL import

MySQL dump slow.

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 logbuffersize.

* sortbuffersize.

* joinbuffersize.

* readbuffersize.

* querycachetype.

* querycachesize.

* logqueriesnotusingindexes.

* slowquerylog.

Configuration and maintenance of backups.

Configuration of Replication.

Trouble shooting and resolving database issues.

Conforming to client compliances and expectations.

This role may entail afterhours support on an oncall basis.

Trouble shooting and resolving database issues.

Database Backup & recovery strategies.

Conforming to client compliances and expectations.

This role may entail shift & afterhours support on an oncall basis.

Good working experience all HA and DR solutions.

Mandatory Technical skills required

Migrating onpremise 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 today Oracle administration activities.

Good to have: Any of the following MySQL certificate:

* Database Administration.

* Database Developer.

Soft Skills:

Good customer connects. Prepare solution presentations.

Positive attitude and excellent communication skills to manage customer calls.

Excellent problemsolving skills. Good communication.

Educational Qualification:

* BCA/MCA/BE/BTech or equivalent.