Mark Wittich

-Lead an offshore DBA team (external) to support Cloud IaaS DB stack -Oracle license usage reduction incl. End of Oracle contract activities -Shaping the DB usage via in-house consulting, creating usage guidelines & policies + propising optimization & automation potentials -Optimizing IaaS DB workloads for minimal license & cost footprint -Ensuring compliance in area of responsibility -support DB migrations to MS Azure -Focus on automation inside the DB area -Ausbildungsbeauftrager of my department

-Shaping the future technology footprint of the company by supporting the data center exits and migrating applications into a cloud operations mode - Taking lead over a DBA team(external) to service and support the Azure IaaS databases (Oracle and SQL Server primarily) - Innovation by actively seeking for automation in my responsibility area - Be knowledge multiplicator and in-house consultant to assure effective use of Cloud technology with focus on DB&storage services - Shape migration processes

Lead Analyst / Developer within the operational team of the Enterprise DWH solution. Functional steering of change management within the team. Further contributing as DWH architect in consulting projects touching the Enterprise DWH solution, guiding developers on design, performing reviews, outlining the strategic (future) hardware setup of the DWH (hardware refresh + cloudification)

Enhancing the existing Enterprise DWH solution by connecting new systems, dealing with changes forced by other projects (development of the system landscape) Strong focus on architectural topics as well as guidance to developers - additional topics are (code) reviews, some development, always focus on smooth operations Development of certain core components (PL/SQL, .NET)

Handling, organizing and analysing a big Enterprise Data Warehouse. Main focus is on BAU/L3 topics, analysis on bugs, performance and user requests. Organizing development on- and offshore and supporting the project that builds up the warehouse in the fields of architecture, performance, business knowledge, testing and quality assurance.

Building an Enterprise Warehouse - Consildating and harmonizing the data from the source systems and build THE warehouse solution for reporting on trade data within the company. Focus mainly on BAU activities, project support, architectural and design analysis/improvements and testing.

Maintenance, Enhancements and BAU work on a DWH containing mainly data relevant for the UK Power market Steering offshore development team Arranging and managing all releases Quality ensurance especially for PL/SQL, OWB and .NET code developed in offshore Arranging organisational stuff around the DWH Primary contact and technical lead for this DWH solution

Market Data Analyst / Developer at the Market Data Team of RWE Supply & Trading GmbH Duties and responsibilities • Development and maintenance of ETL processes • Extended Customer support (esp. for Weather Desk and Front Office) • Further development of existing solutions • Securing the supply of market data • Development, maintenance and optimization of customer specific database queries

Contractor at the Market Data Team at RWE IT GmbH (until 31/03/2010) and RWE Supply & Trading GmbH (since 01/04/2010) Duties and responsibilities • Development and maintenance of ETL processes • Customer support • Further development of existing solutions • Securing the supply of market data

• Reporting and Data Warehousing • Further development of reports and the Data Warehouse • Development and maintenance of ETL processes • Customer Support

Studentische Hilfskraft: Reporting and Data Warehousing

Webentwicklung, BWL