MsSQL

• Support high loaded and large databases in High Availability

Amazon web Service MsSQL

• Migrated from Standard to Enterprise platform

MsSQL DEV

• Involved into development process, collaborating with web-developers team
• Migrated ETL-processes from Tableau Prep Builder to SSIS

MsSQL

• Support high loaded and large databases in High Availability

MySQL DEV

• involved into development process, collaborating with web-developers team

MySQL DBA

• reconfigured basic server settings
• switched replication mode to GTID
• updated mysql from 5.7 to 8

• Redesigning current database architecture in DWH

• Performance optimizing of reports
• Taking part into upgrade database revision from 2008 to 2016

Support and Maintenance 1C+MsSQL Servers (2012-2017)

Support and Maintenance SSRS, SSIS and SSAS

Performance monitoring (SCOM), finding bottlenecks and forecasting growth needs of resources on the SQL-side

Configuring and deploy SQL Clusters (Failover and Always-On)

Developing process: SVN, Atlassian-products (Jira, Confluence, Servicedesk)

MsSQL DBA

Support and Maintenance 1C+MsSQL Servers (2012,2014)

Performance monitoring (SCOM), finding bottlenecks and forecasting growth needs of resources on the SQL-side

Configuring and deploy SQL Clusters (Failover and Always-On)

MsSQL Developer

Taking part in launch of the project in Poland based on the terasoft technology

Deal with Reporting system (SSRS) for terasoft-product and Webitel

Develop and deploy architecture for DWH (DWH-project)

Providing service of DBA for other companies in the Holding

Developing proces: SVN, Atlassian-products (Jira, Confluence, Servicedesk)

Country - Ukraine, Kyiv

Project - Deutsche bank

Development of new reporting-solution based on the Cognos.

Reporting - Cognos 9: Framework Manager, Report Studio

Database - Oracle 10g: development design of the database

ETL - Development new solution workflows on the Informatica PowerCenter 8.6

Developing proces: SVN, JIRA, Unit- and integration testing

Country - Romania, Bucharest

Project - Deutsche bank

Non-functional changes in existing CSR Reporting solution related with performance tuning and optimization.

Database - Oracle 10g: creating/modifying views and procedures

ETL - Solution migration from Informatica 8.6 platform to Informatica 9.5.1.

Developing proces: GIT, JIRA, Unit- and integration testing

ETRM implementor

Implementation of ETRM-system Allegro

- Creating Class-Events for Visual Model

- Creating Visual Templates

MsSQL Developer

- Creating objects (Stored procedures, Views, Functions, Triggers) in order to increase quality of the data

-Creating scheduled tasks for automatic data calculations and maintenance

- Developing SSRS-reports (MsSQL 2008-2012)

MsSQL DBA

Backup/restore, performance, security

MsSQL DBA

Replication, Mirroring, backup/restore, performance, security

MsSQL Developer

- Import from other external sources

- Creating objects (Stored procedures, Views, Functions, Triggers) in order to increase quality of the data

-Creating scheduled tasks for automatic data calculations and maintenance

-Creating packages for import and pre-processing the remote data using Microsoft Integration Services technology (MS SQL 2005-2008)

- Developing Analysis Services OLAP-reports (MsSQL2005-2008)

DBA:

- Oracle 9i 10g

- MsSQL 2000-2008

- MySQL 4.0-5.1

Support:

- Cognos 8BI

- Microstrategy 8.1.0

Oracle DBA 9i 10g