Senior Cloud DBA – RMS, London & California

Responsibilities:

• Administration in a production environment of SQL Server, PostGre, Vertica, Informatica and MongoDB databases in a cloud enviroment
• 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

Oracle Expert (Migration) – CapGemini / Westhouse (Retail sector), UK & Germany

Responsibilities:

• 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, PostGre, MySQL, SolidDB
• Technical concept for migration and analyses of the systems
• International project with teams in Germany, India, Netherlands, Poland and UK
• Coordination of Oracle part of the database team in UK, Germany, India and the customer
• Technical lead of the Database team
• RMAN and OEM creation and usage, backup concepts
• Performance optimizing and tuning
• Problem fixing and escalation management
• SAP, Oracle Retail
• Installation, patching, updates, shell-scripting, SQL-scripting, data masking
• Documentation, reporting, presentations
• Retail business of an worldwide seller of electronics and household electrics with over 1000 shops
• Creating the new database architecture

Key Achievements:

• migration of the first and most important system with the largest database within 2 weeks including building of servers and tests
• international team including teams in india
• 80% remote work, members of the team on 10 different locations worldwide
• Starting a project from the scratch
• Very short timeline
• Cooperation between streams on different locations and teams from different cultures and nations
• Poc of different migration and replication tools, e.g. Quest shareplex with the result not to use it for the reason of license fee and using instead of this the technology of the software vendors

Principal Oracle Architect & Performance Specialist (Team Lead) – Accenture / Kommlink (Public)

Responsibilities:    

• Lead of the Oracle database team (ca. 50) including resource and workload management
• Lead and responsibility in the project for the database part
• Oracle 10g & 11g Database administration of large databases (DWH and OLTP > 1500 TB), Solaris, Linux
• Migration 10g to 11g
• Database with 120.000 permanent client user and up to 50 million online users for an application for Job seekers (e-government)
• 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 up to > 1500 TB, 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
• Migration to Oracle Exadata

Senior Oracle Architect & Performance Specialist (Lead) – Centris AG, Switzerland (Health Sector)

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
• PoC for Exadata
• Savings of a few ten millions CHF because of redesign of the database and reducing the space of a few hundreds 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

Principal Oracle Architect & Performance Specialist (Team Lead) – Accenture / Kommlink (Public)

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
• PoC for Exadata
• Savings of a few ten millions CHF because of redesign of the database and reducing the space of a few hundreds 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

Senior Oracle Specialist / DBA / Architect – Atos Worldline Processing (Credit Card Processing) Frankfurt/Main

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
• Banking system support
• Working in an international team
• Programming of PL/SQL-Scripts and Shell-Scripts, Backup & recovery

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 month 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 month 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

Oracle Consultant – Oracle Consulting / Dresdner Bank (now Commerzbank), Frankfurt/Main

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

Oracle Consultant – Oracle Consulting / Dresdner Bank (now Commerzbank), Frankfurt/Main

esponsibilities:
•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

Oracle Programmer – Computing Center of the Federal Financial Management (Government, IT-Systems for the European Commission)

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

Private programming

Key Achievements:
•Development of a software for a small store in Hamburg using Oracle Express and APEX
•Administration and development of a few websites including software for forums (up to 10.000 Users) using HTML, JAVA, PHP and MySQL on Linux-Systems
•Software for Oracle Performance optimization to record and replay statements