Basic-Profil
Profilbild
Alexander Zhirov
Sofort verfügbar
Noch kein Titel gesetzt

Allgemeine Informationen

Startdatum
ASAP / ab sofort
Remote
Nicht angegeben
Umzugsbereitschaft
Nicht angegeben

Kenntnisse

Sprachen
Deutsch Englisch
Skills
Agile Amazon Aurora Ansible Apache Kafka Apache Solr Apache Spark AWS AWS Lambda Azure Benchmarking Big Data CI/CD Cloud Clustering Data Engineering Data Models Data Warehouse DBA Debian DWH Encryption ETL Frameworks Grafana Hadoop Helm IoT ITIL Linux Microservices Microsoft SQL Server MySQL OLAP Perl PL/SQL PostgreSQL PowerShell Prometheus Python RHEL Scrum Snowflake Spark SQL Tableau Transformation Ubuntu Virtualization Windows Windows Server DevOps GCP Java Kubernetes RabbitMQ Sales Salesforce Terraform VMware

Berufs- und Projekthistorie

  • Senior Data Architect and Data Engineer with over 25 years of experience in designing and delivering large-scale

data architectures and strategies, analytics solutions, cloud transformations and migrations.

  • Extensive hands-on experience in architecting and implementing large-scale data platforms in cloud and on-premises.
  • Strong proficiency in data architecture: Data Warehouse, Operational Data Store, Data Lake, Lakehouse, Data Mesh.
  • Deep expertise in data modelling: Relational, Dimensional (Star, Snowflake, Galaxy), Data Vault, Data Marts, 3NF.
  • Extensive experience with Massively Parallel Processing (MPP) and Distributed Data systems.
  • Significant knowledge and experience with Data-as-a-Service (SaaS/DaaS), AI/ML analytics and Business Intelligence.
  • High Proficiency in designing and implementing high-performance ETL/ELT and streaming data pipelines.
  • Strong background in Data Governance, Data Lineage, Data Quality and Data Security.
  • Expert in optimization and administration of high volume OLTP/OLAP databases in mission-critical 24x7 environments,

improving performance, scalability, and high availability.

Core Technical Skills

Cloud and Infrastructure AWS, Azure, GCP, VMware vSphere, Kubernetes

Data Platforms Snowflake, Azure Synapse, Microsoft Fabric, Databricks, Amazon Redshift, Greenplum

Big Data and Processing Apache Spark, Hadoop (HDFS, Hive), AWS EMR

Streaming and Integration Airflow, DBT, Kafka, AWS Kinesis, Debezium, RabbitMQ, AWS Glue, Pentaho, Talend, ADF

Programming and Scripting Python, PySpark, Java, Perl, PowerShell, Unix Shell, SQL, PL/SQL, PL/pgSQL

Databases Oracle, Oracle RAC, PostgreSQL, MS SQL Server, MySQL, AWS RDS, Azure SQL

Operating Systems Unix (HP-UX, Solaris, AIX), Linux (RHEL, Debian, Ubuntu), Windows Server

DevOps and Methodologies CI/CD, Docker, Helm, Terraform, Ansible, Agile/Scrum, ITIL Fundamentals

Work Experience

Senior Solution Architect - Data and Analytics | HCL Technologies Inc. | Feb 2021 - Present

Work with different customers to provide in-depth technical support by designing and implementing data and analytics

solutions. Provided strategic advice and best practices on cloud data platforms, data warehouses and data analytics. Led

technical assessments and architected solutions for cloud migrations and adoption, data architecture modernization and

advanced analytics implementations.

  • Enterprise Data Platform Modernization: Led AWS data platform modernization by architecting and developing

centralized medallion data architecture with dimensional model and integrated data marts. Developed modular and

fault-tolerant data pipelines using Airflow and dbt. Created data lineage for Tableau and Salesforce CRM to improve

auditability and root-cause analysis of data issues. Optimized Snowflake by using clustering keys, result caching, and

compute resource allocation.

  • AWS Data Warehouse Migration: Migrated large Oracle data warehouse to AWS using Amazon Redshift and

Informatica Cloud Data Integration. Designed cloud-native data model and architecture, integrated AWS S3 for data lake

and AWS Lambda for automated processing. Implemented multi-region and multi-cluster data sharing for high

availability and accessibility. Set up AWS SageMaker for ML/AI models and notebooks, integrated Data Lake and DWH.

  • Azure Business Intelligence Platform: Architected and implemented data platform on Azure Databricks and PowerBI.

Designed and developed data streaming pipelines using Debezium for CDC and Delta Live Tables (DLT) for Data Lake

ingestion and transformation. Architected and developed centralized semantic model (tabular model) using Azure

Analysis Service (AAS). Improved Spark Cluster performance by optimizing partitions, shuffles and cache.

  • Data Vault Model Enhancement: Enhanced Data Vault model for efficient data ingestions and transformations,

optimized load performance and query execution times. Tuned SQL queries, implemented materialized views, and

optimized keys and hashing with binary storage. Architected and developed Point-in-Time (PIT) and Bridge tables, and

reviewed business keys, links, and model granularity for accuracy and performance improvement.

  • Master Data Management Migration: Migrated IBM InfoSphere MDM to Informatica Cloud Pak for Data (CP4D),

ensuring master data consistency. Developed data mapping, transformation, and validation processes to improve data

quality and accuracy. Performed benchmark for containerized environment and suggested improvements.

  • Strategic Advisory and Client Engagement: Conducted technical assessments of customers data platforms and

developed roadmaps for cloud transformation. Provided executive presentations and technical workshops. Collaborated

with cross-functional teams, running complex program management, including cross-project planning.

Key Technologies: Oracle, AWS (Redshift, S3, Lambda, SageMaker), Azure Databricks, Azure Data Lake, Azure Data

Factory, Azure Analysis Service, Azure Synapse, PowerBI, Data Vault 2.0, Tableau, dbt, Airflow, Python, Spark

Senior Data Solutions Engineer | VMware Inc. | Sep 2022 - Jan 2025 | Freelance

Engaged part-time for strategic enterprise customers, managed end-to-end data architecture and solution design, with

focus on cloud migration, data platform modernization, transformation, and ML/AI analytics implementation. Provided

strategic advice on cloud migration, performance tuning, and data engineering best practices.

  • Private Cloud Data Platform Implementation: Architected and deployed private cloud data platform on VMware

vSphere cluster tailored to customer’s infrastructure and AI/ML workloads requirements. Designed and implemented

multi-tier reference architecture integrating Greenplum MPP data warehouse for large-scale analytical processing,

Apache Kafka for real-time event streaming, Kubernetes for containerized data workloads orchestration, and Apache Solr

for distributed text search and indexing. Developed real-time data ingestion and transformation pipelines using Kafka

Connect and Schema Registry. Optimized Kafka on Kubernetes by tuning partitions, replication factors, and broker

configurations. Implemented observability and monitoring by Prometheus/Grafana.

  • Enterprise Data Warehouse Migration and Optimization: Led Oracle Exadata to Greenplum cluster migration,

rearchitected data models and optimized storage for high-performance queries. Implemented RabbitMQ with Debezium

for real-time change data capture (CDC) and streaming. Implemented VectorDB for Generative AI and large language

models (LLMs) for advanced search and retrieval of data.

  • Cloud Migration Proof of Concept: Designed and executed multi-cloud migration PoC, assessing AWS, Azure, and GCP

for compatibility with enterprise data and analytics workloads. Defined success KPIs (e.g., data transfer throughput, query

latency, storage performance, operational cost efficiency, and scalability benchmarks) to objectively assess each platform.

Executed end-to-end data migration tests including bulk data transfer. Validated analytics and streaming/real-time

processing for performance and integration with existing pipelines. Delivered architecture recommendations for full-

scale adoption, multi-cloud integration patterns and data lake/data warehousing layer strategies.

  • Data Platform Modernization and Advisory: Assessed legacy on-premises data infrastructure and designed modern,

cloud-native data platforms using Greenplum MPP DWH and containerized microservices (Kubernetes). Advised on

scalability, disaster recovery, and high-availability architectures.

Key Technologies: Greenplum, Kafka, Kubernetes, Apache Solr, RabbitMQ, Debezium, dbt, Airflow, AWS, Azure, GCP

Lead Data Architect | AUTO1 Group | Aug 2020 - Feb 2021 | Freelance

Architected and implemented AWS based data warehouse, integrated real-time data streaming with Apache Kafka and

AWS Aurora (PostgreSQL). Designed and implemented ETL pipelines using AWS Glue, Spark, and PySpark. Created data

lake and data warehouse with Amazon Redshift/Spectrum and AWS S3. Created master data management and data

dictionary using AWS Glue Catalog. Implemented data governance policies, security protocols, and access controls.

Key Technologies: AWS Glue, Amazon Redshift, Amazon Aurora, Amazon S3, Kafka, Spark, PySpark, Python

Associate VP - Data Solutions and Analytics | Evalueserve Inc. | Jul 2019 - Aug 2020

Led architecture and implementation of data solutions, analytics infrastructure, and cloud transformation programs.

Designed data strategies for data platform optimization and led AI/ML adoption for BI and predictive analytics. Provided

thought leadership in big data engineering and cloud migration projects.

  • Enterprise Data Transformation: Led modernization of on-premises legacy data platform to scalable, cloud-native

architecture in AWS. Designed and set up high-volume and fault-tolerant ETL pipelines using AWS Glue, Lambda, Kinesis,

and S3 for batch and real-time ingestion processing. Set up data lake architecture with partitioned storage and schema

evolution to optimize query performance. Integrated Redshift and Athena for analytics. Optimized data availability and

governance using Lake Formation, IAM policies, and data encryption.

  • Telecom External Data Monetization: Designed and implemented data monetization architecture for secure external

data sharing with customers and partners. Designed data pipelines for ingestion, transformation, and segmentation of

large telecom datasets using AWS Glue, EMR, and S3. Applied privacy-by-design principles like data anonymization,

tokenization, and differential privacy techniques to achieve GDPR compliance. Developed segmentation and

benchmarking frameworks for aggregated insights.

  • Centralized Data Warehouse: Architected and implemented enterprise data warehouse by consolidating several

transactional, operational, and third-party data sources and databases into single platforms. Developed ETL/ELT pipelines

using Azure Data Factory, Python and SQL for data ingestion and transformation. Optimized Snowflake storage and

query performance by partitioning, clustering, and materialized views.

  • IoT Architecture and Predictive Analytics: Architect IoT analytics platform in the AWS to process large-volume real-

time sensor data streams. Implemented and deployed ingestion pipelines using Apache Kafka to ingest and stream data

into data lake on S3. Created scalable data transformation pipelines using Apache Spark with gap-filling techniques for

irregular time-series data. Created rule-based predictive models in Python and SQL.

  • Data Governance, Security and Cloud Migration Strategy: Established and implemented enterprise data governance

processes that ensured compliance with GDPR, CCPA, and ISO 27001 rules. Created data classification, lineage,

cataloging, and retention policies. Led large-scale cloud migration projects, performing comparative assessments of

AWS, Azure, and GCP.

  • Leadership and Customers Engagement: Provided strategic guidance to C-level leaders on data modernization and

AI/ML analytics. Delivered technical workshops and executive briefings. Led cross-functional teams.

Key Technologies: Azure, GCP, AWS, Redshift, AWS Glue, Snowflake, Spark, Kafka, Python, Data Governance

Lead Data Architect and Data Engineer | Siemens Energy | Apr 2017 - Jul 2019 | Freelance

  • Led the migration of 40PB of data from Hadoop HDFS to AWS using AWS EMR, S3, Redshift, and Snowflake to deliver

zero-downtime execution with seamless data transformation and performance optimization.

  • Implemented cloud data lake with automated ETL pipelines using AWS Glue, Spark, and Lambda.
  • Developed real-time data pipelines for structured and unstructured data.
  • Optimized Redshift and Snowflake performance by implementing WLM and advanced query optimization techniques.
  • Provided technical leadership and guidance to cross-functional teams, ensuring best practices in data architecture.
  • Worked in close collaboration with global teams in US and India to align data plans.

Key Technologies: Hadoop HDFS, AWS (S3, Redshift, Snowflake, Glue, Lambda), Apache Spark, Talend, Data Vault 2.0

Senior Data Warehouse Architect | Esty Inc. | Dec 2016 - Apr 2017 | Freelance

Designed and implemented scalable data warehouse and self-service BI platform to support advanced analytics and

reporting. Led ETL development and dimensional modeling, using PostgreSQL and Talend to automate data ingestion and

transformation from multiple sources. Optimized the database schema and indexing, improving query performance and BI

report generation time. Developed and automated data quality and validation workflows.

Key Technologies: PostgreSQL, Talend, Tableau

Earlier Work Experience (Summary)

Data Engineering Team Manager | Nexon Europe Inc. | Sep 2015 - Dec 2016

Led data engineering and infrastructure projects, delivering centralized data warehouse and B platform, consolidating

databases, and executing secure migrations to partner data centers. Implemented technical standards and deployed

cloud-based backup and disaster recovery on Amazon S3/Glacier to improve scalability and resilience.

Lead DBA and Senior Systems Engineer | Aeria Games GmbH | Oct 2013 - Sep 2015

Managed 100+ high-transaction databases (Oracle, MSSQL, PostgreSQL) for online gaming, optimizing performance,

backups, and AWS RDS integration to cut costs and improve query speeds. Developed BI on Redshift and Tableau. Ensured

high availability via PostgreSQL clustering and SQL Server virtualization.

Senior DBA and Database Architect | William Hill Plc. | Apr 2012 - Oct 2013

Led high availability OLAP/OLTP databases operations for real-time betting, migrated core systems to SQL Server 2008,

reengineered ETL workflows, and implemented real-time replication to reduce latency and boost responsiveness.

Developed automated backup and recovery, enforced GDPR/PCI-DSS compliance, and optimized mission-critical systems

for availability and performance.

Technical Project Lead and Oracle Expert | Zimory GmbH | Mar 2011 - Apr 2012

Supported development of IaaS cloud management software, designed robust database architectures and implemented

cross-platform replication with Oracle Streams and LogMiner. Automated deployments, optimized performance,

scalability, and supported sales with technical demos and architecture consultations.

Lead Oracle DBA and Systems Engineer | Vodafone Group Plc. | Apr 2006 - Mar 2011

Managed 24/7 mission-critical Oracle databases, driving high availability, performance tuning, and disaster recovery

through RAC, ASM, Data Guard, and workload optimization. Consolidated databases, automated data integration and

backups, enforced SOX compliant security, and provided technical leadership to DBA teams.

Senior Oracle DBA and Subject Matter Expert | Amdocs Inc. | May 2003 - Apr 2006

Led mission-critical Oracle database operations supporting telecom billing systems, achieving 99.99% uptime through

advanced performance tuning, and disaster recovery strategies. Enhanced data processing efficiency with PL/SQL and ETL

workflows, improved query performance through architectural optimization.

Oracle DBA | ACS Ltd | Jun 2000 - May 2003

Managed enterprise Oracle databases with a focus on high availability, performance, and security, including seamless

migrations and robust backup/recovery strategies.

Education and Certifications

  • B.Sc. in Computer Science - University of Hertfordshire ([Telefonnummer nur mit Premium sichtbar])
  • Engineer in Software Engineering - Technological College of Beer-Sheva ([Telefonnummer nur mit Premium sichtbar])
  • Oracle Certified Professional (OCP) - Oracle University
  • Microsoft SQL Server Administrator (MOC 10775) - TÜV Rheinland

Personal Skills

  • Problem-Solving and Analytical Thinking - Strong ability to troubleshoot complex issues efficiently.
  • Customer-Focused Approach - Service-oriented mindset with experience in client-facing roles.
  • Quick Learner and Adaptability - Rapidly adapts to new technologies, tools, and business domains.
  • Independent and Proactive - Self-motivated with a strong ability to work autonomously.
  • Team Collaboration and Leadership - Effective team player with experience leading cross-functional teams.
  • Strong Communication Skills - Clear in technical and non-technical discussions, fluent in English and German.
Mehr Kontaktdaten mit Premium

Kontaktdaten in Freitexten sind ab Premium sichtbar. Mit einem Upgrade kannst du E-Mail-Adressen und Telefonnummern direkt einsehen.

Premium ansehen

Kontaktdaten

Mehr Kontaktdaten mit Premium

Für dieses Profil sind weitere Kontaktdaten hinterlegt, die mit einem passenden Premium-Paket sichtbar werden.

Premium ansehen