Profileimage by Axel Tenkhoff Oracle Datenbank Experte für Administration (RAC, DG), Tuning, PL/SQL und APEX Entwicklung from BadSalzuflen

Axel Tenkhoff

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)

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

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.).

Profileimage by Axel Tenkhoff Oracle Datenbank Experte für Administration (RAC, DG), Tuning, PL/SQL und APEX Entwicklung from BadSalzuflen Oracle database experte: administration (incl. RAC, DG), Tuning, PL/SQL and APEX development
Register