Project description: professional analysis service for international marketplaces - 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); - SQL-query optimization; Technology stack: - PostgreSQL v.13-15; - SQL; - Linux (Ubuntu, Debian); - Ansible; - bash; - GitLab, Git; - Zabbix; - pghero, pgbadger, pgsentinel, pg_dump, pg_dumpall, pgbackrest, pg_upgrade, patroni, etcd, haproxy - Jira, Confluence

- 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 Failover clusters for AlwaysON availability groups; - Configuring and maintenance MS SQL Server cluster with instance redundancy; - MS SQL Server and Oracle database performance optimization; - Configuring and maintenance Oracle Resourse Manager and MS SQL Server Resource Governor; - also I'm studying according the program "DevOps-engineer Pro";

- 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;

- full cycle of 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 (MS SSIS). - Administration of MS SAS analytics servers

- Front-End and Back-End support for Project Management Information System (PMIS) based on MS Project Server 2010/2013 (500 users). - Configure, monitor and troubleshoot the global enterprise directory (Active Directory), MS Exchange Server 2010/2013 mail server (5 AD sites, 2200 users), Windows network services: DNS, DHCP. - Monitoring and troubleshooting of database servers: MS SQL Server (SSIS, SSAS, SSRS) and Oracle (including search (using Profiler and Performance Monitor)), VMware virtual environment (ESXi, VSphere). - Formation of recommendations to the developers of Dynamics Ax on the creation of optimal SQL queries. - Support as a 3rd line of the following systems: Nordis, Infotech, Client-Bank (BSS), MS Dynamics Ax (300 users), etc. - Configure and troubleshoot server operating systems of the Windows and Linux family (including MySQL database replication, LAMP configuration). - Creating a portal based on MS SharePoint Server 2010.

- Maintenance SCADA-systems - Programming plant controllers - Administering MS SQL Server, Windows Servers, etc.

Computer Technology and Automated Systems Software , Degree of IT Engineer

Economics, Degree of Economics