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.
As you'll be collaborating with both internal teams and stakeholders, flexibility in work hours is required to accommodate the business's requirements.
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
- 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
- Desire to study in the field of database administration
- 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.
- English B2
Benefits
Package
- Paid 21 days of holidays per year and 10 additional days for national holiday
- Training opportunities for growth and expansion of knowledge
- Ability to work remotely
- Flexible and hybrid schedule – we value work-life balance
- Referral Bonus Program