Aibi Mathew

Current projects, 2012:
Project-1 Hamad Medical Corporation

Major projects handled
Title: Implementing Oracle Exadata and Exalogic Hardware and Configuring
R12.1.3 Ebusiness Suite Application on Exa Solution

Technology: Oracle R12.1.3, Oracle 11gR2, Exadata, Exalogic, Oracle 11gR2 RAC, SUN ZFS Storage, Sun Infiniband
Switches, Cisco ACE 4710, Cisco 4948 Switches
Operating System: Oracle Enterprise Linux
Role: Oracle Application DBA and Architect
Team Size: 7
Synopsis: The Project happens to be the first Exalogic and Exadata Hardware deployment
In the world for a Health Care Customer and first deployment for Oracle
Ebusiness suite
Responsibility: o Conducted Pre-site Survey before Exa Machine delivery
o Designed the end-end solution for Deploying Oracle Ebusiness on Exadata and Exalogic
o Provided Oracle with Exalogic and Exadata Configuration work sheet and checkup script
o Exalogic and Exadata Implementation and configuration
o Configuration of Exadata Cells for Production and Test
o Configuration of Infiniband Switches and Exalogic VNICS
o Multirack Service - between Exalogic and Exadata
o Configuration of SDP Listeners
o Migration of Oracle Ebusiness suite Database from traditional server to Exadata
o Migration of Oracle Ebusiness Application from Traditional Server to Exalogic Compute Nodes
o Configuring Exalogic storage with NFS Shares and mounting it to each compute Nodes
o Migrating Ebusiness Application to Exalogic Compute Nodes
o Implementing and configuring Cisco Load Balancer with Exalogic Nodes
o Implementing PCP with Exalogic CM Nodes
o Implementing and Configuring External DMZ Application for Ebusiness Suite Application Module
o Migrating Oracle ERP Database to Exadata using RMAN Transport Tablespaces
o RMAN Backup and Restoration ASM-ASM
o ASM based Backup duplication to refresh clone
o Installation and integration of Oracle 12c Cloud Enterprise Manager with Exadata Machine
o Cloning ERP Application and Database on Exa Stack using RMAN
o Migrating and Moving Customizations to Ebusiness Application
o Application System Administration
o Configuring and Monitoring Workflow Mailer
o Providing 24/7 support to 5 Application Instances which has 99.9 % uptime SLA.
o Implementing Swing Bench to Monitor the Application and Database performance
o Implementation of ASR with Exadata Nodes
o Applying latest Exadata and EECS bundle Patches
o Upgrading IB Switch Firmware and EECS version to 2.0
Project 2 Alkhaliji Bank (Sun Microsystems, Germany)

Major projects handled
Title: PRODUCTION DBA
Synopsis: Working as a Production DBA handling Six 2 node RAC databases, five
Oracle HA active/passive databases, 6 Oracle Single node Databases, 17 physical standby databases, 17 single node test and Dev databases, 78 Sql Server databases, Veritas backup solution and Oracle 10g Grid management
The responsibilities included:
⇔ Supporting end-end Database infrastructure
⇔ Implementing Oracle HA databases and Physical standby.
⇔ Database upgrade and migration.
⇔ DR Failover and Datacentre shutdown Tasks.
⇔ Oracle 10g Grid implementation and deploying agents.
⇔ Implementing Veritas backup for Oracle and Sql.
⇔ Daily Oracle and Sql server database monitoring and alert checking's.
⇔ Monitoring the User load, CPU, memory usage.
⇔ Database Health checks.
⇔ Handling Controlpoint for raising Service tickets and resolution.
⇔ Backup Monitoring.
⇔ Implementing AUDIT policies, DATA CENTRE SHUTDOWN policies.
⇔ Oracle Licensing, Technical Documentation.
⇔ Implementing SQL SERVER 2005 Database Mirroring for Active/ Passive Sql Databases.
⇔ Configuring SQL server 2005 Replication for high availability.
⇔ Sql server 2005 Database Migration to a new Storage as part of Primary datacenter Shutdown.
⇔ Configuring Backups for Sql server 2005 instances using VERITAS backup.
⇔ Routine activities of creating staging instance using Production backups
⇔ Use of RMAN utility to take backups


Project-3 Doha Bank
Major projects handled
Title: Oracle Database Migration and Consolidation to Sun M9000 Servers

Technology: Oracle 10gR2/11gR2 RAC, SUNM9000, Sun Cluster, Sun Containers
Operating System: Sun Sparc
Role: Oracle Database Consultant and Solution Architect
Team Size: 3
Synopsis: The Project is to migrate and consolidate all current running Oracle Databases
Which includes Core Banking Database to M9000 Sun Hardware.
Solution Design and Hardware Sizing for the new consolidated environment
Implementing and configuring Oracle 11gR2/10Gr2 RAC Database on ASM file
File system
Core Database migration from HP UX to Sun M9000 SPARC OS
Implementing Oracle 10g/11g Physical Standby

Project-4 Sidra Medical and Research Center
Major projects handled
Title: SIDRA Framework Infrastructure Solution Design

Technology: Oracle 11gR2 Extended RAC, Microsoft SQL Server 2008, IBM Blade Servers,
GPFS/POWER HA
Operating System: Windows 2008, IBM AIX 6.1
Role: Solution Architect
Team Size: 1
Synopsis: Worked with DELL Global team to build and design SIDRA's Framework
Infrastructure which was based on Oracle 11gR2 Extended RAC Cluster and
Microsoft Sql Server 2008 Active/Passive Cluster Setup over 2 Data Centers
Are 25 KM's Far. The solution was designed using EMC VMAX Storages with
VPLEX technology.


Project-5 NDIA (New Doha International Airport)

Major projects handled
Title: Oracle JD Edwards Application Implementation on a
Primary High Available Oracle RAC extended Cluster

Technology: Oracle 11gR2 RAC, HP Blade 620c., 460 c Servers, Oracle ASM,

Operating System: HP UNIX
Role: Infrastructure Project Manager and solution Architect
Team Size: 3
Synopsis: Implementing Oracle JD Edwards Application on high Available Solution Designing and building Infrastructure solution with hardware sizing
Implementing Oracle 11gR2 Extended Cluster


Project-6 Qatar Olympic Committee
Major projects handled
Title: Oracle Ebusiness Suite upgrade to R12.1.3, Migration of ERP Suite from Windows to Linux OS, Implementing PCP, DMZ layer and Oracle 11gR2 RAC, Configuring Oracle 11gR2 Actve Data Guard and integration with SSO / Identity Management and external authentication via Active Directory

Technology: Oracle Ebusiness R12.1.3, Oracle 11gR2 RAC, Oracle 10g SSO, Oracle 10 g OID, Oracle Discoverer, Oracle Weblogic 10.3.5, Oracle Active Dataguard

Operating System: Oracle Linux 5.6
Role: Oracle Applications DBA and Solution Architect
Team Size: 8
Synopsis: Upgrading Oracle Ebusiness Suite to R12.1.3 from 11.5.10.2
Migrating Oracle 10gR2 Database from Windows 2003 to Linux
Migrating Standalone Database to 11Gr2 RAC
Implementing load balanced ERP Application for Internal and External DMZ
Configuring SSO/OID with Ebusiness Suite and Authentication Via AD
Designing and building Infrastructure solution with hardware sizing
Designing and Implementing Standby DR site

Project-6 Ministry of Social Affairs
Major projects handled
Title: Oracle Ebusiness Suite and and Oracle Fusion Middleware Implementation
Technology: Oracle Ebusiness R12.1.3, Oracle 11gR2 RAC, Oracle 10g SSO, Oracle 10 g OID, Oracle Discoverer, Oracle Weblogic 10.3.5, Oracle Forms and Reports 11g
Operating System: Oracle Linux 5.6
Role: Applications DBA
Team Size: 4
Synopsis: Implementing Oracle Ebusiness Suite R12.1.3
Implementing Oracle Weblogic, forms and Reports
Migrating Standalone Database to 11Gr2 RAC
Configuring SSO/OID with Ebusiness Suite and Authentication Via AD
Designing and building Infrastructure solution with hardware sizing
Designing and Implementing Standby DR site

Project-7 Ministry of Foreign Affairs
Major projects handled
Title: Oracle Ebusiness Suite Implementation
Technology: Oracle Ebusiness R12.1.3, Oracle 11gR2 RAC, IBM P7 Servers, IBM GPFS
Operating System: AIX 6.1
Role: Applications DBA
Team Size: 4
Synopsis: Implementing Oracle Ebusiness Suite R12.1.3
Migrating Standalone Database to 11Gr2 RAC
Implementing DMZ R12 Application on 2 Node RAC Solution (IBM LPAR)
Designing and building Infrastructure solution with hardware sizing
Designing and Implementing Standby DR site


Project-8 CPGA Ministry
Major projects handled
Title: Upgrading 11.5.10.2 to R12.1.3 on High available Load Balanced with DMZ and Oracle RAC Solution

Project-9 Qatar Petroleum International
Major projects handled
Title: Upgrade SAP database and Implementation of DR site for QPI primary SAP Application and Database


Completed Projects, May 2006 till Dec 2010:
Project-1 Gulf Drilling International

Major projects handled
Title: Configuring 11.5.10.2 production ERP system with load balancing, oracle
11gR2 cluster solution, external DMZ (supplier/sourcing)

Project-2 Mannai Corporation
Major projects handled
Title: Implementing SSO OID solution for R12 ERP application with external
Authentication Active Directory

Project-3 Qatar Investment Authority
Major projects handled
Title: Implementation of DR site for QIA Primary Data Center - For 5 Oracle Production Databases, JD Edwards Database and 7 Production Sql Server Databases


Project-4 Qatar Investment Authority
Major projects handled
Title: Upgrading Oracle 11.5.10.2 oracle ERP to R12.1.1 on Windows Platform
And migrating Oracle ERP Database to Windows 2003 64 bit

Project-5 Qatar Foundation
Major projects handled
Title: Upgrade Oracle 11.5.10.2 Application to R12.1.1 with 11gR1 Database
Synopsis: Upgrading current Oracle 11.5.10.2 ebusiness suite to R12.1.1 on Windows
2003 64 bit Platform
Project-6 Qatar Museum Authority

Major projects handled
Title: Implementation of R12.1.2 Oracle Ebusiness Suite with High available
solution
Synopsis: Implementation of R12.1.2 ERP with 2 node load balanced application tier and 11gR2 RAC/ASM
Project-7 ICT QATAR

Major projects handled
Title: Implementing Oracle Applications R12 for Sourcing E-tendering Project on
High Available Solution.
Synopsis: The aim of this project is to implement Oracle R12 for DEV, TEST AND PRODUCTION. Major aspect of the project was to configure 2 node internal application tier and 2 node external DMZ application load balanced via F5 and ACE load balancers, Configure R12 e-tendering Application on a 2- node RAC cluster environment, setup DMZ, LOAD BALANCING, PCP and configure I-MODULES (Sourcing and Isupplier portal) as well as applying Oracle Sourcing and Supplier patches. All the users access the external and internal application VIA internet

Prokect-8 Al-Jazeera Children Channel
Major projects handled
Title: Upgrade 11.5.10 Oracle Ebusiness to 11.5.10.2 with 10g Application Database


Project-9 QATARI-DIAR
Major projects handled
Title: Implementing 2 node 11g RAC database FOR QATARI-DIAR EDMS PROJECT

Project 10 QATAR CENTRAL BANK
Major projects handled
Title: Implementing Oracle 10gR2 RAC database with secondary 2-node DR RAC
Based on Oracle MAA Architecture FOR PORTFOLIO PROJECT with DR

Project 11 QATAR NATIONAL BANK
Major projects handled
Title: Upgrade and Convert NAPS 9.2.0.6 database to 11.1.0.7 RAC database system

Project 12 NATIONAL HEALTH AUTHORITY
Major projects handled
Title: Implementing Oracle Applications 11.5.10.2 SPLIT Configuration.
Synopsis: The aim of this project is to implement Oracle 11.5.10.2 on Split Platform. Major aspect of the project was Installing 11.5.10.2 for Dev and Prod (Multi Node) .The project involved configuring Application Tier on Linux and 10g Database on HP-UNIX and Upgrade database to 10.2.0.3 and setup workflow &.Setup Load-balancer and PCP

Project 13 Doha BANK
Major projects handled
Title: DOHA INSURANCE PROJECT ( High Available Solution)
Synopsis: The aim of this project is to implement 2 node RAC with ASM for Production

Project 14 Qatar Islamic Bank
Major projects handled
Title: Implementing Oracle RAC high available solution for the ECC system.
Synopsis: The aim of this project is to convert the ECC Banking Database into 2 node RAC database environment with Logical standby database and Disaster recovery site

Project 15 Alsraiya Holding
Major projects handled
Title: Sql server 2008 Failover cluster