Klaus Ewers - Exasolution DBA

Recommended expert

Paderborn, Germany

Experience

Jun 2024 - Dec 2024

7 months

Exasolution DBA

Rechenzentrum Innsbruck

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

Sep 2022 - Dec 2023

1 year 4 months

ERP Migration

Elis GmbH

Consolidation of ERP landscapes of different branches into a standard system
Analysis of legacy system data structure with the business unit
Building the migration framework to the standard system
Loading the migration structure and handing over migration files to production in Paris
Support in error analysis and fixing
Expansion of interfaces to SalesDS
Technologies: MSSQL on-prem, MSSQL Cloud, Oracle, Confluence, Jira, Git

Apr 2021 - Dec 2021

9 months

Data Engineering – DWH / ETL

Haba

Re-engineering legacy structures and populating the old DWH on MSSQL
Re-engineering SSIS jobs to connect SAP4/HANA to existing structures
Connecting MS Dynamics AX to existing structures
Connecting the product system
Support in building a new DWH with Enterprise Analytics (company KPIs), Embedded Analytics (process KPIs), and Performance Analytics (product KPIs)
Technologies: MS SQL on-prem + Cloud, SSIS, SSMS, SQL Agent Jobs, Freeplane, Snowflake, Confluence, Jira

Feb 2021 - Mar 2021

2 months

Data Quality Architect

Douglas

Developing a generic data quality concept and its implementation
Conducting an as-is analysis of the connection to country data sources
Creating a generic concept (Snowflake data model)
Initial implementation in Talend jobs
Creating the 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 through XML mapping for MS Dynamics
Supporting the creation of data warehouse concepts
Developing ESB routes
Creating mappings with Talend Datamapper
Writing documentation
Conducting integration tests, problem clearing, and fixing errors
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 customization of interfaces together with project managers
Support in creating data processing concepts
Implementation including developer tests
Creation of documentation
Execution of 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, SoapUI

Apr 2017 - Dec 2017

9 months

Frontend Master Data (Investment)

DekaInvest Bank

Extraction, normalization and preparation of data from various systems for the NX manager
Installation and extension of master data interfaces
Implementation using shell scripts, stored procedures, awk and sed
Level 3 support for interfaces
Clarification of missing definition requirements
Support for specifications for new interfaces and extensions in the legacy system
Collaboration in project management and effort estimation
Implementation at the 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
Level 3 support
Migration of the legacy system
Clarification of missing definitions and support for specifications for the new system
Clarification of data protection requirements with specialist departments and development
Effort estimation and implementation at the database and system level
Technologies: Sybase ASE & IQ, UC4, shell scripting, SQL tools

Mar 2015 - Sep 2015

7 months

ETL Developer

DHL

Loading a data warehouse
Development of a framework for XML mapping (file–table) in Talend DI
Use of the Talend XML module
System baseline structure analysis and file structure analysis
Clarification of missing definition requirements (XML attributes to table columns)
Creation of XML mappings for new reports in close coordination with the client
Leading a small team (Dispatcher ETL transfer test team)
Support in 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 applications in the data warehouse
Market analysis and introduction of a new ETL tool (SSIS) compliant with the existing IT structure
Point of contact for DWH modeling and performance issues of the old DWH
Specifications for the implementation of a new metadata-driven 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 management on the database side (Sun SPARC to x86 cluster)
Contact for business side on new versions
Analysis and ordering of the cluster zone (Sun Cluster)
Setup and upgrade of databases as well as migration to the new zone
Adjustment of server parameters for 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
Running the process and defining the structure of 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 supply from staging area to Vertica
Advising on 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)
Consulting and procurement of hardware and software
Setup and execution of initial tests (POC)
Project planning of the migration and building the new data warehouse with Exasolution
Planning and setup of the staging area and migration of existing data via ETL
Data normalization and setup of data delivery as well as initial backup structures
Contact for enhancements, infrastructure changes and recovery
Performance tuning of Sybase ASE servers as well as planning server upgrades
Technologies: EXASOL, Shellscript, Perl, OpenProject, Talend ETL, C, Sybase ASE & IQ, Oracle

Jan 2002 - Dec 2008

7 years

Data Warehouse

BMG / SonyBMG

Building a new data warehouse with Sybase IQ
Consulting and procurement of hardware and software
Conducting market analyses and POCs
Migration of existing data from ASE to the DWH and extension with host data
Advising project managers on the type and scope of adding more countries to the DWH
Setting up MySQL and PostgreSQL servers for web presences
Data delivery to external providers
Performance tuning of Sybase ASE, IQ and ASA servers
Planning server upgrades and using 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
Point of contact for enhancements
Maintenance of batch scripts (Shell, Unix)
Technologies: Perl, shell scripts, PowerDesigner, awk, sed, Sybase ASE

Summary

Data Warehouse Project Manager

The following premises were set: new data warehouse with new technology; loading large volumes of data in a short time; querying large data volumes in ad-hoc queries with low response times; low maintenance effort.

ETL interface and database developer

Supporting the business unit in implementing the functional design with data-related requirements and ensuring their security.

I implemented interfaces to the data warehouse and data lake using Talend and SSIS.

I developed interfaces in the database environment, using linked servers, remote server connections, replication, and CDC connections.

Re-engineering and migration of legacy systems

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

Skills

Functions

Consulting Market Analyses Of Database And Etl Tools
Analyzing Existing Processes And Workflows
Error Analysis (Level 3 Support)
Database Administration Of Sybase, Mysql, Exasolution
Maintenance Level 2 And 3 Support, Dwh Migration
Migration From Sybase Iq To Exasolution
Database Development, Creating And Adjusting Stored Procedures In The Database
Interface Development: Etl, Shell Scripts, Sql Scripts

Focus

Data Warehouse
Data Migration
Data Integration
Exasolution
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 In Odi
Basic Knowledge In 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

Dba Administration, Performance And Tuning, Upgrade
Data Warehouse Architecture, Setup, Expansion, Administration, And Advising All Stakeholders
Clarifying Interfaces With Business Units

Industries