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 disciplinesPostgreSQL administration experience of at least 3 yearsKnowledge of creating failover database clusters for PostgreSQLExperience for administrative MySQL DBExperience in building and maintaining complex replication schemesTCP / IP networking skillsColumn and Document DB experience of at least 1 year (MongoDB, ClickHouse)Knowledge of monitoring systems such as Zabbix, PrometheusExperience in designing systems running continuously and uninterruptedly (24x7x365) under high loadUnderstanding 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 experienceKnowledge of SQL language, and the ability to optimize PostgreSQL performance.Proficiency in Mandarin and English