Resume

Sign in

Oracle Sql Server

Location:
Cairo, Cairo Governorate, Egypt
Posted:
March 12, 2018

Contact this candidate

Resume:

Haitham Hesham Mohammed Khalifa

** * (Gate *) - Hadayek El Ahram Giza

Tel: (002) 012******** + (002) 010********

E-mail: ac4r8f@r.postjobfree.com

ac4r8f@r.postjobfree.com

Objectives:

Seeking an opportunity in the field of Information Technology, in a challenging and competitive environment where my professional background, communication and interpersonal skills can be applied and developed.

A challenging position at Database Administration Field in a professional organization that utilizes my experience and problem solving skills.

Work Experience:

Job Title: Database Section Head (Full Time)

Company: The Egyptian Exchange

Duration: from 15/11/2008 until now.

Job Responsibilities: Administrate DB (Oracle, SQL server and Informix) and Apps (EBS)

Oracle DBA General Tasks:

Install, Upgrade, Create, and Administer Oracle database 8i, 9i, 10g, 11g and 12c

Managing Oracle on Different Platforms: Windows, Linux (Redhat, Suse), UNIX (Solaris, AIX)

Planning the database and Configure the database for an application.

Worked in Both DSS and OLTP database environment.

Attending to regular alerts on Tablespace space issues, OS space issues, CPU utilization etc.

Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Checking ALERT logs for unknown errors and troubleshooting the same.

Moving Data using (Export/Import, Data Pump, SQL*Loader).

Configure and Manage ASM

Database Backup and Recovery Tasks:

Ensure daily backup for all production databases are finished successfully.

Plan and implement backup and recovery strategy using RMAN, Flashback.

Restoration of successfully taken backups to test the data & to estimate time lines for restorations when needed.

Audit and follow up on Daily, Weekly Cold, Hot Backups and archive logs.

Worked to many Backup Solutions (Net Backup, IBM TSM, Net Worker)

Database Replication/Migration Tasks:

Replication using Materialized View and Oracle Streams.

Replication with Different Platform using Golden Gate.

Migration DB (MS SQL Server or Informix) to Oracle

Database Availability Tasks:

Install and Manage Oracle Real Application cluster (RAC) 10g, 11g and 12c.

Install and Manage Oracle Data Guard (Configuration and maintenance of Oracle Data guard for Ensuring minimal downtime during natural disasters)

Manage Data Guard physical, logical and snapshot standby database.

Database Performance Tasks:

Monitoring and Tuning SQL Statement, Instance and database performance

Generate the Statspack, AWR, ADDM and ASH Report for gathering the performance data

Identifying Problem SQL Statements using advisors

Using SQL Performance Analyzer and Database Replay

Database Security Tasks:

Creation of Users, Roles and grant Privileges to the users according to client policy.

Configure Audit, VPD, OLS, Proxy Users, Profile and Authentication.

Encryption: Data Masking, DBMS_CRYPTO, TDE, RMAN Encryption, Data Pump Encryption.

Security Solution: Implement Database Vault, Audit Vault and Database Firewall.

Apps DBA Tasks:

Installing different EBS Application releases on UNIX, Windows for both R11 and R12.

Using AD Utilities as (ADADMIN, ADPATCH and ADCTRL, etc.) to maintain, update, upgrade and troubleshooting bugs.

Installing operating systems and configuring it for installing Applications environment.

Performing Backup, Recovery and cloning for Oracle Applications

End user training in the company projects for the Oracle HR, financial modules and technical tasks.

Implementation of Oracle HR and Financial Modules

Microsoft SQL Server DB Tasks:

Install, Upgrade, Create, and Administer SQL Server 2005, 2008, 2012, 2016 database

Plans and implements backup and recovery strategy

Monitoring and Tuning database performance.

Advanced tasks: Mirroring, Log Shipping, Replication

IBM Informix DB Tasks:

Approve, schedule, plan, and supervise the installation and testing of new databases Informix 10, 11

Backup and Recovery using ONTAPE

Management using Command-line tools (ONCHECK, ONDBLOG, ONINIT, ONLOG, ONMODE, ONPARAMS, ONSPACES, ONSTAT)

Purge Database using DB Export/Import.

Monitoring and tuning database performance using (IBM Server Studio)

Job Title: Database Consultant

Company: Free lancer

Duration: from 01/03/2014 until now

VIP Customers:

Tokio Marine: Implement OVM and Install Oracle RAC and Data Guard

ICL: Performance Tuning and Implement RAC 11g on Windows

DMS: Migration Full system (Database, web logic Server and application) to anther platform.

ACROW: Migration Database and EBS from Solaris to AIX

Vodafone Egypt:

o Migration Database 12c with Zero Downtime

o Implement RAC 12c R2 on AIX

o Install and Configure Golden Gate

Job Title: Oracle Instructor

Company: ARADO, Egabi, Next Academy, ItEgypt and etc (Part Time).

Duration: from 01/01/2010 until now

Job Responsibilities: Teaching Oracle DBA Track and Advanced Courses:

Oracle Database 12c: New Features for Administrators Ed 2

Oracle Database 11g: Performance Tuning

Oracle Database 11g: SQL Tuning

Oracle Database 11g: Managing Oracle on Linux for DBAs

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated

Oracle Database 11g: Data Guard Administration

Oracle Database 11g: Backup and Recovery Workshop

Oracle Database 11g: Implement Streams

Oracle Database 11g: Security

Job Title: Oracle Team Leader

Company: New Horizons (Full Time).

Duration: from 01/01/2008 to 14/11/2008.

Job Responsibilities:

• Deliver advanced courses • Develop My Team • Salary schema

• Perform some technical solution • Skill matrix • Development plans

Job Title: Oracle Instructor.

Duration: from 22/6/2006 to 31/12/2007.

Job Responsibilities: • Teaching Oracle 9i DBA Track

• Teaching Oracle 10g DBA and Developer Track

VIP Customers:

Bank sector: National Bank of Egypt, Banque misr, Faisal Bank, Arab Bank, Alex Bank, Bank of Tanzania

Petroleum sector: Gupco, Pgesco, Gasco, Bapetco, Enppi

Telecommunication sector: Vodafone, Mobinil (Orange)

Insurance Sector: CIL (AXA), Tokio Marine, Misr Insurance, DMS

Other Company: IDA, NTG Egypt, Tea Computers, Almaloma computer (Libya), Misr International Hospital, National Navigation Company

Job Title: Training DBA and Developer.

Company: Information System & Services (IS&S)

Duration: from 1/8/2005 to: 3/1/2006.

Job Responsibilities: Project Developed (Customer Relationship Management 'CRM System'), Watching, Improvement System Performance

Certifications:

• Oracle Database Administrator Certified Associate (OCA) • Novell Certified Linux Administrator (CLA)

• Oracle Database Administrator Certified Professional (OCP) • Oracle Database SQL Expert (OCE) Working in the Following Projects:

Participated in the implementation of many projects the Egyptian Exchange, And most notably:

One of the latest trading systems in the world "X-Stream System"

DR Site using (Oracle high Availability: RAC 11gR2 and Data Guard)

Data Warehouse system using (Oracle 10gR2 and Oracle Stream)

Consolidation Project (Oracle 10gR2 and Oracle 11gR2)

Informix History system using (Informix 10)

New EGX Web Site using (Oracle 10gR2 and SQL Server 2008)

New Surveillance System using (Oracle RAC 11gR2)

SME System (Small Market Exchange system) using (Oracle 10gR2 and DB Informix 10)

LDM System (Listing, Discourse and membership system) using (Oracle 10gR2)

Customer Relationship Management 'CRM System' using (Oracle DB, Oracle Developer).

"Steganography" (hide text into voice) Concerns the application of the technique of “Steganography” using the LSB (least significant bit) method, the main objective being to replace the LSB in the voice message and replace it with one bit from the message till we hide the entire message we want to, using (C#, VC++, Flash MX, Power Point, Photoshop)

Graphic projects:

Web Sites for "Hardware Computer Company","Islamic","Mashakel.Com" using (Oracle DB, HTML, Flash 6, Photoshop 6, Swish Animation, and MS Picture It).

Design Cards, Pamphlets, Logo, Advertisement and Montage Clip for "Tourism, Charity, Medical, Company and Actors " using (MS Picture It, Photoshop 6, Power Point, Power Director, Premiere Pro, Proshow Gold, Video Editor 7, Video Studio 6& MS Publisher)

Creation 3D Building and Furniture Decor using (3D Studio Max 3) Training Courses for Database:

Course Name: Location Date

Oracle Database 11g: OCM Exam Preparation Workshop Online Official Course 02/2017 Oracle 11g RAC Administration New Horizons [Dubai] 03/2015 IBM Big Data Specialist IBM 09/2014

Oracle11g RAC and Grid Infrastructure Egabi 03/2011 Informix 11 System Administration (IX811GB) IBM [United Kingdom] 11/2010 Implementing SQL Server 2008 Database (6232) Global Knowledge 12/2009 Maintaining SQL Server 2008 Database (6231) Global Knowledge 12/2009 Oracle11g: New Features for Administrators Orascom (OTT) 03/2008 Oracle10g: Managing Oracle on Linux New Horizons 01/2007 Introduction to Oracle10g: SQL New Horizons 08/2007 Oracle10g: Program with PL/SQL New Horizons 08/2007 Oracle Forms10g: Build Internet Applications New Horizons 08/2007 Oracle Reports10g: Build Reports New Horizons 08/2007 Oracle10g: Workshop I New Horizons 08/2006

Oracle10g: Workshop II New Horizons 09/2006

Oracle10g: Performance Tuning New Horizons 10/2006 Oracle10g: Backup and Recovery New Horizons 12/2006 Introduction to Oracle9i: SQL IS&S 05/2005

Oracle9i: Fundamentals I IS&S 05/2005

Oracle9i: Fundamentals II IS&S 06/2005

Oracle9i: Performance Tuning IS&S 07/2005

Other Training Courses:

Course Name: Location Date

VMware vSphere: Optimize and Scale EMC [Dubai] 12/2015 Symantec NetBackup 7.5 Administration for UNIX Symantec [Dubai] 11/2013 Red Hat Linux Essentials RH033 Linux Plus 08/2009

Red Hat Linux System Administration RH131 Linux Plus 08/2009 Essentials Featuring the Solaris 10 OS SA-100 New Horizons 07/2007 ICDL SCLT 04/2006

Introduction CCNA and ICND Misr Learn 06/2004

3D Studio Max AMAC 08/2001

Skills:

Language Skills:

English Fluent.

Arabic is the Mother Tongue.

Functional Skills:

Highly Communications Skills.

Good leadership skills.

I have the Ability to be a Part of Teamwork.

Advanced Research Abilities.

Working as a trainer and lecturer for a very long time.

Create Reports to the top administration.

Planning, Strategy Development & Policy Implementation.

Follow Technical Notes and Making Documentation to avoid future mistakes. Computer Skills:

Operating Systems: Windows, Linux (Redhat, Suse and Oracle), UNIX (Solaris, AIX).

Database: Oracle, MS SQL Server, IBM Informix.

Virtualization software: VMware, Oracle VM(virtualbox)

Hardware: Good experience in personal computer assembling and maintenance.

Web Design: Good experience in web design specially HTML.

Desktop Skills: MS office Word, Power point, Excel, Outlook, Access, Visio. EDUCATIONS:

Bachelor of Computer Science from Modern Academy for Computer Science and Management Technology (MAM) in Maadi

Graduation Year: May 2005

Major: Computer Science

Graduation Grade: good (73.16%)

Graduation Project: "Camouflage", Steganography technique over network (Hide text into voice), Web Site for (www.Camouflage.3nv.com), Slides, Documentation and Very Good Presentation.

Our main object was to make a data hiding using Steganography method and send the data through out a network after the data is hided and user can receive the data in the other terminal and extract the hidden data in the message.

Project Tools: C#, VC++, Flash MX, Swish Max, Power Point, Photoshop.

Project Evaluation: Excellent

Grade of Fifth Year: Very Good (83.11%)

PERSONAL INFORMATION:

• Gender: Male. • Date of Birth: April 7, 1983.

• Place of Birth: Saudi Arabia. • Marital Status: Married.

• Nationality: Egyptian. • Driving License: Yes

• Military situation: Exemption. • Hobbies: Guitar, Writing, Graphics Program.

• Experience Period: 11 years • Countries Visited: United Kingdom, Saudi Arabia and UAE.

• Activities:

The head of the music band in Nuqrashi School

The head of the Future Group in the Modern Academy

• Awards:

Certificate of appreciation from the teacher’s union for scientific excellence in the computer

A letter of thanks from the pgesco company for good performance on oracle courses

Sculptured souvenir from the General Authority for Industrial Development (IDA) for good performance on oracle courses

Sculptured souvenir from Sudanese Customs Authority for good performance on oracle courses

Sculptured souvenir and letter of thanks from the EGX for good performance on prepare for the new trading system X-stream

REFERENCES AVAILABLE UPON REQUEST



Contact this candidate