MS SQLData base administrator

Job Description

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 shiftsPrimary skills: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 on-premise 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 mysqldump, mysql, mysqlimport, 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 experience all HA and DR solutions.Mandatory Technical skills required Migrating on-premise 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 activitiesGood to have: Any of the following MySQL certificate:o Database Administrationo Database DeveloperSoft Skills: Good customer connects. Prepare solution presentations. Positive attitude and excellent communication skills to manage customer calls. Excellent problem-solving skills. Good communication.Educational Qualification: BCA/MCA/BE/B.Tech or equivalent

Keyskills :
mysqlazure