MySQL Database Administrator (Fintech) - IC

Classy Wheeler Limited; Hong Kong; On-site; HKD 446,400 - 669,600; Full time

Job summary

A fintech solutions company in Hong Kong is seeking a MySQL Database Administrator to handle database administration for large deployment services. Candidates should have over 3 years of experience in MySQL and SQL tuning, familiarity with database HA architecture, and the ability to work independently while being a team player. This position emphasizes the administration of large-scale databases and requires expertise in a Linux environment along with scripting skills.

Qualifications

• 3+ years’ practical experience in MySQL Database Administration.
• Familiarity with MySQL HA architecture.
• Ability to work independently and as a team player.

Responsibilities

• Perform database administration for large deployment services.
• Monitor, maintain, and tune SQL for greater reliability.
• Develop scripts and test backup and recovery strategy.

Skills

MySQL Database Administration

SQL Tuning

Redis Administration

MongoDB Administration

Performance Optimization

Team Player

Education

Degree in Computer Science or related discipline

Tools

MySQL

MongoDB

Redis

Linux

Ansible

AWS RDS

Job description

MySQL Database Administrator (Fintech) - IC

Client Description

Australian-based Fintech solutions company

Job Description

• Perform database administration for large deployment services to ensure integrity, availability, security and resolve database related problems.
• Install, configure, upgrade, and patch Database systems in Production, Stage, Testing and Development environments.
• Monitor, maintain, and tune SQL for greater reliability and performance.
• Develop scripts and test backup and recovery strategy.
• Working closely with the Application Development Teams regarding technical requirements and feasibility test.

Job Requirements

• Degree in Computer Science, Information Technology or related discipline
• 3+ years’ practical experience in Mysql Database Administration, SQL tuning and holder
• Family with Mysql, MangoDB, Redis administration and Performance optimization
• Familiar with Mysql HA architecture such as: MHA, MGR / Master-Slave
• Familiar with Redis HA architecture such as Sentinel
• Familiar with MangoDB master-slave architecture
• Familiar with mysql incremental backup such as xtrabackup
• Familiar with Linux environment
• Familiar with shell/python/ruby/go
• Priority admission is given to meeting the following conditions but not must - Familiar with ansible, Familiar with AWS RDS, Experience in mysql database management over 1Tb data
• Team player and able to work independently