Senior System Engineer, Principal Oracle Consultant

Responsibilities:
* Migration of Terabyte sized Oracle databases from 11 to 12c (e.g. at Totemic [finance] and
Linklaters [law]) ~ 100 databases
* Performance Tuning (e.g. AIG, Lionstrust [both finance], Bourne Leisure [travel], Linklaters,
Totemic)
* Proof of Concept Exadata (Linklaters, Tesco), SAP
* Implementation Exadata (Linklaters, Tesco, Tesco Bank)
* Migration SQL server databases to Oracle Exadata (Tesco) including new design of databases and
new load jobs, creating new architecture (system and database)
* Implementation of DBVisit replication & Standby
* OEM upgrade and Implementation (e.g. Linklaters)
* Migration and Tuning SAP and Documentum to Exadata (Linklaters)
* Partitioning, Migration & Tuning (Channel 4)
* Backup implementation, Tuning, database splitting (Channel 5, Express Newspapers)
* Downgrading from Enterprise Edition to Standard Edition
* Documentation and planning
* Troubleshooting, Support, SR-Escalation
Key Achievements:
* Global Award as Engineered Systems Partner of the Year (UK, EMEA. GLOBAL)
* Accepted as Speaker for HOTSOS Conference
* Win of Exadata Proof of Concept and Implementation at Linklaters
* Beat the Load Expectations by factor 20 at Tesco
* Tuning at AIG improved statements (80 million times faster)
* Finding a nearly a dozen undocumented bugs in 12c migration, fixed a known 12c bug where
Oracle has no solution

Responsibilities:
* Migration of Oracle databases to Linux x86 with ASM and RAC
* Performance Tuning
* Hardening Systems against illegal access
* Penetration tests
* Lead DBA in a team of three
* Process optimization
* Documentation and planning & daily business, changes, support
Key Achievements:
* Successful passing of the penetration tests as only one team after hardening (all other teams
failed, e.g. Network, Apps, Systems, Web)
* Redesign of Development methods to improve performance

Responsibilities:
* Stream lead for all database teams worldwide (Germany, India, UK, Poland, Netherlands, Turkey)
* Working with board members of the client, especially CIO
* Part of the streams board, migration of datacenter to a new provider offshore
* Onboarding and planning of internal and external resources
* Migration of ca. 500 databases to a new datacenter and provider (ca. 250 Oracle DB 10g and 11g
up to 2.5 TB), MS SQLSERVER, PostgreSQL, MySQL, SolidDB
* Developing the technical concept for migration and analyses of the systems
* International project with teams in Germany, India, Netherlands, Poland and UK
* Coordination of all teams worldwide (10 locations and ca. 80 technical experts worldwide)
* Performance optimizing and tuning
* Problem fixing and escalation management
* SAP, Oracle Retail
* Installation, patching, updates, shell-scripting, SQL-scripting, data masking
* Documentation, reporting, presentations
* Creating the new database architecture
Key Achievements:
* Fast delivery within 2 weeks of the major systems after test
* Delivering before time and within budget. (Project was finished 2 months earlier)
* international team including teams in India
* Starting a project from the scratch
* Very short timeline
* Cooperation between streams on different locations and teams from different cultures and
nations
* Learning and usage of completely new technologies

Responsibilities:
* Successful Migration of a few 12 TB Oracle databases from Solaris x86 file based single
instance to Linux x86 with ASM and RAC
* Analysis of the databases and take over from the application team to the production support
team
* Coordination of the migration over 3 teams (Application, Database and OS)
* Documentation and planning
* Taking a method with minimum to zero downtime
* Implementing policies and changing the databases to company standard
* Finishing before Christmas
* Using RMAN, Dataguard and Goldengate
Key Achievements:
* Database design is not standard (over-indexed, to many datafiles ~2500)
* Database is application driven and against all policies including users with DBA-permissions
* Performance problems because of the wrong data model
* Change of a platform with a downtime less than 5 minutes
* Key-Application for the client, relevant for the full production process

Responsibilities:
* Installation and Configuration of a 2 node RAC with ASM on RHEL 6
* Migration of around 30 production databases including backup/recovery concepts
* Documentation
* Managing the requirements with other departments

Responsibilities:
* Administration in a production environment of SQL Server, PostgreSQL, Vertica, Informatica and
MongoDB in a cloud environment
* Writing of documentation
* LDAP POC and Implementation on Vertica
* Working with Customer Support Team in Zurich, Support of development teams in London and USA
* Deployment of new releases & databases, upgrade and installation of databases
* Problem fixing and on-call service
* Working together with teams in California
* Deployment of the RMS software products

Key Achievements:
* Proof of concept for LDAP
* Security analysis of MongoDB

Responsibilities:
* Director of a team of ca. 80 DBA (45 internal & 35 external)
* Huge project with 1500 person (600 external)
* Plans for personal development of employees
* Resource planning
* Management of time scheduling and budgets within the project
* Oracle 10g & 11g Database administration of large databases (DWH and OLTP > 2 Petabyte),
Solaris, Linux
* Migration 10g to 11g
* Lead in performance analysis and optimizing, Capacity Management
* Analysis, Development and Implementation of a new release
* Trouble shooting, shell scripting, PL/SQL-Scripting
Key Achievements:
* Lead part (for performance) in the release implementation
* Lead in performance analysis and fixing
* Pro-active resource management
* Administration of production and development databases with over 2 PB, both OLTP and DWH,
database time for request < 15 ms
* Migration and updates of databases to 10g R2 and 11g R2 with RAC, ASM and OEM

Responsibilities:
* Lead and responsibility in performance analysis and optimizing of the new software SHP
including resource and workload management in a team of 6 DBA
* Oracle 8i, 10g & 11g Database administration of large databases (DWH and OLTP > 200 TB),
HP-UX, Linux
* Implementation of the new Swiss Health Platform (SHP)
* Migration of database, new software and new clients
* Analysis, Development and Implementation of a partitioning concept and index concept, Capacity
management
* Trouble shooting, shell scripting, PL/SQL-Programming
Key Achievements:
* Lead part (for performance) in the project implementation of SHP, including DB schema design;
worked in cooperation with persons representing Adcubum, Oracle and CSC
* Integration of a new key customer within a working day (technical performance lead)
* Administrated 50+ production and development databases with up to > 200 TB, both OLTP and DWH
* Analysis, conception and implementation of a partitioning and index concept for all key
clients
* Implementation of high availability solutions with Oracle RAC
* Migration and updates of databases to 10g R2 and 11g R2 with RAC, ASM, STREAMS and OEM
* Performance optimizing of SUMEX in cooperation with ELCA
* Escalation manager for Oracle support
* Presentation of the technical concepts and success at a DOAG regional conference and at key
clients
* 3-day-workshop with Jonathan Lewis
* Performed SQL and instance tuning using a range of technologies including ADDM and AWR,
Statspack, SQL trace and tkprof, various third-party tools, developed automated procedures to
analyze and reproduce statements for performance analysis
* Analysis of Oracle OEM packs and decision of implementation
* Proof of Concepts for Exadata
* Savings of a few ten million CHF because of redesign of the database and reducing the space of
a few hundred TB
* All projects goal reached in time or faster
* Education of a trainee and a new employee
* Working in an international team from 12 nations

Responsibilities:
* Lead for the resource management of all the databases including cost & capacity management
* Database administration of around 200+ 24/7 production, test and development databases, AIX,
Linux, HP-UX
* Full range of Oracle experience including programming of PL/SQL-Scripts and Shell-Scripts,
Backup & recovery
* Banking system support
* Working in an international team
Key Achievements:
* Provided database administration services in mission critical banking environment (credit card
processing)
* Lead of implementation of VISA-PCI-Standards for the key databases
* Implementation of PCI including TDE and upgrade from 10g to 11g in one step within one night
and 2 months earlier than expected
* Experience in fraud analysis of credit card systems
* Migrations of databases (versions from 8 to 11g R1)
* Lead of migration from 8i to 10g R2 in one step, 4 months earlier than expected
* Responsibility of the key product databases (Fraud, debt collection, online payment and online
banking)
* No broken of the SLA in over 6 years
* Development of an automatize replication system for QA-Tests with RMAN-Duplicate, reduction of
the personal cost of 1.5 FTE and 500.000 € hardware costs
* Taking part in the successful implementation and development of iDeal, an online payment
platform, here especially the database design and tuning
* Technical database lead of extraction of the database part for debt collection without an
outage of the production system into a new database (debt collection was in schemas in which
are the online banking)
* Education of the trainees
* Analysis between MySQL, Oracle and DB2
* Development of a system for space forecast, analysis of the cost per product
* Part of the commission for the cost distribution to the products
* Lead of fraud test for a new software for HR
* Leading development of a strictly implementation process from development, test and production
in cooperation with other teams
* Translation and realization of management board decisions in the team
* Hosting of ca. 45% of all credit card transaction in Germany and key clients in the
Netherlands, Italy and Belgium and formerly the RBS
* Database administration of SAP

Responsibilities:
* Full range of Oracle experience on Solaris
* Programming of PL/SQL Scripts and Shell-Scripts, Implementation of new scripts, shell
scripting
* Weekly reports for the management of the database usage and cost distribution to the
departments
Key Achievements:
* Database administration and migration, Script programming
* Fraud analysis of the databases
* Implementation of managed standby databases and weekly tests of it
* Strictly implementation process

Responsibilities:
* Developing with Forms and Reports, Oracle Designer, Discoverer
* Programming of PL/SQL-Scripts and Shell-Scripts
* V-Model
Key Achievements:
* Development of a tool for project administration (PROSA)
* High standard of quality
* Software for special VAT of Helgoland
* Development of a software for Agricultural subsidiaries (AIDA)
* Lead of a part project for a new software for risk analysis and fraud of Agricultural
subsidiaries
* Year 2000 problem