Profilbild von   Principal Oracle DBA Advanced Support Engineer (IC4), Senior Technical Consultant, Oracle DBA Specialist aus Unterhaching

verfügbar

Letztes Update: 06.09.2022

Principal Oracle DBA Advanced Support Engineer (IC4), Senior Technical Consultant, Oracle DBA Specialist

Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (gut)

Dateianlagen

Mahmoud Reda- Resume.pdf

Skills

Oracle, Windows NT, CCNA, Visual Basic, Oracle Database, Database, databases, Oracle Goldengate Replication, PDB, Oracle DBA, database administration, Oracle Platinum Customer, Backup, Oracle Net services configuration, Cloud, 12c, PaaS, Database Migration, Siebel, SuperCluster, T8 / M8 Servers, RAC 11.2.0.3, RMAN, core banking, Linux, Solaris, SPARC, AIX, Windows, expdp, impdp, TDE, encryption, InfiniBand, DB, telecommunication, ODS, ETL, USSD, BO, IBM AIX, ZFS, real time data, Oracle Golden Gate, change data capture, DDL, Load, data synchronization, weblogic, Oracle GoldenGate Veridata Agent, SSL/TLS, ORACLE RAC Database, RAC database 11.2.0.4, Oracle virtual machine, virtual machine, Firewall, connection string, DB Firewall proxy IP, Oracle Database Firewalls, NIC, subnet, DB Firewall, backups, Sql, Real Application Cluster 10g, RAC, Database 10g, Oracle10g Security, Oracle 10g, Oracle Collaboration Suite 10, Windows 2003 Server SP2, OCR, Oracle Real Application Cluster 10g, Vote Disks, Automatic Storage, SUN, Oracle Database 9.2.0.7, Site Support, AIX 5.2, Oracle Fail Safe 3.3.4, WINDOWS 2003 SERVER, HP-UX, ASM, AIX ML5, Network File System, NFS, Tivoli Libraries, Oracle Application Cluster 10g, Application Cluster 11g R2, Oracle Real Application Cluster 11g R2, PCI, application server, IP address, user accounts, operating system, network traffic, Application Cluster 10g, Sun Solaris, RAC Database, Legato Tape Library, 10g, RAC 10g, Oracle ERP, Oracle Database 10g 10.2.0.3, Oracle Application 11.5.9, file system, Vote, Private Network, 9i, Sun Solaris 10, Windows 2003, Oracle Database 9i, Sun Solaris 10, Oracle Database versions 9.2.0.7,10.2.0.2 & 10.2.0.4, Solaris 10, GIS, Windows Server 2000, Linux Redhat, database security, Oracle database 9.2.0.2, HP-UX B.11.31, materialized views, x86, Oracle Management Server, OMS, Oracle Application Servers, Windows Server 2003, Microsoft SQL Server 2000, Server, DB2, INIT File, RAC configuration, Oracle Database Administration 10g workshop1, Oracle Database Administration 10g, Real Application Cluster 10g RAC, Application Cluster 9i, Sun Cluster v3.1, Real Application Cluster RAC 9i, Sun Cluster v3, GPS, Oracle SQL 10g, Oracle Database 10g, Oracle Enterprise Manager 10g, Oracle Application Server 10g

Projekthistorie

04/2011 - 05/2019
Principal Oracle DBA Advanced Support Engineer (IC4)
Oracle Corporation

(Oracle Advanced Support Center based on Egypt)

Principal Oracle DBA Advanced Support Engineer (IC4)

Performing database administration support services from Oracle support Center
in Egypt in sharing in many projects for preparing educational materials for
customers and other support engineers.

Job Description:

* Provide specialized DBA technical and functional assistance,
to Oracle customers' worldwide.
* Troubleshooting and supporting highly complex technology and
software application implementations.

* To manage and resolve Service Requests logged by customers
(internal and external) on Oracle products and contribute to
proactive support activities according to product support
strategy and model

* Owning and resolving problems and managing customer
expectations throughout the Service Request life-cycle in
accordance with global standards

* Working towards, adopting and contributing to new processes and
tools
* Contributing to Knowledge Management content
creation and maintenance (Metalink)

* Working with development on product improvement programs
(testing, BETA programs etc) as required

* Respond and resolve customer issues within Key Performance
Indicator targets
* Maintain an up-to-date and in-depth knowledge of new products
released in the market for the given clusters




* Ensure the timely completion of planned proactive tasks and
Service Requests
* Operate in line with Bug Diagnosis and
Escalation/Development Bug guidelines in resolution of Bug
related Service Requests
* AM&R Team which was responsible for remote patching
for Oracle Platinum Customer

Key Areas covered in support:

* General Database administration and maintenance tasks
* Patches installation and Upgrade
* Troubleshooting skills
* Backup and recovery procedures
* Database security procedures
* Solving emergency database issues
* Oracle Net services configuration troubleshooting and tracing

Key Projects :

* Vodafone Egypt (Private Cloud implementation)

* Install Oracle Grid Infrastructure 12c on DBaas Cluster Nodes on
T8 /M8 servers.
* Install and Patch oracle database homes 11.2.0.4, 12.1.0.2 and
* 12.2.0.1 on T8 / M8 servers.
* EM13C Agent Installations on DBaas Cluster Nodes.
* EM13C Discovery of Hosts /Clusters and Oracle Homes installed
on DBaas Cluster Nodes.
* Create PaaS Infrastructure Zones.
* Create PaaS Software Pools.
* Create SSA Users and Setting up Quotas.
* Create Service Catalog and Service Templates.
* Database Migration "Provisioning" for 30 Databases Database
Migration for Promo/Siebel Databases from current Super Cluster
to Cloud on SuperCluster and T8 / M8 Servers.

* MTN Nigeria

* Migrate Factsdb 30 TB database and convert it to RAC 11.2.0.3 on
ASM using RMAN incremental backup with minimal down time
* Migrate OPTPROD 20TB database 11.1.0.7 with GI 11.2.0.3 on
ASM using RMAN incremental backup with minimal downtime.

* MTN Ghana

* Onsite support for all database environments like (BIBDP and
mobile money database with a very huge database.
* Migrate BIBP database 160TB to 1/2 Exadata using RMAN
incremental backup in order to minimize the downtime
* Using HCC in order to compress Application data.




* Commercial Bank of Africa (CBA Kenya)
* Migrate 30 databases including core banking databases for
different countries from different platforms (Linux, Solaris,
HP_UX and SPARC) to SuperCluster M8 using different
migration methods for cross platform migration (Incremental
Transportable Tablespaces, GoldenGate, datapump and
heterogeneous dataguard).

* QNB Qatar

* Migrate 8 databases from different platforms (AIX, Windows) and
different versions (10g, 11gR1) to Exadata machine using different
migration methods (RMAN incremental backup, expdp/impdp,
RMAN duplicate for standby).
* Implementation for TDE for critical tables for core banking
database and use Goldengate to minimize downtime during data
encryption.

* Vodafone Egypt

* Change InfiniBand bonding on Exadata X4-2 from active/active to
active/passive
* Adding X-2 Exadata DB compute nodes to X-4 Exadata Cluster
* Adding X-2 Exadata Cells to X-4 Exadata Cluster
* Onsite support for main telecommunication database 160 TB
services (ODS, ETL, USSD and BO).

* Exadata Patching Activity (For Oracle Platinum Customer)

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

* Ageas Portugal Exadata Patching

* Patching Exadata System for Cells, YUM and Bundle patch
including GI and DB upgrades remotely to the latest BP.

* Morrisons UK Exadata Patching

* Patching Exadata System for Cells, YUM and Bundle patch
including GI and DB upgrades remotely to the latest BP including
Grid Infrastructure upgrade to 12.1.0.2 and applying the latest BP
for Production and DR environments.

* Network Rail UK Exadata Patching

* Patching Exadata System for Cells, YUM and Bundle patch
including GI and DB upgrades remotely to the latest BP including
Grid Infrastructure and Database upgrade to 12.1.0.2 and
applying the latest BP for Production and DR environments.

* MTN Cote D'Ivoire

* Patching the Cell Storage to 12.1.1.1.1
* Patching db nodes to 12.1.1.1.1




* Upgrade Grid Infrastructure from 11.2.0.4 to 12.1.0.2.
* Database migration and upgrade from 11.2.0.3 six databases to
12.1.0.2 CDB with six Pluggable databases (PDB) on Exadata
Servers.

* Equity Bank Kenya

* Migrate most critical databases 11.2.0.4 Single instance (3
databases) including core banking database from AIX platform to
Solaris Sparc on Super Cluster Zones RAC Databases using Oracle
Data Guard between IBM AIX on Power systems and Oracle
Solaris on SPARC systems.

* ADDC UAE

* Configure ZFS backup appliance and mounting the shares on
SuperCluser.
* Configure DNFS for RMAN backup.
* Perform High Availability Test for SuperCluster and RAC.

* 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
:
* Installation of Oracle GoldenGate software in sources and target.
* Configure Sources and Target Database for oracle golden gate
requirements.
* Configure extract processes perform change data capture (CDC)
from (Redo logfile & archive log file) for specific schemas & tables
on different sources.
* Configure DDL Synchronization between sources and target.
* Performed GoldenGate Initial Load using Oracle Database
utilities
* Assistance with initial data synchronization to secondary server.
* Oracle GodenGate performance enhancement.
* Review and setup best practices related to Oracle GoldenGate
implementation.
Setup and Implement a high-speed data-comparison and repair solution using
Oracle GoldenGate Veridata 12c:
* Installed Oracle GoldenGate Veridata 12c with high availably
architecture using oracle weblogic cluster.
* Created the Oracle GoldenGate Veridata Repository Schema.
* Configured Domain for Oracle GoldenGate Veridata.
* Deployed and Configured Oracle GoldenGate Veridata Agent.
* Configure data source connections.
* Configure compare group that is linked to a set of source and
target data source connections.
* Configure compare pairs group.
* Oracle GoldenGate Veridata 12c performance enhancement.

* Zain Kuwait

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
:
* Installation of Oracle GoldenGate software in sources and target.
* Configure Sources and Target Database for oracle golden gate
requirements
* Configure extract processes perform change data capture (CDC)
from (Redo logfile & archive log file) for specific schemas & tables
on different sources.
* Performed GoldenGate Initial Load using Oracle Database
utilities
* Assistance with initial data synchronization to secondary server.
* Oracle GodenGate performance enhancement.
* Review and setup best practices related to Oracle GoldenGate
implementation.
Setup and Implement a high-speed data-comparison and repair solution using
Oracle GoldenGate Veridata 12c:
* Installed Oracle GoldenGate Veridata 12c
* Created the Oracle GoldenGate Veridata Repository Schema.
* Configured Domain for Oracle GoldenGate Veridata.
* Deployed and Configured Oracle GoldenGate Veridata Agent.
* Configure data source connections.
* Configure compare group that is linked to a set of source and
target data source connections.
* Configure compare pairs group.
* Oracle GoldenGate Veridata 12c performance enhancement.
Setup and Implement Goldengate Monitor Tool as monitoring solution for all
Goldengate environment (sources and target).

* Kuwait Finance House(KFH)

* Configure SSL/TLS on ORACLE RAC Database for Client
Authentication and Encryption with Self Signed Certificates on
Both Ends using orapki.
* Configure TDE in order to encrypt customer sensitive data.

* HMC Qatar

* Re-organize ASM Diskgroups for Exadata Cell Storage in order to
increase the size of Data diskgroup and decrease Reco diskgroup.

* EMasary Egypt:

* Oracle Database Appliance (ODA) 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.

* Qatar Central Bank (QCB):

* Implementing two Paired Oracle Audit Vault Servers
(Active/Passive) using Oracle Database Standby Technology, the
first Audit vault server (primary) is an Oracle virtual machine




from server box 1 at the primary site and the second audit vault
server is an Oracle virtual machine from server box 2 at the
primary site as well, both servers are paired together.
* Oracle Database Firewall is implemented in proxy mode; this
requires changing applications connection string to use the load
balancer IP (if used) or the DB Firewall proxy IP instead of
connecting directly to the database.
* Two Oracle Database Firewalls are configured as standalone but
with identical configuration and this requires an intelligent load
balancer that performs DB service health check like F5-BIG IP.
* Two NIC cards are configured per each DB Firewall as there is
only one subnet and only one zone at both primary and DR sites,
one NIC used to configure the management IP and the second one
will be used to configure the proxy IP of the DB Firewall.

11/2006 - 04/2011
Senior Technical Consultant
Egabi Solutions

Performing database consultation tasks for different Egabi customers like
Ministry of Industry (IDA), Bank Misr and others. Consultation work involves all
database administration Real Application Cluster, Oracle Data Guard
implementations.

Used Import Export utilities for making logic backups and used Sql*Loader for
loading external data from non-oracle database to oracle database. Configured
RMAN to take full and incremental backups on different platforms.

Responsibilities:
* Conduct courses in:
* Oracle Real Application Cluster 10g (RAC).
* Oracle Database 10g (Workshop 1 & 2).
* Oracle10g Security.
* Oracle 10g Enterprise Manager Grid Control.

Key Projects :

* Ministry of Industry Egypt

* Implement and configure of Oracle Collaboration Suite 10 (0CS)
on Windows 2003 Server SP2.
* Implement and configure of Oracle Real Application Cluster10g
(RAC) On Windows 2003 Server SP2.

* Bank Misr Egypt:

* Implement and configure of Oracle Real Application Cluster10g
(RAC) on AIX HACMP 5.2 using Raw Device for OCR and Vote
Disks and Database Files.

* Exports and Development Bank Sudan

* Implement and configure Oracle Data Guard ATM application as
part of disaster recovery plans.




* Military Information Data Center Egypt

* Implement and configure of Oracle Real Application Cluster 10g
(RAC) on AIX Using Raw Devices for OCR and Vote Disks and
Automatic Storage Management (ASM) for Database Files and
Archivelog files.

* Central Bank of Egypt(CBE)

* Implement and configure Oracle Real Application Cluster 10g
Central Bank of Egypt (CBE) on sun Solaris over SUN cluster 10
using raw devices.

* Bank of Alex(BOA) Egypt

* Oracle Database 9.2.0.7 on Site Support on AIX 5.2 over HACMP.
And using Finical Application for 12 months.

* Ministry of Interior Egypt

* Implement and configure of Oracle Fail Safe 3.3.4 on WINDOWS
2003 SERVER.
* Implement and configure Recovery Manager (RMAN) backup
strategy on Tivoli Tape Library as full and incremental backups.

* MediTel (Second Operator) Morocco

* Implement and configure of Oracle Real Application Cluster10g
(RAC) on HP-UX Serviceguard Using Raw Device as storage for
OCR and Vote Disks and ASM for Database Files and Archive log.

* National Security Authority NAS Egypt

* Implement Oracle Real Application Cluster 10g on AIX ML5 over
HACMP for two nodes Using Raw Devices for Ocr and Vote Disks
and Database Files and Network File System (NFS) for
Archivelogs files.
* Implement RMAN Backup Strategy for RAC environment using
Tivoli Libraries.
* Adding a third Node for Oracle Application Cluster 10g
environment over AIX ML 5 using HACMP.
* Implement Oracle Real Application Cluster 11g R2 on AIX TL 5
version
* 6.1 over HACMP using ASM to store OCR and Voting Disks and
for Database Files, also using SCAN IP for Client connections.
* Implement Oracle Real Application Cluster 11g R2 on AIX ML5
over HACMP for two nodes using ASM for OCR and VOTE Disks
and database files.
* Configure Oracle Database Guard for RAC Database as primary
database and RAC database as standby.

* Egyptian Arab land Bank (Full security implementation for PCI
compliance)


* Implement and Configure Oracle Database Vault on Linux redHat




4 in order to
*
* Limit SYS privileges
* specify the application server IP address to connect to database
using specific application using specific user ,
* Prevent third party programs to connect to the database
* Prevent some IP addresses from connection to the database.
* Lock and expire default user accounts
* Changing default user passwords
* Change passwords for administrative accounts
* Change default passwords for all users
* Enforce password management
* Manage access to SYSDBA and SYSOPER roles
* Enable Oracle data dictionary protection
* Follow the principle of least privilege
* Public privileges
* Restrict permissions on run-time facilities
* Authenticate clients
* Restrict operating system access
* Secure the Oracle listener.
* Prevent runtime changes to listener
* Checking network IP addresses
* Encrypt network traffic
* Apply all security patches
* Report security issues to Oracle

* The Egyptian Credit Bureau (Iscore) Egypt

* Implement and Configure Oracle Real Application Cluster 10g On
Sun Solaris over Sun Cluster 10 using Raw Device as storage for
OCR and Vote disks and Database Files and Network File System
(NFS) for Archivelogs for Both Nodes, over IP Multipathing
(IPMP) for Public and Private Connections.
* Implement and Configure Recovery Manager (RMAN) backup
Strategy for RAC Database using Legato Tape Library.
* Implement and configure Oracle Database Vault 10g on RAC 10g
over Sun Solaris, Limit SYS user Privileges, specify the application
server IP address to connect to database using specific application,
do not allow third party programs to connect to the database,
prevent some IP addresses from connection to the database.

* National Water Company(NWC) KSA

* Implement and Configure Oracle ERP Release 12.0.4 multi tires
installation on Linux.

* Saggaf Pharmacies KSA

* Cloning Oracle ERP on Linux.
* Support Oracle Database 10g 10.2.0.3 and Oracle Application
11.5.9 on site Support.

* Du Mobile Network Second Operator (Dubai)

* Implement Oracle Real Application Cluster 10g on Sun Solaris




using QFS file system to store OCR and Vote disks and Database
Files over IP Multipathing (IPMP) for Public and Private Network
connections.

* Saudi Snacks Foods KSA

* Upgrade Oracle Database 9i 9.2.0.7 to 10.2.0.4 on Sun Solaris 10,
Windows 2003 Server Saudi Snacks Foods (KSA).
* Support Oracle Database 9i (9.2.0.7) and 10g Databases (10.2.0.4)
on call support over Sun Solaris 10 and Windows 2003 Server.

* Ministry of Water and Electricity KSA

* Managing Database access and security.
* Oracle Database on Site Support for Oracle Database versions
9.2.0.7,10.2.0.2 & 10.2.0.4 on Sun Solaris sparc 64 bit and perform
upgrade from 9.2.0.7 to 10.2.0.4 Ministry of Water and Electricity
(KSA).
* Migrate from 9i version (9.2.0.7) to 10g version (10.2.0.4&10.2.0.2)
on Sun Solaris 10 using GIS Application.
* Configure RMAN Backup with NetBackup as there backup
strategy for All Databases.
* Migrate Oracle Database version 10.2.0.4 from FileSystem to ASM
using RMAN backup as a copy on Sun Solairs 10
* Migrate Database version 10.2.0.4 from Windows Server 2000 to
Linux Redhat 4 using RMAN convert for cross platform migration
* Managing database security

* Ministry Of Health KSA

* Migrate Oracle database 9.2.0.2 from SUN Solaris single node to
10.2.0.5 on HP-UX B.11.31 Real Application Cluster and configure
Oracle Replication using Read-only materialized views and
Updateable materialized views for 15 other databases with
different versions.

* Orascom Telecom (Algeria)

* Implement Oracle Grid Control Disaster Recovery 10.2.0.4 on
Linux x86 64 bit as Data Guard for Oracle Management
Repository(OMR) and two Oracle Management Server(OMS) on
Different Servers One connect to the primary OMR and the Second
connect to the Standby OMR as their strategy for Oracle Grid
Control Disaster Recovery.
* Managing more than 40 Oracle Databases and 1bout 10
* Oracle Application Servers on HP-UX,SUN Solaris Sparc
,Windows Server 2003 Integration Between Oracle Grid
Control and Microsoft SQL Server 2000 For monitoring and check
alerts using Oracle plug- in for Microsoft SQL Server .
* Integration between Grid Control and DB2 for Monitoring and
check the alerts for DB2.
* Integration between Grid Control and HP Open view by using
Oracle Connector for HP Open viewer and configure as Bi
direction.
* Configure Oracle Diagnostic packs and Oracle Tuning Packs for




Oracle Database and provide tools for monitoring the database
performance.
* Configure Email Notification and Alerts for Oracle Critical cases
as Database Down, Agent Down... etc.

* Mediterranean Smart Cards Company (Egypt)

* Oracle Real Application Cluster Health Check ,Configure Load
Balance for both RAC instances ,test failover for both RAC
Instance configure the INIT File for RAC configuration

* Orascom Telecom Algiers (Training)

* Oracle Grid Control 10g

* Customs and Ports General Authority Qatar (Training)

* Oracle Database Administration 10g workshop1.
* Oracle Real Application Cluster 10g (RAC).

* Oracle Dubai (Training)

* Oracle Real Application Cluster 10g (RAC).
* Oracle Grid Control 10g.

* Oracle Channel Communication Center(CCC) (Training)

* Oracle Real Application Cluster 10g (RAC) for Oracle partners in
KSA.
* Oracle Database Administration 10g Workshop 1 in Emak
international Academy Egypt.
* Oracle Database Administration 10g Workshop 2 in Emak
international Academy Egypt.
* Oracle Database Vault training for Oracle Partners in KSA.
* Oracle Real Application Cluster 10g (RAC) for Oracle Partners in
Cote d'votre.
* Oracle Real Application Cluster 10g (RAC) for Oracle Partners in
Emak international Academy Egypt.

* ITI (Training) Egypt

* Oracle Database Administration 10g Workshop 1.
* Oracle Database Administration 10g Workshop 2.
* Oracle Real Application Cluster 10g RAC.

* Gupco Petroleum Company Egypt

* Implement and Configure Oracle Real Application Cluster 9i over
Sun Solaris over Sun Cluster v3.1.
* Oracle Real Application Cluster RAC 9i over Sun Solaris over Sun
Cluster v3.1 Training.


* Agility Services Hyderabad (India)(Training)

* Oracle Database Administration 10g.
* Oracle Data Guard 10g Administration.

01/2006 - 10/2006
Oracle DBA Specialist
EMAK International Academy

Conducted Oracle Technology training for EMAK clients like Oracle GPS, Arab
Construction Bank and others.

Responsibilities:

* Conduct courses in:
* Oracle SQL 10g.
* Oracle Database 9i (Fundamental 1 & 2).
* Oracle Database 10g (Workshop 1 & 2).
* 10g New Features for Administrators.
* Oracle Enterprise Manager 10g Grid Control.


* Installation and Configuration of Oracle Application Server 10g on
Different platforms.

* Implement and configure High Availability Solution (Data Guard) in
Industrial Development Bank.

* Security administration and implement different oracle security solutions.

Reisebereitschaft

Verfügbar in den Ländern Deutschland
Profilbild von   Principal Oracle DBA Advanced Support Engineer (IC4), Senior Technical Consultant, Oracle DBA Specialist aus Unterhaching Principal Oracle DBA Advanced Support Engineer (IC4), Senior Technical Consultant, Oracle DBA Specialist
Registrieren