Position: DBA
Category: SQL
English level: intermediate
Years of experience: 5


January 2021 — till now
Kazdream Technologies, Astana
DBA
- Cassandra, Clickhouse administration
- Maintenance of database objects, configuration, schedule backups and recovery in the event of
hardware failures or user errors
- Configure Cassandra/Clickhouse cluster with 3 replicas and different number of shards
- Performance observation and tuning
- Update DBMS versions(major/minor)
Software: CassandraDB, Clickhouse, RedHat Enterprise Linux 6/7, VirtualBox, Grafana, Promoteus.

January 2018 — January 2021
Nitec JSC, Astana
DBA
MySQL, MS SQL Server and MongoDB administration.
- Managed different sizes databases up to 20TB and with different load.
- Maintenance of database objects, configuration, scheduling backups and recovery in the event of
hardware failures or user errors
- Performance observation and tuning
- Updated DBMS versions(major/minor)
- Migrated to new hardware, installing and configure AlwaysOn Cluster and Failover Cluster for MS
SQL Server
- Set up data replication between database servers (MySQL, MS SQL, MongoDB)
- Stress tests to identify bottlenecks in the system and fix them.
- Once tested MySQL InnoDB Cluster Failover Cluster on preproduction tests.
Software: MySQL Server 5.5 / 5.6 / 5.7 / 8.0, MS SQL Server, MS SQL Server AlwaysOn, Windows Server,
WS Failover Cluster, RedHat Enterprise Linux 6/7, MongoDB 3.6, MySQL InnoDB Cluster, Insider, VirtualBox