Senior Database Administrator

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

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