Klaus Ewers - Exasol DBA and Data Warehouse Expert

🚀 FRATCH GPT 2.0 - Find freelancers with a single prompt. Now including price benchmarking.

Recommended expert

Paderborn, Germany

Check rate

Experience

Jun 2024 - Dec 2024

7 months

Exasolution DBA

Rechenzentrum Innsbruck

DBA Exasolution Server consulting and migration to version 8
Analysis of SQL query performance and tuning
Troubleshooting in batch scripts
Technologies: Gitlab, EXACloud, EXAOperation, DBeaver, Control M

Sep 2022 - Dec 2023

1 year 4 months

ERP Migration

Elis GmbH

Consolidation of the ERP landscapes of various branches into one standard system
Analysis of the data structure of the legacy system with the business department
Setup of the migration structure to the standard system
Loading of the migration structure and handover of the migration files to production in Paris
Support with error analysis and fixing
Extension of interfaces to SalesDS
Technologies: MSSQL onPrem, MSSQL Cloud, Oracle, Confluence, Jira, GIT

Apr 2021 - Dec 2021

9 months

Data Engineering – DWH / ETL

Haba

Reengineering of the old structures and loading of the old DWH on MSSQL
Reengineering of SSIS jobs for connecting SAP4/HANA to existing structures
Connection of MS Dynamics AX to existing structures
Connection of the product system
Support in rebuilding a new DWH with Enterprise Analytics (KPI company), Embedded Analytics (KPI processes) and Performance Analytics (KPI products)
Technologies: MS SQL onPrem + Cloud, SSIS, SSMS, SQL Agent Jobs, Freeplane, Snowflake, Confluence, Jira

Feb 2021 - Mar 2021

2 months

Data Quality Architect

Douglas

Creating a generic data quality concept and implementing it
Carrying out an as-is analysis of the connection of country data sources
Creating a generic concept (Snowflake data model)
Initial implementation in Talend jobs
Creating technical documentation
Technologies: SSMS, Jira, Snowflake, DB2

Feb 2020 - Apr 2020

3 months

Talend Expert

EMP Interim

Processing data via queue in XML format and preparing it via XML mapping for MS Dynamics
Support in creating functional specifications
Development of ESB routes
Creation of mappings with Talend Datamapper
Creation of documentation
Performing integration tests, issue clearing and bug fixing
Technologies: Talend ESB, MSSQL, RabbitMQ, SQL tools, QBunny, Postman, Jira

Feb 2018 - Dec 2019

1 year 11 months

Application Management (Talend Development)

FI-SPlus

Technical implementation and adaptation of interfaces together with project managers
Support in creating technical concepts
Implementation including developer tests
Creation of documentation
Carrying out integration tests, issue clearing, and bug fixing
Expansion of the operations manual
Delivery of the application to operations
Technologies: Talend, Oracle, MSSQL, DB2, SQL tools, Soap_UI

Apr 2017 - Dec 2017

9 months

Frontend Master Data (Investment)

DekaInvest Bank

Extraction, standardization, and preparation of data from different systems for the NX Manager
Installation and expansion of master data interfaces
Implementation in shell scripts, stored procedures, awk, and sed
3rd level support for interfaces
Clarification of missing definition requirements
Support with specifications for new interfaces and extensions in the legacy system
Collaboration on project management and effort estimation
Implementation on database and system level
Technologies: Sybase ASE, Oracle, shell scripting, SQL tools

Oct 2015 - Jan 2017

1 year 4 months

Counterparty Risk (Investment Risk Calculation)

Commerzbank

Performance analyses on Sybase ASE
Implementation of requirements using shell scripts and stored procedures
3rd level support
Migration of the legacy system
Clarification of missing definitions and support with specifications for the new system
Clarification of data protection requirements with business units and development
Effort estimation and implementation on database and system level
Technologies: Sybase ASE & IQ, UC4, shell scripting, SQL tools

Mar 2015 - Sep 2015

7 months

ETL Developer

DHL

Loading of a data warehouse
Development of a framework for XML mapping (file to table) in Talend DI
Use of the Talend XML module
Analysis of system basic structure and file structure
Clarification of missing definition requirements (XML attributes to table columns)
Creation of XML mappings for new reports in close coordination with the customer
Leading a small team (dispatcher ETL transfer test team)
Support with project management and planning
Technologies: Teradata, Talend ETL

Mar 2014 - Feb 2015

1 year

Exasol Expert / Data Warehouse

IMS Health

Process analysis and redesign of existing data warehouse applications
Market analysis and introduction of a new ETL tool (SSIS) in line with the existing IT structure
Contact person for DWH modeling and performance issues of the old DWH
Guidelines for introducing a metadata-driven new DWH
Support with PowerPoint presentations and knowledge transfer to India
Technologies: SSIS, Exasol, DBSchema, Erwin, ESP, Harvest

Apr 2013 - Dec 2013

9 months

Server Platform Optimization (SPO)

Commerzbank

Analysis of the database servers and cluster zone (Sybase ASE / IQ)
Project lead on the database side (Sun SPARC to x86 cluster)
Contact person for the business side regarding new versions
Analysis and ordering of the cluster zone (Sun Cluster)
Setup and upgrade of the databases as well as migration to the new zone
Adjustment of server parameters to the new versions
Support with performance issues
Creation of migration scripts
Technologies: Shellscript, ASE 15.7, ASIQ 15.4 & 16, Perl

Aug 2012 - Jan 2013

6 months

Data Archiving according to GDPdU

Projektfabrik GmbH

Reengineering of data models from different databases
Talend data migration from DB2, Oracle and MSSQL to MySQL
Processing of flat files with Talend
Creation of generic extraction jobs
Ensuring data integrity and quality
Execution of the process and definition of the structure of the ETL jobs in Talend
Technologies: Talend ETL, DB2, Oracle, MSSQL, SmartX, SmartV

May 2012 - Jul 2012

3 months

Migration Support

Groupon Berlin

Migration from PostgreSQL to Vertica Server
Data delivery from the staging area to Vertica
Advice on the data schema in Vertica
Technologies: PostgreSQL, Vertica, Talend ETL

Jan 2009 - Dec 2012

4 years

DWH Project Manager

Sonymusic GSA

Migration of the DWH from Sybase IQ to Exasolution
Market analysis for new software (Exasol, Infobright)
Advice, procurement of hardware and software
Setup and execution of first tests (POC)
Project planning for the migration and setup of the new data warehouse with Exasolution
Planning and setup of the staging area as well as migration of the existing data using ETL
Normalization of the data and setup of the data supply as well as initial backup structures
Contact person for extensions, infrastructure changes and recovery
Performance and tuning of Sybase ASE servers as well as planning of server upgrades
Technologies: EXASOL, Shellscript, Perl, OpenProject, Talend ETL, C, Sybase ASE & IQ, Oracle

Jan 2002 - Dec 2008

7 years

Data Warehouse

BMG / SonyBMG

Setup of a new data warehouse with Sybase IQ
Advice as well as procurement of hardware and software
Execution of market analyses and POCs
Migration of existing data from ASE into the DWH and extension with host data
Advice to project managers on the type and scope of integrating additional countries into the DWH
Setup of MySQL and PostgreSQL servers for internet sites
Data delivery to external providers
Performance and tuning of Sybase ASE, IQ and ASA servers
Planning of server upgrades and use of new features
Technologies: Sybase IQ, Sybase ASE, Sybase ASA, MySQL, PostgreSQL, Shellscript, Perl, OpenProject, ODI

Jan 1999 - Dec 2002

4 years

Database Administrator

BMS / Arvato Systems

Administration of Sybase servers and upgrade from ASE 11.5 to 11.9
Design and development of the upgrade script (Perl)
Troubleshooting in live operations
Contact person for enhancements
Maintenance of batch scripts (Shell, Unix)
Technologies: Perl, shell scripts, PowerDesigner, awk, sed, Sybase ASE

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Media and Entertainment, Information Technology, Banking and Finance, Professional Services, Healthcare, and Manufacturing.

Media and Entertainment

Information Technology

Banking and Finance

Professional Services

Healthcare

Manufacturing

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Project Management, and Finance.

Information Technology

Business Intelligence

Project Management

Finance

Summary

DWH project manager

The following premises were set: new DWH with new technology, large amounts of data to be inserted in a short time, large amounts of data to be queried in ad hoc queries with short response times, low maintenance effort

Interface and database developer ETL

Supporting the business department in implementing the functional concept with the requirements on the data side and ensuring them.

I implemented interfaces to the DWH and data lake with Talend SSIS.

I developed interfaces in the database environment. Link servers, remote server connections, replication, and CDC connections were used.

Reengineering and migration of legacy systems

Consulting, support, and implementation of various legacy systems on MSSQL, Oracle, and DB2 into a running current ERP system on MSSQL.

Skills

Functions

Consultant For Market Analyses Of Db And Etl Tools
Analysis Of Existing Processes And Workflows
Error Analysis (3rd Level Support)
Administration Of Sybase, Mysql, Exasol Databases
Maintenance 2nd And 3rd Level Support, Dwh Migration
Migration From Sybase Iq To Exasol
Database Development, Setup And Adjustments Of Stps In The Database
Interface Development Etl, Shell Scripts, Sql Scripts

Focus

Data Warehouse
Data Migration
Data Integration
Exasol
Sybase Dba
Etl

Programming Languages

C
Perl
Shell
Pascal
Sed
Awk
Java
Lua

Database Systems

Expert Knowledge: Sybase Adaptive Server Iq; Sybase Adaptive Server Anywhere; Sybase Adaptive Server Enterprise; Mssql; Exasol Dwa Inmemory; Mysql; Postgresql
Basic Knowledge: Vertica; Terradata; Oracle; Db2 Zos; Mongodb

Etl Tools

Talend Di
Talend Datamapper
Talend Esb
Ms Ssis
Ms Ssms
Basic Knowledge Of Odi
Basic Knowledge Of Informatica

Tools

Ticket Systems
Dbschema
Erwin
Powerdesigner
Sql Server Management Studio
Advanced Query Tool
Freeplane
Hpqc
Jira
Confluence

Software

Ms Project
Openproject
In-Step (Scrum)

Experience In The Areas Of

Dba Administration, Performance And Tuning, Upgrade
Data Warehouse Architect, Setup, Expansion, Administration And Consulting For All Stakeholders
Clarification Of Interfaces With The Business Departments

Industries

Consulting Companies
Media
Banks
Investment Banking
Internet Business
Healthcare
Logistics
Retail

Presentations

Migration Of The Warehouse With Consideration Of Cost Savings And Future Viability Barc
Use Of Sybase Iq Server In The Dwh (2005 Frankfurt)
Breakfast For Datawarehouse Sybase Iq (2008 Vienna)

Languages

German

Native

English

Advanced

Education

University of Paderborn

Diplom Physicist · Physics · Paderborn, Germany

Statistics

Experience

Total positions 16

Experience in Media and Entertainment 11 y

Avg length 1 y 6 m

Longest experience 6 y 11 m

Expertise

Recent roles Exasolution DBA, ERP Migration, Data Engineering – DWH / ETL

Main industries Media and Entertainment, Information Technology, Banking and Finance

Main business areas Information Technology, Business Intelligence, Project Management

Qualifications

Highest degree Master

Profile

Member since

September 2025

Last update

September 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Klaus is based in Paderborn, Germany.

Klaus speaks the following languages: German (Native), English (Advanced).

Klaus has at least 23 years of experience. During this time, Klaus has worked in at least 16 different roles and for 15 different companies. The average length of individual experience is 1 year and 5 months. Note that Klaus may not have shared all experience and actually has more experience.

Based on recent experience, Klaus would be well-suited for roles such as: Exasolution DBA, ERP Migration, Data Engineering – DWH / ETL.

Klaus's most recent position is Exasolution DBA at Rechenzentrum Innsbruck.

In recent years, Klaus has worked for Rechenzentrum Innsbruck, Elis GmbH, and Haba.

Klaus is most experienced in industries like Media and Entertainment, Information Technology, and Banking and Finance. Klaus also has some experience in Professional Services, Healthcare, and Manufacturing.

Klaus is most experienced in business areas like Information Technology, Business Intelligence, and Project Management. Klaus also has some experience in Finance.

Klaus has recently worked in industries like Professional Services, Manufacturing, and Information Technology.

Klaus has recently worked in business areas like Information Technology and Business Intelligence.

Klaus holds a Master in Physics from University of Paderborn.

The availability of Klaus needs to be confirmed.

Daily rate distribution

0 2 4 6 8

<€400 €400-800 €800-1200 €1600+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000

750

500

250

Daily rate avg. 900 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000

750

500

250

Median rate 900 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 7 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.