Працював в 6 компаніях   23 роки 10 місяців

Недержавні організації / NGO, IT, Медицина та Охорона здоров'я, Банки

Senior Data Engineer for Data Engineering and Identity Management Team

United Nations Office in Vienna

Недержавні організації / NGO

2 роки 4 місяці

03.2022 - до теперішнього часу

  • Deployed data pipelines and data transformations which turn the raw data into relevant datasets and insights, using Databricks and Azure Data Factory
  • Assisted the development teams in deploying data applications including, close-to real-time architectures such as streaming pipelines, using Spark Structured Streaming or Azure Functions
  • Developed and maintained PySpark jobs using Azure Databricks to clean and transform data.
  • Leveraged Delta Lake to implement Lakehouse architecture.
  • Worked with dbx (Databricks CLI extensions) for Databricks workflows management
  • Developed data quality jobs using soda-core.
  • Created and configured azure cloud services.
  • Adept in troubleshooting and identifying current issues and providing effective solutions.
  • Designed and built data architectures including the design and set-up of scalable Modern Data Platforms including infrastructure-as-code, proper CICD, solid DevOps and the best-fit technologies for the use case.
  • Acted as a Data Engineer Expert on the latest trends in the data analytics landscape and shared best practices with the internal team.
  • Work with external vendors and partner technologies including AWS.
  • Designed data integration and pipeline architecture for gData2 project, provided data analytics and delivered data to gData team.
  • Deployed Azure Data Factory in UN environment, implemented data ingestion through database connections, REST API's, flat files, excel files, message queues.
  • Implemented Data Science Methods such as Data Mining and Cleansing, provided data analysis and visualization with Power BI reports and dashboards as well as legacy SSRS reports.
  • Provided technical support to gData2 project to ensure the performance KPI of the UN translators.
  • Managed and responded to escalated client inquiries. Researched products and new technologies to increase efficiency of business and operations Kept all tickets and projects updated and track time in a detailed format.

Senior Database Administrator - remote

B2B Soft Inc.

IT

6 років 2 місяці

05.2018 - до теперішнього часу

  • Managed POC production environment – 5 clusters with more than 4000 client OLTP databases, including DWH
  • Revamped backup and recovery strategies across multiple SQL servers
  • Collaborated with cross-functional teams to transition to a cloud-based infrastructure, integrating Azure SQL Database services
  • Designed and deployed database security measures, including encryption and access controls
  • Managed production performance and provided recommendations

Azure Engineer for Global Technical Team

United Nations Office on Drugs and Crime in Vienna

Недержавні організації / NGO

3 роки 6 місяців

03.2019 - 09.2022

  • Monitored, managed, and maintained day to day activities of UN Azure environments – GTT and OICT subscriptions, responded and addressed system alerts, notifications.
  • Implemented BCDR and Backup policies on Azure platforms, implemented backup channel to AWS.
  • Built scalable and reusable scripts to deploy infrastructure for GTT applications according to approved architecture and UN standards.
  • Collected requirements and created 2 years roadmap for migrating UN on premises Enterprise infrastructure to Azure Cloud.
  • Supervised contractors as Officer in Charge, created training plans.
  • Designed, implemented, configured, and maintained various Azure SaaS Cloud Services.
  • Deployed and maintained Azure IaaS Virtual Machines and Azure Application and Networking Services to support growth into the cloud.
  • Monitored performance of Azure SQL Instances and Azure Applications
  • Designed and Implemented Data Projects in Azure Data Factory and Power BI, applied Agile Software Development methodologies.
  • Created Devops pipelines for application infrastructure needs to ensure deployments are fully automated.
  • Assisted with resource provisioning, migration, configurations in Azure.
  • Managed Azure networking and security (Firewalls, Network Security Groups, identity and access management.) and monitored the logging of systems.
  • Assisted in daily administration and operational activities including monitoring, support, and maintenance of Azure workloads, worked with log collection tools and analysis such as Azure Monitor, Log Analytics Workspaces, and App Insights.
  • Supported Azure native DNS services, managed data encryption of Azure SQL Instances.
  • Applied operating system critical updates, security patches, configuration changes using Automation Accounts and Update Management.
  • Automated all deployable tasks from beginning to end to reduce manual intervention using Devops tools.
  • Coordinated with networking, firewall, security, applications teams while implementing cloud solutions.
  • Implemented Azure AD, created necessary app registrations, service principles that are required for azure services to authenticate and authorize.
  • Helped in reducing operational incidents through standardization and process improvements.
  • Implemented primary Azure services (Virtual Machines, Active Directory, Automation, Monitor, Log Analytics, Enterprise Search, Elastic Services).
  • Developed and deployed Terraform, ARM templates and PowerShell scripts.
  • Owned the business relationship with Microsoft support team. Developed, planned, managed, implemented, and fully documented IT projects.
  • Identified improvements to IT documentation, network maps, processes/procedures, and tickets.

Senior Database Administrator, Supervisor for DGACM

UNODC Austria

Недержавні організації / NGO

9 років 8 місяців

07.2009 - 03.2019

  • Managed Database production systems - locally in UN Vienna Data Center, remotely in Geneva, New York, and Nairobi Data Centers Supported development teams, validated, and optimized database design and monitored database performance in all stages – QAT, UAT and Production
  • Developed operational and statistical Reports, based on heterogeneous data sources - RDBMS, Data Warehouse, and OLAP; collected and managed SSRS execution statistics.
  • Developed and deployed OLAP cubes in SSAS for front end analysis in Excel Power View and SharePoint
  • Created KPI’s and measures to support the project goals.
  • Managed monitoring processes - global OLTP and OLAP production monitoring, replication and SSRS monitoring Developed, planned, managed, implemented, and fully documented IT projects with the PRINCE 2 methodology.
  • Installed and managed clustered and standalone Microsoft SQL Server Production Systems – Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS).Migrated production systems to major Microsoft SQL Server Versions - 2005, 2008, 2012, 2014.Managed database documentation.
  • Upgraded and patched Microsoft SQL Server database environments with the latest releases.
  • Implemented and managed Microsoft SQL Server security.
  • Implemented heterogeneous Microsoft SQL Server replication between UN Data Centers in Vienna, New York, Geneva, and Nairobi
  • Designed and implemented database disaster recovery plans, coordinated database restore verification procedures with OICT teams, scheduled the regular verification of the database backups stored on tapes.
  • Designed and developed the ETL process, deployed Data Warehouse and Analysis Services solutions for Business Intelligence.
  • Managed Microsoft SQL Server Reporting Services (SSRS) 2005/2008/2012 – standalone and farms
  • Responded to UN Helpdesk tickets and system alerts.
  • Supported change management procedure on production environments.
  • Ensured compliance with license agreements.

Senior Database Administrator

iMDsoft, Israel

Медицина та Охорона здоров'я

5 років 3 місяці

04.2004 - 07.2009

  • Planned, installed, and maintained production database environments – Microsoft SQL Server, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS).
  • Designed and implemented and managed Information Security Designed and implemented full database life cycle from conceptual and logical modeling to physical database implementation and maintenance.
  • Designed and created a documentation of data definitions, data relationships, naming and formatting standards in the development of Clinical Information Systems.
  • Supported the creation of Business Analytics, required by the hospitals. Designed the Data Warehouses and OLAP models for the clinical data analysis, designed and created statistical reports in Crystal Reports and Reporting Services
  • Integrated the data, coming from the heterogeneous sources.
  • Designed and implemented staging solutions, based on Microsoft SQL Server replication; planned, installed, and maintained Microsoft SQL Server cluster environments; implemented standby Microsoft SQL solutions such as mirroring and log shipping.
  • Supported R&D development team, generated change management scripts; provided best SQL practices to R&D team.
  • Migrated Microsoft SQL Server 2000 instances to SQL Server 2005.Planned and implemented storage benchmark tests in the leading testing lab (IBM Lab Montpelier, France; HP Lab Raanana, Israel). Deep knowledge of RAID types as well as Microsoft SQL Server virtualization
  • Developed Code and created processes to automate repetitive tasks.
  • Researched and tested new database technologies.
  • Directly contacted vendors for technical support.
  • Maintained archived data on appropriate storage devices.

Database Administrator

Nice Actimize, Israel

Банки

3 роки 5 місяців

10.2000 - 03.2004

  • Administered Microsoft SQL Server, Sybase Adaptive Server, Oracle production OLAP and OLTP production systems.
  • Designed and developed OLAP models, including cubes, dimensions, measures and events for anti-money laundering, brokerage compliance and fraud prevention.
  • Development tasks – SQL, PL/SQL objects, stored procedures, functions, triggers.
  • Designed the Statistical Data Warehouses, based on requirements, including the ETL processes, DTS.
  • Created upgrade scripts, supported R&D Team.
  • Managed Information Security Managed Backup Strategy and OLTP and OLAP performance.
  • Performed monitoring tasks on Windows and Sun environments.
  • Created and delivered internal training for the R&D Team.

Ключова інформація

Programming languages and frameworks:

  • Python
  • PySpark
  • T-SQLSoda
  • DLT

Database management systems and data warehousing:

  • MS SQL Server
  • Azure SQL
  • Google Big Query
  • Snowflake

Data Engineering and Management:

  • Azure Data Factory
  • Azure Databricks
  • Apache Airflow

Data Modeling

  • Delta lake using ADLS gen2

CICD & Version Control:

  • Azure DevOps (CI/CD)
  • GitLab

BI tools:

  • PowerBI

Cloud platforms

  • Azure
  • AWS

Навчався в 1 закладі

Sevastopol National Technical University

Радиотехника

Севастополь, 1998

Володіє мовами

Англійська

вільно

Німецька

вище середнього

Іврит

вище середнього

Російська

вільно

Українська

вільно

Volodymyr

Remote Data Engineer Database Administrator part time

Київ

25 $

51 рік

Активно шукає роботу

неповна зайнятість

Характер роботи: віддалена робота

Оновлено 1 день тому