Talent.com
你所在的国家不提供此工作机会。
Senior Database Administrator

Senior Database Administrator

Zeal GroupHong Kong, Hong Kong, HK
30 天前
职位类型
  • Quick Apply
职位描述

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.

What you’ll be doing

  • 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.

Requirements

Requirements

What you’ll need

  • 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
  • 为此搜索创建职位提醒

    Senior Administrator • Hong Kong, Hong Kong, HK