Profileimage by Mohamed AboShady database and middle ware Technical Consultant from Cairo

Mohamed AboShady

available
Contact

Last update: 03.10.2021

database and middle ware Technical Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

mohamed refky resume_update.pdf

Skills

Oracle, database, Oracle Database, Middleware, integrator, Java EE, node Oracle, Oracle WebLogic servers, Oracle Data Integrator, WebLogic Server managed servers, Oracle Real Application Clusters, ETL, OEM, Database migration, DB, Oracle RAC, Oracle Active Data Guard 11g R2, SUN, SUN Cluster, IVR, Unix, SPARC, ZFS, database server, databases, Oracle Database 11g, Weblogic Cluster 10.3.6, WebLogic, file structure, SQL scripts, SQL tuning, Cloud computing, 12C, IBM, MSSQL Server, Oracle Weblogic, JVM, MYSQL, Apache tomcat server, VNX, VMAX, Oracle flash storage system storage, business logic, VMware, Vcenter, User Experience, Linux, Java 1.6, Apache Web Server, PHP, Oracle Grid Control 11g, Oracle grid control server, cloning, metadata, Oracle Data Integrator packages, clustering, web interface, Oracle Weblogic server, Oracle weblogic server cluster, real time data, change data capture, DDL, Load, data synchronization, Oracle GoldenGate Veridata 12c, OBIEE, data quality, Oracle Internet Directory, application server, 10g R2, Identity Management, J2EE, Windows 2008, operating system, R3, Oracle AS 10.1.3 J2EE, Apache 2.0, OAS 10.1.3, OC4J, HTTP server, Oracle Database RAC, Oracle Report Server, EAR file application Over OC4J, Load Balancer, OAS, HTTP, Webcache, windows 2003, Oracle 10g, Unix AIX 5.3, backup, XML PUBLISHER server, Oracle Enterprise Manger Cloud, Oracle Golden Gate 11g Boot, Oracle database administration, Oracle application server 10g, Oracle Data Integrator 11g Boot, Oracle Enterprise Manager 12c Cloud Control, Oracle Enterprise Manager, Oracle Weblogic 9.2, Cloud Control 12c, Oracle database appliance administration, Oracle 9i RAC, 10g RAC, 11g, 12c Design, Implementation, Oracle Streams, Replication, Oracle Enterprise Manager 10gR2 & 11g and 12c Implementation, Oracle VM for X86, RMAN, Oracle application server Administration, BEA WebLogic Server 9/10, 12c System Administration, Linux RedHat, Windows, Unix AIX, Unix Sun Sparc, Unix HP- !

Project history

10/2021 - 10/2021
Technical Consultant
Egabi Solutions
AS An experienced Oracle Technology Consultant at Vodafone Egypt
I have a broad experience in Oracle Database Administration &
Oracle Middleware been worked at number of sites as below:
Petroleum Development Oman :

Design and implement oracle data integrator 12.2.1.2 Java EE agents high
availability solution between two sites, a two-node Oracle Data Integrator
cluster running on two Oracle WebLogic servers via the use of HW load
balancer :
1- Oracle Data Integrator applications run on two clustered WebLogic
Server managed servers.
2- Coherence cache is used to handle scheduler service uniqueness.
3- ODI's master and work repository database is configured with
Oracle Real Application Clusters and Data Guard to avoid
database failures.
4- Setup and configured ODI standalone server as DR site for main
site .
5- Enhance ETL jobs performance (ODI & Database ).
6- Integrate ODI server with OEM 13.2 to monitoring ODI jobs .

Vodafone Egypt :




Customer Car Database migration :

Enables near zero downtime upgrades & Migration for mission-critical Database , The
solution allows company to maximize revenue-generating activities with the least amount
of impact to business users by Migrate single node database 10.2.0.4 with 1 terabyte
DB size to Oracle RAC 2 nodes 11.2.0.3 :
1- Design and implement oracle Real application cluster 11.2.0.3 with
ASM .
2- Export and import for Base Data.
3- Enable ODI CDC on source Database .
4- Setup ODI Jobs to migrate Changed data only .

Balance Transfer Database DR :

Deploy a High Availability and Disaster Recovery Solution Using Oracle
Active Data Guard 11g R2 on Primary database 11.2.0.2 (local site) single
node on SUN Cluster and Physical standby database 11.2.0.2 (remote
site) single node on SUN Cluster using Sun cluster geographic parameters
.

IVR Database Migration Online :

Enables zero downtime upgrades & Migration for mission-critical Database , The
solution allows company to maximize revenue-generating activities with the least amount
of impact to business users by Migrate and upgrade single node 10.2..0.4 on HP Unix to
single node database 11.2.0.4 on Sun SPARC database using oracle GoldenGate :
1- Install Database Single node 11.2.0.4 on ZFS storage .
2- Setup the target environment (hardware, storage, network, etc).
3- Start the Oracle GoldenGate Capture process on the source Oracle
DB.
4- Copy the source database to the target database server and
synchronize the databases in real-time.
5- Configure the GoldenGate Delivery process .
6- Execute test plans against the new target Oracle Database .

Data Handler Solution

1- Design and implement oracle Real application cluster 11.2.0.3 ( 3
nodes ) :
- Preinstallation Tasks for Oracle Grid Infrastructure for a Cluster .
- Install Oracle Grid Infrastructure for a Cluster .
- Postinstallation Tasks for Oracle Grid Infrastructure for a Cluster
.
- Create ASM Disk Groups for Data and Fast Recovery Area .
- Install Oracle Database 11g with Oracle Real Application
Clusters .
- Setup Transparent Application Failover (TAF) service for
application Failover

2- Design and implement oracle Weblogic Cluster 10.3.6 (3 machines
) :
- Install WebLogic on 3 physical machines .
- Create the WebLogic Domain on one physical machine .
- Configure the domain by adding Managed Servers and Machines
on one physical machine .
- Copy the domain file structure to the others physical machine and
enroll it to the WebLogic Domain .
- Ensure that all WebLogic Machines are operational .
- Create and configure the Cluster .
- Ensure that the Cluster is operational .




-
NDC (Number of Digit Change) :

Support in Migration number of phone to 11 digits project :
- Designed and review migration SQL scripts to enhance migration
performance and minimize downtime for VAS telecom systems
databases.
- Support Development Team in SQL tuning and enhance
migration processing time .

Oracle Cloud computing 12C Implementation :

1- Create Oracle Management Repository (OMR) As single Database
ASM instance .
2- install the following components:
* Oracle Management Service 12.1.0.2
* Oracle Management Agent 12.1.0.2
3- Integrate with IBM Tivoli using SNMPP methodology .
4- Configured user notification rules to send alarms to IBM Tivoli.
5- Administer, diagnose, and tune Oracle Database targets (80
Databases).
6- Administer, diagnose, and tune MSSQL Server targets (5
Databases).
7- Administer, diagnose, and tune Oracle Weblogic .
8- Configure and deploy JVM diagnostic .
9- Administer, diagnose, and tune MYSQL Server targets (10
Databases)
10- Administer, diagnose, and tune Apache tomcat server (17 Server)
11- Administer, diagnose, and tune ODI server.
12- Integrate With EMC storage (VNX-VMAX) to monitoring using
EMC plugin .
13- Integrate with Oracle flash storage system storage .
14- Setup OEM groups to group different teams assets .
15- Centralize the scheduling of tasks on multiple systems.
16- Group related targets to facilitate administrative tasks.
17- Supply built-in reporting to quickly view and analyze information
about managed systems.
18- Create Metric Extensions to monitoring business logic .
19- Integrate with VMware Vcenter to monitoring VMware
environment
20- Upgrade OMS & Agents to 12.1.0.5

Oracle Real User Experience Insight

Install Real User Experience Insight 13.1 as Single-Server Deployment on Oracle
Linux

6.0 :

1- Installing Oracle Linux the required RPMs Using a Yum Repository .

2- Installing Java 1.6 .

3- Installing the Apache Web Server and PHP.

4- Installing the Oracle Database Instant Client.

5-Installing the php-oci8 Module.


Oracle Grid Control 11G:




- Design and implement Oracle Grid Control 11g :
1- Setup and installation Oracle grid control server (Oracle
Management Repository (OMR) -Web tier - Oracle
Management Service (OMS)).
2- Patching OMS Required for Setting up Provisioning and
cloning .
3- Administer, diagnose, and tune Oracle Database targets (80
Databases).
4- Administer, diagnose, and tune MSSQL Server targets (5
Databases).
5- Administer, diagnose, and tune MYSQL Server targets (10
Databases)
6- Administer, diagnose, and tune Apache tomcat server (17
Server)
7- Administer, diagnose, and tune ODI server.
8- Centralize the scheduling of tasks on multiple systems.
9- Group related targets to facilitate administrative tasks.
10- Supply built-in reporting to quickly view and analyze
information about managed systems
Revenue accuracy Project :
- Design and implement oracle Data integrator server 10.1.3.5.0
* Create Master & Work repository Database
* Set up a Oracle Data Integrator topology
* Use manage projects in Oracle Data Integrator to develop interfaces
and other Objects
* Enrich Oracle Data Integrator data models with more metadata
* Create an integration process using Oracle Data Integrator packages
* Create interfaces and add multiple sources to an interface
* Manage packages
* Customize data flow and get the best performance out of system
* Migrate Master and Work repository from development server to
production Server
* Configure ODI clustering over two nodes
* Deploy Topology & Designer web interface to Oracle Weblogic
server .
- Design and implement Oracle weblogic server
- Design and implement Oracle weblogic server cluster
* Upgrade Data integrator server 10.1.3.5.0 to 10.1.3.5.6
* Setup CDC module

Etisalat UAE :

Setup and Implement solution that can synchronize the desired data
between
transactional and reporting systems in real time data replication processes
to create data warehousing Operational Data Store (ODS) using Oracle
Golden Gate :
1- Installation of Oracle GoldenGate software in sources and target.
2- Configure Sources and Target Database for oracle golden gate
requirements .
3- Configure extract processes perform change data capture (CDC)
from (Redo logfile & archive log file ) for specific schemas &
tables on different sources .
4- Configure DDL Synchronization between sources and target .
5- Performed GoldenGate Initial Load using Oracle Database utilities
6- Assistance with initial data synchronization to secondary server.
7- Oracle GodenGate performance enhancement.




8- Review and setup best practices related to Oracle GoldenGate
implementation.
9- Setup OEM plugging for oracle GoldenGate.

Setup and Implement a high-speed data-comparison and repair solution
using Oracle GoldenGate Veridata 12c :
1- Installed Oracle GoldenGate Veridata 12c with high availably
architecture using oracle weblogic cluster .
2- Created the Oracle GoldenGate Veridata Repository Schema .
3- Configured Domain for Oracle GoldenGate Veridata .
4- Deployed and Configured Oracle GoldenGate Veridata Agent.
5- Configure data source connections .
6- Configure compare group that is linked to a set of source and target
data source connections .
7- Configure compare pairs group .
8- Oracle GoldenGate Veridata 12c performance enhancement
9-
Exa-Data Patching Activity (Fo Oracle Platinum Customer)

- Patching ExaData System for Cells, YUM and Bundle patch
including GI and DB upgrades remotely for many EMEA
customers.

EMasary Egypt :

* Oracle Database Appliance Bare Metal Restore Procedure X5-2.
* Install And Configure oracle RAC database 11.2.0.4 For Oracle
Database Appliance .
* Migrate oracle database from single node to ODA online using
Oracle goldengate .

MTN Ghana:

* Onsite support for Oracle Exadata machine .
* Oracle Exadata performance enhancement .

Ministry of Education UAE

- Design and implement OBIEE 11G - Cluster (High Availability) :
(Horizontal Scale out of System Components)

1. Create shared area for RPD, catalog, cache
2. Install OBIEE on to new node, select Enterprise Install > Scale Out
3. Provide details for WLS Admin Server
4. Node is configured to be new managed server within cluster
5. Use EM to add system components to the new server
6. Designate secondary controllers for scheduler, cluster controller

- Design and implement WebLogic cluster consisting of two Managed
Servers running
on a separate physical machine :

1. Install WebLogic on both physical machines
2. Create the WebLogic Domain on one physical machine
3. Configure the domain by adding Managed Servers and Machines
on one physical
machine
4. Copy the domain file structure to the other physical machine and




enroll it to the
WebLogic Domain
5. Ensure that both WebLogic Machines are operational
6. Create and configure the Cluster
7. Ensure that the Cluster is operational

NBE Bank :

- Design and implement oracle Data integrator server 10.1.3.5.0

* Create Master & Work repository Database
* Upgrade oracle Data integrator server from 10.1.3.5.0 to 10.1.3.6.2
* Set up a Oracle Data Integrator topology
* Use manage projects in Oracle Data Integrator to develop interfaces
and other Objects
* Enrich Oracle Data Integrator data models with more metadata
* Create an integration process using Oracle Data Integrator packages
* Create interfaces and add multiple sources to an interface
* Launch a session to run an interface
* Enforce data quality constraints in an interface
* Manage packages
* Customize data flow and get the best performance out of system
* Migrate Master and Work repository from development server to
production Server
* Extract and load Data from oracle E-Business 12i using ingrate
oracle data integrator with E-Business using (ODI RKM)

MTN Nigeria

Use Oracle Internet Directory as a central directory For Oracle Database
user authentication and centralized privilege management.

Shoura Bank ( Djibouti )

- Design and implement oracle Database server 10.2.0.2
- Upgrade oracle Database to 10.2.0.4
- Design and implement oracle application server :
* install oracle application server 10g R2 forms and reports standalone
* create forms server and deploy application forms over it
* create report server and deploy reports over it.
* set and configure report server parameters to improve report server
performance

Information and Decision Support Center ( IDSC )

- Design and implement oracle application server high availability
topology
* create oracle application server database infrastructure over oracle
RAC.
* apply oracle Database Companion CD for two RAC instance
* configure and create oracle application server meta database
repository for two RAC instance.
* OracleAS Cluster (Identity Management) 2 nodes .
* OracleAS Cluster( middle tire J2EE instance) 2 nodes & BI instance
.
* OracleAS webcache Cluster




.
Ministry of State for Administrative Development

- Design and implement oracle Real application cluster
* Two Database instance 11g R1
* ASM Storage
* Windows 2008 64 bit service back 2 operating system

HC:

- Design and implement oracle application server R3 high availability
topology
* create two J2EE instance cluster
* Front End Oracle AS 10.1.3 J2EE with OHS (Apache 2.0) From
10.1.3 Companion CD
* Setup Fast Connection Failover (FCF) Within OAS 10.1.3 OC4J
Instances

Arab contractors Egypt

- Design and implement oracle application server 10g R2 high availability
topology:
* create two J2EE instance cluster
* create oracle report server
* create oracle forms server
* Deploy Oracle forms application
* Deploy Oracle reports
- Perform full performance and tuning for application server
* Tuning HTTP server
* Tuning webcache server
* Tuning OC4J instance
* Tuning Report Server
* Tuning Forms Server

Ministry of Justice Duties (AOAF)

- Design and implement oracle application server10g R2 high availability
topology:
* Create Metadata Repository over Oracle Database RAC
* Create three J2EE instance cluster
* Create three Webcache cluster
* Create oracle forms server
* Create Oracle Report Server
* Deploy EAR file application Over OC4J
* Configure Hardware Load Balancer with OAS (HTTP&Webcache)

Ministry of Defiance

- Design and implement oracle application server10g R2 high availability
topology:
* Create Metadata Repository over Oracle Database RAC
* Create three J2EE instance cluster
* Create three Webcache cluster
* Create oracle forms server
* Create Oracle Report Server




* Deploy WAR file application Over OC4J
* Configure Hardware Load Balancer with OAS (HTTP&Webcache)
- Perform full performance and tuning for application server
* Tuning HTTP server
* Tuning webcache server
* Tuning OC4J instance
* Tuning Report Server

Ministry of Justice Duties

* Provide a solution to upgrade windows 2003 from 32 bit to 64 bit to in
order to avoid SGA max size limitation on windows 32 bit to enhance
DB performance
* Implement Oracle 10g streaming between main center and 14 branches
for traffic administration

07/2014 - 03/2015
Senior Advanced
Oracle ACS

11/2010 - 01/2014
Senior database Engineer
Vodafone Egypt
Jan 2007 - Nov

Contact form

Contact details