Azure SQL Database & Data Engineering
Resume:
Page *
Yaroslav
Diachyshyn
Summary
Software Engineer with more than 32 years of experience in the IT field. Interested work with Database, Datawarehouse, ERP, CRM system, Big Data. All time dedicated to constantly improving tools and infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business. Last 2 years have focused more on Administrate role and Data Engineer, supporting database server PostgreSQL on Linux Server in AWS, MS SQL Server on Windows 2008-2022. Used PostgreSQL, MS SQL, Oracle, MySQL, MariaDB,JavaScript, AWS, Azure,python in different projects.
Technical Skills
Programming Languages
C
Zig
Rust
Go
T-SQL (PL/pgSQL)
FoxPro
HTML
C#
Java
Python
JavaScript
Node
Clouds
AWS
Azure
GCP
RDBMS / Database servers
Oracle
IBM Db2
PostgreSQL
MySQL
MongoDB
MariaDB
MS SQL
SQLite
Page 2
Cassandra
Clickhouse
ScylaDB
Redis, Valkey
Operating Systems
Windows (7-11, Server 2008-2025)
Linux (Debian, ArchLinux,Ubuntu,CentOS)
FreeBSD
Solaris, AIX
IBM OS/2
Mac OS
VMware vSphere
Tools and Technologies
Power Bi
Odoo
Microsoft Dynamics
BAF/BAS/1C
Banking, finance software
Eclipse
Tableau Desktop
Crystal Report
IntelliJ IDEA
VMware vSphere
Kafka
Hadoop
HDFS
Hive
Cassandra
Azure Databricks
Docker
Spark
Synapse Analytics
Snowflake
Airflow
IDERA ER/Studio Data Architect
Big Data
Microsoft Visual Studio
PgAdmin
Dbeaver
Page 3
Navicat
Looker
Jupyter Notebooks
Docker on Ubuntu and Windows 10,11
Hyper V
Active Directory
Microsoft Management Studio
Azure Data Studio
Microsoft Integration Runtime
Linux bash command line
Experience
Project name: Short temporary projects (6-9 months) in the financial field, insurance
( as freelancer and consultant )
Description: Development and maintenance of a working time accounting program Project responsibilities: Project Architect / Senior Data Developer /Senior Data Engineer/DBA/Data analyst
Project Architect
Administrated and developed Oracle 12c database
Azure (ADF) ETL/ELT, Data Delta Lake
Microsoft Fabric
Synapse Analytics
Databricks (fintech, retail)
AWS Glue, QuickSight,Snowflake
GCP : Pub/Sub, Dataproc:, Cloud Composer
Tableau
CD/CI
Kafka, ksqlDB, Apache Flink, Apache Iceberg
C#
Python (pySpark, polars, dbt, pandas, Pydantic, Great Expectations, dask)
Redshift
Microsoft Visual Studio
JavaScript
Looker
Spark
Airflow (DAG-python), ETL/ELT pipelines built
Kubernetes, docker
Google Analytics 4, A/B testing
Administrated, installed.supported and developed PostgreSQL 16.1
(Maintenance plan backup restore databases, replications master-slave streaming and logical ) on AWS EC2
Page 4
MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb Cluster, classic master-slave), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore databases, migration databases
MariaDB (10.3, 10.6) AWS RDS, AWS EC2,AWS Amazon Aurora
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using PostgreSQL, MySQL, MariaDB, MS SQL and other noSQL databases
MongoDB
Hadoop
Spark
Cassandra
Snowflake
Airflow
Looker
Administrate and developer, supported MS SQL 2012-2022
Replication data between databases
Administrate Linux Server based on Debian, CentOS,Oracle, Ubuntu, MS SQL Server (2017,2019)
Creating and using SSIS packages, using SSRS, using SSAS
Finance report
Solution current task
Maintenance plan backup restore databases, replications
Virtualization on Hyper-V, VirtualBox, VMware
vSphere & ESX install Windows, Linux, Freebsd and administration, installation, configuration, maintenance of relevant databases ms sql, mysql, postgresql (monitoring tools, problem solving, work optimization performance, lag replication), writing backup scripts, writing server access rules and opening relevant ports for databases (firewall), access via ssh protocol with keys. Access to the server via a web browser and management using lilo.
Installing Windows Server, Desktop operation system and MS Office
Data Modelling tools (Studio Data Architect)
Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio, Azure Data Studio, Microsoft Integration Runtime Duration: 3years
Period: 2022-2025
Customer: USA, Israel,Ukraine, Greece, Turkey, Bulgaria, Romania, Kazakhstan, Georgia Project name: Set of projects social networks (israelit.pro) Description: Development and maintenance of a working time accounting program Project responsibilities: Project Architect / Senior Data Developer /Senior Data Engineer/DBA
Project Architect
Administrated and developed Oracle 12c database
Azure (ADF) ETL/ELT, Data Delta Lake
AWS Glue, QuickSight
Page 5
Tableau
C#
Python
Microsoft Visual Studio
JavaScript
Administrated, installed.supported and developed PostgreSQL 12.1
(Maintenance plan backup restore databases, replications master-slave streaming and logical ) on AWS EC2
MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb Cluster), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore databases, migration databases
MariaDB (10.3, 10.6) on AWS EC2
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using PostgreSQL, MySQL, MariaDB, MS SQL and other noSQL databases
MongoDB
Hadoop
Spark
Cassandra
Snowflake
Airflow
Administrate and developer, supported MS SQL 2012-2022
Replication data between databases
Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2017,2019)
Creating and using SSIS packages, using SSRS, using SSAS
Finance report
Solution current task
Maintenance plan backup restore databases, replications
Virtualization on Hyper-V, VirtualBox, VMware
Installing Windows Server, Desktop operation system and MS Office
Data Modelling tools (Studio Data Architect)
Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio, Azure Data Studio, Microsoft Integration Runtime Duration: 2 years
Period: 2020-2022
Customer: USA, Philippines, Israel,Ukraine,Armenia Project name: Set of projects fintech (www.infopulse.com) Description: Development and maintenance of a working time accounting program Project responsibilities: Senior Database Developer/Senior BI Engineer/DBA /Data Engineer
Administrated and developed Oracle 12c database
Azure (ADF) ETL/ELT
Microsoft Visual Studio
Page 6
C#
Administrated, supported and developed PostgreSQL 10.1
Administrate and developer MS SQL 2012-2019
Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2012,2016)
Creating and using SSIS packages, using SSRS, using SSAS
1C Platform ERP, Trade, E-commerce
Finance report
Solution current task
Maintenance plan backup restore databases
Virtualization on Hyper-V, VirtualBox, VMware
Installing Windows Server, Desktop operation system and MS Office
Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using MS SQL and HANA. Duration: 1 years
Period: 2019-2020
Customer: USA, India, Argentina, Ukraine
Project name: Set of projects construction and e-commerce sphere Description: Development and maintenance of a working time accounting program Project responsibilities: Senior BI Engineer/Administrator
Administrated and developed Oracle 12c database
Administrated, supported and developed PostgreSQL 10.1
Administrate and developer MS SQL 2012-2019
Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2012,2016)
Creating and using SSIS packages, using SSRS, using SSAS
1C Platform ERP, Trade, E-commerce
Odoo ERP
Finance report
Solution current task
Maintenance plan backup restore databases
Virtualization on Hyper-V, VirtualBox, VMware
Installing Windows Server, Desktop operation system and MS Office
Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio
Duration: 2 years
Period: 2017-2019
Customer: UA
Page 7
Project name: Distribution sphere
Description: Development of a program for accounting of working time and payment Project responsibilities: Senior BI Engineer
Administrate MS SQL 2012, 2016,Oracle 11g, PostgreSQL 9
Administrate Windows, Linux Server
Development on MS SQL 2012, 2016,Oracle 11g, PostgreSQL 9
Optimize SQL Query
Duration: 5 months
Period: 2017-2017
Customer: UA
Project name: Construction sphere of trade company Description: Development of a program for accounting of working time and payment Project responsibilities: Senior BI Engineer
Administrated,supported Windows Server 2008
Administrate CRM system of construction, Oracle 11g database
Administrate PostgreSQL 8
Write report and optimize SQL Query
Configuration on 1C based ERP system
Calculate of salary
Procurement planning
Odoo ERP
Sales proceeds
Duration: 9 months
Period: 2016-2017
Customer: UA
Project name: Set of projects distribution sphere of trade distribute company Description: Automation of financial transactions. Optimization of logistics operations.
Project responsibilities: Senior Software Engineer
Developed module of trade and logistic
Oracle 11g database developer
Projected database table structure relation between them
Build plane optimal path shipping of goods and calculate time and viewed result on "open street" analog Google map
Depreciation calculation
Duration: 2 year
Period: 2015-2016
Customer: UA
Page 8
Project name: Set of projects automotive, distribution sphere of Trade company Description: Accounting and automation of business processes. Automation of financial transactions.
Project responsibilities: BI Engineer/Administrator
Administered Linux Server, Windows Server 2008, 2012, Oracle 11g, Sybase 9.x,MS SQL 2000-2008
Maintenance plan backup restore databases
1C platform ERP system
Created reports for clients
Optimized sales
Installing Windows Desktop system and MS Office
Planned purchases
Report about work time of Employees
Duration: 8 year
Period: 2007-2015
Customer: UA
Project name: FinTech Domain of Procredit bank (https://www.procreditbank.com.ua) Description: Practical development and support ODB (operational day of bank) and the statistical reporting of National Bank of Ukraine Project responsibilities: IT System Administrator
Administrate Oracle 11g, FoxPro
Administrate MS SQL 2000
Administrate DB2v8 on AIX
Create an application for resolved local problem
Administrate Windows 2003 Server
Manage Active Directory of Bank
Administrate Linux Server, Mail Server IBM Lotus Domino, building network infrastructure
Training users
Maintenance plan backup restore databases
Hot swap hardware on server
Supported accounting system of Bank, installing client – banking software, Loan software CRM system, Cisco hardware, lawyers software
Configure Mini ATC
Report of deposit, credit
Installing Windows Desktop system and MS Office
Handle statistic information
Write reporting and finance economic calculation of effective loan Duration: 5 year
Period: 2002-2007
Customer: UA
Page 9
Project name: FinTech Domain of Universal bank (www.universalbank.com) Description: Automation and optimization of banking operations Project responsibilities: BI Engineer/Administrator
Create on FoxPro application for resolved local problem
Administrate Novell OS
Create application for Borland Delphi to calculate Salary of Employees
Training users
Supported Database Oracle 11g
Administrate Linux Server
Supported of Bank Accounting system
Configure Client-bank system
Report of deposit, credit
Installing Windows Desktop system and MS Office
Handle statistic information
Installing supported Sybase Database
Installing Windows Desktop system and MS Office
Duration: 4 year
Period: 1998-2002
Customer: UA
Project name: Lviv railway (www.uz.gov.ua)
Description: Network projects on the Lviv railway on FoxPro 2.6, Visual FoxPro 3.0
Project responsibilities: Senior Software Engineer
Development and introduction of network projects on FoxPro 2.6, Visual FoxPro 3.0
Installing supported Sybase Database
Installing Windows Desktop system and MS Office
Installing OS/2
Create Accounting System
Training users
Finance report
Work with database FoxPro, Oracle
Resolved local task
Duration: 4 year
Period: 1994-1998
Customer: UA
Page 10
Education
M. Sc. in Mathematics
Lviv State University of Ivan Franko
Graduated in 1994
Languages
English – Intermediate
Ukrainian – Native
Contact Information
Email : *******@*****.***
Mobile:+380*********
Linked: https://www.linkedin.com/in/yaroslav-diachyshyn-74882637/ Web : https://www.yasoft.in.ua/
Telegram : @djYarko
Contact this candidate