Sql Server Data Engineer
Resume:
Oleg Marushchak
Tulsa, OK *******@******.*** 918-***-**** https://www.linkedin.com/in/oleg-marushchak/ SUMMARY
Experienced and certified Azure and Snowflake Data Engineer, MS SQL Server Database DBA/Engineer, Databricks Engineer with 20 years of expertise. Involved in designing, implementing, and optimizing data solutions and managing complex databases. Adept at leveraging advanced tools and techniques to drive data driven decision-making and ensure high performance and reliability. RELEVANT EXPERIENCE
Senior DBA & Data Engineer
Amaryllis Payments Solution Tel Aviv, Israel May 2024 -Current Time (Remote)
• Created and optimized complex SQL queries for 24/7 transactional OLTP and DWH databases on MS SQL Server (Azure VM), stored procedures, and functions to meet application requirements and ensure efficient data retrieval and manipulation.
• Developed and maintained ETL processes to integrate data from OLTP databases into a Data Warehouse, ensuring data accuracy, consistency, and seamless integration across platforms using MS SQL Server Integration Services (SSIS) and Change Data Capture (CDC).
• Monitored and analyzed database performance metrics on SQL Server instances, implemented optimization strategies and tuned configurations to ensure high performance and reliability using SSMS, Red Gate.
• Setup and resolved issue with SQL Server Always On Groups.
• Implemented and managed database backup and recovery procedures in MS SQL Server to protect data integrity and ensure business continuity in case of system failures or data loss using SSMS.
• Currently exploring the feasibility of building and migrating Data Warehouse (DWH) to Azure Databricks, focusing on its capabilities for data processing, performance optimization, and seamless integration with business intelligence tools.
Senior Data Engineer
EPAM Systems Kyiv, Ukraine July 2021 - May 2024
• Developed and managed ETL/ELT data pipelines using Azure Data Factory from scratch to orchestrate and automate data workflows, including data ingestion, transformation, and movement across various sources and destinations.
• Configured and maintained integration Snowflake with data storage solutions (Azure Data Lake, Azure SQL) and data orchestration systems (Azure Data Factory).
• Developed and implemented ETL processes for large-scale data processing using Apache Spark on Azure Databricks.
• Managed data reliability, versioning, and governance in Azure Databricks using Delta Lake.
• Optimized Azure Databricks cluster performance and workflows to improve efficiency and reduce costs.
• Implemented RBAC, slow change dimension Type 1/2, missing file functionality.
• Implemented data and workflows using Azure Data Lake, Azure BLOB Storage, Azure Functions, Azure Cosmos DB and Azure Logic Apps for efficient data processing and automation Continuously monitored the performance and health of Azure Data Factory data pipelines, troubleshot issues, and implemented optimizations to improve efficiency, reliability, and scalability of data integration and ETL processes.
• Created and optimized database schemas, tables, and indexes in Azure SQL Database to ensure efficient data storage, retrieval, and performance for application requirements using T-SQL.
• Developed, debugged, and optimized T-SQL queries stored procedures in Azure SQL Server and to handle complex data manipulation and reporting needs, ensuring high performance and responsiveness of applications using T-SQL.
• Optimized queries and data architecture in Snowflake, enhancing performance, reducing computational costs, and improving overall system response times using Snowflake SQL.
• Designed efficient data schemas in Snowflake and configured automatic scaling to meet evolving data needs.
• Migrated data in online mode from Azure SQL Database to Snowflake, including the transfer and transformation of datasets to ensure seamless integration and optimized performance in the new environment using Azure Data Factory CDC and parquet files.
• Migrated Clover (ETL tool) jobs from on-prem to cloud ADF using Azure SQL objects.
• Improved Azure Functions using Python.
• Collaborated with our Data and DevOps streams to create effective Azure DevOps pipelines.
• Improved CI\CD improvements for ADF and SQL repositories. Senior Data Engineer
Trinetix, Inc Sheridan, WY Jun 2020 - Jul 2021 (Remote)
• Designed and optimized database schemas, tables, and indexes in Azure SQL Database to enhance data storage, retrieval, and performance based on application requirements.
• Developed, debugged, and optimized T-SQL queries and stored procedures in Azure SQL Database for complex data manipulation and reporting, ensuring high performance and application responsiveness.
• Enhanced query performance and data architecture in Azure SQL Database by optimizing data structures, reducing computational costs, and configuring automatic scaling to adapt to changing data needs.
• Developed new ad-hoc queries and stored procedures on the database layer (SQL Server) using SSMS.
• Developed Azure Functions.
Data Engineer
RGC, LLC Kyiv, Ukraine Oct 2019 - May 2020 (On site)
• Created and optimized database schemas, tables, and indexes in MS SQL Server to ensure efficient data storage, retrieval, and performance for application requirements.
• Developed, debug, and optimized T-SQL queries and stored procedures in MS SQL Server to handle complex data manipulation and reporting needs, ensuring high performance and responsiveness of applications
• Developed and maintained ETL/ ELT processes (SSIS) to integrate data from source files (XML, CSV, etc.) into a Data Warehouse on MS SQL
• Server, ensuring data accuracy, consistency, and seamless integration across platforms using MS SQL Server Integration Services (SSIS).
• Developed and deployed OLAP cubes using SQL Server Analysis Services (SSAS) to enable complex data analysis and enhance business intelligence capabilities.
• Designed and developed reports using SQL Server Reporting Services (SSRS) to provide actionable insights and support data driven decision-making.
• Managed continuous migration of one billion-record database from MySQL (greater than one billion rows) to MS SQL Server, ensuring seamless data transfer and integration with minimal downtime.
• Setup automation loading from not well-structured file sources (using C# Scripts). Lead DBA & Data Engineer
Niva Pereyaslavshchiny, LLC Kyiv, Ukraine Jul 2012 - Oct 2019 (On site)
• Designed and optimized database schemas, tables, and indexes in MS SQL Server to maximize data storage efficiency, retrieval speed, and overall application performance.
• Developed, debugged, and optimized T-SQL queries and stored procedures in MS SQL Server for complex data manipulation and reporting, ensuring robust application performance and responsiveness.
• Monitored and analyzed database performance metrics in MS SQL Server, utilizing SSMS to implement optimization strategies and finetune configurations for enhanced performance and reliability.
• Implemented and managed database backup and recovery procedures in MS SQL Server using SSMS to safeguard data integrity and ensure business continuity in the event of system failures or data loss.
• Designed and implemented a Data Warehouse (DWH) using SSAS.
• Developed SSIS packages for routine migrations.
HARD SKILLS
Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Azure Logic Apps, Azure Functions, Azure BLOB Storage, Azure Databricks, Snowflake, MS SQL DBA, MS SQL, MS SSAS, MS SSIS, MS SSRS.
SOFT SKILLS
Effective communication, Time management, Conflict resolution, Microsoft Office Suite EDUCATION
Master of Engineering, Kyiv Polytechnic Institute Kyiv, Ukraine 2001 WORK AUTHORAZATION
USA: EAD, Category: C11. With any employer in any US state. CERTIFICATION AND BAGES
• Microsoft Certified: Azure Data Engineer Associate DP203 until Jun 2025
• Microsoft Certified: Azure Data Fundamentals DP-900 no expired date.
• Databricks: Lakehouse Fundamentals
• Snowflake: Hands On Essentials - Data Warehouse
Contact this candidate