Mahmoud Reda - WIZBII Mahmoud Reda has published his/her professional profile on WIZBII. M R

Mahmoud Reda

Working for Oracle Egypt Advanced Customer Support Team

Summary

I am Mahmoud Reda working in Oracle Egypt Advanced Customer Services Team (ACS) Database I have a deep experience on ASM,RAC ,OEM, Database 10g,11g and 12C ,Goldengate and Exadata

Skills

DBAnetworkSysadmin

Experiences

Principal Advanced Service Engineer

04-2011 - NowIT developmentKey Projects: • 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. • 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). • Exa-Data 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. • 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. • 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.

Senior Technical Consultant

11-2006 - 03-2011 IT development• 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. 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. 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. • 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 Solairs 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 • 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. • 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. • Egyptian Arab land Bank (Full security implementation for PCI compliance) • Implement and Configure Oracle Database Vault on Linux redHat 4 in order to 1- Limit SYS privileges 2- specify the application server IP address to connect to database using specific application using specific user , 3- Prevent third party programs to connect to the database 4- 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

Education & training

Mansoura Uni

1999 - 2005 Mansoura, Mansoura Qism 2, Mansoura, Dakahlia Governorate, Egypt, MansouraInfra / Networks / Telecom

My soft skills

Persevering
Responsive
Analytical
Team player

Languages spoken

  • English

    Professional

  • Arabic

    Native language

Make every future a success.
  • Job directory
  • Business directory