Keywords
Skills
Current skills: ORACLE software development and support
Oracle Security: PKI, TDE, Database Vault, SSL, Unified Auditing, Oracle Enterprise User Security
Incident, Problem Change & Capacitymanagement (ITIL)
- 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)
- 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 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
Kurzzeitprojekte: jederzeit
Other
Oracle core competence
Trainings
Skills
Databases
Microsoft: WORD, EXCEL, POWERPOINT, ACCESS, PROJECTS high experience
Database architecture
Data Warehouse (DWH VLDB) / OLAP / Big Data
- 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 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
- 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)
- 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
- Oracle Data Miner ODM 11.2 – 12.2 strong experience
- Oracle BI 12.2 “
- Oracle Text Mining “
- Weka 3: Data Mining “
- Jasper JasperReports Server medium
- Oracle BI Publisher basic
- 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 “
- IBM ACM 5.3 (Algo Credit Manager) bzw. ACL (Algo Credit Limitmanager) high experience
- 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 “
- 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 “
- 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 “
- HP Servicecenter 2.x high experience
- IBM 5.0.2 Rational Team Concert “
- SVN “
- GIT “
- Dockers 17.0.x medium
- VMWare 3.1.3 “
- Virtualbox 4.x “
- Oracle VM 3.4 “
- Solaris Zone, LDOM, Root Domain “
- AIX LPAR “
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)
- 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
- 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
- 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.2024
Check the freelancer's Exali insurance profile (insured activities, scope, etc.) »