14.04.2026 aktualisiert

**** ******** ****
verifiziert
Premiumkunde
100 % verfügbar

Senior Data Architect and Data Engineer

Berlin, Deutschland
Weltweit
Bachelor of Science in Computer Science
Berlin, Deutschland
Weltweit
Bachelor of Science in Computer Science

Profilanlagen

Alex Zhirov CV.pdf

Über mich

Over 25 years of extensive experience in designing and delivering large-scale data architectures and strategies, analytics solutions, and cloud transformations, with extensive hands-on experience in architecting and implementing large-scale data platforms in cloud and on-premises.

Skills

Sql Data WarehouseApache AirflowAmazon Web ServicesAmazon S3Data AnalysisMicrosoft AzureBig DataUNIXCloud DatabaseDatenverarbeitungDaasData ArchitectureDatenvalidierungDatenbereinigungData GovernanceDateninfrastrukturData IntegrationETLDatenmanagementDatenzuordnungData MartData TransformationData MigrationDatenmodellDatenqualitätDatensicherheitData Transformation ServicesData VaultDatenvisualisierungData WarehousingRelationale DatenbankenLinuxDimensionale ModellierungDistributed Data StoreGitHubPythonPostgreSQLLogische DatenmodelleMicrosoft Certified Database AdministratorMetadaten-RepositoryAzure SQLWindows-ServerOperational Data StoreOracle DatabasesPerformance-TuningMicrosoft Power BIDataOpsAzure Machine LearningAzure Data LakeSQLStreamingSalesforce TableauTalendTransact-SqlAzure Data FactorySql Server Database AdministrationSnowflakedbtApache SparkMysql DatabasesChange Data CaptureDatenstrategieMicrosoft Fabric (Analytics-Plattform)Data LakeAWS AuroraDebezium.ioData LineageAWS GlueDatenanalytikAWS Data AnalyticsApache KafkaDatenmanagementPhysical Data ModelsCloud-MigrationAzure Service FabricTerraformAzure Synapse AnalyticsSql Database AdministrationDaten-PipelineAmazon RedshiftDatabricks
• 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.

Sprachen

DeutschverhandlungssicherEnglischverhandlungssicher

Projekthistorie

Senior Solutions Architect - Data and Analytics

HCL

Internet und Informationstechnologie

>10.000 Mitarbeiter

Led end-to-end architecture, design, and delivery of enterprise data and analytics solutions across multiple customers, providing strategic advisory on cloud data platforms, data modernization, and advanced analytics. Architected large-scale AWS data platform modernization initiatives, implementing centralized medallion architectures, dimensional models, modular pipelines with Airflow/dbt, and Snowflake performance optimization. Directed major Oracle-to-AWS Redshift migration programs, designing cloud-native models, integrating S3-based data lakes, orchestrating automated processing with Lambda, and enabling multi-region, multi-cluster data sharing; additionally set up SageMaker-based ML environments integrated with DWH and Data Lake.

Delivered Azure-based BI and analytics platforms using Databricks, DLT, Debezium CDC pipelines, and centralized semantic models by Azure Analysis Services, while optimizing Spark performance and cluster efficiency. Enhanced enterprise Data Vault implementations through performance tuning, PIT/Bridge design, model refinement, and query optimization . Led MDM migration from IBM InfoSphere to Informatica CP4D, improving data quality, benchmark performance, and operational consistency.

Provided strategic architectural assessments, roadmaps, executive presentations, and cross-functional program leadership across cloud transformation and analytics initiatives.

Senior Data Solutions Engineer

VMware

Internet und Informationstechnologie

>10.000 Mitarbeiter

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.

Skills: Data Warehousing · Big Data · Data Modeling · Sales Presentations · VMware vSphere · RabbitMQ · Apache Kafka · Data Governance · Data Architecture · Data Warehouse Architecture · Data Migration · Data Engineering · Kubernetes · Pre-Sales Technical Consulting · Data Visualization · Data Strategies · Technical Presentations · Data Solution Architecture · Customer Support · Cloud Migration · Greenplum · Pre-Sales Support · Data Security · Data Streaming · Data Infrastructure · Post-Sales Support · Sales · Customer Engagement · PostgreSQL · Data Quality · Sales Engineering · Presales Technical Support

Lead Data Architect

Auto1 Group AG

Internet und Informationstechnologie

1000-5000 Mitarbeiter

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.

Skills: Data Warehousing · Amazon Aurora · Amazon Web Services (AWS) · Data Modeling · Apache Kafka · Business Intelligence (BI) · Data Analytics · Data Architecture · Data Migration · Data Visualization · AWS Glue · Data Streaming · Amazon Redshift · Apache Spark · Data Infrastructure

Lead Solutions Architect - Data and Analytics

Evalueserve

Internet und Informationstechnologie

5000-10.000 Mitarbeiter

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.

Skills: Data Warehousing · Amazon Web Services (AWS) · Data Modeling · Google Cloud Platform (GCP) · Sales Presentations · Data Governance · Data Analytics · Microsoft Azure · Pre-Sales Technical Consulting · Data Visualization · Data Strategies · Data Solution Architecture · Pre-Sales Support · Data Security · Data Infrastructure · Post-Sales Support · Data Quality · Presales Technical Support

Lead Data Architect and Data Engineer

Siemens

Energie, Wasser und Umwelt

5000-10.000 Mitarbeiter

• Led the migration of 40PB of data from Hadoop HDFS to AWS utilizing 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.

Skills: Data Warehousing · Amazon Aurora · Amazon Web Services (AWS) · Data Modeling · Apache Kafka · Data Governance · Snowflake · Linux · Data Analytics · Data Architecture · Data Migration · Data Visualization · Data Strategies · Machine Learning · AWS Glue · Amazon Redshift · Apache Spark · Data Infrastructure · Data Quality

Senior Data Warehouse Architect

Etsy

Internet und Informationstechnologie

50-250 Mitarbeiter

Designed and implemented a scalable data warehouse and BI platform to support advanced analytics and reporting. Led ETL development and dimensional modeling, utilizing 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.

Skills: Data Warehousing · Windows Server · Data Modeling · Snowflake · Linux · Business Intelligence (BI) · Data Analytics · Data Architecture · Data Warehouse Architecture · Data Migration · Data Visualization · Amazon Redshift · Data Infrastructure · PostgreSQL

Data Engineering Team Manager

Nexon Europe GmbH

Internet und Informationstechnologie

500-1000 Mitarbeiter

Led data engineering and infrastructure projects, delivering centralized data warehouse and BI 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.

Skills: Data Warehousing · Amazon Web Services (AWS) · Windows Server · Data Modeling · SQL Server Analysis Services (SSAS) · MySQL · Linux · Data Analytics · SQL Server Integration Services (SSIS) · Oracle RAC · SQL Server Reporting Services (SSRS) · Microsoft SQL Server · Unix · Tableau · PL/SQL · Data Infrastructure · PostgreSQL · Oracle

Lead DBA and Senior Systems Engineer

Aeria Games GmbH

Internet und Informationstechnologie

500-1000 Mitarbeiter

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. Built BI on Redshift and Tableau. Ensured high availability via PostgreSQL clustering and SQL Server virtualization.

Skills: ETL · Data Warehousing · Amazon Web Services (AWS) · Windows Server · Data Modeling · MySQL · RabbitMQ · Linux · SQL Server Integration Services (SSIS) · Microsoft SQL Server · Unix · Tableau · PL/SQL · MySQL Adminstration · Data Infrastructure · SQL Database Administration · PostgreSQL · Oracle · Oracle Database Administration

Senior DBA and Systems Engineer

William Hill

Internet und Informationstechnologie

1000-5000 Mitarbeiter

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.

Skills: Windows Server · Data Modeling · Linux · SQL Server Integration Services (SSIS) · Oracle RAC · Microsoft SQL Server · Unix · Data Infrastructure · SQL Database Administration · Oracle · Oracle Database Administration

Technical Project Lead and Databases Expert

Zimory GmbH

Internet und Informationstechnologie

10-50 Mitarbeiter

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.

Skills: Windows Server · Agile Methodologies · Linux · Java · Unix · PL/SQL · Oracle Streams · Data Infrastructure · Oracle · Oracle Database Administration

Lead Oracle DBA and Systems Engineer

Vodafone

Telekommunikation

5000-10.000 Mitarbeiter

Managed 24/7 mission-critical Oracle environments, 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.

Skills: Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Systems Engineering · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration

Senior Oracle DBA and Subject Matter Expert

Amdocs

Telekommunikation

5000-10.000 Mitarbeiter

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.

Skills: Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration

Oracle DBA

ACS

Internet und Informationstechnologie

50-250 Mitarbeiter

Managed enterprise Oracle databases with a focus on high availability, performance, and security, including seamless migrations and robust backup/recovery strategies.

Skills: ETL · Data Modeling · Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration

Zertifikate

Administering Microsoft SQL Server 2012

TÜV Rheinland Group

2014

Oracle Certified Professional (DBA)

Oracle

2010

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden