people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontakt


Kontakt


people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontaktdaten anfordern


Freelancerprofil: -0231040

Administrator DBA Oracle, Bankwissen, ITIL

Position:
IT Administration / Support
IT Datenbankadministration
IT Helpdesk/ Technischer Support
Projekte im Werdegang

05/2014 - Oracle, Bankwissen, ITIL
Oracle DBA German Retail Banking 3 rd Level Support part of a team supporting Deutsche Bank's German retail banking. 600 RAC clustered/Dataguard databases at the time when Deutsche was consolidating systems with the Post Bank acquisition. About half of the databases were running SAP Banking application software. Support (3 rd Level) was within the local German team (Meetings/emails 90% German language, conversation 70% German language) and not provided globally and included shift and on-call work and Problem solving/Tuning requests and 4x yearly PSU patching. As project work I was responsible for the customisation of Deutsche Bank's in-house backup script framework to improve the ease of maintenance and reduce the number of incident tickets via a standardisation approach. The aim was to have only one backup template regardless of the role of the database in the dataguard configuration and for the configuration to be DR Aware' meaning during switchovers (.e.g during DR testing weekends) no change to the configuration would be needed RESPONSIBILITIES . ? Global Databases 3 rd Level Support ? On-call duties ? Performing patching and upgrades ? Troubleshooting & Tuning ? Incident and Change Request Administration (ITIL / Remedy) ? Environment Productivity Enhancements including standardiastion (Shell scripting) ? Writing documentaion

03/2012 - 05/2014 Oracle, ITIL
Oracle DBA Global 3 rd Level Support Part of a worldwide Deutsche Bank management SCN Task force across the world to organise and patch Hundreds of databases (with various configurations, Dataguard, RAC) to protect against the Oracle SCN bug Oracle worked closely with Deutsche Bank to do what it could to protect the bank. The first publicly available patch for this bug was the Jan 2012 PSU followed by the Apr 2012 PSU along with additional Oracle recommended settings Also part of the global support team providing global 3 rd level Support for Oracle databases as part of a "follow the sun" cover utilising Remedy as the tool for IT Service Management. A number of applications were running on Exadata Machines RESPONSIBILITIES ? Global Databases 3 rd Level Support ? On-call duties ? Performing patching and upgrades ? Troubleshooting & Tuning ? Document patch requirements for version/platform/priority combinations ? Shell Scripting ? Mentoring Colleagues in Singapore ? Assist contacts with the patching / upgrading of their databases ? Incident and Change Request Administration (ITIL / Remedy) ? Write documentation to help with description of the bug for contacts

01/2012 - 04/2012 Oracle, Windows, Linux, Sun OS / Solaris, AIX
Oracle Production DBA, Cargill For one of the biggest private companies in the world dealing in everything from wheat to Chocolate I was Production DBA supporting 1400 databases from versions 9i to 11g worldwide making extensive use of 11g Grid Control (together with direct host access) to manage and support RAC Clusters,RMAN Backup Dataguard configurations and ASM instances on both Windows and Linux/Solaris/ AIX Platforms. Working as part of a virtual team made up of members in Europe, Latin America, North America and Asia as part of a follow-the-sun model. Remedy (BMC) was used throughout the company for IT Service Management RESPONSIBILITIES ? Database systems problem resolution ? Troubleshooting & Tuning ? Database creation and decommissioning ? on-call duties ? Incident and Change Request Administration

11/2011 - Oracle, Exportwissen
Dec2011 Arval UK Short consultancy assignment to build 3 HP Proliant BL series Blades with Redhat Enterprise Server 5 together with the installation and configuration of 6 individual Oracle 11gR2 database instances with ASM on multipathed storage on a SAN fabric. Active Dataguard also to be configured. The databases were part of a migration of environments from France to the UK for this large Fleet Management company ? Work with Storage personnel for the sizing and presentation of LUNs ? Work with HP Integrated Lights Out (ILO) front-end ? Install and configure Redhat ES 5.7 on the Proliant Blades ? Download and install relevant Qlogic HBA software and utlities ? Configure multipathing using Device Mapper ? Create ASM disk/diskgroups using the multipathed devices ? Create 6 database instances utilising Oracle Restart ? Build and Configure Active Dataguard using rman duplicate database ? Import Oracle datapump dump files into the databases ? Create a build documents for Storage and DBA personnel ? Using data pumps for import and export ? Working with Redhat Support to Resolve support issues Oracle Consultant

10/2010 - 11/2011 Oracle, Flash/ActionScript
development,testing & deployment environment for a Multi-Terabyte Data Warehouse application supporting Deutsche Bank's Credit Risk Application for regulatory monthly reporting of the key data of the Deutsche Bank Group in Frankfurt, London, New York, Singapore. The environment was quite experimental in that it was testing the use of Flash Disks, cluster file systems (Gluster) and Exadata RESPONSIBILITIES ? Support & mentor outsourced developers and DBAs ? Creating, Patching & Upgrading databases ? Performance analysis ? Standardization and management control of DBA tasks ? Installation & Creation of 2 node RAC environment ? Develop and implement a backup & restore process to support the daily & monthly test/deployment cycle (must allow the testers to be able to backup and deploy through incarnations whether using an rman catalog or not and whether a full or incremental backups) ? Develop a procedure to enable the creation of databases (including accompanying ASM instances) on demand and within 24 hrs ? Develop a log cleanup script (korn shell) for 11g databases Senior Oracle DBA/Developer

05/2010 - 09/2010 Oracle, Unix Allgemein, Netzwerk
Senior Oracle DBA, System Integration part of the acquisition of the derivative business of Sal Oppenheim by Macquarie Bank. Working sideby-side with a team of system integrators, Unix administrators, Network Engineers and numerous other skills required for the successful migration of the new Data Centres and offices. My general role involved the creation and configuration of the database infrastructure to support the migration of current Sal Oppenheim trading applications to a new Macquarie platform supported by Macquarie standards RESPONSIBILITIES ? User communication and Requirements Gathering ? Database/Client creation & Patching ? Installing and configuring ASM ? Database Loads (exp/data pump) for data migrations ? Bash Shell scripting a user automated database refresh process ? Involved in Destruction Testing Cluster failover testing ? Documentation for TSG (Technical Support Group) ? Very close working relationships with other technical team members Senior Oracle DBA

07/2007 - 12/2007 Oracle, Veritas, Sun OS / Solaris
Oracle Infrastructure Project Lead To regenerate the momentum on two projects that had come to a standstill: Oracle 10g upgrade/Migration project adnd DBA "Toolkit" project (in-house tailored automated database environment written in Korn shell scripts). The environment consisted of over 400 databases running mixed Oracle versions with Veritas clusters spread over 4 countries running Solaris8/10. These projects were part of many related and complimentary projects involved in a huge upgrade of the technology stack around the operation of the databases Steps: start regular project meetings; perform a re-scoping; determine new & realistic deliverables & provide timelines and present to management attend group project meetings. And further, to analyse, recommend implement and manage improvements and ensure they worked after the migration. As an indication of the satisfaction with my work in the team I was offered a permanent position but unfortunately, could not accept the offer at the time RESPONSIBILITIES ? Regenerate momentum on a Oracle 10g/Solaris migration project ? Oracle 10g Migrations - definition of roles and scope ? Oracle 10g Migrations - Scheduling, Testing, Implementation, Optimisation, documentation ? Oracle 10g Migrations- Impact Analysis, Risk Assessment of Oracle 10g new features ? DBA Toolkit - Evaluate competing sets of UBS DBA toolkits on migrated environment ? DBA Toolkit - Recommend and manage the implementation of improvements to the existing Toolkit ? Oracle 10g Migrations & DBA Toolkit - communicate with tech. stack personnel, attend meetings ,report

07/2006 - 06/2007 Oracle, Luftfahrt/ Verteidigung
Oracle DBA European Agency for Aviation Safety, Cologne, Germany

10/2005 - 06/2006 Luftfahrt/ Verteidigung, Oracle, ETL - Extract/Transform/Load
Multi-version database and operating system environment running part in-house developed web-based applications and part third party applications on 40 databases that help the agency in its role of certifying all aspects of aviation safety in Europe Oracle DBA ETL, Amadeus, Nice

01/2005 - 10/2005 MVS/OS-390, Linux, Oracle, ETL - Extract/Transform/Load
World Wide Travel Global Information Distribution System migration from MVS / DB2 to Linux / Oracle at the largest travel and booking software development company in Europe. Brought in as a consultant to help the consultancy firm Accenture Oracle Production DBA ETL consultant

05/2004 - 11/2004 Oracle, MS SQL Server, Informatica, PL/SQL
Nestle Globe , one of the biggest IT Projects in Europe was a Europe wide incremental SAP roll-out with modules such as HR receiving data from numerous complimentary applications and in a variety of formats and on both Oracle and MSSQL Server Databases. In the middle of all this is Informatica driving the extraction, transformation and delivery of the data to SAP. With additional commitment of Informatica PowerChannel and Easysoft connection software Plsql Developer/DBA

10/2000 - 04/2004 PL/SQL, Meldewesen
Frankfurt, Germany DBA in a 5 man Frankfurt Project team and 20 man overall project team (Frankfurt, London and New York) responsible for the 5 databases in a system that acts as a Central Staging Area for the Global Data Delivery Project feeding the Bank's credit risk and German regulatory reporting systems Plsql Developer/DBA

 
Branche

  Banken & Finanzen
 
Kenntnisse

Hardware
IBM Mainframe
Betriebssysteme
AIX
AIX (++ (trained), 0-2 yrs.)
Linux
OS/390
Sun OS / Solaris
Sun OS / Solaris (++ (trained), 0-2 yrs.)
Unix
Programmiersprachen
Flash/ActionScript
Java
Perl (+ (basic knowledge), 0 yrs.)
PL/SQL (+++ (good), 2-4 yrs.)
PL/SQL
Shell - C-Shell, K-Shell, Bourne-Shell (+++ (good), 2-4 yrs.)
SQL

Datenbanken
MS SQL Server
Oracle
Oracle (++++ (excellent), > 4 yrs.)

Datenkomm. / Netzwerk
Netzwerk
Oracle Weblogic Server (+ (basic knowledge), 0 yrs.)
Storage Systeme

Design / Entwicklung

SAP / ERP Module

Software / Tools
CVS (Concurrent Version System)
PVCS Serena Versionsmanagement

Standards / Prozesse
Anwendungsbetreuung
Changemanagement
ETL - Extract/Transform/Load
ITIL
Problem Management
 
Ausbildung & Zertifikate

k.A  
 
Sprachen

deutsch
englisch (++++)


Sonstiges

 

We love Freelancing
& project work

die people4project Recruiting-Spezialisten unterstützen IT Fachbereiche und Unternehmensberatungen mit der Auswahl von geeigneten Freelancer / IT Fachkräften

Kontakt

Wir freuen uns auf Sie...

people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Tel: +49 (89) 55 29 39 -40

  Google Map  |  Kontakt

 

über uns

wir sind Recruiting-Spezialisten für die temporäre Unterstützung von IT Entwicklungs- und Betriebsthemen, sowie das Managen von Freelancer-Einsätzen bei unseren Kunden.

...mehr

Â