Recommended expert

Stefan Freundt

Oracle Consultant

Stefan Freundt
Kirchseeon, Germany

Experience

Feb 2017 - Apr 2024
7 years 3 months

Oracle Consultant

Bayerisches Landeskriminalamt

  • Support for Oracle administration and tuning
  • Area: 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
Jan 2017 - Jan 2017
1 month

Oracle Consultant

Star512 Datenbank GmbH

  • Proof of concept with Oracle 12c, evaluation of old and new options
  • Area: data warehouse (DWH), business intelligence (BI), administration
  • Tools: Oracle 12c, PL/SQL, SQL, SQL*Plus
  • PoC topics: table statistics (local and global), extended star schema, bitmap indexes
Feb 2016 - Dec 2016
11 months

Business Intelligence Developer

Kabel Deutschland – Vodafone GmbH

  • Business intelligence development and unloading of large data volumes
  • Area: 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, AWR reports, sql_trace, tkprof
  • Experience: Oracle GoldenGate, data migration from Oracle to Oracle and from MySQL to Oracle, Java 1.8, Control-M, evaluation of 12c new features
Feb 2016 - Jun 2016
5 months

Oracle Consultant

O2 – Telefonica

  • Database and SQL tuning of the CRM database (20 days)
  • Area: development
  • Tools: Oracle 12c, AWR reports, sql_trace, tkprof, Toad, code review of PL/SQL code
Jan 2016 - Jan 2016
1 month

Oracle Trainer

Integrata / msg-life

  • Training on SQL trace, tkprof, V$ views, optimizer, statistics and hints, memory optimization, IO optimization, locks and access conflicts
  • Area: training
  • Tools: Oracle 12c, AWR reports, sql_trace, tkprof, SQL Developer
Dec 2014 - Dec 2015
1 year 1 month

Oracle Consultant

Munich Re / Fujitsu Munich

  • Upgraded/migrated Oracle 11g to Oracle 12c for about 200 databases
  • Migrated the first 10 databases, split into subprojects, supported the Indian operations team in English
  • Used container and pluggable databases, Oracle Enterprise User Security, Transparent Data Encryption, wallets, DB Vault, and realms
  • Application and SQL tuning, optimized table design (a temporary table slowed statements by factor 10), Data Guard, in-memory DB
  • Tools: Data Pump (expdp, impdp), SQL*Plus, Toad, SQL Developer, Oracle Cloud Control, bash, ksh
Jan 2007 - Dec 2014
8 years
Munich, Germany

Oracle Middleware Consultant

T-Systems Toll-Collect

  • Replaced Oracle iAS/BPEL/ESB middleware with Red Hat Fuse 7.1 and JBoss 6.1
  • Handled middleware administration, workshops, messaging system, deployment, documentation, and disaster recovery planning
  • Tools: Oracle Application Interface, Oracle ESB 10.1.3.5, Oracle BPEL, Red Hat Fuse, JBoss, OpenJDK 7, Red Hat Enterprise Linux, Apache, Tomcat, Artifactory, Active MQ, SOAP, XML, XSD, Git, Visio
Mar 2004 - Dec 2015
11 years 10 months
Munich, Germany

Senior Oracle Consultant

T-Systems Toll-Collect

  • Large-scale performance and error analysis project for 350 databases with a team of 25
  • SQL tuning: debugging, sql_trace, tkprof, execution plan analysis, indexes (B*-tree, bitmap, function-based), parallelization, optimizer hints
  • DBA tuning: AWR reports, cache tuning (shared pool, PGA), IO tuning, wait tuning
  • Data warehouse: partitioning (interval, range, hash, list), local and global indexes, materialized views with query rewrite, GROUP BY ROLLUP/CUBE, change data capture
  • Administration: installation, patches, backup & recovery, Data Guard, flashback, networking, clustering (Solaris, Red Hat, VMware), documentation
  • Database administration: OS environment design, silent installation, migration, relink, init.ora/spfile, monitoring
  • Backup & recovery (RMAN, LogMiner), tablespace management, user and role management, LOB management, advanced queuing, replication
  • Tools: Oracle 8.1.7–12.1, RMAN, Grid/Cloud Control, Enterprise Manager, shell scripts

Highlights:

  • Analyzed hardware contention waits with LOBs and resolved them with patch/event
  • Reduced middleware licensing costs by migrating to Red Hat Fuse/JBoss
  • Solaris to Linux migration cut hardware costs
  • Restored deleted online redo logs without data loss
  • Flashback improved test performance by factor 5

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (12 years), Government and Administration (7 years), Telecommunication (1 year), and Insurance (1 year).

Information Technology
Government and Administration
Telecommunication
Insurance

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (20 years), Operations (8 years), and Business Intelligence (1 year).

Information Technology
Operations
Business Intelligence

Skills

Programming Languages

  • Oracle Sql
  • Pl/sql
  • Pascal
  • C
  • C++
  • Java

Databases

  • Oracle 7.3
  • Oracle 8.0
  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18
  • Oracle 19

Operating Systems

  • Windows 9x
  • Windows Nt
  • Windows 2000
  • Windows Xp
  • Windows 7
  • Windows 10
  • Redhat Linux
  • Sun Solaris
  • Suse Linux
  • Hpux
  • Aix

Hardware

  • Sun
  • Pcs

Products, Standards And Experience

  • Oracle Sql Tuning And Database Tuning
  • Pl/sql
  • Oracle Exadata
  • Data Warehouse
  • Database Modeling And Design
  • Oracle Goldengate
  • Large Data Volume Processing
  • Oracle Installation And Database Administration
  • Training (Oracle Dba, Tuning, Backup & Recovery)
  • Backup & Recovery
  • Oracle Recovery Manager (Rman)
  • Data Center Operations
  • Ticket Handling
  • Software Deployment
  • Oracle Specifics On Linux/unix And Windows
  • Oracle Real Application Clusters
  • Oracle For Sap

Languages

German
Native
English
Advanced
Russian
Advanced

Education

PhD, semiconductors / ultrashort pulse lasers / optics · Physics · magna cum laude

Certifications & licenses

Oracle Certified Professional for Oracle 9i

Oracle Certified Professional for Oracle 8.1.7

Oracle Certified Professional for Oracle 8.0.5

Oracle Certified Professional 8.0 / 8i / 9i

Profile

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

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Stefan based?

Stefan is based in Kirchseeon, Germany.

What languages does Stefan speak?

Stefan speaks the following languages: German (Native), English (Advanced), Russian (Advanced).

How many years of experience does Stefan have?

Stefan has at least 20 years of experience. During this time, Stefan has worked in at least 5 different roles and for 7 different companies. The average length of individual experience is 3 years and 6 months. Note that Stefan may not have shared all experience and actually has more experience.

What roles would Stefan be best suited for?

Based on recent experience, Stefan would be well-suited for roles such as: Oracle Consultant, Business Intelligence Developer, Oracle Trainer.

What is Stefan's latest experience?

Stefan's most recent position is Oracle Consultant at Bayerisches Landeskriminalamt.

What companies has Stefan worked for in recent years?

In recent years, Stefan has worked for Bayerisches Landeskriminalamt.

Which industries is Stefan most experienced in?

Stefan is most experienced in industries like Information Technology (IT), Government and Public Administration, and Insurance. Stefan also has some experience in Telecommunication.

Which business areas is Stefan most experienced in?

Stefan is most experienced in business areas like Information Technology (IT), Operations, and Business Intelligence.

Which industries has Stefan worked in recently?

Stefan has recently worked in industries like Government and Public Administration.

Which business areas has Stefan worked in recently?

Stefan has recently worked in business areas like Information Technology (IT).

What is Stefan's education?

Stefan holds a Doctorate in Physics.

Does Stefan have any certificates?

Stefan has 4 certificates. Among them, these include: Oracle Certified Professional for Oracle 9i, Oracle Certified Professional for Oracle 8.1.7, and Oracle Certified Professional for Oracle 8.0.5.

What is the availability of Stefan?

Stefan is immediately available for suitable projects.

What is the rate of Stefan?

Stefan's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Stefan?

To hire Stefan, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 970-1130 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.