Amr Ismail Hassan

** ******* ***** ***** **., Ain Shams, Cairo, Egypt

Objective:

Seeking a challenging position in a reputable organization where I can utilize my full potential, enhance my experience & develop my career in the field of Communication Engineering & Information Technology. Education Background:

Master Degree in Information System Technology, Sadat Academy A Proposed Assessment Model of Database Performance on Virtual Machine vs. Traditional Server waiting for discussion for the thesis B.Sc. of Business Administration – Information Technology, Helwan University. Graduation Date: 1999 Graduation Degree: Very Good.

Graduation Project: Database of Human Resources for Egypt Air Graduation Project Degree: Excellent. Professional Experience:

ISKAN Insurance Company Oracle Database Consultant from August 2014 till present

Creates and maintains all databases required for development, testing, and production usage.

Performs the capacity planning required to create and maintain the Databases.

Performs ongoing tuning of the database instances.

Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.

Plans and implements backup and recovery of the Oracle database.

Controls migrations of programs, database changes, reference data changes and menu changes through the Implements and enforces security for all of the Oracle Databases.

Performs database reorganization as required to assist performance and ensure maximum uptime of the database.

Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.

The DBA is usually the point of contact for Oracle Corporation.

Enforces and maintains database constraints’ to ensure integrity of the database.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

Assists with impact analysis of any changes made to the database objects.

Troubleshoots with problems regarding the databases, applications and development tools.

Create new database users as required.

The DBA has ultimate responsibility for the physical database design Commercial international life assurance CIL DBA Supervisor from Jun 2013 till August 2014

Assess and develop long-term strategic goals for production database in conjunction with data owners and department managers.

Work with application development staff and quality assurance policies and procedures.

Create models for new database development and / or changes to existing ones.

Install and configure relevant network components to ensure database access as well as database consistency and integrity

Respond to and resolve database access and performance issues

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

Design and implement redundant system policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Monitor, optimize and allocate physical data storage for database system.

Plan and coordinate data migrations between systems.

Develop, implement, and maintain change control and testing processes for modification to database.

Create, or support creation of, required reports in response to business user needs.

Conduct research and make recommendations on database production, services, protocols, and standards in support of procurement and development efforts.

Perform database transaction and security audits.

Establish appropriate end-user database access control levels.

Develop routines for end-user to facilitate best practices database use.

Manage and/or provide guidance to junior members of the team. Successful projects that I’ve worked on

migrate main system RAC from windows system with oracle standard edition to Linux OS with oracle RAC enterprise edition

implement test server for business intelligent system on Linux server

integrate all system with oracle grid control system Telecom Egypt DBA Manager from July 2001 till Jun 2013 Junior Oracle Database Administrator from July 2001 till July 2003. Oracle Database Administrator from July 2003 till July 2006. Sr. Oracle Database Administrator from July 2006 Jun 2010. DBA Manager from July 2010 to Jun 2013.

Responsible for administering, installing, configuring, supporting & the maintenance of all database components.

Planning & maintaining of back-ups & recovery procedures.

Installation and maintenance of database server & application tools.

Analyze the overall database environment, identifies trends in database operation and evaluating the impact on the existing environment.

Ensure all database related problems are resolved in a timely manner to minimize user impact.

Coordinate and perform oracle database installation and upgrades.

Responsible for managing & controlling security.

Install Oracle RDBMS and oracle applications, under the advice of an Oracle technical consultant.

Allocating system storage and planning future storage requirements for the database system.

Modifying the database structure, as necessary, according to the information given by application developers.

Ensuring adhering to Oracle license agreement.

Controlling & monitoring user access to the database.

Maintaining archived data on tape.

Contacting Oracle Corporation for technical support.

Ensuring that the associated hardware resources allocated to the databases and also ensuring high availability and optimum performance.

Working professionally with Oracle tools and managing oracle by grid control, enterprise 10g, 9I.

Monitoring and optimizing performance tuning by ASH, ADDM and AWR.

Solving technical problems reported by user departments related to the existing applications.

Installing Oracle Software on different platforms such as Windows Server 2003, UNIX and Linux.

Patching the Database from 10g to 11g.

Knowledge of real application cluster and data guard. Successful projects that I’ve worked on:

MAXIMO where I have installed real application cluster 10g R2 on operating system AIX 5L and installing critical patch update (CPU) and also implemented RMAN for backup.

ITSM where I have installed Oracle database 10g R2 on operating system AIX 5L and also installed base release and patch it to 10.2.0.4.

Reporter Production & Test where I have installed Oracle database 10g R2 on operating system AIX 5L.

Fraud System where I have upgraded the database from 9i to 10.2.0.4. on operating system sun Solaris (SPARIC) which consists of 3 servers Fraud, Diamond & CRR.

Billing System where I have upgraded to 10.2.0.4 on operating system HPUX – Itanium and monitoring the system check the backup using RMAN.

Training Courses:

Project manager professional ( PMP ) Year:2016

Oracle 11g New Feature, Oracle Egypt. Year:

Oracle 10g R2 Real Application Clusters, Oracle Egypt. Year:

Tuning DB with status back, Oracle Egypt. Year:

RAC Session, Oracle Egypt. Year:

Data Mask, Oracle Egypt. Year:

Database Vault, Oracle Egypt. Year:

Security Overview, Oracle Egypt. Year:

RMAN Session, Oracle Egypt. Year:

Implementing OCM (Oracle Configuration Manager), Oracle Egypt. Year:

Implementing RMAN, Oracle Egypt. Year:

Oracle Database 10g: Backup and recovery, Orascom Telecom. Year:

Oracle Database 10 g administrators, Orascom Telecom. Year:

OCA Oracle Database 10g, Orascom Telecom. Year:

Oracle 9i Database Security, Oracle London. Year:2006

Oracle 9i Database Performance Tuning R2 ED 2, Oracle London. Year:2006 Languages:

Arabic: Mother Tongue

English: Very Good.

Personal Information:

Date of Birth: 11-November-1976.

Nationality: Egyptian.

Military Status: Exempted.

Marital Status: Married.

Telephone Numbers: 010*-**-**-***

Email: acyb9p@r.postjobfree.com

Facebook Page: Oracle DBA Issues

References are furnished upon request.

Contact this candidate