Haitham Hesham Mohammed Khalifa
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.
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
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
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.
• 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
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
• 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)
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
Arabic is the Mother Tongue.
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%)
• 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.
The head of the music band in Nuqrashi School
The head of the Future Group in the Modern Academy
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