freiberufler Oracle Datenbankadministrator auf freelance.de

Oracle Datenbankadministrator

offline
  • 80‐120€/Stunde
  • 81735 München
  • auf Anfrage
  • es  |  en  |  de
  • 10.08.2021

Kurzvorstellung

A very proficient Freelancer Oracle DBA Consultant with excellent technical skills and knowledge : RAC,performance tuning, RMAN, GoldenGate, patching, upgrades, migrations, standby databases, Exadata.

Auszug Referenzen (4)

"P. is one of the very few Oracle consultants I can entrust with our RACs. He's very insightful, researches thoroughly and coordinates very well."
Freelance Oracle Consultant
Marius Burz
Tätigkeitszeitraum

9/2019 – 9/2019

Tätigkeitsbeschreibung

Projects and tasks:
System audit (evaluation & improvements)
Performance tuning
Patch installation
Restore test and UAT system build

Eingesetzte Qualifikationen

Oracle (allg.)

"P. has tons of domain knowledge and years of experience. He is a pleasure to work with and solved our problems quickly and permanently. 10/10"
Freelance Oracle Consultant
Mario Steinhoff
Tätigkeitszeitraum

2/2019 – 2/2019

Tätigkeitsbeschreibung

Projects and tasks:
DR strategy setup
Backups (RMAN)
Test restore
Backup and restore guides
Patching

Eingesetzte Qualifikationen

Oracle (allg.)

"P. M. war von September 2015 bis Juni 2020 als Freelance Oracle DBA bei Wirecard im Einsatz. Sehr geschätzter Kollege!"
Freelance Oracle DBA/Consultant
Elena Zerner-Kaening
Tätigkeitszeitraum

9/2015 – 6/2020

Tätigkeitsbeschreibung

Projects and tasks:
GoldenGate (CDC replacement)
Table partitioning / data reorganization and reduction
Migration of main DB OLTP (RAC) to new HW
Migration of other DBs to 12C/19C
Day to day support
Patching
HW migrations
Backups (Tape with Networker)
Issues troubleshooting and resolution
Performance tuning (also on Exadata systems)

Eingesetzte Qualifikationen

Oracle (allg.), Oracle RMAN (Recovery Manager)

"P. is one of the most experienced Oracle DBAs I ever worked with. His deep knowledge helped us to migrate, stabilize and optimize our DB landscape"
Freelance Oracle DBA/Consultant
Tobias Fuchs
Tätigkeitszeitraum

6/2015 – 6/2021

Tätigkeitsbeschreibung

Projects and tasks:
Troubleshooting and system stabilization (Performance tuning).
Performance Tuning
GoldenGate
Patching
Advise on future DB strategy.
Evaluation of AWS as Cloud Solution for Oracle Infrastructure
Evaluation of OCI as Cloud Solution for Oracle Infrastructure
HW migration and Upgrade to 12C (RAC) of main OLPT DB
Space reorganization and reduction
Training Junior DBA.
Introduction of Oracle Streams as replication technology.
Backup and Restore (RMAN)

Eingesetzte Qualifikationen

Oracle Data Guard, Oracle Database, Oracle RAC (Real Application Clusters), Oracle RMAN (Recovery Manager)

Qualifikationen

  • Oracle Advanced Queuing (OAQ)
  • Oracle (allg.)
  • Oracle Data Guard
  • Oracle Database
  • Oracle Multitenant
  • Oracle RAC (Real Application Clusters)
  • Oracle RMAN (Recovery Manager)
  • Oracle Virtual Private Database (VPD)

Projekt‐ & Berufserfahrung

Freelance Oracle Consultant
Bank-Verlag GmbH, Cologne Bonn Region
11/2019 – 11/2019 (1 Monat)
Banken
Tätigkeitszeitraum

11/2019 – 11/2019

Tätigkeitsbeschreibung

Proof of Concept – DB migration to Maria DB using Goldengate

Eingesetzte Qualifikationen

Oracle (allg.)

Freelance Oracle Consultant
CHECK24 Vergleichsportal GmbH, München
9/2019 – 9/2019 (1 Monat)
Vergleichsportal
Tätigkeitszeitraum

9/2019 – 9/2019

Tätigkeitsbeschreibung

Projects and tasks:
System audit (evaluation & improvements)
Performance tuning
Patch installation
Restore test and UAT system build

Eingesetzte Qualifikationen

Oracle (allg.)

Freelance Oracle Consultant
CFProfile, Düsseldorf
2/2019 – 2/2019 (1 Monat)
Dienstleistungsbranchen (Service)
Tätigkeitszeitraum

2/2019 – 2/2019

Tätigkeitsbeschreibung

Projects and tasks:
DR strategy setup
Backups (RMAN)
Test restore
Backup and restore guides
Patching

Eingesetzte Qualifikationen

Oracle (allg.)

Freelance Oracle Consultant
VDMA, Frankfurt Rhine-Main
3/2016 – 3/2016 (1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

3/2016 – 3/2016

Tätigkeitsbeschreibung

Performance tuning

Eingesetzte Qualifikationen

Oracle (allg.)

Freelance Oracle DBA/Consultant
Optima Gaming, Seville
10/2015 – offen (8 Jahre, 6 Monate)
Online Betting Services
Tätigkeitszeitraum

10/2015 – offen

Tätigkeitsbeschreibung

Projects and tasks:
GoldenGate for data migration and transformation
Implementation of Oracle 12C multitenant databases
Migration customer databases to 12C
Introduction of Linux as main OS to support databases
Implementation of CRS to replace Failsafe as clustering solution
Implementation of ASM
Performance tuning
Troubleshooting and resolution of issues

Eingesetzte Qualifikationen

Oracle (allg.), Oracle RMAN (Recovery Manager)

Freelance Oracle DBA/Consultant
Wirecard AG, München
9/2015 – 6/2020 (4 Jahre, 10 Monate)
Finanzdienstleister
Tätigkeitszeitraum

9/2015 – 6/2020

Tätigkeitsbeschreibung

Projects and tasks:
GoldenGate (CDC replacement)
Table partitioning / data reorganization and reduction
Migration of main DB OLTP (RAC) to new HW
Migration of other DBs to 12C/19C
Day to day support
Patching
HW migrations
Backups (Tape with Networker)
Issues troubleshooting and resolution
Performance tuning (also on Exadata systems)

Eingesetzte Qualifikationen

Oracle (allg.), Oracle RMAN (Recovery Manager)

Freelance Oracle DBA/Consultant
Zooplus, München
6/2015 – 6/2021 (6 Jahre, 1 Monat)
Handel
Tätigkeitszeitraum

6/2015 – 6/2021

Tätigkeitsbeschreibung

Projects and tasks:
Troubleshooting and system stabilization (Performance tuning).
Performance Tuning
GoldenGate
Patching
Advise on future DB strategy.
Evaluation of AWS as Cloud Solution for Oracle Infrastructure
Evaluation of OCI as Cloud Solution for Oracle Infrastructure
HW migration and Upgrade to 12C (RAC) of main OLPT DB
Space reorganization and reduction
Training Junior DBA.
Introduction of Oracle Streams as replication technology.
Backup and Restore (RMAN)

Eingesetzte Qualifikationen

Oracle Data Guard, Oracle Database, Oracle RAC (Real Application Clusters), Oracle RMAN (Recovery Manager)

Senior Oracle Database Administrator (Festanstellung)
Wirecard, München
8/2013 – 5/2015 (1 Jahr, 10 Monate)
Finanzdienstleister
Tätigkeitszeitraum

8/2013 – 5/2015

Tätigkeitsbeschreibung

• Performance tuning
• Monitoring and troubleshooting
• Disaster recovery (RMAN backups and physical Standby DB)
• Space management: Monitoring and Planning
• Oracle patches and upgrades
• HW requirement specifications
• Developer support

Eingesetzte Qualifikationen

Oracle (allg.)

Senior Oracle Database Administrator (Festanstellung)
Zooplus, München
3/2011 – 8/2013 (2 Jahre, 6 Monate)
Handel
Tätigkeitszeitraum

3/2011 – 8/2013

Tätigkeitsbeschreibung

Oracle 11gR2 – RAC, Linux (RHL 6)
Senior DBA in charge of production and development databases
As a Senior DBA in charge of the company's production (Oracle 11.2.0.3 running on a 4 node RAC cluster) and development databases my duties include :
• Performance tuning
• Monitoring and troubleshooting
• Disaster recovery (RMAN backups and single node physical Standby DB)
• Space management: Monitoring and Planning
• Oracle patches and upgrades (original system was upgraded from 11.1.0.7 to 11.2.0.3)
• HW requirement specifications
I'm also in charge of supporting the development teams (all Zooplus' systems are developed in-house). This includes maintenance on development databases,SQL tuning , advise on Oracle's best practices and relational databases design considerations.

Eingesetzte Qualifikationen

Oracle (allg.)

Oracle DBA (Festanstellung)
Carrefour Spain, Madrid
8/2009 – 11/2010 (1 Jahr, 4 Monate)
Großhandel
Tätigkeitszeitraum

8/2009 – 11/2010

Tätigkeitsbeschreibung

As part of a two man team,in charge of managing performance on production Oracle Databases (10.2 and 11.1.7) owned by Carrefour Spain,my duties include :

* Proactive Tuning : Monitor and evaluate databases in order to
improve performance. Taking into consideration SQL queries and
PL/SQL procedures,physical design,instance parameters and
Oracle bugs as candidates for improvement. Also, when required,
advise developers on Oracle's best practices.

Methodology: Response Time Tuning based on ad-hoc queries
on AWR tables (DBA_HIST_*) and AWR and ASH reports

* Reactive Tuning : Diagnose and solve problems as they are
reported by the users and the application team.

Methodology: Response Time Tuning based on V$ tables,
DBA_HIST_* tables , AWR and ASH reports.

Eingesetzte Qualifikationen

Oracle (allg.)

Lead Oracle Database Administrator (Festanstellung)
Stan James, Gribaltar
10/2006 – 7/2009 (2 Jahre, 10 Monate)
Online Gambling
Tätigkeitszeitraum

10/2006 – 7/2009

Tätigkeitsbeschreibung

Main person in charge of the Company's whole Oracle infrastructure for both Production and Test environments. Stanjames is an on-line business, 24/7 and depends 100% on its Oracle Databases.
My main duties on the production systems included :
• Monitoring.
• Performance Tuning and problem solving.
• Disaster Recovery: Backup and recovery (RMAN) ,Standby Databases.
• Space management: Monitoring and Planning.
• Installation of Application patches.
• Oracle Patches and Bug tracking.
• Change control and documentation.
• On-call support.
For the test environments I was responsible for:
• Creation (using RMAN Duplicas) and maintenance.
• Installation / test of application patches and Change Control.
• Helping with UAT and Stress testing.
• Advising PMs, testers and developers on best practices.
I was also responsible for the selection,training and mentoring of new members of the team.

Eingesetzte Qualifikationen

Oracle (allg.)

Oracle Database Administrator (Festanstellung)
Siemens (Nottingham UK), Nottingham
9/2005 – 9/2009 (4 Jahre, 1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

9/2005 – 9/2009

Tätigkeitsbeschreibung

Oracle 10G R2 – 8i RDBMS, 10G IAS, Sun Solaris 8/9/10.
Provide DBA support for internal projects.
• Data Warehouse Development.
• Application Patching
• Database upgrades
• Data migration
As part of these projects my duties included: SQL and Database
tuning, capacity planning, Oracle software installation and patching, database creation,scripting (PL/SQL, Korn Shell, Perl), developer assistance on Oracle's design best practices,debugging and trouble shooting, writing technical documentation, data loading.

My position was primarily focused on Project / Developer support but I was also involved on
some production activities such as:
• DR Exercise
• On call support (until March 2006)
• RMAN backup and recovery
• Space monitoring

Eingesetzte Qualifikationen

Oracle (allg.)

Oracle Database Administrator (Festanstellung)
Atos Origin, Nottingham
1/2003 – 9/2005 (2 Jahre, 9 Monate)
IT & Entwicklung
Tätigkeitszeitraum

1/2003 – 9/2005

Tätigkeitsbeschreibung

Oracle 10G – 8i RDBMS, Windows 2000/NT platform. Providing production and developer support for critical Payroll and Rail systems. Daily tasks include patching, tuning, SQL tunning, Backup and Recovery, user and developer assistance, database creation and migration, production On-Call support.

Eingesetzte Qualifikationen

Oracle (allg.)

Zertifikate

ITIL Foundation
2013
Certified Expert Oracle Database 10g: Real Application Cluster Administrator
2010
Oracle Database 11g Performance Tuning Certified Expert
2010
Oracle11g Certified Professional Database Administrator
2010
Oracle10g Certified Professional Database Administrator
2005
Oracle9i Certified Professional Database Administrator
2004
Oracle8i Certified Professional Database Administrator
2004

Ausbildung

Engineering
Computer Science
2001
Buenos Aires Argentina

Weitere Kenntnisse

Oracle Database Administration (7/8i/9i/10g/11g/12C/19C)
Knowledge of : RAC, Dataguard, RMAN, OEM, Database Control, ADDM,
exp/imp, expdp/impdp,Dataguard,Resource Manager,VPD,FGA,DBCA,OUI,
DBUA, SQLPlus,Streams , Multitenant, GoldenGate

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Spanisch (Muttersprache)
  • Deutsch (Gut)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
3028
Alter
45
Berufserfahrung
21 Jahre und 2 Monate (seit 01/2003)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden