Christopher Eshemokhai-Senior Oracle DBA and WebLogic Administrator, Oracle Business Intelligence for Applications
Experience
Senior Oracle DBA and WebLogic Administrator, Oracle Business Intelligence for Applications
- Oracle databases 11g, 12c and 19c RAC
- Installation, configuration and deployment of Oracle Fusion Middleware 11g & 12c (WebLogic, SOA, Oracle Forms and Report Server, etc., OBIA)
- Administration of Oracle 11g, 12c, RAC and 19c
- Applying patches
- Installation, configuration and deployment of Tomcat
- Oracle tuning
- The system includes several production, QA, test & development Oracle databases and WebLogic application servers 11g & 12c
Senior Oracle DBA, WebLogic Administrator, Oracle Business Intelligence for Applications
Informationstechnikzentrum Bund (ITZ Bund)
- IT-supported customs clearance. The Automated Tariff and Local Customs Processing System (ATLAS); electronic customs tariff, specialist procedures ZGR-online, ZEUS, Debbi, etc.
- Oracle databases 11g, 12c and 19c
- Oracle Fusion Middleware 11g, 12c and OBIA
- The system includes multiple production, QA, test & development Oracle databases and WebLogic application servers 11g & 12c
- Design, installation, configuration and updates
- Installation, configuration and deployment of Oracle Fusion Middleware 11g & 12c (WebLogic, SOA, Oracle Forms and Report Server, etc.), Oracle Business Intelligence for Applications
- Administration of Oracle 11g, 12c, RAC and 19c
- Applying patches
- Installation, configuration and deployment of Tomcat
- Daily monitoring tasks
- Database systems, Oracle Application Server Unix shell scripts. Monitoring of web servers
- Monitoring of Oracle jobs (e.g., job failures, etc., with Grid Control 11g, Cloud Control 12c)
- Monitoring server availability with Nagios
- Monitoring alert_log (ORA errors) with shell scripts
- Processing trace files
- Tuning, troubleshooting and optimization
- Conducting problem analysis
- Error resolution
- Changing Oracle and WebLogic internal parameters
Senior Oracle DBA
Amedes GmbH
- Training staff on Oracle 11gR2
- Installation and configuration of Oracle 11gR2
- Workshops and templates for separating application and database servers
- Backup using Networker. Testing and cross-recovery cloning and duplication with RMAN
- Tuning and optimization of the data warehouse
- Creating standby databases and Data Guard for Oracle 11gR2
Senior Oracle DBA
RWE IT GmbH
- Setup, migration, administration and tuning of Oracle 11gR2 RAC and Data Guard 11gR2 on Unix environments (Solaris 11 and Linux Red Hat) and ASM
- Supporting all areas of RWE IT's integrated business model as an internal IT service provider
- Provisioning, development and operation of standard and specialized software as well as hardware and network infrastructure
- The system includes several production, QA, test & development Oracle databases with applications
- Data warehouse over 20 TB
- SAP systems
- Exadata database machine X4-2
- Oracle Fusion Middleware
- Design, installation, configuration and updates
- Installation and configuration of Oracle 11gR2 Real Application Cluster with multiple nodes and databases
- Administration of heterogeneous environments (Solaris, Exadata and Linux Red Hat)
- Applying 11gR2 patches
- Installation and configuration of 11gR2 Data Guard
- Installation, configuration and deployment of Oracle Fusion Middleware 11g (WebLogic, SOA, Oracle Forms and Report Server, etc.)
- Daily monitoring tasks
- Monitoring of Oracle jobs (e.g., job failures, etc., with Oracle Enterprise Manager 11g Grid Control and Enterprise Manager 12c)
- Monitoring of servers with Nagios
- Monitoring alert_log (ORA errors) with shell scripts
- Handling trace files
- Managing tickets with HP OpenView Service Center
- Tuning, troubleshooting and optimization
- Conducting problem analysis
- Error resolution
- Changing Oracle internal parameters
- Backup and recovery
- Online backup with RMAN via TSM (Tivoli)
- Restoring databases (datafile, tablespaces, point-in-time recovery, etc.)
- Migration from Oracle 10g to 11gR2 on Linux environment and Solaris 5.10
Senior Oracle DBA
Kuehne & Nagel
- Setup, migration, administration and tuning of Oracle 11gR2 RAC and Data Guard 11gR2 in Oracle VM Linux 6.2 on ASM and SAN NetApp in three environments: Hamburg, Hong Kong and New York
- The system includes multiple production, QA, test & development Oracle databases with applications for seafreight, airfreight, contract logistics, customer solutions, road & rail logistics, insurance brokers, lead logistics, real estate and SAP systems
- Design, installation, configuration and updates
- Installation and configuration of Oracle 11gR2 Real Application Cluster and database administration
- Applying 11gR2 patches
- Installation and configuration of 11gR2 Data Guard
- Daily monitoring tasks
- Monitoring of Oracle jobs (e.g., job failures, etc., with Oracle Enterprise Manager 11g Grid Control and Enterprise Manager 12c)
- Monitoring of servers with Nagios
- Monitoring alert_log (ORA errors) with shell scripts
- Handling trace files
- Tuning, troubleshooting and optimization
- Conducting problem analysis
- Error resolution
- Changing Oracle internal parameters
- Backup and recovery
- Online backup with RMAN via TSM (Tivoli)
- Restoring databases (datafile, tablespaces, point-in-time recovery, etc.)
- Migration from Oracle 10g to 11gR2 on Linux environments on NetApp OVM Linux 6.2
Senior Oracle DBA
Talanx AG
- Administration and tuning of Oracle 10g RAC and 11g RAC and Informix 9/10 on Linux OS SLE10 servers
- The system includes multiple production, QA, test and development Oracle databases with applications such as a terabyte data warehouse, insurance entry systems, SAP systems, customer relationship management (Siebel), IBM WebSphere 6.1, as well as several internet and intranet applications
- Design, installation, configuration and updates
- Installation and configuration of Oracle 10g and 11g Real Application Cluster on Veritas Cluster 5.0, and database administration
- Applying 11g patches
- IBM WebSphere 6.1 as middle tier
- Administration of Informix 9/10 database
- Daily monitoring tasks
- Monitoring Oracle jobs (e.g. job failures etc. with Oracle Enterprise Manager Grid Control 10g, 11g, Nagios and Spotlight)
- Monitoring server availability with Tivoli
- Monitoring alert_log (ORA errors) with shell scripts
- Handling trace files
- Tuning, troubleshooting and optimization
- Performing problem analysis
- Troubleshooting
- Changing Oracle internal parameters
- Backup and recovery
- Online backup with RMAN
- Networker
- Restoring databases (datafiles, tablespaces, point-in-time recovery etc.)
- Migration from Oracle 10g to 11g in a Linux environment on Veritas Cluster 5.0
Senior Oracle DBA
Baxter (Deutschland) GmbH
- Warehouse management systems and automation technology
- Oracle Application Server and database
- Infrastructure qualification in a validated environment
- Building Oracle 10g, 11gR2 Real Application Cluster
- The system includes multiple production, QA, test and development Oracle databases with applications for warehouse management, Oracle Application Server and IBM WebSphere 6.1
- Design, installation, configuration and updates
- Installation and configuration of Oracle 11gR2 Real Application Cluster, and database administration
- IBM WebSphere 6.1 as middle tier and Oracle Application Server 10g as middleware
- Installation, configuration and administration of Oracle Application Server 10g
- Applying 11g patches
- Installation and configuration of 11gR2 Data Guard
- Daily monitoring tasks
- Database systems and Oracle Application Server Unix shell scripting. Monitoring web servers
- Monitoring Oracle jobs (e.g. job failures etc. with Oracle Enterprise Manager 10g, Grid Control)
- Monitoring server availability with Nagios
- Monitoring alert_log (ORA errors) with shell scripts
- Handling trace files
- Designing warehouse management infrastructure
- Collaborating with WebSphere integration, design team, managing integration with ERP
- Executing qualification tests
- Installing RF radio frequency
- Creating documentation
- Installation and configuration of Voice Console Server (Vocollect)
Senior Oracle DBA
Kuehne & Nagel
- Building RAC 11gR1 Real Application Cluster and Data Guard in three environments Hamburg, Hong Kong and New York with database on ASM in SAN
- Tuning Oracle 10g, IBM WebSphere Application Server, Business Objects on Unix Linux 64bit Red Hat
- The system includes multiple production, QA, test and development Oracle databases with applications for sea freight, air freight, contract logistics, customer solutions, road and rail logistics, insurance brokers, lead logistics, real estate and SAP systems
- Design, installation, configuration and updates
- Installation and configuration of Oracle 11gR1 Real Application Cluster and database administration
- Applying 11g patches
- Installation and configuration of 11gR1 Data Guard
- Daily monitoring tasks
- Monitoring Oracle jobs (e.g. job failures etc. with Oracle Enterprise Manager 10g, Grid Control)
- Monitoring server availability with Nagios
- Monitoring alert_log (ORA errors) with shell scripts
- Handling trace files
- Tuning, troubleshooting and optimization
- Performing problem analysis
- Troubleshooting
- Changing Oracle internal parameters
- Backup and recovery
- Online backup with RMAN via TSM (Tivoli)
- Restoring databases (datafiles, tablespaces, point-in-time recovery etc.)
Oracle DBA
Civitec
- Backup with RMAN via Networker, test and cross recovery with RMAN
- Installation and configuration of SAP BRTOOLS and the related Networker module and backup with SAP BRTOOL
- Recovery, cloning and duplication with RMAN
- Installing Oracle patches, migration and upgrade from 10g
Tuning and optimization of Oracle 10g
Rieker Schuh AG
Senior Oracle & Apps DBA
Netma NATO
- Administration and tuning of Oracle 8i, 9i, 10g, and 11g Oracle Applications 11 (11.5.10.2), EBS R12, and Oracle Application Server 10g in various Oracle projects on Unix environments (IBM AIX 5.3 HACMP cluster and Linux Enterprise 9) on SAN
- The system includes production, QA, test, and development Oracle databases with Oracle Applications 11.5.10.2, custom applications, message handlers, Oracle 9i Dataguard, Oracle Applications (Oracle Financials, FA, HR, AP, GL, AR, OM modules), and Oracle Application Server 10g
- Design, installation, configuration, and update
- Installation and configuration of Oracle 8i and 9i databases, Oracle 10g Real Application Cluster and 11g, database creation (cloning), and database administration on Linux and AIX 5.3
- Installation, configuration, and administration of Oracle Applications 11.5.10.2 on Linux ES9
- Installation and configuration of Oracle Application Server 10g on Linux ES9 and AIX 5.3
- Installation and configuration of BEA WebLogic 10g
- Cloning of databases and Oracle Applications
- Implementation, upgrade, and support of Oracle Applications modules (Oracle Financials, FA, HR, AP, GL, AR, OM, INV) and Apache Web Server as middle tier
- Oracle Application Unix processes (Concurrent Manager, Workflow Manager, etc.)
- Applying patches for 8i, 9i, 10g, and Oracle Applications family patches
- Installation and configuration of Oracle Internet Directory with LDAP
- Daily monitoring tasks
- Database systems, Oracle Applications 11i with Unix shell scripting
- Monitoring Oracle jobs (e.g. job failures) with Oracle Enterprise Manager 2.2 and Spotlight, Statspack, AWR
- Monitoring server availability with Tivoli
- Monitoring alert log (ORA errors) with shell scripts
- Handling trace files
- Tuning, troubleshooting, and optimization
- Conducting problem analysis
- Modifying Oracle internal parameters
- Indexing tables
- Migration
- Migration from Oracle 9i to 10g in a Linux environment
- Migration from 9i to 11g in an AIX environment
- Backup and recovery
- Regular schema exports and full exports with crontab
- Online and offline backups with RMAN and Tivoli Storage Manager
- Database recovery
- Restoration of databases (datafiles, tablespaces, etc.)
Implementation of Oracle 10g RAC
Langenscheidt
- Installation and configuration of Oracle 10g RAC on Linux SLES10
Senior Oracle DBA
Allianz AG
- Administration and tuning of Oracle 10g RAC and 9i on Unix/Linux 64-bit, Sun Solaris (8, 9, 10 on multiple SunFire 15K and 10E), Veritas Cluster 4.0, AIX 5L 5.3 HACMP, and Windows 2003 across multiple nodes, including Oracle ASM storage
- System administration of distributed database systems and replication
- The system includes multiple production, QA, test, and development Oracle databases with applications like multi-terabyte data warehouses, insurance processing systems, SAP systems, customer relationship management (Siebel), banking applications, Oracle 10g Dataguard, IBM WebSphere, BEA WebLogic, and various internet and intranet applications
- Oracle deployment and packaging
- Design, installation, configuration, and update
- Installation and configuration of Oracle 9i and 10g Real Application Cluster, Oracle 10g on Veritas Cluster 4.0, database creation (cloning), and database administration
- Cloning of databases
- Apache Web Server and WebSphere as middle tier
- Applying patches for 9i, 10g, and Oracle Applications
- Installation and configuration of Oracle 9i and 10g Dataguard
- Installation and configuration of Oracle Application Server 10g
- Installation and configuration of BEA WebLogic and WebLogic Portal
- Daily monitoring tasks
- Database systems, Oracle Application Server with Unix shell scripting; monitoring web servers
- Monitoring Oracle jobs (e.g. job failures) with Oracle Enterprise Manager 2.2, Grid Control, Spotlight, and Tivoli Statspack
- Monitoring server availability with Tivoli
- Monitoring alert log (ORA errors) with shell scripts
- Handling trace files
- Tuning, troubleshooting, and optimization
- Conducting problem analysis
- Error resolution
- Modifying Oracle internal parameters
- Indexing tables
- Backup and recovery
- Online backups with RMAN
- Veritas NetBackup
- Database restoration (datafiles, tablespaces, point-in-time recovery, etc.)
Tuning and optimization of Oracle 10G
Implementation of Oracle 9i RAC
Bundesamt für den Zivildienst
- Installation and configuration of Oracle 9i RAC on Linux 64-bit
Tuning and optimization of Oracle 9i
BayernInvest
Senior Oracle & Sybase DBA
GFK AG
- Administration and tuning of Oracle 10g in a Unix environment Linux 64bit and administration of Sybase ASE 12.5 & 15.0 (Solaris 10 on multiple SunFire 15K, 10K)
- Sun HA Cluster 3, Oracle 10 RAC on multiple nodes and Oracle ASM storage system
- Administration of distributed database systems and replication
- The system includes multiple Oracle databases with applications for market research, an 800G data warehouse, and SAP systems
- Design, installation, configuration, and upgrades
- Installation and configuration of Oracle 10g Real Application Cluster databases on ASM storage system, database creation (cloning), and database administration
- Installation of Sybase ASE 15.0
- Installation and administration of EM Grid Control
- Applying patches for Oracle 10g
- Daily monitoring tasks
- Database systems and Oracle Application Server Unix shell scripting
- Monitoring Oracle jobs (e.g., job failures etc.) with Oracle Enterprise Manager 10.2.0.3, Grid Control
- Monitoring server availability with Grid
- Monitoring alert log (ORA errors) with shell scripts
- Handling trace files
- Monitoring Sybase servers with shell scripts
- Tuning, troubleshooting, and optimization
- Performing problem analysis
- Modifying Oracle internal parameters
- Indexing tables
- Backup and recovery
- Online backup with RMAN
- Legato NetBackup
- Recovery of databases
- Restoring databases (datafile, tablespaces, point-in-time recovery, etc.)
- Importing dumps into Sybase
Senior Oracle DBA
T-Systems RZ
- Administration and tuning of Oracle 8i, 9i, 10g and Oracle Application Server 9i and 10g SOA 10.1.3 in a Unix environment (Solaris 8, Solaris 10 on multiple SunFire 15K, 10K, Veritas HA Cluster 4.0, Veritas Volume Manager)
- Administration of distributed database systems and replication for the Toll Collect toll project
- The system includes multiple Oracle databases with applications for online bookings, satellite capture systems, BWS (SAP HUB Adapters), a data warehouse with Cognos Process, CRM Siebel, Oracle Advanced Queue, Oracle 9i Data Guard, Oracle OPS and 9i and 10g RAC, IAS 10g, SOA 10.1.3, J2EE and OC4J applications, as well as BEA WebLogic
- Deployment and packaging of Oracle
- Design, installation, configuration, and updates
- Installation and configuration of Oracle 8i OPS databases, failover and 9i, Oracle 9i and 10g Real Application Clusters, Oracle 10g, database creation (cloning) and database administration
- Oracle 8i and 9i on Sun systems with Solaris 2.8, 2.10
- Database cloning
- Oracle Application Server 10g, SOA 10.1.3, J2EE, OC4J, Ants
- Deployment of OC4J, Apache Tomcat 5
- Apache Web Server as middle tier
- Applying patches to 8i, 9i, 10g Oracle Applications
- Installation and configuration of Oracle 9i, 10g Data Guard
- Installation and configuration of Oracle Application Server 10g
- Daily monitoring tasks
- Database systems and Unix shell scripting for Oracle Application Server
- Monitoring Oracle jobs (e.g., job failures etc.) with Oracle Enterprise Manager 2.2, Grid Control and Spotlight, TeamQuest, SiteScope, Statspack
- Troubleshooting errors
- Monitoring server availability with Tivoli
- Monitoring alert log (ORA errors) with shell scripts
- Handling trace files
- Monitoring, starting, and stopping Oracle AQ and SAP adapters
- Tuning, troubleshooting, and optimization
- Performing problem analysis
- Modifying Oracle internal parameters
- Indexing tables
- Tuning Oracle Application Server (Apache, OC4J)
- Backup and recovery
- Online backup with RMAN
- Veritas NetBackup
- Recovery of databases
- Restoring databases (datafile, tablespaces, point-in-time recovery, etc.)
- Migration from Oracle 8i to 10g in a Sun Solaris environment
Oracle DBA and reporting
Automotive Industry Supplier
- Oracle consulting, administration, and tuning of Oracle 9i
- Generating reports using Oracle Reports (Developer 6i)
- Data consolidation using Oracle Discoverer
- Environment: Designer/2000, Developer/2000, OracleiDS9i, Oracle 9i, PL/SQL, PowerBuilder, Sun Solaris 8.0
Oracle DBA
TUI InfoTec
- Administration and tuning of Oracle 8i, 9i, and Oracle Applications 11i in various Oracle projects in a Unix environment (Solaris 8 on SunFire 15K with 13 domains)
- Veritas HA Cluster 3
- The system includes Oracle databases with Oracle Applications 11.5.7 and 11.5.8, a data warehouse with Cognos Process, customer relationship management (Siebel), MQ Series, BEA WebLogic, Oracle 9i Data Guard, Oracle 9i RAC, a yield management system, and Oracle Applications (Oracle Financials, FA, AP, GL, AR, OM modules)
- Design, installation, configuration, and upgrades
- Installation and configuration of Oracle 8i and 9i databases, Oracle 9i Real Application Cluster, database creation (cloning), and database administration
- Installation, configuration, and administration of Oracle Applications 11.5.7 and 11.5.8
- Oracle 8i and 9i on Sun systems with Solaris 2.8
- Cloning databases and Oracle Applications
- Implementation, upgrade, and support of Oracle Applications modules (Oracle Financials, FA, AP, GL, AR, OM, INV) and Oracle iProcurement
- Apache Web Server as middle tier
- Oracle Application Unix processes (Concurrent Manager, Workflow Manager, etc.)
- Applying patches to 8i, 9i, Oracle Applications
- Installation and configuration of Oracle 9i Data Guard
- Installation and configuration of Oracle Internet Directory with LDAP
- Daily monitoring tasks
- Database systems and Oracle Applications 11i with Unix shell scripts
- Monitoring Oracle jobs (e.g., job failures etc.) with Oracle Enterprise Manager 2.2 and Spotlight, Statspack
- Monitoring server availability with Tivoli
- Monitoring alert log (ORA errors) with shell scripts
- Handling trace files
- Monitoring, starting, and stopping MQ Series, BEA WebLogic
- Tuning, troubleshooting, and optimization
- Performing problem analysis
- Modifying Oracle internal parameters
- Indexing tables
- Backup and recovery
- Regular schema exports and full exports with cron
- Online and offline backup with RMAN
- BCV backups with TimeFinder, Veritas NetBackup, Tivoli Data Protection
- Recovery of databases
- Restoring databases (datafile, tablespaces, etc.)
Oracle DBA
T-Systems
- Administration and tuning of Oracle 7.3.4, 8.0.5, 8i, 9i in Unix environments (Sinix, NEC, HP-UX, Solaris 2.6, 2.7), Sun HA Cluster 2.2, 3.0, and on Windows NT
- Administration of distributed database systems and replication for Deutsche Post AG
- The system includes Oracle databases spread across 600 servers in different locations in Germany and some other European countries
- Administration of Oracle with applications such as PC Franking (Stampit), PC Premium Letter, mail center, terabyte data warehouse with Informatica Process and PowerMart
- Installation, administration, configuration and updates
- Installation and configuration of Sun HA Cluster OS versions 2.2 and 3.0
- Oracle 8i and Oracle 9i on Sun systems running Solaris 7 and Solaris 8
- Installation and configuration of Oracle 8i standby database
- Oracle 8.0.5 on Windows NT 4
- Oracle 7.3.4 on Sinix RM400, RM600, Primenergy and NEC machines
- Upgrade from Oracle 7.3.3 to 7.3.4 and 8i
- Applying patches 7.3.4.4, 8.7.3.2
- Daily monitoring tasks
- Co-responsible for a replication environment (mail center) with 80 databases spread across Germany
- Monitoring multiple Sun HA clusters, HP clusters and Sinix systems
- Monitoring delayed and distributed database systems with Unix shell scripts (Oracle replication)
- Monitoring Oracle jobs (user_jobs, e.g., job failures, etc.)
- Monitoring server availability with the ITO tool
- Monitoring alert logs with the Patrol tool
- Monitoring error messages (ORA errors) with BMC Patrol
- Handling trace files
- Migration
- Migration from Oracle 7 & 8 to Oracle 8i and 9i
- Porting Oracle 8 from Windows NT to Sinix RM400 Unix environment
- Tuning and optimization
- Performing problem analysis
- Changing Oracle internal parameters
- Backup and recovery
- Regular exports of schemas and full exports
- Backing up with Networker
- Recovering databases to a specific point in time
- Recovering a schema to a specific point in time.
Oracle DBA
Hamburgischen Elektrizitätswerken
- Support for Oracle DBA tasks in various Oracle projects in a Unix environment (Solaris 6, 7, 8), SAN, Sun HA Cluster 2.2, and on Windows NT
- The system includes Oracle databases with a data warehouse using Informatica Process and PowerMart, a billing system (Geneva), customer relationship management (Siebel), PeopleSoft, Hansenet ISP, Oracle Applications (Oracle Financials, OM, INV, AR, AP), distributed across 30 servers with more than 100 instances
- Installation, configuration and updates
- Installation, configuration and database creation of Oracle 8i (8.1.6 Release 2 and 3) on Windows NT
- Oracle 8i on Sun systems with Solaris 2.6, 7, 8
- Oracle 8.0.5 on Windows NT 4
- Upgrade from Oracle 7.3.4 to 8i
- Applying patches for 8i
- SAP/Oracle interface
- Implementation, database creation (8.1.7) of billing applications (Geneva) for Hansenet
- Daily monitoring tasks
- Database systems with Unix shell scripts
- Monitoring Oracle jobs (e.g., job failures) with Oracle Enterprise Manager 2.2
- Monitoring server availability with OEM
- Monitoring alert logs (ORA errors) with OEM
- Handling trace files
- Migration
- Migration from Oracle 7 & 8i to Oracle 8i (data warehouse, PeopleSoft, Siebel, Geneva, etc.)
- Porting Oracle 8 from Windows NT to Solaris Unix environment
- Tuning, troubleshooting and optimization
- Performing problem analysis
- Changing Oracle internal parameters
- Backup and recovery
- Regular exports of schemas and full exports
- Online and offline backups with RMAN and IBM ADSM (Tivoli)
- Database recovery
- Restoring databases (datafiles, tablespaces, etc.)
Oracle DBA
Deutsche Post AG
- Administration and tuning of Oracle 7.3.4, 8.0.5, 8i in Unix environments (Sinix, NEC, HP-UX, Solaris 2.6) and on Windows NT
- Administration of distributed database systems and replication
- The system includes Oracle databases spread across 600 servers in different locations in Germany and some other European countries. Responsible for 160 of these servers in a team of 4 Oracle DBAs
- Installation, configuration and updates
- Installation and configuration of the operating system on HP-UX
- Setting up volumes and mirroring disks on Sinix
- Installation, configuration and database creation of Oracle 8i (8.1.6 Release 2) on HP-UX machines
- Oracle 8i on a Sun system running Solaris 7
- Oracle 8.0.5 on Windows NT 4
- Oracle 7.3.4 on Sinix R400, R600 and NEC machines
- Upgrade from Oracle 7.3.3 to 7.3.4
- Applying patches 7.3.4.4
- SAP/Oracle interface
- Daily monitoring tasks
- Co-responsible for a replication environment (fleet management) with 80 databases spread across Germany as well as in Warsaw and Linz
- Monitoring delayed and distributed database systems with Unix shell scripts
- Monitoring Oracle jobs (user_jobs, e.g., job failures, etc.)
- Monitoring server availability with the ITO tool
- Monitoring alert logs with the Patrol tool
- Monitoring error messages (ORA errors) with BMC Patrol
- Handling trace files
- Migration
- Migration from Oracle 7 & 8 to Oracle 8i
- Porting Oracle 8 from Windows NT to Sinix R400 Unix environment
- Tuning and optimization
- Performing problem analysis
- Changing Oracle internal parameters
- Backup and recovery
- Regular exports of schemas and full exports
- Backups with Networker
- Recovering databases to a specific point in time
- Recovering a schema to a specific point in time.
Informix Database/Oracle DBA
FJA Feilmeyer & Junker AG
- Supporting implementation tasks in the admin and inventory system in the BHW VWS2 project on an Informix Database Server 7.3 running on Sinix
- Client companies: BHW Lebensversicherung AG and BHW Bausparkasse AG
- Development of ESQL, PL/SQL, SQL scripts and UNIX shell scripts
- Fixing errors caused by migration
- Creating new applications - interfaces - performance statistics
- Conducting system analysis
Oracle DBA
Bremer Entsorgungsbetriebe
- Administration and tuning of Oracle 7.3.4
Reports and Data Consolidation
Kraft-Jacobs-Suchard
- Generating reports with Oracle Report
- Consolidating data using Oracle Discoverer
- Participated in Y2K Year 2000 testing
- Created interface documentation in the Oracle Data Warehouse
- Created and edited SPL using Oracle 7 on RS6000 in conjunction with Oracle Express Server 6.2
- Monthly reports for the Kraft-Jacobs-Suchard group
- Outputting reports in HTML format
- Writing PL/SQL and SQL scripts
Internet Development
- Developed an internet search engine with an MSQL database connection in a Unix environment
- Programmed the search engine, created the MSQL database, and designed input, delete, and update forms using HTML, CGI, and Perl
Client/Server Application
- Online transaction processing to support the inventory management and order system
- Supported the processing of approximately 10,000 orders, 3,800 customers, 7,700 addresses, 10,000 items, and 10,000 quotes per year
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained staff
- Implemented on Windows 3.1 using MS Visual Basic 5.0 as the frontend and MS SQL Server 6.5 on Windows NT 4.0
Helpdesk Application
Bremer Entsorgungsbetriebe
- Application to support the internal helpdesk system at Bremer Entsorgungsbetriebe
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained staff
- Implemented on Windows 3.1 using MS Access 2.0
Client/Server Application
- IT application to support customer consulting on property drainage issues in the state of Bremen
- Supported management of customer master data, property master data, technical detail information, and consulting processes
- Mail merge functions and protocol printout
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained staff
- Installed and configured Oracle 7.3.4
- Implemented on Windows 3.1 using MS Access 2.0 as the frontend and Oracle 7.3.4 as the database server on Windows NT 4.0
Client/Server Application
Bremer Entsorgungsbetriebe
- IT application for time sheet entry for wage earners and employees
- Set up Bremer Entsorgungsbetriebe's in-house payroll system (SAP software)
- Concurrent access by over 40 time sheet clerks
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed and configured Oracle 7.3.4
- Installed the application
- Trained employees
- Created installation disks using MS Access Development Tool
- Implemented on Windows 3.1 with MS Access 2.0 as front end and Oracle 7 as database server
Standalone Application
Eberhard Brühl Verlade- und Transportsysteme
- Online transaction process to support order and purchasing management
- Database application to support quote and order processing
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained employees
- Created installation disks using MS Access Development Tool
- Implemented on Windows 3.1 using MS Access 2.0 database
Standalone Application
- Database of all treatment and recycling facilities in Germany
- Consolidation of all treatment and recycling facilities for selection by waste types and criteria
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained employees
- Implemented on Windows 95 using MS Access 2.0 database
File/Server Application
- Database for customer management, calculation of sewer construction and connection fees, late payment surcharges, deferral interest and wastewater consumption for the city of Bremen
- File/Server application with concurrent access by multiple employees
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Trained employees
Client/Server Application
- Database for customer and appointment management of oil and petrol separator disposal in Diepholz district, Lower Saxony
- Created a UI prototype
- Designed and implemented the data model
- Implemented the application
- Created user documentation
- Installed the application
- Installed and configured MSSQL Server 6.5
- Trained employees
- Implemented as a client/server application using MS Access 7.0 as front end and MSSQL 6.5 as back end on Windows NT Server 4.0
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Government and Administration, Healthcare, Transportation, Pharmaceutical, and Insurance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Operations, Supply Chain Management, Human Resources, and Procurement.
Skills
- Self-employed Since 1996, Engineering Office For Software Development, Software Engineering, Development Of Custom Databases (Oracle 7x And Oracle 8, 8i, 9i, 10g, 11g, 12c And 19c Server Computing, Internet And Intranet, Msql, Mysql, Adabas, Informix 7.3, Db2 Udb 8)
- Programming: Visual Basic Application, Vbscript, Pl/sql, Java, Javascript, Perl, Shell Scripting, Cgi, C++, Oracle Pl/sql
- Web Servers: Oracle Webserver, Oracle Webdb, Oracle9ias, Oracle Ias 10g Release 2, Soa Oracle Application Server, Oracle Fusion Middleware 11g & 12c, Obia, Apache Web Server 2.4.2, Iis, Apache Tomcat 7
- Database Administration: Administration Of Oracle 7 & 8, 8i, 9i, 10g, 11g, 12c And 19c Under Oracle Parallel Server 8i, Real Application Clusters 9i, 10g, 11g, Oracle Grid Computing, 19c Rac
- Operating Systems: Windows Nt 4.0, 2003, 2008, 2012 Server, Xp Professional; Unix Sun Solaris 8, 9, 10 & 11; Hp-ux 10.x; Aix 5.3; Sinix; Nec; Linux Red Hat 6, 7, 8 And Suse Sles 9, 10, 11 & 12
- Databases And Applications: Oracle 7x, Oracle 8, 8i, 9i Rac, 10g, 10g Rac, 11g Rac, 12c Rac With Asm, 18c, 19c Rac, Oracle E-business Suite 11i And R12 (Oracle Financials, Fa, Ap, Gl, Ar, Om Modules), Informix 7.3, Db2 Udb 8, Microsoft Sql Server 6.5, 7.0, 2000, 2003, 2008
- Networks/communication: Tcp/ip, Nis, Dns, Dhcp, Ldap, San
- Software Packages/methodologies/tools: Oracle Developer 2000, 10g; Oracle Designer 2000, 10g; Discoverer 3.0, 10g; Oracle9 Ids; Oracle Express Server, Olap And Oracle Express Objects; Cognos Suite; Powermart Suite; Bea Weblogic; Oracle Fusion Middleware 11g & 12c, 14c; Tivoli Data Protection; Big Brother; Rman; Bcv Timefinder; Veritas Cluster 5.0; Veritas Volume Manager; Bmc Patrol; Hp Openview; Hp Service Center; Itsm Remedy; Ibm Maximo; Ito; Crm Siebel; Microsoft Visual Studio 97, Visual Studio 6.0; Ms Office Professional And Office Development Tools
- Hardware & Operating Systems: Sf15k, E10k, Siemens Rm600, Rm400; Nec, Compaq, Fujitsu, Aix, Hp, Linux Red Hat 5.3, 6.2, 7.5, 8 And Suse Sle 10, 11 & 12; Sun Solaris Sparc 5.6 To 5.11
- Industries: Banking And Insurance, Service Providers, Pharmaceutical Industry, Manufacturing And Trade, Public Sector, Transport And Logistics, Energy Suppliers, Tourism
Languages
Education
Economics
Aachen University of Applied Sciences
Diploma in Engineering · Process Engineering · Aachen, Germany
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Christopher based?
What languages does Christopher speak?
How many years of experience does Christopher have?
What roles would Christopher be best suited for?
What is Christopher's latest experience?
What companies has Christopher worked for in recent years?
Which industries is Christopher most experienced in?
Which business areas is Christopher most experienced in?
Which industries has Christopher worked in recently?
Which business areas has Christopher worked in recently?
What is Christopher's education?
What is the availability of Christopher?
What is the rate of Christopher?
How to hire Christopher?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Senior Oracle DBA and WebLogic Administrator, Oracle Business Intelligence for Applications
Nearby freelancers
Professionals working in or nearby Eschborn, Germany
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.