Valerii Artemev

Valeriy Artem’yev Database Administrator/Architect Executive Summary • Overall more than 20 years of work experience in IT • Experience in: SQL Server - 19 years, T-SQL query optimization - 10 years, SSIS - 8 years, SSRS - 8 years, Oracle DB Server - 7 years; PostgreSQL – 3 years; MariaDB – 2 years; ClickHouse – 2 years; YandexDB – 1 year; Datastax – 1 year; Hazelcast - 1 year; • Skillful, experienced database administrator and a developer with good communication and analytical skills. Always trying to be innovative, identify and develop opportunities. • Learning agility, good self-management knowledge Technical Skills Skill Category Skill List Methodologies ITIL, Agile, Scrum, Waterflow Programming Languages T-SQL, HTML, Python Technologies WSFC, AlwaysON, All kinds of replication, Galera clustering, AWS, Git, Terraform, Ansible, HCL, Docker, GitLab, Zabbix, Prometheus, Grafana, Alertmanager, Loki RDBMS MS SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, ClickHouse, YandexDB, Datastax, Hazelcast Operating Systems Linux, MS Windows 2000/XP/Vista/7/8/10/2016/2019 Development Tools VS Code, DBeaver, PowerBI Desktop, PyCharm Certifications Certification Category Certification Grade/Remarks 1 Microsoft® Certified Database Administrator (MCDBA), Microsoft® Certified Systems Administrator (MCSA) Education Institution: Ufa State Petroleum Technological University (Ufa, Russia) Dates Attended: 2009 - 2012 Qualification: Computer Technology and Automated Systems Software Degree of IT Engineer Institution: Ural State University (Ekaterinburg, Russia) Dates Attended: 1992 - 1996 Qualification: Economics Bachelor Degree of Economics Professional Experience Company: STSoft (remote) Duration: April 2023-present Role: Database Architect Responsibilities: - Delivering expert-level (L3) support for high-load RDBMS environments, ensuring minimal downtime and quick incident resolution; - Developing and automating database infrastructure using Terraform, Ansible, and scripting in Python; - Creating and maintaining comprehensive support and operational documentation for incident handling; - Monitoring system health and performance using Prometheus and Grafana, with a focus on proactive alerting and capacity planning; Technologies: ClickHouse, PostgreSQL, DataStax, Cassandra, Hazelcast, YDB, Python, Terraform, Ansible, Prometheus, Grafana, etc. Company: MarketGuru (remote) Duration: June 2022-March 2023 Role: Database Administrator - Installing, configuring and maintaining PostgreSQL servers with heavy load, including in AWS RDS; - 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; Responsibilities: Technologies: PostgreSQL v.13-15, AWS RDS, SQL, Linux (Ubuntu, Debian), Ansible, bash, GitLab, Git, Zabbix, pghero, pgbadger, pgsentinel, pg_dump, pg_dumpall, pgbackrest, pg_upgrade, Jira, Confluence 2 Company: VTB bank (Moscow, Russia) Duration: June 2020- June 2022 Role: Database Administrator Responsibilities: database administrator’s full set of responsibilities: • Installing and configuring MS SQL Server, Oracle, PostgreSQL instances on Windows and Linux platforms with heavy load, including in AWS RDS; • Configuring PostgeSQL streaming and logical replication (OnPremises and AWS RDS horizontally scaled DBs); • 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; • and so on... Technologies: SSDS, AlwaysON, T-SQL, MS Windows FC, Linux, MS SQL, Oracle, PostgreSQL, AWS RDS Company: IAEA, SGIS (Vienna, Austria) Duration: April 2019 – April 2020 Role: Database Administrator, Report developer Responsibilities: 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 Technologies: SSDS, SSAS, SSRS, SSIS, PowerBI, Git, Azure DevOps Company: StroyGazConsalting Ltd, Gasprom (St-Petersburg, Russia) Duration: January 2016 – April 2019 Role: Database administrator, SharePoint administrator, Report developer Responsibilities: • 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 SQL Server Integration Services). • Resource Governor setting. • Administering the PowerBI Report Server, including setting up Kerberos authentication and scheduled report updates. • Administration of MS SAS analytics servers and MS SharePoint farms.• MS SQL database administration: setting up backups, identifying sources of degradation of server performance and their 3 • • • • • • 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 SQL Server Integration Services). Administering the PowerBI Report Server, including setting up Kerberos authentication and scheduled report updates. Administration of MS SAS analytics servers and MS SharePoint farms. Various reports development Technologies: SSDS, SSAS, SSRS, SSIS, PowerBI,AlwaysON,Project Server, SharePoint Server Company: Gazprom dobycha Noyabrsk Ltd, Gasprom (Noyabrsk, Russia) Duration: June 2004 - June 2015 Role: Database and System administrators Team Leader (4 subordinate employees) Responsibilities: Technologies: • 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. SSDS, SSAS, SSRS, SSIS, PowerBI, AlwaysON, Project Server, SharePoint server, Linux Foreign Language Skills Language Written Spoken English Upper-Intermediate Upper-Intermediate 4 German Pre- Intermediate Pre- Intermediate Personal qualities • Systematic approach to organizing my work • Good at multitasking • Result oriented • Using insistence and perseverance when doing my tasks • Have a great wish to improve myself • Have the responsiveness and wishing to help others • Team player Additional information I’m passing DevOps-engineer PRO programme now. 5