Go to Website
  • en
  • de

Stefan F.

Support Oracle Administration and Tuning

Kirchseeon, Germany

Experience

Feb 2017 - Present
8 years 7 months
Germany

Support Oracle Administration and Tuning

Bayerisches LKA

  • Administration, Oracle RAC, Oracle ASM
  • Tools: Oracle 11g, Oracle 12c, PL/SQL, SQL, SQL*Plus, Oracle RAC, Oracle ASM, check_mk, Namis, Oracle Cloud Control, Apache Tomcat, WildFly, Oracle WebLogic Server (WLS)
Jan 2017 - Jan 2017
1 month
Kirchseeon, Germany

Proof of Concept with Oracle 12c, Evaluating Old and New Options

Star512 Datenbank GmbH

  • Data warehouse (DWH), Business Intelligence (BI), Administration
  • Tools: Oracle 12c, PL/SQL, SQL, SQL*Plus
  • PoC on: table statistics local and global, extended star schema and bitmap indexes
Feb 2016 - Dec 2016
11 months
Germany

Business Intelligence Development, Unloading Large Data Volumes

Kabel Deutschland - Vodafone GmbH

  • Business Intelligence development and production
  • Tools: Oracle 12c, SQL Developer, PL/SQL, SQL, Oracle Exadata, Exadata Smart Scan, Oracle Exadata Flash Cache, Oracle In-Memory
  • Unloading large data volumes
  • AWR reports, SQL trace, TKPROF
  • Experience with Oracle GoldenGate, Oracle-to-Oracle and MySQL-to-Oracle replication
  • Java 1.8
  • Control-M job scheduling
  • Evaluated 12c new features
Feb 2016 - Jun 2016
5 months
Germany

Database and SQL Tuning of CRM Database

O2 - Telefonica

  • (20 days)
  • Development
  • Tools: Oracle 12c, AWR reports, SQL trace, TKPROF, Toad
  • Code review of PL/SQL code
Jan 2016 - Jan 2016
1 month
Germany

Oracle Administration, Database Tuning and Monitoring

Integrata / msg-life

  • Training
  • SQL trace, TKPROF, V$ views, optimizer, statistics and hints, memory optimization, I/O optimization, locks and contention
  • Tools: Oracle 12c, AWR reports, SQL trace, TKPROF, SQL Developer
Dec 2014 - Dec 2015
1 year 1 month
Munich, Germany

Upgrade/Migration Oracle 11g to Oracle 12c

Munich Re / Fujitsu Munich

  • Created migration scripts/documentation to upgrade ~200 Oracle 11g databases to 12c
  • Migrated first 10 databases
  • Split into individual projects
  • Supported Indian operations team in migration (in English)
  • Used Container and Pluggable Databases
  • Implemented Oracle Enterprise User Security for centralized user management
  • Transparent Data Encryption for backup encryption
  • Used wallets
  • DB Vault and realms (infrastructure vs application DBA separation)
  • Application tuning, SQL tuning, table design optimization (adding a temp table sped up a key statement by factor 10)
  • Used Oracle Enterprise User Security to map Active Directory users to a shared DB user
  • Data Guard for high availability and failover
  • In-Memory database
  • Issue: statement ran too long
  • Solution: analyzed table design and execution plan, created temp table and used it in app to speed up by 10x
  • Tools: Data Pump (expdp, impdp), SQL*Plus, Toad, SQL Developer, Oracle Cloud Control, bash, ksh
Nov 2011 - Nov 2011
1 month
Erding, Germany

Oracle Database Tuning

MD-Consulting

  • Training
  • SQL trace, TKPROF, V$ views, optimizer, statistics and hints, memory optimization, I/O optimization, locks and contention, parallel query
  • Tools: Oracle 11g, AWR reports
Nov 2011 - Nov 2011
1 month
Hamburg, Germany

Oracle Database Tuning and Monitoring

Unilog Integrata

  • Training
  • SQL trace, TKPROF, V$ views, optimizer, statistics and hints, memory optimization, I/O optimization, locks and contention, parallel query
  • Tools: Oracle 11g, AWR reports
May 2009 - May 2009
1 month
Berlin, Germany

Oracle Administration and Backup & Recovery

DLR

  • Training
  • Storage structure, file structure, user management, archiving, backup & recovery
  • Tools: Oracle 11g, RMAN, AWR reports
May 2008 - May 2008
1 month
Nürtingen, Germany

Oracle Tuning Workshop

Bürotex

  • Training
  • SQL trace, TKPROF, V$ views, optimizer, statistics and hints, memory optimization, I/O optimization, locks and contention, parallel query
  • Analysis of customer-specific statements
  • Tools: Oracle 11g
Jan 2007 - Dec 2014
8 years
Munich, Germany

Replace Oracle Middleware with Red Hat Middleware

T-Systems for Toll-Collect

  • Large project for T-Systems/Toll-Collect
  • Replaced central Oracle iAS/BPEL/ESB middleware with Red Hat Fuse Middleware (Fuse ESB 7.1, JBoss 6.1)
  • Middleware administration
  • Workshops on middleware operation
  • Messaging system
  • Installation, operation, and emergency plan documentation
  • Software delivery deployment
  • Tools: Oracle OAI, Oracle ESB 10.1.3.5, Oracle BPEL, Red Hat Fuse 7.1, JBoss 6.1, JON, OpenJDK 7, RHEL 6.5, JVM, Apache Tomcat, JFrog Artifactory, certificates, ActiveMQ, Message Broker, SOAP, XML/XSD, Git client, Visio
  • Middleware highlight: solved intermittent Oracle BPEL error in test by adding CPUs
Mar 2006 - Mar 2006
1 month
Munich, Germany

Oracle Administration and Backup & Recovery on Linux

Unilog-Integrata

  • Training
  • Tools: Oracle 10g
Feb 2006 - Feb 2006
1 month
Dresden, Germany

Database and SQL Tuning Training

Landesamt für Finanzen

  • Training
  • SQL trace, TKPROF, V$ views, optimizer, statistics and hints, memory optimization, I/O optimization, locks and contention, parallel query
  • Analysis of customer-specific statements
  • Tools: Oracle 10g / 9i
Nov 2005 - Nov 2005
1 month
Leipzig, Germany

Oracle Administration and Backup & Recovery on Linux

Unilog-Integrata

  • Training
  • Oracle installation, storage management, filesystem
  • Tools: Oracle 9i
Nov 2004 - Nov 2004
1 month
Mannheim, Germany

Speaker

DOAG (German Oracle User Group)

Mar 2004 - Dec 2015
11 years 10 months
Munich, Germany

Large Truck Toll Project

T-Systems, Toll-Collect

  • Team of 25 for 350 databases
  • Performance and error analysis of Oracle apps
  • SQL performance analysis, debugging, SQL trace, TKPROF
  • Long-running anonymizations on 100M+ row tables
  • Latch-free waits
  • App error analysis (infinite loops from simple SQL)
  • Data inconsistency fixes
  • SQL tuning, execution plan analysis, optimizer hints
  • Index design (B-tree, bitmap, function-based)
  • Parallel queries, partitioning, materialized views with query rewrite
  • Group by rollup and cube
  • Change data capture triggers
  • DB admin: creation, patching, backup/recovery, network configs, listener, service requests
  • Clusters: Solaris failover, RHEL VMware
  • Documentation and workshops
  • OS setup, silent installs, migrations, patch installs
  • Time zone, NLS check
  • Init.ora and spfile management
  • Monitoring, archive, standby with Data Guard, flashback
  • RMAN, LogMiner, transportable tablespaces, datapump, endian conversion
  • Users, roles, profiles, session kill
  • Tablespace management, reorg
  • SQL & PL/SQL development, triggers, procs
  • LOB management and reorg
  • Advanced queuing, replication, DB links
  • Grid/Cloud Control
  • Shell scripting
  • Workshops on SQL tuning, new features
  • Highlights: resolved enq HW contention for LOBs, cut middleware costs, migration Solaris→Linux, recovered deleted redo logs, tuned direct write waits, 5x test throughput with flashback, optimized anonymization, forced full scan to speed up
  • Tools: Oracle 8.1.7.4–12.1, RMAN, Data Guard, standby, PITR, console/grid/cloud control
  • Managed 350 DBs, TB-scale DWH and 200 commits/sec, Cognos DB, PL/SQL
Feb 2004 - Feb 2004
1 month
Esslingen, Germany

Design and Implement Backup & Recovery Strategy

Bechtle-Verlag, TOP21

  • Administration, backup & recovery
  • Tools: Oracle 8.1.5, 9.2.0, RMAN, Data Guard, Oracle FailSafe
Feb 2004 - Feb 2004
1 month
Munich, Germany

Oracle Database Administration and Backup & Recovery Strategy

Unilog Integrata

  • Various
  • Tools: Oracle 9.2, SQL*Plus, RMAN
Jan 2004 - Jan 2004
1 month
Esslingen, Germany

Crash Recovery, Corrupt Block Recovery

Bechtle-Verlag, TOP21

  • Publishing
  • Tools: Oracle 8.1.5, Export, Import, DBMS_REPAIR
Jan 2004 - Jan 2004
1 month
Frankfurt, Germany

Tuning Workflow Application on Oracle Database

Standard Life Insurance

  • Insurance, workflow
  • Tools: Oracle 9.2, SQL*Plus, Perfstat/Statspack, Toad
Jan 2004 - Jan 2004
1 month
Ratingen, Germany

Oracle Database Administration and Backup & Recovery Strategy

Vodafone, Sun

  • Telecommunications
  • Tools: Oracle 9.2, SQL*Plus, RMAN
Dec 2003 - Dec 2003
1 month
Frankfurt, Germany

Oracle Development and Administration

Atos Origin

  • Credit card billing, payments
  • Tools: Oracle 9.2, SQL*Plus, Enterprise Manager
Dec 2003 - Dec 2003
1 month
Frankfurt, Germany

Oracle Tuning

Unilog Integrata AG

  • Tools: Oracle 9.2, Enterprise Manager, Performance & Diagnostic Pack, Perfstat/Statspack, STAR-Query, materialized views, partitioning, optimizer hints, tracing and diagnosis
Nov 2003 - Nov 2003
1 month
Paderborn, Germany

Oracle Administration and Tuning

Peacock GmbH

  • Tools: Oracle 9.2, Enterprise Manager, Performance & Diagnostic Pack, Perfstat/Statspack, STAR-Query, materialized views, optimizer hints
Nov 2003 - Nov 2003
1 month
Stuttgart, Germany

Oracle Administration, Migration and Tuning

Unilog Integrata

  • Tools: Oracle 8.1.7, 9.2, Enterprise Manager, Performance & Diagnostic Pack, Perfstat/Statspack
Oct 2003 - Oct 2003
1 month
Wiesbaden, Germany

Oracle Administration and Backup & Recovery

Sparkassenversicherung

  • Tools: Oracle 8.1.7, SQL*Plus
Oct 2003 - Oct 2003
1 month
Berlin, Germany

Oracle Installation, Administration and Backup & Recovery

Vodafone AG

  • Tools: Oracle 8.1.7, 9.2, Solaris
Sep 2003 - Dec 2003
4 months

Develop Course Materials for Oracle on Linux

Unilog Integrata

Sep 2003 - Sep 2003
1 month
Lingen, Germany

Support, Crash Recovery with Undocumented init.ora Parameters

Erwin-Müller-Gruppe

  • Tools: Oracle 8.1.7
Sep 2003 - Sep 2003
1 month
Stuttgart, Germany

Install/Evaluate Oracle 9i RAC, Beta Test Oracle 10g

Oracle / HP / NetApp

  • Tools: United Linux 8, Oracle 9.2, 10g
Sep 2003 - Sep 2003
1 month
Wiesbaden, Germany

Oracle Tuning and Automation

Sparkassenversicherung

  • Tools: Oracle 8.1.7, Enterprise Manager, SQL*Plus scripts, Perfstat/Statspack, statistics, optimizer hints
Sep 2003 - Sep 2003
1 month
Cologne, Germany

Oracle Administration, Migration and Tuning

Unilog Integrata

  • Tools: Windows 2000, Oracle 9.2, Enterprise Manager, Perfstat/Statspack, STAR-Query, materialized views, partitioning, optimizer hints
Jul 2003 - Jul 2003
1 month
Lippstadt, Germany

Oracle Administration and Backup & Recovery

GIS mbH

  • Tools: SQL*Plus, Enterprise Manager
Jul 2003 - Jul 2003
1 month
Wiesbaden, Germany

Oracle SQL and Administration

Hessische Zentrale Datenverarbeitung (HZD)

  • Tools: SQLPlus, SQLPlus scripts
Jul 2003 - Jul 2003
1 month
Wiesbaden, Germany

Oracle Administration, Oracle Migration

Sparkassenversicherung

  • Tools: Windows 2000, Oracle 8.1.7 to 9.2
Jul 2003 - Jul 2003
1 month
Bonn, Germany

Install Oracle FailSafe

Stadtwerke Bonn

  • Tools: Oracle FailSafe Manager
Jun 2003 - Jun 2003
1 month

Oracle 9i New Features Workshop

Unilog Integrata AG

Jun 2003 - Jun 2003
1 month

Oracle Administration and Backup & Recovery

Unilog Integrata AG

  • Tools: SQL*Plus, Enterprise Manager
May 2003 - May 2003
1 month
Kempten, Germany

Oracle Spatial / GIS Database

Riwa GIS mbH

May 2003 - May 2003
1 month

Oracle Administration and Enterprise Manager

Unilog Integrata

May 2003 - May 2003
1 month

Oracle PL/SQL Programming

Unilog Integrata

  • Tools: SQL*Plus, PL/SQL
Apr 2003 - Apr 2003
1 month
Berg, Germany

Oracle Installation and Tuning

MD Consulting

  • Tools: Windows 2000, Oracle 9.2
Apr 2003 - Apr 2003
1 month
Paderborn, Germany

Oracle Backup & Recovery

Peacock

Apr 2003 - Apr 2003
1 month
Kempten, Germany

Oracle Spatial / GIS Database

Riwa GIS mbH

Mar 2003 - Mar 2003
1 month

Oracle New Features / Tuning

Guardus Solutions AG

Mar 2003 - Mar 2003
1 month
Munich, Germany

Install Oracle Standby Database on Solaris

Materna Information & Communication

  • Tools: Oracle 9.2, Solaris 8
Feb 2003 - May 2003
4 months

Develop Course Materials for Oracle Cluster: Standby DB, FailSafe, Parallel

Unilog-Integrata

Feb 2003 - Feb 2003
1 month
Germany

Install/Workshop Oracle 8.1.7 and 9.2

Landesamt für Umweltschutz

  • Tools/Languages: Windows 2000, ArcServ backup tool
Feb 2003 - Feb 2003
1 month

Install/Evaluate Oracle RAC 9i on Linux

Oracle / Fujitsu Siemens

Feb 2003 - Feb 2003
1 month

Oracle SQL

Unilog Integrata

  • Tools: SQL*Plus
Feb 2003 - Feb 2003
1 month

Oracle Tuning

Unilog Integrata

  • Tools: Perfstat/Statspack, Enterprise Manager, Diagnostic Pack
Jan 2003 - Jan 2003
1 month
Amberg, Germany

Install/Train/Commission Standby Database

Bayerische Justiz

  • Tools/Languages: Oracle 9.2.0, Solaris 8
Jan 2003 - Jan 2003
1 month
Munich, Germany

Install Oracle Server and Internet Application Server

Netexpress

  • Tools/Languages: Oracle 9.2.0, Suse Linux 8
Dec 2002 - Dec 2002
1 month

Oracle Administration Course

Unilog Integrata

Nov 2002 - Nov 2002
1 month
Wiesbaden, Germany

Oracle Administration Workshop

Sparkassenversicherung

  • Tools/Languages: Oracle 8.1.7, Windows NT, SQL*Plus
Oct 2002 - Oct 2002
1 month

SQL Tuning

Bertelsmann / Nionex

  • Tools/Languages: Oracle 8.1.7.4, Windows NT, Solaris, Toad, optimizer hints
Sep 2002 - Oct 2002
2 months
Amberg, Germany

Install Oracle on Solaris, Configure Standby DB

Bayerische Justiz

  • Tools/Languages: Oracle 9.2.0, Solaris 8
Jun 2002 - Jun 2002
1 month

SQL Tuning

Karstadt/Quelle (Itellium)

  • Tools/Languages: Oracle 8.1.7, HPUX, Toad
Mar 2002 - Mar 2002
1 month

Database Tuning (Memory Tuning)

Eurolog AG

  • Tools/Languages: Oracle 8.1.6, HPUX, Perfstat/Statspack
Dec 2001 - Jan 2002
2 months

Oracle Administration

Hewlett & Packard GmbH

Dec 2001 - Jan 2002
2 months

Oracle Administration

Materna Information & Communication

Nov 2001 - Nov 2001
1 month
Mannheim, Germany

Speaker

DOAG (German Oracle User Group)

  • "Silent installation via response file"
  • "Undo management = auto... no more rollback issues"
Nov 2001 - Nov 2001
1 month

Oracle FailSafe (Active/Passive Cluster) Installation

Landeszentralbank Bayern

  • Tools/Languages: Oracle 8.1.7, Windows 2000
Sep 2001 - Sep 2001
1 month

Database Tuning

Landeszentralbank Bayern

  • Tools/Languages: Oracle 8.1.7, Windows NT/2000
Jun 2001 - Jun 2001
1 month

Silent Oracle Installation via Response File

Landeszentralbank Bayern

  • Tools/Languages: Oracle 8.1.7, Windows NT
Jun 2001 - Jun 2001
1 month
Berlin, Germany

Speaker

Oracle Open World

  • "Database Tuning"
  • "Oracle 9i New Features"
Dec 1997 - Sep 2001
3 years 10 months
Munich, Germany

Trainer, Oracle University

Oracle Deutschland GmbH

  • Trainings on:
  • Oracle SQL (5 days)
  • Oracle Database Administration and Backup & Recovery (10 days)
  • Oracle Database Tuning (5 days)
  • Oracle on Windows (2 days)
  • Oracle for SAP Administrators

Languages

German
Native
English
Advanced
Russian
Advanced

Education

Lorem ipsum dolor sit amet

PhD, Semiconductors / Ultrashort Pulse Lasers / Optics · Physics

Certifications & licenses

Oracle Certified Professional 9i

Oracle Certified Professional 8.1.7

Oracle Certified Professional 8.0.5

Oracle Certified Professional 8i

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Ben S.

Data Engineer

View Profile
Joachim B.

Further development and maintenance of a company-wide monitoring database

View Profile
Stephan Z.

GIS Expert and Database Developer in Traveler Information Systems

View Profile
Frank E.

DevOps

View Profile
Serge K.

Senior DevOps (external)

View Profile
Michal B.

Senior Golang Engineer

View Profile
Volker L.

Technischer Projektleiter

View Profile
Vitali H.

Power BI Expert

View Profile
Ernst H.

Support/Development/Consulting – Process development, e-invoicing, XRechnung, ZUGFeRD

View Profile
Werner M.

IT Support

View Profile
Ildar A.

Senior Data Engineer

View Profile
Stephan S.

Senior Data/ML Consultant & Technical Lead

View Profile
Marco S.

Business Analyst, Data Warehouse Developer

View Profile
Germo G.

BI Development

View Profile
Gerd K.

Database and Software Developer

View Profile
fratch Part of Bitkom logo
linkedIncrunchbaseyoutube
  • English
  • Deutsch

2025 © FRATCH.IO GmbH. All rights reserved.