Resume

Sign in

Oracle DBA/APPS DBA

Location:
Riyadh, Riyadh, Saudi Arabia
Posted:
September 22, 2019

Contact this candidate

Resume:

Professional profile:

I have joined Oracle Egypt., since Nov 2011.

Before joining AlZahrani, I was part of Oracle Managed Cloud Services "Oracle On Demand", Oracle Egypt since Aug 2011, worked as senior Support Engineer in Database, E-Business suite and middle wares like (Application server, Web logic and Oracle Fusion ) ; troubleshooting complex performance issues and offering enhancement and fixes for failed patches or complex data fixes as well as participating in the lunch of Oracle DB 12c and Apps R12.2 across On Demand Customers and working closely with Support and Development teams.

Was production manager for National oilwell Varco Co. participated in upgrade project for company application from 12.1.3 to 12.2.

During my carrier, I have performed a wide range of DBA and OS tasks like maintaining, Cloning, Patching, upgrading, deployment and installation for different releases and versions, especially for the following Products:

•Database "9i, 10g, 11g and 12c".

Oracle Exadata and Oracle database appliance.

•Oracle E-business Suite "11i, R12 and 12.2".

•Linux Redhat "4, 5 & 6".

•AIX.

With Solid technical, experience in the following Middle Tiers:

• Oracle Web Logic "10.3 & 11g".

• Oracle Application Server

• Oracle Fusion

I have also configured, maintained, upgraded and installed the following High Availability Products:

• Oracle RAC "10g & 11g ".

• Oracle Data Guard and Standby Database

• Oracle Fail Safe

My OS Knowledge field:

• RedHat Linux

• Oracle Linux

• HP-UX

• Solaris

• Windows Server 2008 & 2012

My knowledge extends to the following Oracle specific machines:

• Oracle Exadata Database Machine

• Oracle Data Appliance "ODA".

Experience

1) Hassan Misfer Al-Zahrani & Partners Co. - Saudi Arabia (April 2015 – Present)

Application and database Team leader.

Migrated single ebs R12 instance to Oracle database appliance (RAC, PCP and Multi nodes migration(.

Upgraded EBS R12 database from 11.1.7.0 to 11.2.0.4.7

Responsible of database and EBS team.

Created Virtual machines on ODA to host oracle databases and applications.

Installed and administrate Oracle BI EE 11 & 12c.

Installed and administrate Oracle BI APPS 11g.

Responsible of OMC (Oracle management cloud).

Administrate and worked on integration of oracle Sales cloud with EBS.

2) Oracle Egypt (NOV 2011 until April 2015).

Senior Oracle support engineer.

Worked as a team member of change management team (On Demand); handling the ECM customers' (Enterprise Change Management) as planning & execution of requests for changes (RFCs) (EBS, database, RAC, application servers etc...)

Day to day activities:

Responsible of handling the RFCs opened by oracle ECM customers including:

Configurations RFCs.

Patching RFCs.

CUSTOM RFCs.

Fix data in RFCs.

Release management.

Also Worked in vertical team for NOV (National oil well VARCO.).

3) American university of Cairo (Feb 2013 till 2014)

Banner/Database consultant.

Working as Banner and oracle database consultant for AUC.

Handling operational day-to-day tasks.

Upgraded Argos (reports tool) to latest version.

Upgraded Database ASM RAC from 10g to 11g.

Upgraded SSB and INB WebLogic servers to latest versions.

4) EMAK INTERANATIONAL ACADEMY (JUN 2010 to NOV 2011)

Senior Oracle database/APPS administrator.

Day to day activities for ERP:

Cloning, Patching, Code Migration, Performance Tuning, Database monitoring, User management, Backup/recovery management, tar management, monitoring applications and its services.

Responsible for the overall database administration, monitoring and control all of the organization's enterprise databases - RAC and Non-RAC (Oracle).

Responsible for providing backend support for the development, testing and acceptance environments for Oracle ERP and new projects relying on Oracle.

Responsible for the creation, configuration, upgrade, backup, tuning, capacity planning & administration of multiple Oracle (10g/11g) databases.

Administer/building PCP, RAC, Data Guard, RMAN and other related technologies.

Administer and maintain Oracle 10g and 11g on Solaris and Linux.

Some of my activities at projects:

Writing scripts on Linux using shell.

Tuning APPS database & concurrent managers.

Troubleshoot& fixing concurrent requests problems.

Installing HR globalization patches.

Cloning and patching the APPS (using adpatch for the application& Opatch for the database).

Compiling and maintaining the APPS system files using adadmin.

Upgrade oracle E-business suite to R 12.1.3.

Manage the oracle application under Linux including scheduling maintenance tasks using crontab.

Installing Oracle E-business suite R12.0.4, R12.1.1, R12.1on Linux, Windows2003 server.

Installing Oracle E-business suite R11.05 on Linux, Windows2003 server.

Install Arabic for R12.

Building Oracle RAC on Solaris and Linux.

Build Oracle data guard, APPS data guard.

Upgrade apps 11i to R12 on Linux.

Fix problems with forms and reports.

Fix Arabic problems using PASTA.

Some of my projects at EMAK:

APPS in FIRST ARABIAN HOTELS & RESORTS (4 SESSONS HOTEL).

APPS in DORRA GROUPS.

APPS in Dream park Egypt:

APPS in MAC HOLDING.

APPS in ACROW.

5) ORASCOM TRAINING & TECHNOLOGY (April 2006 to MAY 2010)

Senior Oracle DBA and instructor.

Responsible for installing, managing, patching and maintaining the oracle application R11i, R12 under Linux including scheduling maintenance tasks and backup the application.

Instructing all The Courses of Oracle Developer & DBA Tracks including Performance tuning, R12 Oracle Install, Patch and Maintain Oracle Applications.

Supervising the following MCIT projects:

General Ledger.

E. government.

Al-Ahram advertisements agency.

Central.

Training center.

Education

B.Sc. of Mechanical Engineering, Faculty of Engineering Zagazig University.

Major: Mechanical Engineering. Minor: power.

Awarded the B.Sc. in mechanical engineering in May 2000 with a grade of ' pass'. And 'Excellent' grade of project.

Oracle certifications:

Certificate in Oracle 10g database administration Professional (OCP-DBA)

•Oracle 10g SQL, SQL*PLUS, ISQL*PLUS, PL/SQL.

•Oracle Architectural Components, Managing Oracle Instance, Managing Security and Resources, Managing Users, Managing Privileges.

•Basic Oracle Net Architecture, Configuring Shared Server, RMAN Backups, Transporting Data between Databases, Loading Data into a Database.

•Sizing SGA Structures.

•Application Tuning, SQL Statement Tuning, Operating System Tuning

•Oracle performance tuning.

Certificate in Oracle 10g Forms Developer Professional (OCP-Developer)

•Intro to SQL/PL-SQL.

•Developing Program Units.

•Oracle 10g Build Internet Applications.

Oracle 10g Build Internet Reports

Training Courses Attended & Covered:

•Oracle 10g Database Performance Tuning.

•Oracle Exadata Administration.

•System administration R12.

•R12 Oracle Install, Patch, and Maintain Oracle Applications.

•SQL tuning.

•Oracle data guard.

•Oracle 10g Database Fundamentals I.

•Oracle 10g Database Fundamentals II.

•Oracle 10g SQL.

•Oracle10g Program with PL_SQL.

•Oracle 10g Build Internet Applications.

•Oracle 10g Build Internet Reports.

•Oracle 10g Designer First Class.

•Administrating Linux (Red Hat).

•Managing Oracle on UNIX.

•Analysis and Design Concepts.

•Data Modeling and Relational Database Design.

•Assembly (Intel and compatible processors).

Personal information:

Name:

Sherif Mohamed Abd Elsalam.

Gender:

Male.

Nationality:

Egyptian.

Date of Birth:

19/5/1976.

City of Birth:

Cairo.

Marital Status:

Married.

Military service:

Fully Exempted.

Contact information:

Address:

5 Alfady St. from Dr. Lashin; Elmalek Fisal.

Mobile No:

+966-*********

E-Mail:

adaezy@r.postjobfree.com

adaezy@r.postjobfree.com

References available upon request



Contact this candidate