Дмитро

Dmitry Reva
Senior Database Developer / DBA
Tel: [open contact info](look above in the "contact info" section)
Linkedin: [open contact info](look above in the "contact info" section)
Email: [open contact info](look above in the "contact info" section)

Summary:
• 25 + years of professional experience in the Information Technology industry;
• 20 + years of experience in database development;
• Rich experience in database OLTP/OLAP development;
• Solid experience in C#/ADO.NET/Win Forms development;
• Domains of experience: financial, marketing investigation, retail;
• Development and expertise highlights:
– Database modelling and development (MS SQL, Oracle, DB2);
– Data integration and ETL processes design (SSIS);
– Data analysis (SSAS);
– Data reporting (SSRS);
– T-SQL, PL/SQL coding;
– Database performance analysis and tuning;
– Database Unit testing;
– Database migration, reverse engineering;
– No SQL (Mongo DB).

Education:
Bachelor’s Degree, Computer science, Dniepropetrovsk College of Automatics and Telemechanics,
Ukraine

Work Experience:
DataArt Solutions, Inc., (www.dataart.com)
Senior Database Developer 2019 – Present
GSApps, Inc.
Senior Database Developer 2018 – 2019
DB Best, Inc.
Senior Database Developer 2016 – 2018
SoftServe, Inc.
Senior Database Developer 2014 – 2016
Luxoft, Inc.
Senior Database Developer, Support Specialist 2012 – 2014
Centravis Ltd
Database Architect, Senior Database Developer, Project Manager 2010 – 2012
GMS Service Ltd
Senior Database Developer, Support Specialist 2008 – 2010
ATB – Market, a retail company
Middle Database Developer, Database Architect 2006 – 2008
Fozzy Ost, a retail company
Middle Database developer, Support Specialist, 2000 – 2006
Database and System Administrator, UI Developer, QA Specialist

Recently Completed Projects:

Financial projects
Client: the USA financial companies
Description: The projects work on financial operations with assets. They get financial data from
different sources and make decision which assets to buy and sell. I’ve been
occupying the DBA role in the projects and working on different SQL servers and
databases.
Platform: MS SQL Server 2019
Languages: T-SQL, XML, JSON, Powershell
Environments: Management Studio v19, Visual Studio 2022, Query Store, GIT, DPA Solarwinds
Ignite, Extended exents.
Position: Senior Database Administrator
Activities:
• Database modelling and development;
• SQL performance tuning, optimization;
• Deployment scripts preparation;
• DB Unit Testing;
• System monitoring;
• Integration tasks
• Always ON migration (creating a new AG node)
• Code revieving.

Marketing Investigations, Sales Planning, Promotional Planning
Client: Large worldwide marketing institution
Description: The application collects sales data history from different locations and stores after
the promotional actions that were applied to certain products/product groups.
There are different promotion action types such as price decrease, promotion
features, buy 2 for 1, etc. Then the application allows us to make a new promotion
action and predict sales volumes changes according to the promotions. Some
products have to sale better but meanwhile, some other products in this group will
sale less. There is a functionality that allows financiers to get the general effect of
the promotion action. So they can evaluate how approximately sales will increase
and what financial effect they will have.
Platform: MS SQL Server 2016
Languages: T-SQL, XML, JSON
Environments: Management Studio v18, Visual Studio 2015, Sql Profiler, SourceTree, Sonar
Cube
Position: Senior Database Developer
Activities:
 • Database modelling and development;
• SQL performance tuning, optimization;
• Deployment scripts preparation;
• DB Unit Testing;
• Code revieving.

System Performance Tuning Application
Client: Large worldwide software company
Description: The developed application scans performance counters of servers set and finds
out which counters are critical in a system. This application allows us to eliminate
the weaknesses in order to increase the system performance and make it more
troubleproof. For example, one server needs a more powerful CPU, another one
has insufficient HDD space. Sometimes it was beneficial to use a cloud server
instead of a physical one, etc. The application returns warnings and critical notes
as a result.
Languages: T-SQL, XML, JSON
Environments: Management Studio, Visual Studio 2015, SQL Profiler, SourceSafe
Position: Senior Database Developer
Activities:
• System requirements analysis/review;
• Database development;
• SQL performance tuning;
• Deployment scripts preparation.

Business Intelligence Project for the Retail Company
Client: Large national retail company
Description: The project included Business Analysis data cubes for sellers, the purchasing
department, and marketers. The tasks included devising and supporting
marketing's KPI part (integration and OLAP parts). There was a set of KPIs that
came from the shop branches. These KPI results were loaded into the data
warehouse and used it in the SSAS system for Business Analysts and marketers.
Languages: T-SQL
Environments: Management Studio, Visual Studio 2010, MS SQL 2008 R2
Position: Senior Database Developer
Activities:
• Database development (Stored procedures for data transforming);
• ETL development, support (SSIS);
• OLAP development, support (SSAS);
• SQL performance tuning;
• Communication with the client (BAs, PMs, Architects).
Skills:
Programming and Markup Languages:
SQL, PL/SQL, T-SQL, UML, XML, JSON, HTML, CSS

Technologies and Frameworks:
MS SQL Server(2000-2019), SSRS, SSIS, SSAS, C#(ADO.NET, Win Froms), Powershell, DPA
Solarwinds Ignite

Databases:
Oracle 9i, MS SQL Server 2000-2019, DB2, Mongo DB

Development Environments:
SSMS, Microsoft Visual Studio, Sybase Power Designer, SQL Profiler, Extended events, Query
Store, PL/SQL Developer, Powershell, MS Office, Azure cloud

Version Control Systems:
SVN, Git, SourceSafe

English level: Intermediate

Operational Systems:
MS Windows