Database Administration Principal
Alkhorayef Group
Total years of experience :13 years, 8 Months
Upgrade Oracle E-business Suite from R12.1.3 to R12.2.8
• Upgrade Grid infrastructure from 11.2.0.4 to 12.1.0.2
• Upgrade DB from 11.2.0.4 to 12.1.0.2
• Upgrade Oracle E-business Suite to R12.2.0
• Apply latest 12.2 Release Update Pack (RUP) to Upgrade To R12.2.8
▪ Oracle database Performance tuning tasks including but not limited to the following
• Identify performance bottleneck by running AWR and ADDM reports
• Analyze AWR reports and applying recommendations if any
• Identify SQL statements that consumes time and perform SQL tuning
• Analyze huge tables and apply partitioning if applicable
• Identify database locking
▪ Backup, recovery, patching, upgrade, and all Oracle DB maintenance tasks
▪ Daily Health Check for all production databases and its DR Site and take proactive actions
▪ Configuring Cloud Control 13c
• add all production databases as targets for monitoring
• add all production servers as targets for monitoring
• add Minicluster to cloud control for monitoring
• add Siebel enterprise
• configure alerts to send email for any suspected issue like high tablespace usage, high CPU
utilization, Memory Utilization, file system usage, database blocking sessions, data guard
unreachable and many other metrics
▪ Integration of Oracle E-business Suite R12.1.3 with Oracle Access Manager 12c (12.2.1.3.0)
• Install and Configure Oracle Internet Directory
• Install and Configure Oracle Access Manager
• Install and Configure Oracle HTTP Server 11gR2 WebGate
• Integrate Oracle E-Business Suite with Oracle Access Manager
▪ Oracle e-business Suite Administration, Patching, Cloning and all E-business Suite maintenance
tasks
▪ Siebel CRM installation, Configuration and Administration
▪ Oracle SOA installation and configuration for Siebel, SIEBEL CRM to EBS integration
Performing database consultation tasks for different egabi’ s customers in Egypt, Saudi Arabia,
Consultation work involves all database administration and Oracle E-Business installation, setup,
cloning, migration, configuration tasks and handling Team members
Key Projects
▪ Upgrade Oracle E-business Suite R12.1.3 to R12.2.6 (TAKWA-KSA)
▪ Upgrade Oracle E-business Suite R12.1.3 to R12.2.5 (BAHRI-KSA)
Database Tier:
1- Upgrade GRID infrastructure from 11gR2 11.2.0.3 to 12c
2- Upgrade database from 11gR2 11.2.0.3 to 12c.
Application Tier:
1- Upgrade Oracle E-business Suite to the release R12.2.0
2- Apply latest 12.2 Release Update Pack (RUP) to Upgrade to R12.2.5
▪ Migration/Upgrade Oracle OBIEE 11.1..1.6 and ODI 11.1.1.5 running on windows to OBIEE 12c and
ODI 12c running on Linux (Saudi Post - KSA)
Key Phases
1- Migrate/Upgrade OBIEE 11.1.1.6 running on windows to OBIEE 11.1.1.9 running on Linux
as there is no Direct upgrade from OBIEE 11.1.1.6 to 12c
2- Upgrade from OBIEE 11.1.1.9 to 12c
3- Migrate/Upgrade ODI 11.1.1.5 running on windows to ODI 11.1.1.9 running on Linux
4- Upgrade from ODI 11.1.1.9 to 12c
5- Upgrade Oracle DWH database from 10g to 12c
▪ Scaling E-Business suite into highly available environment (Ooredoo - Algeria(
Convert Oracle EBS12.1.3 database from single database to RAC database using RCONFIG
utility
▪ Oracle e-Business suite 11.5.10.2 database 9.2.0.5 Migration (ECRA - KSA)
Migrate oracle e-Business suite 11.5.10.2 database 9.2.0.5 running on sun Solaris using expdp &
impdp data pump utility to Linux 6 platform and upgrade database to 11.2.0.3.
▪ Upgrade Oracle RAC 2 nodes OS from Linux 5 to Linux 6 and upgrade Apps 2 Node OS from Linux 5
to Linux 6 (AL Zamil Group -KSA)
Database Tier
1- DE configure Oracle RAC node from cluster
2- Upgrade OS from Linux 5 to Linux 6
3- Add Node again to cluster
4- Repeat above steps for the other Node
Application Tier
1- Run Pre-clone on first app node the make tar of the entire app tier
2- Upgrade OS from Linux 5 to Linux 6
1- Configure primary site for DR configuration
2- Configure DR site (they are using Microsoft cloud AZURE running Linux 6) for DR
configuration
3- Build and start replication from primary site to DR site by making full database backup at
primary site and restore it at DR site then start replication from primary to DR
▪ Enabling SSL in Oracle E-Business Suite Release 12 NBE Bank, Egypt
Configure E-business Suite to use https rather than http by applying SSL certificate
▪ Oracle OVM installation (convert from physical servers to virtual servers) (Saudi Royal Protocols-
KSA)
1- Install OVM manager on a separate Server or you can install it on a PC as it is only for
management the entire Virtual Environment
2- Install OVM Server on the Physical Server that you need to split it into several Virtual
Machines
3- Create Server Pool using OVM manager on the just created OVM Server
4- Create 2 virtual machines in the just created Server Pool one for database and one for
Middleware
5- Install and create database on database VM like any other physical Server then restore
backup from production environment to the just created database
6- Install WebLogic, Forms and reports on Middleware Server
▪ Oracle RAC installation and upgrade (National Security, Egypt over IBM-AIX)
1- Upgrade Current CRS 11.2.0.1 and database 11.2.0.1 to CRS 11.2.0.4 and database
11.2.0.4
2- Build Data guard for the just upgraded database
▪ E-business DMZ configuration and deployment for iRecruitment ( Riyadh bank, KSA)
1- Configure a second application Tier in the Internal ERP app Tier
2- Install and configure Reverse Proxy in DMZ Zone so it acts as a reverse proxy between
client requests and the just created app Tier
3- Implement SSL certificate on reverse proxy
▪ E-business DMZ configuration and deployment for iSupplier (MODON-KSA)
1- Configure a second application Tier in the Internal ERP app Tier
2- Install and configure Reverse Proxy in DMZ Zone so it acts as a reverse proxy between
client requests and the just created app Tier
3- Implement SSL certificate on reverse proxy
▪ E-business database Compression (PEPSI- KSA)
▪ Oracle E-business Suite Consultant for (MODON-KSA)
1- oracle E-business Suite administration, maintenance and cloning
2- Oracle SSO administration, troubleshooting
3- Oracle webtier, oracle webgate, oracle E-business Access gate installation
▪ Oracle E-business Suite Consultant for (SWCC-KSA)
1- Managing and maintaining Oracle E-business Suite Environment
2- Two database servers Oracle RAC TWO nodes
3- Two App Tier Server running, load balancer, PCP
4- Two Apps Tier Servers running in DMZ for iSupplier
5- Four EBS Test instances
▪ Oracle EBS installing, patching and performance tuning
▪ Cloning oracle database and oracle e-business suite
▪ Database backup and recovery
Oracle CRM & ERP Operations
▪ Vodafone Billing Process Operation and Monitoring, Retrievals
▪ Responsible for Operating, Monitoring, and Maintaining Vodafone Services
▪ (Daily - Weekly - Monthly Backups, Restores, Services Operation, etc).
▪ Manage StorageTek Tape Library
▪ Epayment handling
courses: Oracle E-Business administration English (professional) Arabic language (native) 9-Month
faculty of computers and information, Egypt,