Connecting...

Sr. MySQL Database Administrator

Job Title: Sr. MySQL Database Administrator
Contract Type: Permanent
Location: Kuala Lumpur
Industry:
Salary: RM Attractive
Reference: A000 000 (AFRU-205345)
Contact Name: Chandra Surya Govindarajoo
Contact Email: chandrasurya.govindarajoo@ellwoodconsulting.com.my
Job Published: February 28, 2019 17:20

Job Description

About our client

An MNC based provider of cloud-based, on-demand software for supply chains for various industries.  

 

About the role

Responsible for administrating, maintaining, installation, configuration and upgrading MySQL databases.

 

Your responsibilities

  • Database administration including security, backup, performance-tuning, Disaster recovery and resolve broad range of database related problems on a daily basis working along with team of DBA's.

  • MySQL instances, Innodb engine, capacity planning of databases and forecast required H/W, software licenses.

  • Work with developers in defining optimal database architecture, optimizing SQL queries and overall performance tuning.

  • Building strategy for maintenance and migration/upgrade from DEV to UAT and PROD.

  • Provide thorough solutions & understanding of disaster recovery, planning and implementation.

  • Work with QA, deployment team and Product Management to understand requirements and work on database patch on UAT and production.

  • Work in on-call and be available as and when required along with a team of DBA's.

  • Monitor and optimize MySQL database performance and capacity planning.

  • Establishing and testing disaster recovery policies and procedures.

  • Root cause analysis of database related issues.

  • Ability to detect and troubleshoot DB Server related CPU, memory, I/O, disk space and other resource contention.

  • Ability to detect POC's on requirements and new releases independently.

 

You will have

  • Min Diploma, Bachelor's Degree or equivalent in Computer Science or related field.

  • Total 5+ years’ experience as MySQL DBA, strong shell scripting, Linux command line skills. 

  • Strong communication and presentation skills. 

  • Good to have knowledge on Oracle Database & Data modeling tools.

  • Experience should be on MySQL 5.6.X and above, MySQL Enterprise Backup (MEB) 3.8.X and above, MySQL Enterprise Monitor 4.0.X and above, Infobright 4.9.2 and above.

  • Experience working in large [50+] database instance environments with size ranging up-to 1TB having Master-Slave replications, group replication, InnoDB Cluster and DB Upgrades.

  • Good to have basic understanding of Oracle Database 12c w.r.t administration and backup, SQL Server.

  • Understanding of OS, network, Storage, memory, OS variables primarily on Linux Platform primarily. Thorough working experience in Linux environment is mandatory.

  • Should have thorough knowledge of MySQL replication topologies.

  • Familiar with InnoDB engine and performance tuning related to InnoDB engine.

  • Understand existing Backup and Design and Implement various MYSQL backup/recovery strategies.

  • Should have thorough knowledge of shell scripting. Should have worked on complex shell scripts [any of bash/Perl/python/C].

  • Preferred knowledge of monitoring MySQL databases through Nagios/MEM/Zabbix.

  • Good to have knowledge of Installation, configuration and upgrading of Oracle server software and working with Oracle Support.

  • Should be capable to understand and Improve upon the existing and create/update new Documents, standards and best practices.

  • Preferred knowledge of Data modelling tools like DBDesigner/ Erwin / Workbench w.r.t MySQL databases.

  • Understand requirements and deploy specific configuration databases as and when required by development team.

  • Should have experience working with MySQL Enterprise Backup Version 3.8.X and above, MySQL Enterprise Monitor 2.3.X and above, or similar technology on MySQL 5.6.X and above Databases.

  • Should be ready to work on weekend and after-hours deployment tasks as and when required.

  • Good to have knowledge/experience with Percona Toolkit, Ansible.