Valerii Artemev

- deployment and configuring PostgreSQL database servers with IaC approach (Ansible). I implemented it in the company; - PostgreSQL performance tuning (pghero, pgbadger, pgsentinel); - upgrading PostgreSQL 13 -> 14 -> 15 (pg_upgrade, logical replication); - setting up and maintaining replication (physical, logical); - configuring backup system (pg_dump, pg_dumpall, pgbackrest) for PTR restoration; - setting up and maintaining PostgreSQL monitoring system (Zabbix); - - query optimization;

• Installing, configuring and maintaining MS SQL Server and Oracle instances on Windows and Linux platforms; • Implementing complete database maintenance SQL Server Agent tasks and Oracle Scheduler; • Implementing and maintaining any kind of MS SQL replication; • Configuring and maintenance MS Windows FC for AlwaysON availability groups; • Configuring and maintenance MS SQL Server cluster with instance redundancy; • MS SQL Server and Oracle database performance optimization;

- Data warehouse development - ETL-packages development based on MS SSIS - OLAP-cube development based on MS SSAS - Reports development by using MS SSRS and PowerBI Desktop - Ad-Hoc queries development by using T-SQL

• MS SQL database administration: setting up backups, identifying sources of degradation of server performance and their localization, tuning server performance for a specific environment, query optimization. • Configuring and maintaining fault tolerance of the DBMS using cluster technologies (AlwaysON, SQL Server Failover Cluster). • Maintenance of all types of data replication. • Setting up import and export of data from various sources through ETL systems (SSIS).