Senior Oracle DBA

Referenznummer KDNR.022

IT Experience since 1990

Languages

German (mother tongue)
English (fluent)

Expertise

Industry Experience

Telecommunications, Finance, Oil & Gas, Logistics

Specialised Knowledge

Application Performance Tuning; SQL Tuning; Oracle Database Administration; Oracle High Availability (ASM, Dataguard, Grid); PL/SQL Development

Methods and Processes

Migrations and Migration Strategies; BSCS, Oracle BRM

Technical Skills

Operating Systems

Windows, Unix/Linux; Mac OS X

Databases

Oracle 7.x, 8i, 9i, 10g, 11g, 12c

Programming

PL/SQL; C, Shell scripting, XML, Soap

Software

LHS BSCS, Oracle BRM (Portal Infranet), Avaloq

Projects

Logistics

03/2011 – today  Oracle DBA (Freelance position)

Migration of 500+ Oracle Databases (RAC, Dataguard and Standalone) from 9i, 10g to 11g

Role / Responsibilities:

Planing and Implementing the Migration of “Customer” Application

Migration Oracle 10g Databases to Oracle 11g

Move of Databases and Middleware to new Servers and Storage

Implementing the Oracle Grid infrastructure

Troubleshooting, Performance Tuning

PL/SQL Development for “Parcel Track and Trace” PADASA

Technology: SLES 11, Oracle 10g, 11g, Dataguard, EM 12c, RAC, ASM, VmWare, HP Blades

Consulting

06/2010 – 02/2011   Oracle DBA & Developer (Permanent Position)

Designing and Implementing an advanced Oracle User Authentication Tool

Role / Responsibilities:

Porting a ADABAS Natural application to Oracle PL/SQL 11g.

Database Administration and Troubleshooting for various customers.

PL/SQL Development

Technology: UNIX, Oracle Server 10g, 11g

Telecommunications

07/2008 – 12/2009 Oracle DBA & Developer (Freelance position)

Stabilization of Oracle BRM 7.2 (Portal Infranet)

Oracle BRM upgrade to 7.3.1, Upgrade Oracle 9.2 -> 11.1

Role / Responsibilities:

4   Database Performance Tuning, Monitoring, SQL Tuning

4   Compression of XML LOBs (Itemized Bills) in order to reduce space requirements and to increase processing speed.

4   11g Advanced Compression

4   11g Optimizer configuration, SQL Baselines

4   Oracle BRM environment replication using Datapump and  PL/SQL

4   Database Administration

Technology: HP/UX, Sun Solaris, Oracle 9i, 11g, Oracle BRM 7.2 and 7.3.1 (Billing Software)