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