Description

Job Code : EWC - 1417

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 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-premise 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, 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
  • Troubleshooting and resolving database issues.
  • Conforming to client compliances and expectations.
  • This role may entail after-hours support on an on-call basis.
  • Troubleshooting 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 with all HA and DR solutions.

Key Skills
Education

ANY GRADUATE

Back To Jobs