Olexander

Oleksandr Vasiuk
Database Development Engineer
Software Development Engineer
Gdańsk, Poland
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
telegram: @olxvas

Summary
I am an IT professional with 25+ years of experience in software development.
My main stack is Microsoft (.NET/C#/SQL Server), I also have a background in web development, Delphi.
Database design and development always were a part of my responsibilities, as well as administration,
monitoring, and performance optimization.
Having a master degree in engineering, I try to use my skills in applied math to solve difficult algorithmic
problems.
I believe my experience with many different ERP and CRM systems makes me good at translating
business needs to the requirements, specifications, user manuals, and architectural design documents.
In my spare time I enjoy experimenting with machine learning and programming for 3D modeling.

Skillset
Languages/Frameworks: C#, .NET. WinForms, ASP.NET, JS, jQuery, Delphi, XSLT, HTML
Databases: MS SQL Server, MySQL, Oracle, MongoDB, MS Access, Interbase
Tools/Misc: Visual Studio, SSMS, PowerShell ISE, Delphi, SSRS, SSIS

Professional experience
Database Developer, Partners & Co (Gdańsk, Poland) Jan 2024
• Database performance optimization
• Legal support for migrants’ development
• Database migration (MS SQL -> MS SQL)

Tools & Technologies: SQL Server · ASP.NET MVC

SDE-II, Amazon Web Services (Gdańsk, Poland) Jun 2021 – Jun 2023
Software developer in a custom migration automation tooling team
Key Responsibilities:
● Developing various migration automation tools for multiple internal and customer projects.
● Writing code in C#, Java, and various SQL dialects (T-SQL, PL-SQL, etc.).
● Working with different frameworks and parsers (.NET, Spring, ANTLR) required to automate code
conversion.
● Writing unit, functional, integration, and load tests.

Page 1 / 3
● Creating design documents and specifications, such as BRD and TDD.
● Participating in team SCRUM ceremonies, proposing estimates, defining project scope.
● Participating in code reviews and knowledge transfer sessions.
Key Achievements:
● Designed and created full specification for SSRS to QuickSight reports converter, and later acted as a
SME for the development team. The tool was used by one key customer to transform DAL for
compatibility.
● Created test data samples generator for SQL Server databases with considering objects relations and
query parameters using parsing when database metadata is not available. Used as a part of test
environment setup.
● Developed parser of complex Oracle AWR HTML reports, which translates it to the fully customizable
JSON. The utility became part of a solution, which met security limitations.
● Took part in embedded SQL queries migration. Created parsers, analyzers, and converters for new
source languages, PHP and VB.NET. As a result, thousands of hours of manual labor are saved.

Tools & Technologies: C# · WinForms · SQL Server · SSRS · XML/XSLT/JSON

Senior Database Engineer, DB Best (Kharkiv, Ukraine) Nov 2011 – Jun 2021
Multiple projects around data management
Key Responsibilities:
● Database development, administration, monitoring, and optimization.
● Providing SDE expertise to the database engineering organization.
● Integrating various data management systems into a single solution.
● Participating in database migration projects.
● Developing in-house advanced database monitoring solution.
● Implementing database best practices for external clients.
Key Achievements:
● Using native SQL Server tools such as Query Store, I created a solution to load test repeats actual
user’s activity without access to production databases. This solution reduced 80% of index storage
and improved 20% of performance.
● Created an extension for Microsoft SSMA which emulates Oracle spatial types using SQL Server Geo
data types.
● Analyzed the performance of newly created CRM product, found multiple issues in database design
and programming objects. After my optimization the database passed performance tests and was
successfully deployed to production.
● Added to the monitoring system a component which aggregates various performance counters
metrics and shows them in a highly configurable SSRS graphic report. It allowed the support team to
predict issues and proactively make changes to the database infrastructure.
● Designed and implemented a solution which consolidates data from various sources (Mixpanel,
MongoDB, MariaDB, etc.) in a single cloud target. The solution supports comprehensive configuration
and runs in parallel to ensure less than two minutes latency.

Tools & Technologies: SQL Server · Oracle · MongoDB · MariaDB · C#

Senior Web Developer, Sigma (Kharkiv, Ukraine) Oct 2010 – Nov 2011
Microsoft Commerce Server 2007 e-commerce solution development and support
Page 2 / 3
Senior SDEngineer, Stella Systems (Kharkiv, Ukraine) Nov 2006 – Sep 2010
• Designed and singlehandedly implemented an internal workflow management, a web-site with visual
workflow designer, tasks planning, reporting, and time management.
• Integrated the internal system with Salesforce CRM, which also saved on licensing cost, using a single
account instead of individual subscriptions.
• The solution was used by ~200 people daily and replaced hundreds of shared Excel spreadsheets.

Tools & Technologies: C# · ASP.NET (WebForms) · JS · jQuery · SQL Server

Software developer, Nowy Styl (Kharkiv, Ukraine) Aug 2002 – Jan 2006
As part of a team of six people, built a comprehensive in-house ERP system, which covered Sales,
Logistics, Manufacturing, Technology, HRM, Accounting, and Finance. The system was used by the ~500
corporate employees for four years, before it was replaced by the third-party product.

Tools & Technologies: C# · MS Access · MS Exchange · SQL Server · ASP.NET

System administrator, Tekhinprom (Kharkiv, Ukraine) May 2000 – Aug 2002
System and database administration, software development. Created a comprehensive solution for
automated goods, monetary and bills accounting, which is being used to this day.

System administrator, Seat ltd (Kharkiv, Ukraine) Jul 1997 – May 2000
Participated in the development of two ERP systems and their adoption by the staff

Software Developer, Jul 1993 – Jul 1997
National Aerospace University "KhAI" (Kharkiv, Ukraine)
Developed software for electronic display boards

Freelance projects
● A utility to calculate the optimal rectangular cutting process. More than ten manufacturers of cabinet
furniture purchased the software to save on cost and time.
● A custom CRM for the small law-firm.
● An accounting system for an agricultural enterprise with plot visualization on the map.
● A dental practice management system, sold to four local clinics.

Education
National Aerospace University “KhAI”, Ukraine. Sep 1989 – Jul 1994
Master’s Degree in Process Engineering

Languages
Ukrainian, Russian: Native
English: Intermediate (B1)

Page 3 / 3