Працював в 9 компаніях 29 років 3 місяці
IT, Промисловість та Виробництво, Торгівля оптова / Дистрибуція / Імпорт-експорт, Освіта
SDE II
Amazon Web Services
IT
2 роки
06.2021 - 06.2023
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.
- 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 meats security limitations.
- Taken part in embedded SQL queries migration. Created parsers, analyzers, and converters for new source languages, PHP and VB.NET. As a results thousands of hours of manual labor are saved.
Tools & Technologies:
SQL Server · SSRS · C# · XML/XSLT/JSON
Senior Database Engineer
DB Best (Kharkiv, Ukraine)
IT
9 років 7 місяців
11.2011 - 06.2021
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 repeatsactual user’s activity without access to production databases. This solution reduced 80% ofindex storage and improved 20% of performance.
- Created an extension for Microsoft SSMA which emulates Oracle spatial types using SQLServer Geo data types.
- Analyzed the performance of newly created CRM product, found multiple issues in databasedesign and programming objects. After my optimization the database passed performancetests and was successfully deployed to production.
- Added to monitoring system a component which aggregates various performance countersmetrics and shows them in a highly configurable SSRS graphic report. It allowed support teamto predict issues and proactively make changes to the database infrastructure.
- Designed and implemented a solution which consolided data from various sources (Mixpanel,MongoDB, MariaDB, etc.) in a single cloud target. The solution supports comprehensiveconfiguration 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)
IT
1 рік 1 місяць
10.2010 - 11.2011
Microsoft Commerce Server 2007 e-commerce solution development and support
Senior Software Development Engineer
Stella Systems (Kharkiv, Ukraine)
IT
3 роки 10 місяців
11.2006 - 09.2010
Designed and singlehandedly implemented a 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 single account instead of individual subscriptions.
The solution was used by ~200 people daily and replaced hundreds of shared Excel spreadsheets.
Tools & Technologies:
SQL Server · ASP.NET (WebForms) · JavaScript · jQuery ·
Software Developer
Nowy Styl (Kharkiv, Ukraine)
Промисловість та Виробництво
3 роки 5 місяців
08.2002 - 01.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:
ASPNET 1.0 – 2.0 (C#) · MS Access (VBA) · MS Exchange (VBS) · SQL Server
Software Developer
Freelance projects
IT
5 років
01.2000 - 01.2005
- 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 plots visualization on the map.
- A dental practice management system, sold to four local clinics.
System Administrator
Tekhinprom (Kharkiv, Ukraine)
Торгівля оптова / Дистрибуція / Імпорт-експорт
2 роки 3 місяці
05.2000 - 08.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.
Tools & Technologies:
Delphi · Firebird
System Administrator
Seat ltd (Kharkiv, Ukraine)
Промисловість та Виробництво
2 роки 10 місяців
07.1997 - 05.2000
Participated in the development of two ERP systems and their adoption by the staff
Tools & Technologies:
Borland Pascal · Delphi · Interbase · Btrieve
Software Developer
National Aerospace University "KhAI" (Kharkiv, Ukraine)
Освіта
4 роки
07.1993 - 07.1997
Developed software for electronic display boards
Ключова інформація
Перетворювати бажання клієнта на проектні вимоги.
Наукоємна алгоритмізація.
Оптимізація.
Навчався в 1 закладі
National Aerospace University “KhAI”, Ukraine
Process Engineering
Kharkiv, 1994
Володіє мовами
Англійська
середній
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Російська
рідна
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Українська
вільно
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Додаткова інформація
Компьютерные навыки
I am an IT professional with 25+ years of experience in software development. My main stack is Microsoft (SQL Server/C#),
Database design and development always were a part of my responsibilities, as well as administration, monitoring, and performance optimization.
I also have a background in web development, Delphi.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.
I play the guitar, the recorder (block flute) etc., write musical arrangements, had my rock band.
Oleksandr
Oleksandr
Database Developer (MS SQL Server)
Харків
Активно шукає роботу
повна зайнятість
Характер роботи: віддалена робота
Оновлено 1 тиждень тому