Axel Tenkhoff

Bad Salzuflen

available

Last update: 06.09.2022

Oracle database experte: administration (incl. RAC, DG), Tuning, PL/SQL and APEX development

Graduation: Master of Computer Science (Diplom Informatiker) Universität Paderborn 04/1996

Hourly-/Daily rates: show

Languages: German (Native or Bilingual) | English (Limited professional)

Keywords

Oracle SQL ITIL PLSQL Oracle Data Guard Oracle XML DB Oracle Performance Tuning Oracle 11/12/18 Docker APEX 5.1/18.1 SCRUM Erfahrung Scrum Kanban Agile SQL (PostgreSQL SQL / data modeling SQL / XML REST & SOAP-Schnittstellen

Attachments

Profil_en.docx

Profil.docx

Skills

Current skills: ORACLE software development and support

OLTP, DWH, Multitenant (11gR2 – 12.2 / 18c / 19c)
PL/SQL, SQL, XMLDB, JSON, Oracle Text, Spatial, Graph APEX 5.x (11gR2 - 12.2 / 18c / 19c)
Predictive Analysis (Oracle Data Mining, R)
Data Model (Data Vault, Star Schema, Snow Flake, OLTP 3.NF, EAV)

ORACLE database administration (RAC, Dataguard, HA Cluster, ASM, Multitenant)

OS: 10g, 11gR2, 12c, 12.2, 18c, 19c Windows, Linux (,HPUX, AIX and Solaris)
Virtualisierung (Hard, Soft): Solaris LDOM, Rootdomain, AIX LPAR, Oracle VM, Virtualbox, Dockers

Oracle Tuning: SQL, PLSQL, RDBMS, OS and SAN / NFS
Oracle Security: PKI, TDE, Database Vault, SSL, Unified Auditing, Oracle Enterprise User Security
Incident, Problem Change & Capacitymanagement (ITIL)

Project history

10/2018 - 12/2020

XTTS Cross Plattform Transportable Tablespace Migration AIX -> Linux

xyz (Banks and financial services, >10.000 employees)

Zeitraum: 01.10.2018 – 31.12.2018

Branche: Bank

Projekt: XTTS Cross Plattform Transportable Tablespace

Migration AIX -> Linux

Infrastruktur: Linux, AIX, Oracle 12.1

Tätigkeiten:

Entwicklung von SQL/PLSQL und Shellscripts für automatisiertes XTTS
Dokumentation
Kapazitätsplanung und Zeitmessung
Bug Analyse und Bugfix

08/2019 - 05/2020

PL/SQL Entwicklung, Tuning und DBA Unterstützung

xyz (Public service, >10.000 employees)

Zeitraum: 14.08.2019 – dato

Branche: Behörde

Projekt: Risikomanagement

Infrastruktur: Linux, Solaris Oracle 12.1/12.2

Beschreibung: PL/SQL Entwicklung, Tuning und DBA Unterstützung

Tätigkeiten: PL/SQL Entwicklung und Bugfixing.

Unterstützung im Bereich Oracle Upgrades 12.2 und 19c.

Umstellung auf Multitenant DB’s.

09/2018 - 12/2019

Cloud Control 13.3, Oracle Betrieb, Oracle Upgrades, Datenmigration, Projektunterstützung

(Banks and financial services, >10.000 employees)

Zeitraum: 01.09.2018 – 31.12.2019

Branche: Bank

Projekt: Cloud Control, Oracle Betrieb, Oracle Upgrades, Datenmigration, Projektunterstützung

Infrastruktur: Linux, Windows, AIX, Oracle 12.1/12.2, EM13c 13.3

Beschreibung: Oracle Betrieb inkl RAC, Dataguard, Oracle Upgrades, Multitenant, Projektunterstützung, Entwicklung,

Performancetuning

06/2016 - 06/2017

Quality Gate APEX Anwendung

xyz (Automotive and vehicle construction, >10.000 employees)

Zeitraum: 01.06.2016– 30.06.2017

Branche: Automobil

Projekt: Quality Gate APEX Anwendung

Infrastruktur: Solaris 10, AIX 5.1, Red Hat Linux (KVM Virtualisierung), Oracle 12.1

Beschreibung: Die Anwendung dient der Qualitätssicherung von > 1500 Oracle Instances.

Es werden Remote synthetische Benchmarks, Healtchcheck Script, AWR Metric…

SQL Scripts aufgerufen und die Daten zentral gespeichert.

In einem Dashboard werden die Quality Gates grafisch angezeigt. Per drill down werden dann alle QS Informationen und Metadaten angezeigt und über Masken gepflegt.

Tätigkeiten:

Agile Software Entwicklung mit 7 – 14 tägigen Sprints, wöchentliches Reporting und Statusmeeting
Datenmodellierung inkl. view Layer
Entwicklung von SQL Loader Scripts ETL PL/SQL Package
Entwicklung eines zentralen Unix Cronjobs und remote ssh Shellscript inkl. Mailing

und Logging in der zentralen QS Oracle (APEX) Instance.

Remotes Datensammeln per SQL
AWR Daten: osstat, sysstat,…
Oracle Cloud Control Daten: Unix Memory, ORA- Diag Daten
Healthcheck Daten (Redo Grösse, Member,..SGA, PGA…)
Synthetischer Benchmark (CPU, Full Tablescans, Parallel Query…)
Datensammeln von Metadaten und ITIL Daten zu den Oracle Instances
Service Center Incidents, Problems, Changes, Gruppen…
Dokumente (Word, PDF) in BLOBs inkl Oracle Text Volltext Indizierung
ETL per sqlldr & PLSQL Package in eine zentrales Quality Gate Repository
Graphische Web Oberfläche mit APEX 4.x (inkl. dynamic actions)
Eingabemasken (Forms) / Interactive Reports / Charts
Job Steuerung: ETL inkl. Detail Logging

Local Availability

Open to travel worldwide

Verfügbarkeit: ab 04.05.2020: 100% vor Ort Einsatz und Rufbereitschaft (24 x 7)
Kurzzeitprojekte: jederzeit

Other

Oracle core competence

Database Administration (ITIL, DevOps)
Oracle MAA & HA: RAC, Data Guard & Fail Over Cluster
Multitenant
Sharding
Installation, Upgrade & Patches (ITIL, DevOps)
Databank Migrationen: OS Wechsel, Endian Convert, Hardware Umzüge, Cloud Migrationen (AWS, Oracle Cloud)
Backup and Recovery RMAN (inkl Setup, Tuning), Anbindung an Backup Software: TSM, DELL EMC Data Domain Boost, Veritas Netbackup)
InOperationsnahme: Documentation and Operationsshandbücher (ITIL, DevOps)
Monitoring & Capacity Management
Tuning & Troubleshooting
Table, Index, LOB Reorg (online, near zero downtime), Partitioning and Compression
Development: Conception, ER-Modeling, Realization with PL/SQL and APEX (Agil, DevOps)
Development of Funktionstests & Load tests (Agil, DevOps)
Data Quality Management
Hardware / Software Planning inkl. Virtualisierung, Lizenzoptimierung
Virtualisierung (Hard, Soft): Solaris LDOM, Rootdomain, AIX LPAR, Oracle VM, Virtualbox, Dockers
Consultation, Coaching, Workshops & Schulung
Unified Auditing

Oracle Versionen, Features and Options

ORACLE Versionen bis Enterprise Edition (EE) 11R2g – 18c / 19c
RAC, Data Guard & HA ASM (inkl. Flex ASM)
Data Warehouse 11R2g – 18c / 19c
Oracle Advanced Analytics 11.2 – 18c / 19c
Partitioning (DWH, OLTP) inkl. Partition Advisor
10g – 12.2 / 18c / 19c Migrationen (inkl. OS RMAN Endian Convert and Infrastructurewechsel), XTTS, Transportable Tablespaces
Parallel Query, DML and DDL
Data Vault 1.0 / 2.0 Modelling
Development, Planning, Tuning im Environment VLDB
Oracle In Memory Option 12.2
Oracle's Machine Learning 12.2
Advanced Analytics 12.2
Data Mining with ODM 4.2
Optimizer and Plan Stabilisierung: CBO + Statistics (DBMS_STATS) bis 12.2 inkl. Tuning Advisor
PL/SQL Debugging (inkl. JDWP Java), PL/SQL Profiling
Oracle Advanced Compression bis 18c inkl. Advanced Compression Advisor
Basic, Advanced, Warehouse & Archive Compression
LOB Securefile compression and deduplicate
Datapump Compression
Advanced Network Compression
HCC (Hybrid Column Compression Exadata, ZFS)
Oracle ILM
Golthe Gate, Oracle Standby (inkl. Logical Standby and Active Dataguard) bis 12.2
Streams,XStream, Change Data Capture (CDC), Replication, Materialized Views (MV), Golthe Gate, Distributed Transaction
Advanced Queuing (AQ) bis 12.1
Logminer bis 12.2
Oracle Text inkl. UDS (User DataStore), Textmining and Sentiment Analysis bis 18c
Oracle Multimedia
Oracle Spatial and Graph (inkl. Oracle Property Graph 12.2, Sesame, Jena), RDF Resource Description Framework / OWL
APEX bis 5.1 & PL/SQL Gateway: htp / htf / owa
Oracle XML / XDB 12.2
Oracle REST API, Webservices, utl_http, utl_smtp, utl_tcp
Oracle Workspacemanager (WM) bis 11.2
Oracle Rules Manager and Expression Filter bis 11.2
Oracle DBV (Database Vault) and TDE (Transparent Data Encryption)
Oracle Security: Wallet, Secure PKI, Kerberos, LDAP, Roles & Grants, Proxy …
Oracle sqlldr direct, conventional, external tables, convert, Tuning, Parallel, EBCDIC Dateien with > 1 Milliarde Zeilen
Virtual Privat Database (VPD) / Fine Grain Auditing (FGA)

Trainings

Oracle Dataguard 11g
Oracle Golthe Gate 11g
ITIL: Incident, Problem and Change Management ITIL v2
HP Service Center: Incident , Problem , Change Management

AIX 7.1 Schulung

Certifications

IKM Oracle 11g PL/SQL PROGRAMMING (Score 89%)
ORACLE 9i / 10g Database Administrator Certified Professional OCP
ORACLE 9i PL/SQL Developer Certified Associate OCA
Foundation Certificate IT Service Management ITIL v2

Dataschutz Certificates (Bankensektor)

Industry Knowledge

Medien strong experience
- Content Managementsysteme (CMS) “
- ProduktData Management (PDM) “
Handel “
Automotive (Automotive) “
- After Sales Systeme: Gewährleistung, Werkstattsysteme, Regressionssysteme “
- Dealer Management Systeme (DMS) “
- CAD and CAE “
Öffentlicher Dienst “
Finanzdienstleistung “
- Liwith & Risk Management
- Excess Reporting
- Meldewesen (CRR, ESZB Geldmarktstatistik)
Softwaredevelopment “

Telecommunication (TK) medium
Transport / Logistics “
Consulting “

Hosting Service Provider “

Post “
Heavy industry „

Versicherung „

Skills
Databases

ORACLE Versionen: 10g , 11gR2, 12.1, 12.2, 18c, 19c strong experience
Installation / Migration / Administration “
Tuning: SQL, PL/SQL, Segment, Server,OS, Hardware and Storage “
Platform Migration with XTTS, Dataguard, RMAN Convert “

Migrationen: MySQL to ORACLE “
Migrationen: ACCESS , CLIPPER , UDS (BS 2000) , INFORMIX to ORACLE medium

Business Intelligence (BI)

Oracle Data Miner ODM 11.2 – 12.2 strong experience
Oracle BI 12.2 “
Oracle Text Mining “

Weka 3: Data Mining “

Reporting

Jasper JasperReports Server medium

Oracle BI Publisher basic

Programmierlanguages

SQL / PL/SQL Versionen: 10g, 11gR2, 12.1, 12.2,18c strong experience

KORN / BOURNE / BASH - SHELL “

XML / XSD / XSL(-FO) / SVG high experience
JSON REST “
XPath 2.0 / XLST 2.0 / XSL-FO 1.1 “
HTML (Versionen: 3.2 bis 5.0) “

JAVASCRIPT “
PYTHON

AWK / SED medium

CSS “

JAVA “

C / C++ “
PERL “

Standard software

IBM ACM 5.3 (Algo Credit Manager) bzw. ACL (Algo Credit Limitmanager) high experience

Developments- & Modelingstools

QUEST TOAD 7.6 – 12.12 strong experience
ORACLE SQL Developer 4.1 - 17.4 “
ORACLE DESIGNER 2000 1.2 – 10g “
Oracle Data Modeler 4.1 – 17.4 “

ORACLE APEX 4.2 – 5.1 “

utPLSQL (Unit Testing framework for Oracle PL/SQL) high experience
DbUnit/Junit “

Reporting Jasper Reports medium
Eclipse 3.2 + Oxygene XML / XSD Plugin “

UML “
Jenkins / Maven “

DB Administration / Monitoring / APM

ORACLE Cloud Control / ENTERPRISE MANAGER / GRID CONTROL / DB Console 11gR2 – 13.3 high experience
VERITAS PRECISE INDEPTH (ORACLE) 3.2 medium
VERITAS I3 (ORACLE) 7.1 “
QUEST Spotlight / Foglight (ORACLE) 5.5 “
Cisco APPDYNAMICS 4.3 “
HP ALM (Qualitycenter) 11.52 “

Operationsssysteme (OS)

HP HP–UX 10.20 – 11.11 (Itanium / PA Risc) 32 / 64 Bit medium
MICROSOFT WINDOWS Windows 10, Server 2003, 2010 “
SUN SOLARIS 10, 11 Sparc / X86 32 / 64 Bit “
LINUX SuSE ES 7, 8 , 9 “
RED HAT 9 , AS 3 “

IBM AIX 4.3.2 – 5.2 (HACMP) 32 / 64 Bit “

Konfigurations-, Versionierungs- and ITIL-Tools

HP Servicecenter 2.x high experience
IBM 5.0.2 Rational Team Concert “
SVN “
GIT “

Virtualization

Dockers 17.0.x medium
VMWare 3.1.3 “
Virtualbox 4.x “
Oracle VM 3.4 “
Solaris Zone, LDOM, Root Domain “
AIX LPAR “

Office
Microsoft: WORD, EXCEL, POWERPOINT, ACCESS, PROJECTS high experience
Database architecture
Data Warehouse (DWH VLDB) / OLAP / Big Data

Professional concepts Datawarehouse-Systems
Definition of Systemarchitecture (SMP / MPP / CLUSTER / RAC / GRID)
Planning des Amountsgerüsts & Storage Planning (SAN, NAS, ASM)
Planning Rollout
ETL Tools: SQL*LOADER, UTL_FILE,REPLICATION, MV, AQ, STREAMS, CDC)

and Extraction Transformation Loading (ETL)

Data Consolidation and cleasing – Source Systems: BS2000 / Z/OS and ORACLE OLTP System
Job Control (SHELLSCRIPT , PL/SQL, dbms_jobs and dbms_schedule )
Administration and Tuning ORACLE 11gR2, 12.2, 18c
Datamodeling (STAR / SNOWFLAKE), Data Vault 1.0, 2.0
Create and Tunen komplexer SQL
- Aggregation, Analysis and Reporting Funktionalität
- SQL Model Funktionalität
Oracle Data Miner ODM Application inkl. 12.2
Oracle Advanced Analytics 11.2 – 18c

OLTP

Definition der Systemarchitecture
Extraction Transformation Loading (ETL)
Fachliche and technische Abstimmung der Schnittstellen zu the Quellsystemen
Dataconsolidation and Bereinigung der Quellsystemen (BS2000 / Z/OS)
Job Control (SHELLSCRIPT / PL/SQL )
Databankadministration and –tuning ORACLE 11gR2, 12.2, 18c
Datamodeling 3.NF, Data Vault (DWH Hybrid Systeme), EAV Modelle
Design / Redesign and Tuning very large OLTP Applications
- > 4000 CONCURRENT USER and > 4,4 TB Data
- > 8000 CONCURRENT USER

Databank HA Solutions:

Planning and Construction grosser HA Solutions (OLTP and DWH)
RAC / Dataguard
Sun / HP UX MC Service Guard Failover Cluster
Backup Strategies and Tuning of RMAN
Replikationen with Advanced Replication, Stream, CDC and Golthe Gate
Desaster Recovery Concepte

Covered by Exali's professional indemnity insurance

The freelancer is covered by a reliable insurance provider that offers protection against common risks associated with digital and IT professions (damage claims, third-party cyber damage, etc.).

Covered from 01.06.2015 until 01.06.2025

Check the freelancer's Exali insurance profile (insured activities, scope, etc.) »