Oracle Database Consultant

--------------------------------------------------------------------------
Oracle Consultant Linux Adminstrator, Programmer
Project Duration: February 2016 – March 2016
Client Name / Sector: To be disclosed upon request / Multinational Service Provider, located in Munich, Germany
Role: Consultant, Oracle DBA, Linux Administrator, Programmer
Project:
Bidirectional replication of a production Oracle Database using Oracle 12.2 with Dbvisit replicate and PL/SQL-, SQL-, shell- and Perl-Scripts. Part of the project was also creation of a tailored Nagios plugin for status monitoring of the export, import and merge processes on both databases.
Software: Oracle database 12.2.0.1.0 Standard Edition, Oracle Linux 7.2, Dbvisit Replicate 7.0.52, Nagios 3.5.1, SQL Developer 4, Bash, Perl 5.10, version control Git
--------------------------------------------------------------------------
Oracle Consultant Linux Adminstrator, Trainer
Project Duration: June 2014 – December 2015
Client Name / Sector: To be disclosed upon request / Multinational Service Provider, located in Munich, Germany
Role: Consultant, Oracle DBA, Linux Administrator, Trainer
Project:
Oracle database support for more than 20 databases, using Oracle 12.1.0.2, Real Application Clusters (RAC), standby databases as well as single instance installations.. These databases form the clients' test, development, reference and production systems.
The project consists of a test, development and reference system in Munich. The production system is currently deployed in Iraq (Baghdad).
My duties include installation and administration, performance tuning, and quality assurance of all Oracle databases.

As Linux administrator I'm responsible for planning, implementing and administrating the Linux application servers, email servers (iRedmail), a local Oracle yum repository server and monitoring servers (OMD) in this project.
As a Linux trainer I developed and implemented a training plan for the end customers' system administrators on the reference system in Munich.
I'm the central point of contact for all Oracle an Linux related issues in the project.

Software: Oracle database 12.1.0.2, Oracle Real Application Clusters (RAC), TvDStandby Software, OMD, iRedmail, SQL Developer 4, Bash, Perl 5.8., Oracle Linux 6.5, Revision control system Apache Subversion (SVN), Teamviewer
--------------------------------------------------------------------------
Oracle Consultant in an agile development environment
Project Duration: May 2013 – June 2014
Client Name / Sector: To be disclosed upon request / Multinational Service Provider, located in Berlin and Bonn, Germany
Role: Consultant, Oracle DBA
Project:
Oracle database support for more than 50 databases. These databases form the clients' test, development, reference and production systems.
The project consists of approximately 85 programmers and is based on agile development with 15-18 SCRUM teams.
My duties include data modeling, normalization, performance tuning, quality assurance, PL/SQL programming, installation and administration of all Oracle databases.
I am the central point of contact for all Oracle related issues in the project.

Software: Oracle Database 11.2.0.3, Oracle Real Application Cluster 11.2.0.3, Oracle Enterprise Manager Cloud Control 12c, Oracle Data Guard, Oracle SQL Developer, Redhat Enterprise Server 5.9 and 6.3

--------------------------------------------------------------------------
MySQL application and Cluster
Project Duration: February 2012 - January 2013
Client Name/Sector:to be disclosed upon request/Mobile Telecommunications, Iraq
Role: Consultant, MySQL DBA and Developer
Project:
Database design and implementation of a client specific application with major focus on high performance and security.
This includes programming of stored procedures, functions and triggers. For security reasons the business logic is implemented in the stored procedures and isolated from the middle-tier and client side.

Installation of a 3 node Percona XtraDB Cluster (Galera library) Percona Server with MySQL 5.5.26 on Liunx CentOS 6.3.
Design and implementation of stress tests, node failover and programming of monitoring software for the MySQL cluster.
Design and implementation of a backup- and disaster strategy.
In-house workshops about MySQL Cluster.

Software: Percona XtraDB Cluster, wine, HeidiSQL 7, Perl 5.8., CentOS 6.3, Revision control system Apache Subversion (SVN)

--------------------------------------------------------------------------
Internal Workshops Oracle RMAN
Project Duration: October 2012
Client Name/Sector: Apliman Technologies/Mobile Telecommunications Applications, Beirut, Lebanon
Role: Oracle DBA, Trainer
Project:
Design and internal training workshops Oracle Database Backup and Recovery with RMAN Hands-on (Oracle 11.2, Oracle Linux 6).

Software: Oracle Database 11.2.0.1, Oracle Enterprise Manager, Perl, Oracle Linux 6.3, Oracle VirtualBox 4

--------------------------------------------------------------------------
Oracle Real Application Cluster (RAC) Installation, Database Migration
Project Duration: June 2011 – August 2011
Client Name/Sector: to be disclosed upon request/Mobile Telecommunications, Iraq
Role: Oracle DBA, Trainer
Project:
Design and implementation for a database migration from single instance to RAC with minimal downtime.
Installation of a 2 node RAC (Oracle 11.2.0.1) with ASM instances (Grid Control 11.2.0.1) on RedHat Linux 5.7.
For redundant access to the SAN we used Device Mapper Multipathing (DM Multipathing) and Oracle ASMLib.
RAC Failover tests.
Migration of the production system, database size 1.75 TB from single instance to RAC.
The initial migration was done on-site after that the client performed User Acceptance Tests (UAT).
The final migration was done remotely.
Design and implementation of a backup and disaster recovery strategy with RMAN.
Internal training workshops about Oracle Enterprise Manager Grid Control.

Software: Oracle Grid Control 11.2.0.1, Oracle Database 11.2.0.1, Oracle Enterprise Manager, Oracle SQL Developer, Perl 5.8., Redhat Enterprise Server 5.7

--------------------------------------------------------------------------
Oracle RAC Performance Tuning, Data Guard Troubleshooting
Project Duration: February 2011 – March 2011
Client Name/Sector: Beirut Municipality/Public Sector, Beirut, Lebanon
Role: Consultant, Oracle DBA
Project:
Oracle database health check of a 2 node RAC (Windows Server 2003) as well as the standby database.
Data Guard environment (zero data loss) troubleshooting assistance,
Performance tuning of the primary database (SQL/Instance Tuning)

Software: Oracle Database 10.2.0.4, Oracle Enterprise Manager, Perl 5.8., Windows 2003 Server

--------------------------------------------------------------------------
Oracle RAC Performance Tuning, Backup Optimization
Project Duration: August 2010
Client Name/Sector: to be disclosed upon request/Financial institution, Beirut, Lebanon
Role: Consultant, Oracle DBA
Project:
Oracle database health check of a 2 node RAC (Oracle Version 10.2.) on Windows Server 2003,
database performance tuning (SQL/Instance Tuning),
Backup- and recovery strategy optimization (hot backup with RMAN)

Software: Oracle Database 10.2.0.4, Oracle Enterprise Manager, Perl 5.8., Windows 2003 Server

--------------------------------------------------------------------------
Monitoring software customization, Oracle RAC Performance Tuning
Project Duration: April 2010 – September 2010
Client Name/Sector: to be disclosed upon request/Banking institution, Beirut, Lebanon
Role: Consultant, Oracle DBA
Project:
Oracle database health check of a 2 node RAC (Oracle Version 10.2.) on Redhat Linux 5.3,
SQL/Instance Tuning,
Backup- and recovery strategy optimization (hot backup with RMAN)
Implementation and customization of the monitoring software MERIT on the 2 node production RAC.

Software: Oracle Database 10.2.0.4, Oracle Enterprise Manager, Perl 5.8, Redhat Enterprise Server 5.3, MERIT, Revision control system Apache Subversion (SVN)

--------------------------------------------------------------------------
Oracle RAC Administration and Development
Project Duration: July 2009 February 2010
Client Name/Sector: FIZ CHEMIE Fachinformationszentrum Chemie GmbH/Public Sector, Berlin, Germany
Role: Consultant, Oracle DBA, Developer (PL/SQL, Perl)
Project:

Fachinformationszentrum (FIZ) Chemie, Berlin, Germany became Oracle reference customer in October 2009
URL: http://www.kemptner.com/files/anwenderreportagen/oracle/oracle_fiz_chemie_de.pdf


Database development of the 20 subject specific internet search engines based on Oracle Text with PL/SQL, Perl and shell scripting (bash),
Database administration of the production system 4 node RAC Oracle 11.1.0.6 with ASM instances, database size 25 TB,
SQL/Instance Tuning,
Backup- and recovery strategy optimization (hot backup with RMAN),
backup to disk and tape,
Implementation of an enterprise wide Oracle infrastructure monitoring system with Nagios plugins,
Incorporation of an Oracle database administrator successor at FIZ Chemie,
All work was done remotely (VPN, ssh, skype).

Software: Oracle Database 11.1.0.6, Oracle RAC 11.1.0.6, Oracle Enterprise Manager, Oracle SQL Developer, SQL*Loader, Perl 5.8., bash, Redhat Enterprise Server 5.3, Veritas Netbackup 6.5, Trac ticket system, Revision control system Apache Subversion (SVN)

--------------------------------------------------------------------------
Oracle RAC Administration and Development
Project Duration: August 2002 – June 2009
Client Name/Sector: FIZ CHEMIE Fachinformationszentrum Chemie GmbH/Public Sector, Berlin, Germany
Role: Oracle DBA, Developer (PL/SQL, Perl)
Project:

Main applications are more than 20 subject-specific Internet search engines, based on Oracle Text full text indexing.

Oracle Database Administration and Implementation:
Administration of production systems; 4 node Real Application Cluster (RAC) running on LINUX Suse Enterprise Server 9, Redhat Enterprise Server 5, Oracle 11.1.0.6, Database size 6 TB, main table contains 30 mio. records,
Administration of the development system for stress tests: 2 node RAC, database size 1.75 TB with 25 mio. Oracle Text indexed documents,
Implementation of the application design including data modeling and normalization,
Performance measurement and tuning with statspack, sql trace, DBMS_MONITOR, DBMS_SESSION, automatic workload repository (AWR),
De-fragmentation and re-organization of the partitioned main tables,
Installation of Oracle Software (9.0.1, 9.2, 10.2, 11.1) including patches from test- to production systems,
Application migration from Oracle 9.0.1 to 9.2.0.8 to 10.2.0.2 to 11.1.0.6,
Design and implementation of backup and recovery strategies (hot backup with/without Recovery Manager), database cloning (RAC to single instance system and vice versa) with Veritas Netbackup 6.5, Time Navigator as media management software,
Implementation of heterogeneous workloads (OLTP and data warehousing).

PL/SQL database programming:
Programming of PL/SQL packages, procedures, functions, triggers for the automation of Oracle Text indexing, index optimization, user access via roles.

Perl Programming:
Object oriented programming of a central user authentication and accounting system,
Programming of a SOAP server for financial accounting with SOAP::Lite.
Perl Object Environment (POE) Programming for web based access and control of Oracle Text indexing and backup procedures.

Software: Oracle RAC 9i/10g/11g, Oracle Database 9i/10g/11g, Oracle Enterprise Manager, Oracle Text, Oracle SQL Developer, SQL*Loader, Perl, bash, Veritas Netbackup 6.5, Time Navigator, Suse Enterprise Server 9, Redhat Enterprise Server 5, Trac ticket system, Revision control system Apache Subversion (SVN)

--------------------------------------------------------------------------
System administration, Training
Project Duration: February 1997 – June 2002
Client Name/Sector: Volkshochschule Friedrichshain-Kreuzberg von Berlin /Public Sector, Berlin, Germany
Role: System administrator, instructor
Project:
System administration of heterogeneous network comprising of 3 LINUX (NIS, NFS) and Microsoft servers NT 4.0 (PDC, BDC), 30 workstations, RAID systems as well as the backup and recovery strategy of the aforementioned systems.

Instruction planning and lecturing:
Including courses such as: database programming, front end Web programming, applications and web servers for database access and control, operating systems and MS Office programs.

Software: Windows NT 4.0 , DOS, Linux, MySQL, Perl, MS-Access, MS-Word, MS-Excel