Position: MySQL / Clickhouse / Database Administrator (DBA)
Category: SQL
English level: upper
Years of experience: 10

- migrating highload database services between different datacenters with minimum downtime;
- constantly improved response time of biggest Ukrainian ecommerce platform with optimizing database queries and code;
- written a lot of automation tools for database monitoring, migrating and setting up from scratch.
I have 5+ years DBA experience.

--- Technology stack ---
Databases:
MySQL: Percona Server / XtraDB Cluster (5.x, 8.x), MariaDB, RDS; Clickhouse (Cluster); PostgreSQL; Redis; ElasticSearch; MongoDB; Percona Toolkit

Coding Languages experience:
Python, PHP 7.x, C/C#

Hosting solutions experience:
Bare metal, AWS, GCP

Other technologies/approaches:
Linux, HAProxy, CHProxy, Percona Monitoring Management, Zookeeper, Git, ELK, Sentry, Celery/Azkaban, RabbitMQ, Jenkins, Docker, Nginx, IoT

Key features:
- managing huge databases (> 5 Tb) and huge amount of servers (> 40) simultaneously;
- automating routine processes, migrations, setting up new servers and their monitoring/alerting;
- huge experience with highload products;
- outstanding experience in MySQL queries optimization and performance analyzing;
- strong problem-solving skills;
- communicative and proactive;

--- Experience ---
-- [Product] IL --
Highload. Services with distributed infrastructure. Managing and planning infrastructure, optimizing queries and configs, planning DC migrations and scalability, new servers setup, maintaining Percona Xtradb Cluster. Using SaltStack to automate new servers setup and monitoring. Managing and maintaining Clickhouse cluster, few PostgreSQL servers. Migrating from Zookeeper to Clickhouse Keeper, planning new services etc.

-- [Product] UK --
Supporting Percona XtraDB Cluster and maintaining setup of new servers. Infrastructure planning and maintaining: DC migration (cloud to bare metal), backup strategy, config tuning, improving observability, monitoring and reacting to incidents. Migrating from MySQL 5 to MySQL 8.

-- [Product] DE --
In this role I was researching and implementing new technologies product-wide and optimizing existing. Mainly focused on database (MariaDB) optimizations.

-- [Product] IL --
Got almost 2 years experience as Solution Architect in Israeli shared-economy platform. Here I participated in all critical technical decisions, financial planning and discussions with business partners.

-- [Product] UA --
Highload. Started as developer, in short terms became team lead of production-responsible team and since then was on the edge between developers and devops team. Managing and maintaining Percona Xtradb Cluster with huge amount of nodes and RAM.
In passion with useful solutions and open-minded people. Love to bring real value and evaluate the results. Long-term cooperation is preferable.