MySQL Architect

Job Code : EWC - 1417Mandatory Technical skills required.Migrating on-premise MySQL workloads to Azure database for MySQL (single & flexible) serversMigrating Azure Database for MySQL (single server) to Azure Database for MySQL (flexible server)Security setup: Enabling & Configuring SSL Certificate Authentication to encrypt data transferDay –to-day Oracle administration activities Job ResponsibilitiesPlanning for Production Storage and Capacity Management.Create logical models and build physical modelsInstalling and Managing MySQL Clusters on Azure VMs, Provisioning Azure Database for MySQL (single & flexible) serversMigrating on-premise MySQL instances to Azure Database for MySQLAdminister production and development databases, ensuring maximum availability.Installation and configuration of MySQL on Unix platformsUpgrading from MySQL 5.X to latest versionsApplying Oracle Critical Patch Updates (CPU Patches) for MySQLExtensive working knowledge of utilities like mysqldump, mysql, mysqlimport, mysqldumpslowDemonstrable experience of working effectively with Clients, Internal teams to resolve issues.Good knowledge in UNIX and shell scriptingAble to handle all MySQL Database DBA related daily maintenance tasks.Experience in Database/SQL Performance Tuning activities including configuring:innodb_log_buffer_sizesort_buffer_sizejoin_buffer_sizeread_buffer_sizequery_cache_typequery_cache_sizelog_queries_not_using_indexesslow_query_logConfiguration and maintenance of backupsConfiguration of ReplicationTroubleshooting 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 strategiesConforming 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. Apply tot his job Apply tot his job Apply tot his job