Dmitrii is available for hire

Dmitrii Litovchenko

Verified Expert in Engineering

Query Optimization Developer

Dubai, United Arab Emirates

Toptal member since April 6, 2022

Expertise

Data Migration SQL Database MySQL Agile Development PHP Jira Data Engineering .NET ETL REST API Data Warehouse Software Architecture

Bio

Dmitrii has 20 years of experience in building data-intensive applications, tracking challenging scalability problems, and collecting and sorting data in eCommerce and travel fields. He specializes in data architecture, SQL, data pipelines, and ETL. Dmitrii focuses on the intersection of business and technical requirements to deliver an outstanding product. Customers value Dmitrii for his great passion for performance optimization.

Portfolio

Burjauto DWC LLC

Redis, Software Architecture, PostgreSQL, Query Optimization, SQL, Databases...

IVACLUB LTD

MySQL, Data Warehousing, Software Architecture, SQL, Query Optimization, Scrum...

Yamal LNG JSC

Microsoft SQL Server, Agile, Software Architecture, SQL, Databases...

Experience

Query Optimization - 14 years
Database Design - 14 years
Databases - 14 years
SQL - 14 years
MySQL - 10 years
Agile Software Development - 10 years
Microsoft SQL Server - 10 years
Data Migration - 6 years

Availability

Part-time

Preferred Environment

MacOS, JetBrains

The most amazing...

...product I've designed is a real-time online-store order processing system with 30 ETL pipelines.

Work Experience

Senior Software Engineer

2019 - 2022

Burjauto DWC LLC

Increased the entire system's performance up to 20 times by introducing a new system and software architecture.
Developed pipelines with 30 suppliers to automate the ordering system.
Decreased the database load up to five times by eliminating bottlenecks in the database structure, indices, and SQL queries.

Technologies: Redis, Software Architecture, PostgreSQL, Query Optimization, SQL, Databases, Data Migration, PL/SQL, Python, PHP, ETL, Database Design, Data Engineering, ETL Development, REST APIs, Amazon S3 (AWS S3)

Senior Software Engineer

2017 - 2019

IVACLUB LTD

Developed the company's key product, a network marketing system, and built ETL pipelines to retrieve user data from partners' websites.
Headed a team of three software engineers and used the Scrum methodology.
Constructed a data warehouse and data marts to provide analytical reports for the company's management.

Technologies: MySQL, Data Warehousing, Software Architecture, SQL, Query Optimization, Scrum, Databases, Data Migration, PL/SQL, PHP, Database Design, Data Engineering, ETL Development, REST APIs

Senior Software Engineer

2016 - 2017

Yamal LNG JSC

Designed a system and software architecture and delivered a web-based budget monitoring system that drastically reduced the amount of paperwork employees needed to submit.
Hired and led a team of three software engineers following the Scrum methodology.
Collaborated with stakeholders to gather project requirements, compiled technical project documentation, and approved it with all parties.

Technologies: Microsoft SQL Server, Agile, Software Architecture, SQL, Databases, Query Optimization, PL/SQL, Database Design, C#.NET

Team Lead

2011 - 2016

UFS LLC

Built key company products, such as railway, airline, taxi, and hotel booking services, from scratch.
Integrated Amadeus, Galileo, Sirena, and Sabre APIs.
Managed a team of five software engineers following the Agile methodology.

Technologies: Microsoft SQL Server, Agile, Software Architecture, SQL, Query Optimization, Databases, Database Modeling, PL/SQL, Database Design, C#.NET, Jira, REST APIs, Sabre Global Distribution System

Senior Software Engineer

2009 - 2011

KM Online LLC

Developed a mobile version of the social network vkrugudruzei.ru.
Achieved high system responsiveness by optimizing a database schema, SQL queries, and indices.
Developed a C# .NET serializing system to expose Microsoft SQL Server database tables across the company's projects in an XML format.

Technologies: Microsoft SQL Server, Software Architecture, SQL, Query Optimization, Databases, Database Modeling, PL/SQL, Database Design, C#.NET

Full-stack Software Developer

2005 - 2009

FIRST LLC

Created the order-processing and store-management system for 15 online stores using PHP and MySQL.
Built pipelines with 30 suppliers for downloading and processing their price lists on a daily basis.
Developed the first Russian HP online store of cartridges and paper.

Technologies: MySQL, Microsoft SQL Server, Software Architecture, SQL, Query Optimization, Databases, Database Modeling, PL/SQL, PHP, Database Design, ETL, ETL Development

Experience

Network Marketing System

This is a PHP and MySQL-based web app. As the CTO and software engineer, I built the project with technologies such as event sourcing, data warehousing, API integration, CQRS, and SOA. Also, I developed a Telegram bot for scanning bar and QR codes.

Worldwide Delivery of Automotive Parts

This is a worldwide online-store for automotive spare parts. As the software engineer, I developed a new distributed system and software architecture that eliminated numerous bottlenecks in databases, optimized all SQL queries, and implemented CQRS.

Budget Monitoring System for Yamal LNG

http://yamallng.ru/

Yamal is the second largest Russian natural liquid gas production company. As the department head, I hired and led the work of software engineers following the Scrum methodology. Also, I designed the system and software architecture and delivered a web-based budget monitoring system that drastically reduced the amount of paperwork employees needed to submit.

Education

2000 - 2005

Master's Degree in Engineering Management

Moscow State Automobiles And Roads University - Moscow, Russia

icAgile

APRIL 2010 - PRESENT

Developing Data Access Solutions with Microsoft Visual Studio 2010

Stars & S

Skills

Libraries/APIs

REST APIs

Tools

Jira, JetBrains, Sabre Global Distribution System

Languages

SQL, PHP, C#.NET, Python, Dart

Paradigms

Agile Software Development, Database Design, ETL, Agile, Scrum

Storage

MySQL, Microsoft SQL Server, Databases, Database Modeling, PL/SQL, Redis, PostgreSQL, Amazon S3 (AWS S3)

Frameworks

Angular

Platforms

MacOS

Other

Query Optimization, Data Migration, Data Engineering, ETL Development, Data Warehousing, Software Architecture, System Design

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring