Senior Database Administrator

Senior Database Administrator

Zeal Group Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia 2 days ago Be among the first 25 applicants This range is provided by Zeal Group. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range

HK$35,000.00 / yr - HK$50,000.00 / yr About The Company

Join Zeal Group, the award-winning FinTech Trading Platform and Trading Service provider. Our portfolio of regulated financial institutions and fintech companies is backed by a global team of 700+ professionals with headquarters in the UK and 22 offices worldwide. As a leading online trading provider for FX, commodities, precious metals, and CFD, we facilitate an estimated monthly trading volume of USD 100B by retail investors, traders, and institutions. With our Technology Hub in Cyprus, we offer a dynamic environment for creative minds. About The Role

We\'re seeking an enthusiastic and proactive Database Administrator who specializes in Database administration (PostgreSQL + MySQL) and has a strong passion for IT to join our Technical Operations team due to ZFX\'s ongoing global expansion. The chosen candidate will be responsible for maintaining our databases and providing assistance to our employees and projects related to database tasks, such as optimizing the database resources to align with the company\'s performance, redundancy, and reliability objectives. Responsibilities

Creation and maintenance of infrastructure for PostgreSQL Conduct project migrations to PostgreSQL clusters Administration of MySQL Searching for non-consistent data and adding checks to prevent similar cases in the future Reviewing new code that relates to changes in the way the database works Proactive monitoring and performance troubleshooting Accountability for the high critical environments which should be available 24x7x365 Development of an extensive replication scheme Automation for DB tasks Improving Database infrastructure (deploy and maintain column-oriented DB, Cloud DWH engines) Adherence to ITIL key principles : change management, approval procedures, etc Maintenance of documentation and inventory up to date Setting up backups, monitoring Monitoring workload of the database Qualifications

Bachelor degree or above in related disciplines PostgreSQL administration experience of at least 3 years Knowledge of creating failover database clusters for PostgreSQL Experience for administrative MySQL DB Experience in building and maintaining complex replication schemes TCP / IP networking skills Column and Document DB experience of at least 1 year (MongoDB, ClickHouse) Knowledge of monitoring systems such as Zabbix, Prometheus Experience in designing systems running continuously and uninterruptedly (24x7x365) under high load Understanding of the principles of operation and experience in maintaining cloud DVH storages (BigQuery) Experience in scripting languages (bash and / or python / perl) At least 3 years of Linux administration experience Knowledge of SQL language, and the ability to optimize PostgreSQL performance Proficiency in Mandarin and English Seniority level

Mid-Senior level Employment type

Full-time Job function

Information Technology Industries

Non-profit Organizations and Primary and Secondary Education Referrals increase your chances of interviewing at Zeal Group by 2x

#J-18808-Ljbffr