Oracle, Apex, Datenbank PL/SQL, SQL, Tuning, Performanceanalyse
Aktualisiert am 02.09.2019
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 30.09.2019
Verfügbar zu: 100%
davon vor Ort: 100%
English
fluently
German
fluently

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 2 Monate
2013-08 - 2019-09

Development of web applications

  • Development of web applications with APEX for the Financial Clearing House Business scopes: Payments and Collections
  • Development of a cockpit application to show progress of work of the web users and deliver KPIs to the management
  • Development of a monitoring tool to show status, performance, past and scheduled future execution of all database jobs in the system
  • Performance Tuning of applications
Vodafone Group Services GmbH
10 Jahre 8 Monate
2006-06 - 2017-01

Review and overhaul

  • Review and overhaul of a data model, build of a concept for extension and improvement
  • Database and application performance tuning
  • Maintenance and optimization of PL/SQL programs
  • Implementation of complex materialized views
Yazaki
11 Jahre 4 Monate
2005-02 - 2016-05

Installation, upgrade and administration of Oracle12cR1, Oracle11gR2 and Oracle11.1 database

  • Installation, upgrade and administration of Oracle12cR1, Oracle11gR2 and Oracle11.1 databases
  • Implementation of an Oracle 10g environment
  • Migration of 8.1.7 and 9.2 databases to 10g+10gR2
  • Tuning of Oracle 10g+11g+12c databases and implementation of materialized views for optimization of a data warehouse system
  • Concept and development of a "value-based" auditing with PL/SQL and UNIX shell scripts
  • Support of Advanced Queuing in Oracle databases
X-Map
7 Jahre 5 Monate
2006-04 - 2013-08

1st and 2nd level support

  • Installation, configuration and upgrade of Oracle 10g, 11g and Grid Control
  • PL/SQL and Shell programming
  • Development of web applications with APEX for KPIs and Reporting
  • Preparing and holding of workshops for “Architecture of Oracle” and “Application Analysis and Tuning” Database and application performance tuning
  • 1st and 2nd level support with incident and problem management Partitioning and compression of big tables (up to 2TB data)
Vodafone D2 GmbH
6 Monate
2005-10 - 2006-03

database migration

  • Oracle database migration to 9.2 (DB-size up to 500 GB)
  • Administration of data warehouse databases and database replication
  • Use of OEM and RMAN for DB administration
  • Installation and administration of Oracle 10gR2 databases
  • Performance tuning of SQL and PL/SQL applications
GAD
3 Monate
2005-06 - 2005-08

Application development

  • Application development with PL/SQL and SQL for a data warehouse system (Oracle 10g)
  • Build of materialized views and use of performance advisories
Thyssen
6 Jahre 5 Monate
1998-08 - 2004-12

Implementation

  • Oracle DB Administration, installation, upgrade, backup/recovery, DB-Design, DB-Tuning
  • 1st and 2nd level support for various DB applications
  • Development of applications (PL/SQL, SQL, Pro*Cobol and Java)
  • Implementation of a distributed database replication system
  • Database and application tuning
WestLB and T-Systems
2 Jahre 3 Monate
1996-06 - 1998-08

Consultant for development

  • Group leader of Oracle Core Technology in Düsseldorf with 17 consultants
Oracle
7 Jahre 11 Monate
1990-10 - 1998-08

development

  • Group leader of Oracle Core Technology
  • Consultant for development of applications (C, SQL, PL/SQL, Case, Forms, Reports), database implementation and administration at different customer sites
  • Build of an Oracle/Unix architecture for a big company
Oracle

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

  • 29 years of experience in working with different Oracle tools  and products
  • Application Development with Application Express (APEX), PL/SQL, SQL, C and Java
  • DB-Architecture-, Design-, Modelling- and Administration
  • Backend and Frontend Performance Analysis and Tuning

CAREER

  • Dipl Math.
  • Working 8 years as an Oracle employee
  • Working 21 years as an independent consultant in different Oracle projects

SOFTWARE

Oracle Database 5.1 ? 19c, Grid Control & Tuning Packs, Application Express (APEX), PL/SQL and SQL, Oracle Forms, Oracle Reports, C, Java and Unix shel

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 2 Monate
2013-08 - 2019-09

Development of web applications

  • Development of web applications with APEX for the Financial Clearing House Business scopes: Payments and Collections
  • Development of a cockpit application to show progress of work of the web users and deliver KPIs to the management
  • Development of a monitoring tool to show status, performance, past and scheduled future execution of all database jobs in the system
  • Performance Tuning of applications
Vodafone Group Services GmbH
10 Jahre 8 Monate
2006-06 - 2017-01

Review and overhaul

  • Review and overhaul of a data model, build of a concept for extension and improvement
  • Database and application performance tuning
  • Maintenance and optimization of PL/SQL programs
  • Implementation of complex materialized views
Yazaki
11 Jahre 4 Monate
2005-02 - 2016-05

Installation, upgrade and administration of Oracle12cR1, Oracle11gR2 and Oracle11.1 database

  • Installation, upgrade and administration of Oracle12cR1, Oracle11gR2 and Oracle11.1 databases
  • Implementation of an Oracle 10g environment
  • Migration of 8.1.7 and 9.2 databases to 10g+10gR2
  • Tuning of Oracle 10g+11g+12c databases and implementation of materialized views for optimization of a data warehouse system
  • Concept and development of a "value-based" auditing with PL/SQL and UNIX shell scripts
  • Support of Advanced Queuing in Oracle databases
X-Map
7 Jahre 5 Monate
2006-04 - 2013-08

1st and 2nd level support

  • Installation, configuration and upgrade of Oracle 10g, 11g and Grid Control
  • PL/SQL and Shell programming
  • Development of web applications with APEX for KPIs and Reporting
  • Preparing and holding of workshops for “Architecture of Oracle” and “Application Analysis and Tuning” Database and application performance tuning
  • 1st and 2nd level support with incident and problem management Partitioning and compression of big tables (up to 2TB data)
Vodafone D2 GmbH
6 Monate
2005-10 - 2006-03

database migration

  • Oracle database migration to 9.2 (DB-size up to 500 GB)
  • Administration of data warehouse databases and database replication
  • Use of OEM and RMAN for DB administration
  • Installation and administration of Oracle 10gR2 databases
  • Performance tuning of SQL and PL/SQL applications
GAD
3 Monate
2005-06 - 2005-08

Application development

  • Application development with PL/SQL and SQL for a data warehouse system (Oracle 10g)
  • Build of materialized views and use of performance advisories
Thyssen
6 Jahre 5 Monate
1998-08 - 2004-12

Implementation

  • Oracle DB Administration, installation, upgrade, backup/recovery, DB-Design, DB-Tuning
  • 1st and 2nd level support for various DB applications
  • Development of applications (PL/SQL, SQL, Pro*Cobol and Java)
  • Implementation of a distributed database replication system
  • Database and application tuning
WestLB and T-Systems
2 Jahre 3 Monate
1996-06 - 1998-08

Consultant for development

  • Group leader of Oracle Core Technology in Düsseldorf with 17 consultants
Oracle
7 Jahre 11 Monate
1990-10 - 1998-08

development

  • Group leader of Oracle Core Technology
  • Consultant for development of applications (C, SQL, PL/SQL, Case, Forms, Reports), database implementation and administration at different customer sites
  • Build of an Oracle/Unix architecture for a big company
Oracle

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

  • 29 years of experience in working with different Oracle tools  and products
  • Application Development with Application Express (APEX), PL/SQL, SQL, C and Java
  • DB-Architecture-, Design-, Modelling- and Administration
  • Backend and Frontend Performance Analysis and Tuning

CAREER

  • Dipl Math.
  • Working 8 years as an Oracle employee
  • Working 21 years as an independent consultant in different Oracle projects

SOFTWARE

Oracle Database 5.1 ? 19c, Grid Control & Tuning Packs, Application Express (APEX), PL/SQL and SQL, Oracle Forms, Oracle Reports, C, Java and Unix shel

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.