Objectives

Seeking a challenging position in ORACLE consultation, implementation and

presales where I can gain more experience and utilize my wide experience in

well-established Multinational Company.

Executive Summary

An experienced Oracle Technology Consultant at Giza Arabia I have had a

good experience in oracle public and private cloud solution and broad

experience in Oracle Database Administration, Installation, Maintenance,

Troubleshooting and performance tuning, Dataguard configuration, Real

application cluster (RAC) installation and troubleshooting, both oracle

cloud control and Oracle Grid Control Installation, configuration. During

my work, I was responsible for Installing and supporting Oracle 9i, 10g,

11g,12c,18c and 19c single instance and RAC system besides building a

private cloud IaaS and DBaaS. Managing oracle public cloud STC account,

many upgrades at many sites in Saudi Arabia

Personal Data

Name : Attiya Abd El-hamed Youssif Habib

Nationality : Egypt

Date of Birth : 14-March-1982

Address : Saudia Arabiya - Ryiadh

Marital Status : Married

Mobile : +966********* (KSA)

Email : adm4xi@r.postjobfree.com

EMPLOYMENT HISTORY

Company

1. Giza Arabia -STC onsite support- Sep-2013 till now

2. Advanced Operation Technology Sep-2005 till Aug-2013 (KSA)

Position : Senior Oracle Database Architect

Certification

Database Administration

. Oracle Certified Professional, OCP Database 10G

. Oracle Certified Professional, OCP Database 11G

. Oracle Certified Professional, OCP Database 12C

. Oracle Certified Expert RAC and Grid infrastructure admin, OCE 11G

Planning Certification

. Oracle Autonomous Database Cloud 2020 Certified Specialist

. Oracle cloud infrastructure architect

Projects Implemented

Saudi Telecom Company _STC_

. Obligated to build an adequate Database architecture either single

instance database or real application cluster, high availability and

disaster recover option like Oracle data guard and oracle based on SAN

to SAN replication, well maintained and managed according to

performance and scalability

. Working on oracle database consolidation project which consists of two

parts

1- Resolving gaps license between oracle database on VMware and physical

server

2- Prepare to Consolidate critical databases on engineered systems oracle

Exadata and VMware dedicated DB HW hosts

. Managing hundred on databases in terms architecture for STC Database

requester to better provision the databases with adequate computing

resources and storage option.

. Install and configure many oracle database RAC 11g,12c,18c and 19c

along with single instance

. Managing large oracle database migration either same or different

endian

. Build POC for oracle database as a services as part of cloud computing

using EM13c in term of silo databases

. Designing and building a huge consolidation environment for oracle

database in all STC based on VMware technology.

. Working closely with the private could team to implement and convert

from manual database consolidation and provisioning to be automate

through the private cloud based on VMware

. Working on Enterprise Manager Cloud Control 13c implementation as

central management tool for many Databases considered as core

application database in STC

. Build POC for private cloud IaaS on x86 servers using OVM server, OVM

manager and EM 13c to be used for database environment instead of

VMware private cloud

. Build a self-provisioning portal for DBaaS selecting appropriate VM

cpu's/mem/disk requirement

. Configure a DB instance with a specific SID/Character/DB block size

set on the provisioned OVM

. Managing STC oracle public cloud account in terms of IaaS and DBaaS

provisioning

. Held a sessions for STC requester to understand the lifecycle of a

database as a services public cloud instance also connecting to a VM

using the secure putty program and accessing enterprise manager

database express 12c

. Stop/start/restart database as a Service public cloud instance

. Deleting a database a Service public cloud instance once reclaimed

resources

. Scaling up /down a database a Services public cloud instance

. Patching Database as a service public cloud instance.

Falcom Financial Services --On Site Support--

. Install and configuring oracle 10g R2 RAC AIX 5L Based Systems AS 2

node.

. Oracle Database Vault installation and configuration.

. Oracle Audit Vault installation and configuration.

. Create ASM for the database

. Separate ASM oracle home from database Oracle home.

. upgrading the oracle from 10.2.0.2 to 10.2.0.4 using 10g Release 2

(10.2.0.4) Patch Set 3 for AIX 5L Based Systems (64-Bit)

. Configure Database DR Site based on NetApp (Storage) to NetApp

replication.

. Installing and configure application server on 4 nodes as clustering.

. Configure script to take online Rman backup every day.

. Configured Dataguard for trading Production Databases on DR Site.

. Configured RMAN to take daily full backup for all production

databases.

. Configured Enterprise Manager for all production databases.

. Recreate the configuration files and repository for Database Console

. Building Standby database (Real time apply) for production database.

. Handling Day-to-Day user calls for DB Related problems like Schema

creation, Export and Imports of data from one database to another

database.

. Evaluate the current environment in term of scalability, performance

and high availability.

. Perform all database, oracle EBS application 11i and application

server administration duties for all oracle database environments as

on site support.

. Upgraded Oracle database from 9i to 11g Release 2.

. Oracle Application Server administration (Installation, Configurations

and trouble shooting)

SABB (HSBC Saudi Arabia)

I was working There (Saudi Arabia British bank) Through AOT (Advanced

Operation Technology ...Saudi). As a DBA, rich exposure on Oracle RAC,

Data guard, Grid control & Oracle Application server, I was supporting

many Databases in banking Env. A lot of them were production

databases.

I am part of mission critical support team to support Banking domain

business 24X7.

. Install and Implemented Grid Control technology for applications

server and database monitoring.

. Upgraded and migrate2 Production Database from 10gR1 to 11gR1

. Tuning of database Using AWR Reports, analyzing of schema, rebuilding

of indexes, rebuilding of tables,

. Automating trace file deletion and log deletion from UNIX system mount

point.

. Automating Database Analyzing Scripts using cronjob.

. Managing 5 Standby Databases

. Writing shell scripts for backup, export, import, cronjob etc, and as

per need basis.

. Oracle Application Server administration (Installation, Configurations

and trouble shooting)

. Handling Stock Market Database

. Handling Day-to-Day user calls for DB Related problems like Schema

creation, Export and Imports of data from one database to another

database, DB slowness due to bad query or any DB parameters issue, DB

links related problems as per application need.

. Database upgrade from 9i and 10g

. New Database Installation and Configuration on HP-Unix, Windows,

Solaris and AIX

King Fahd Medical City KFMC

Migrated the database from 8i (8.1.7.0.0) to 10g Rel2 on HP-UX. Exp

utility has been used to migrate the database. Performed Health check

on the database in order to maximize the performance

Additional Projects Implemented

. Installed and setup Oracle 11g and 12c Real Application Cluster (RAC)

Database. The Installation was based on 2 (Two) Nodes of Linux Redhat.

. Perform complete database health check and assessment for database

environment.

o Analyze database performance using oracle tools Stats back

and AWR

o Gather database statistics to enhance performance and

exaction time

o Monitor and measure operating system recourses

. Install and configuring oracle 10g R2 RAC on two servers running Linux

Red hat 4

. Provide and implement a migration plan to and migrate oracle DB single

instances to 10g RAC environment

. Implement and use Shell script and SQL scripts to automate the daily

check process for the running DB services

. Implement and maintain database security (create and maintain users and

roles, assign privileges)

. Setup and maintain documentation and standards

. Manage users, privileges, roles, and quotas to control and monitor user

access to the database

. Maintain backup for databases and restore the database as required

. Install the production- testing DB (SQL 2000-2005) servers

. upgrade from SQL server 2000 to SQL server 2005

Application server and Web logic Projects Implemented

. install oracle AS 10g R2 and R3 on Linux OS

. Configuring SSL (secure socket layer).

. Managing single and cluster nodes.

. Managing instances and ports.

. Application deployment

Sites

. Saudi Telecom Company

. Falcom Financial Services

. SABB (HSBC)

. Al Rajhi Bank

Operating System & Tools

. Unix AIX

. Solaris

. HP

. Linux Red hat & Oracle Linux

. MS Windows OS.

Education & Training

Degree : Faculty of Commerce

University : Tanta University

Language Skills

Arabic: Native tongue.

English: Excellent reading, writing, speaking.

Personal Skills

. Commitment and hard worker

. Good communication skills,

. Good team-work interaction and Collaboration,

. Fast learning with "Can Do " attitude

Contact this candidate