Data Architect & Data Engineer - SQL

MYKOLA VASYLIV

Seattle, WA • 425-***-**** • *******@*****.*** • linkedin.com/in/mykola-vasyliv

Authorized to work in the United States • No sponsorship required DATA ARCHITECT • DATA ENGINEER • SQL DATABASE DEVELOPER SUMMARY

Data architect and data engineer who designs and builds enterprise data platforms end to end — data lakes, warehouses, Spark and Airflow pipelines, and the relational systems behind them. Architected a distributed hybrid-cloud data lake handling 10B+ records and led its migration to AWS. Deep SQL foundation across PostgreSQL, MS SQL Server, Oracle, and Sybase, with extensive work in data modeling, ETL performance tuning, and legacy-to-modern data conversion. Mentors engineers on SQL and data modeling practice.

TECHNICAL SKILLS

Data Architecture: Data lake and data warehouse design, medallion architecture (bronze / silver / gold layers), data marts, dimensional and relational modeling, ETL/ELT, batch and event-driven pipelines, data profiling and cleansing, replication, SAP PowerDesigner

Big Data: Apache Spark, PySpark, Scala, Python, Hadoop, Hive, Kafka, Airflow, Oozie, Zeppelin, Hortonworks Data Platform

(HDP)

Cloud: AWS (S3, Glue, Athena, CloudFormation), Google Cloud storage and data services, Kubernetes, OpenStack Databases: PostgreSQL, Microsoft SQL Server (2000–2014), Oracle, Sybase ASE and SQL Anywhere (ASA 5–12), MySQL, Hive, Informix

Languages: SQL, T-SQL, Scala, Python, C#, JavaScript, PowerScript

.NET: ASP.NET MVC, ADO.NET, Entity Framework, WinForms Platforms & Tools: Linux (Ubuntu, CentOS), Windows Server, GitLab CI, Grafana, Apache Ranger, Kerberos, LDAP, Keycloak, PowerBuilder

PROFESSIONAL EXPERIENCE

ScalHive Dec 2017 – Present

Data Architect — Data Lake & Data Warehouse Remote (Ukraine) B2B Marketing Suppression Platform 2020 – Present

• Refactored core data models for a high-volume unsubscribe and suppression service, improving query performance and simplifying downstream reporting.

• Optimized ETL workloads across Spark and Hive, reducing processing time and cluster cost on recurring batch jobs.

• Migrated workflow orchestration from Oozie to Airflow DAGs, giving the team clearer dependency management, retries, and monitoring.

• Mentored new engineers on SQL and data modeling, raising query quality and reducing review cycles. Stack: Scala, Apache Spark, Kafka, AWS S3, Apache Ranger, Hortonworks Data Platform, Airflow, PostgreSQL Data Platform Migration to AWS 2019 – 2020

• Architected and prototyped a distributed data warehouse on AWS, defining storage layout, partitioning, and ingestion patterns.

• Reviewed the existing data lake and warehouse implementation and produced the migration and modernization plan.

• Redesigned batch and event-driven workflows for large-scale processing in the new cloud environment.

• Designed and implemented data ingestion pipelines feeding the migrated platform. Stack: AWS Glue, S3, CloudFormation, Scala, Apache Spark, Kafka, Hortonworks Data Platform, Airflow, PostgreSQL Hybrid-Cloud Data Management Platform 2017 – 2019

• Architected a distributed data lake spanning on-premises and cloud infrastructure.

• Implemented the data warehouse and downstream data marts serving analytics consumers.

• Designed batch and event-driven workflows for big data processing across the platform.

• Built profiling and cleansing processes for 10B+ records, covering deduplication, filtering, and validation. Stack: Scala, Apache Spark, Hive, Oozie, Kafka, Zeppelin, Hortonworks Data Platform, PostgreSQL, Google Cloud, Kubernetes, OpenStack, GitLab CI, Python, Grafana, Keycloak, LDAP, Kerberos, Linux ViknarOff Jan 2017 – Aug 2017

.NET Developer Ternopil, Ukraine

• Developed business applications against MS SQL Server using C#, ADO.NET, and Entity Framework. Independent Consultant (Upwork / oDesk) 2007 – 2017 Database & Application Developer Remote, International Clients

• Delivered database design, application development, and data migration projects for clients in the US and Europe across a sustained 10-year freelance practice.

• Galactica Alianca (2015–2016): built automated ingestion of supplier price lists (XML, XLS, CSV) from URLs and file drops into MS SQL Server, plus a WinForms product-search application. Stack: C#, .NET, ASP.NET MVC, Entity Framework, Python, PowerBuilder, PowerDesigner, MS SQL Server, MySQL, Sybase ASA Luxoft Dec 2006 – Nov 2007

PowerBuilder Developer Kyiv, Ukraine

• Built and maintained enterprise client/server applications on PowerBuilder and Oracle 9.2 for an international outsourcing client.

EARLIER EXPERIENCE

Kameo — Project Architect / Database Designer (2005 – 2006). Designed MS SQL Server 2000/2005 databases and client applications; data modeling in PowerDesigner.

Universalna Insurance Company — Developer (2004 – 2005). Built a nationwide compulsory-liability insurance system with SQL Remote replication across regional branch offices. TernopilGas — Programmer / Analyst (1999 – 2004). Designed and delivered a 250+ table Sybase SQL Anywhere billing and metering system for natural gas subscribers; built a reusable conversion framework that migrated business data from multiple legacy sources into the new schema, with stored-procedure validation and reconciliation reporting. Industrial Investment Bank — Programmer (1993 – 1999). Developed accounting, deposit, and credit-agreement applications for bank operations.

EDUCATION

Ternopil State University — Department of Physics and Mathematics, Ternopil, Ukraine Degree recognized as equivalent to a U.S. bachelor's degree (credential evaluation available on request). LANGUAGES

English (professional working proficiency) • Ukrainian (native) • Russian (fluent)

Contact this candidate