Remote Senior Database Administrator

Summary

Join Zeal Group, a leading online trading provider, as a Database Administrator to maintain databases, provide assistance, and collaborate with internal teams and stakeholders.

Requirements

• 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

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

Benefits

• 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