Backend Software Engineer Portfolio

2021-2023 Datastream Service

Contributed to the design of a data stream product for seamless data copying to OLAP and data lakes. The system taps into RDBMS CDC and publishes reconstructed entities to a Kafka-based messaging bus. I had full responsibility for the object materialization using the Salesforce Partner API.

Used technologies:

• Java, Avro;
• Salesforce Partner API;
• PostgreSQL/SDB.

2018-2020 DB Comparator Service

Designed and led the development of a database comparator tool that finds and reports any data discrepancies between heterogeneous data stores. It scaled extremely well to compare databases with terabytes of data. Wrapped in Sprint Boot and CLI.

Used technologies:

• Java, Spring Boot, REST, CLI;
• Oracle, PostgreSQL, MySQL.

2018-2021 Consistent DB Copy Service

Used technologies:

• Java, JDBC, Change Data Capture (CDC), Avro, JWT;
• Oracle, PostgreSQL/SDB, MySQL;
• TLS/mTLS, Hashicorp Vault Integration.

2017-2019 Static Database Copy Tool

Contributed to a highly scalable heterogeneous database cloning tool that could copy all or a subset of data between various relational databases while maintaining data consistency. I was responsible for the abstraction layer between the logic and RDBMS support, including SQL optimizations and data conflict resolutions.

Used technologies:

• Java, JDBC, Avro;
• Oracle, PostgreSQL, MySQL, Microsoft SQL Server;

2014-2016 Project: VMware vRealize Automation (vRA)

Designed, prototyped, and implemented extensibility modules to support various use cases. Also designed and implemented the product’s reports and dashboards.

Significantly improved database performance of the catalog and deployment-related vRA functionality. Analyzed hundreds of SQL statements and arranged a set of indexes to balance SQL performance and index maintenance overhead in PostgreSQL. Optimized slow SQL queries to run up to 20 times faster on a large data set.

2012-2014 Project: VMware Application Services (aka Application Director)

Worked on multiple features of VMware Application Services (AppD). Extended database and back-end. Extended ORM/service layers, and a command line interface. Was responsible for the design and implementation of the Application Services public REST API. Ensured the API version compatibility.

Used technologies:

• Java, Spring Framework, REST;

2008-2010 Project: DevOps Reporting and Dashboard

I designed and implemented hundreds of DevOps reports to support the team processes. Designed and built a DevOps Dashboard that was quickly recognized as extremely helpful by both engineering and management. Prototyped and implemented the company-wide reporting solution.

Used technologies:

• Microsoft SQL Server Reporting Services (SSRS);
• .NET (C#/C Sharp, ADO.NET);
• Oracle, MS SQL Server, MySQL, PostgreSQL.

2007-2011 Projects: VMware LabManager and vCloud Director

Converted vCloud Director database to Oracle and PostgreSQL. Made SQL performance optimizations, achieving significant (up to 47 times faster) improvements. Designed and implemented modules, frameworks, and components using Java.

Used technologies:

• Java, C#, Perl; Spring Framework, Hibernate;
• GoF patterns, architectural patterns;
• MS SQL Server, PostgreSQL, MySQL, Oracle 10g/11g trigger and stored procedure development;
• MS SQL Server Reporting Services.

2006 Project: Hardware Tracing Within The Company

Used to track 100k items of inventory. Using .NET C# I developed the Business Logic, Persistence, and Presentation application layers. I developed a database schema and stored procedures to ensure all security requirements for the application were met. A background thread is used regularly to detect if the data on the server has been modified.

Used technologies:

• MS .NET (C#/C Sharp, ADO.NET, Generics, Threading, Data Binding with WinForms, Reflection);
• Model-View-Controller pattern, GoF patterns (Factory, Singelton, Flyweight, Proxy and other patterns);
• Oracle 9i trigger and stored procedure development, PL/SQL Developer, TOAD;
• NUnit, SourceSafe.