MySQL Architect

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.