Data Solutions and Engineering Expert

7/2019 – 8/2020

Led the architecture, design, and implementation of advanced data solutions, analytics platforms, and cloud data transformation projects. Worked closely with clients to develop data-driven strategies, optimize enterprise data platforms, and drive AI/ML adoption for business intelligence and predictive analytics. Provided thought leadership in big data engineering, and cloud migration initiatives.

Amazon Web Services (AWS), Apache Hadoop, Big Data, Data Mining, Data Warehousing, ETL, Microsoft SQL-Server (MS SQL), Oracle Rac, Postgresql

4/2017 – 7/2019

Led the cloud migration and modernization of big data platform, transitioning from on-premises Hadoop and Teradata to a scalable AWS-based architecture. Designed and implemented high-performance data pipelines, ETL workflows, and analytics solutions to support large-scale industrial and IoT applications.

Amazon Web Services (AWS), Business Intelligence and Reporting Tools (BIRT), Data Warehousing, ETL, Postgresql

12/2016 – 4/2017

Designed and implemented a scalable, high-performance data warehouse and BI platform to support advanced analytics and reporting. Led end-to-end ETL development, dimensional modeling, and data visualization strategies to enhance business insights. Implemented PostgreSQL-based data warehouse, improving query performance and data accessibility. Developed ETL using Talend, automating data ingestion and transformation from multiple sources. Created dimensional data models aligned with reporting needs, improving analytics efficiency. Enabled faster data access, improving query performance by 40% and reducing BI report generation time by 50%. Optimized database schema, indexing, and partitioning, ensuring high availability and performance. Automated data validation and transformation workflows, reducing manual effort by 60%.

Amazon Web Services (AWS), Business Intelligence (BI), Data Warehousing, ETL, Postgresql, Snowflake, Tableau

9/2015 – 12/2016

Led the Data Engineering team and IT infrastructure projects, ensuring efficient data management, business intelligence (BI), and reporting solutions. Implemented a data warehouse and BI platform, enabling advanced reporting and data monitoring. Led database consolidation efforts, reducing infrastructure costs and improving system performance. Managed data migration projects, ensuring secure and efficient transfer to partner data centers. Implemented cloud-based backup and disaster recovery solutions using Amazon S3/Glacier. Defined work processes, technologies, and standards to enhance data integration, scalability, and performance.

Data Mining, Data Warehousing, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Mysql, Online Analytical Processing, Online Transaction Processing, Tableau

10/2013 – 9/2015

Managed 100+ high-transactional production databases (Oracle, SQL Server, MySQL). Led database performance tuning, backups, and AWS cloud integration, reducing storage costs and improving query efficiency. Implemented Pentaho-based ETL automation and developed a BI & reporting environment on Amazon Redshift & Tableau. Managed MySQL clusters, ensuring high availability and load balancing for gaming services. Led SQL Server virtualization and database consolidation, optimizing infrastructure and reducing costs. Tuned SQL Server and Oracle, improving query performance and reducing latency for gaming transactions.

Business Intelligence (BI), Data Warehousing, Linux Einführung, Microsoft SQL-Server (MS SQL), Mysql, Oracle Rac, Tableau, Windows Server (allg.)

4/2012 – 10/2013

Managed large-scale OLAP/OLTP databases and ETL processes for mission-critical systems. Administered Oracle RAC, ASM, and MS SQL Server, leading the migration to SQL Server 2008 and optimizing ETL workflows. Improved database performance and availability, reducing downtime risks. Developed automated backup, recovery, and data sync solutions, enhancing disaster recovery. Optimized Oracle RAC, SQL Server, and MySQL Clusters, reducing query latency by 35%. Ensured GDPR and PCI-DSS compliance by implementing strict database access control policies. Developed failover procedures to maintain system integrity during high-traffic betting events. Implemented real-time data replication for instant odds updates and betting transactions. Provided technical support, performance tuning, and data modeling for business applications.

Data Warehousing, Hardware-Design, IT-Support (allg.), Microsoft SQL-Server (MS SQL), Online Analytical Processing, Oracle-Anwendungen, Oracle Application Server (OC4J), Oracle Rac, Oracle RMAN (Recovery Manager), SOAP, Storage, Systemmigration, Systems Engineering, Windows Server 2003, Windows Server (allg.)

3/2011 – 4/2012

Led IaaS cloud management software development, overseeing database architecture, replication, and transactional consistency. Designed and implemented cross-platform Oracle-to-non-Oracle replications using Log Miner, Oracle Streams, and Redo parsing. Built automated database deployment and configuration management processes to support rapid scaling of IaaS cloud environments. Led database development efforts, ensuring optimal query performance, indexing strategies, and partitioning, improving data retrieval speeds by 60%. Optimized system performance and scalability, improving data processing efficiency. Supported sales teams with technical expertise and product demonstrations.

Design (allg.), Filtertechnik, Forschung & Entwicklung, Hardware-Design, Iaas, Indesign, Java (allg.), Konzeption (IT), Management (allg.), Öffentlichkeitsarbeit, Oracle-Anwendungen, Rechnergestütztes Betriebsleitsystem (RBL), Software Design, SQL, Übersetzungen

4/2006 – 3/2011

Managed 24/7 mission-critical Oracle databases, ensuring high availability, performance, and disaster recovery. Led databases optimization, ETL tuning, and SQL performance enhancements, reducing query times by 40%. Administered Oracle RAC, ASM, and Data Guard, improving system resilience. Led database consolidation projects, optimizing storage and cutting infrastructure costs by 30%. Developed automated data pipelines and streamlined MS SQL to Oracle data integration. Automated backup, recovery, and data replication using RMAN, Veritas, and EMC-BCV, reducing manual effort by 50%.
Ensured SOX compliance, database security, and infrastructure automation, cutting manual efforts by 40%. Provided technical leadership and mentoring to DBA teams.

24/7 Leistungen, CRM Beratung (allg.), Data Warehousing, Hardware-Design, IT-Support (allg.), IT Sicherheit (allg.), Microsoft SQL-Server (MS SQL), Online Transaction Processing, Oracle-Anwendungen, Oracle Data Guard, Oracle Rac, PL/SQL, Qualitätsmanagement / QS / QA (IT), SAP Beratung (allg.), SAP IS-RE

5/2003 – 4/2006

Managed high-volume Oracle databases for telecom billing systems, ensuring 99.99% uptime and optimal performance. Led database migrations, performance tuning, and disaster recovery implementations. Developed PL/SQL scripts and ETL processes, optimizing data processing and system efficiency. Managed data conversions and ETL processes for telecom billing applications, ensuring data integrity. Optimized database architectures, partitions/ indexing strategies, improving query runtime by 35%. Ensured compliance with security policies, access controls, and data encryption standards.

Back up / Recovery, Hardware-Design, IT-Support (allg.), Online Transaction Processing, Oracle-Anwendungen, Telekommunikation / Netzwerke (allg.), UNIX

6/2000 – 5/2003

Administered and optimized Oracle databases for IT infrastructure projects, ensuring HA, performance, and security. Led database migrations, backup/recovery strategies, and performance tuning to improve system efficiency. Developed automation scripts to streamline operations and reduce manual workload.

Back up / Recovery, Hardware-Design, It-Beratung, Management (allg.), Oracle-Anwendungen, Oracle RMAN (Recovery Manager), Perl, Samba, SAP Beratung (allg.), Shell (CSH), Storage, Systemmigration, Telekommunikation / Netzwerke (allg.), UNIX