Stefan Freundt - Oracle Consultant

Q: Where is Stefan based?

Stefan is based in Kirchseeon, Germany .

Q: What languages does Stefan speak?

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

Q: 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.

Q: What is Stefan's latest experience?

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

Q: What companies has Stefan worked for in recent years?

In recent years, Stefan has worked for Bayerisches Landeskriminalamt .

Q: Which industries is Stefan most experienced in?

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

Q: Which business areas is Stefan most experienced in?

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

Q: Which industries has Stefan worked in recently?

Stefan has recently worked in industries like Government and Administration .

Q: Which business areas has Stefan worked in recently?

Stefan has recently worked in business areas like Information Technology .

Recommended expert

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

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Government and Administration, Telecommunication, and Insurance.

Information Technology

Government and Administration

Telecommunication

Insurance

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Operations, and Business Intelligence.

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

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

Statistics

Experience

Total positions 8

Experience in Information Technology 12 y

Avg length 3 y 8 m

Longest experience 11 y 9 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles Oracle Consultant, Business Intelligence Developer, Oracle Trainer

Main industries Information Technology, Government and Administration, Telecommunication

Main business areas Information Technology, Operations, Business Intelligence

Qualifications

Highest degree Doctorate

Certifications earned 4

Profile

Created

September 2023

Last Update

September 2024

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

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, Government and 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, Operations, and Business Intelligence.

Which industries has Stefan worked in recently?

Stefan has recently worked in industries like Government and Administration.

Which business areas has Stefan worked in recently?

Stefan has recently worked in business areas like Information Technology.

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.