Sameh Shehata
Mississauga, Ontario L5M7V1
Mobile: 437- 888-4272
**********@*****.***
Professional Summary
More than seven years of Oracle database administration experiences for various kinds of applications in UNIX and NT environments. Over ten years of IT working experience with background of technical problem solving. A self-motivated, responsible, and reliable team player with a set of very strong technical skills.
Core qualification
Oracle Database Administration
Oracle System Modeling and Tools
Oracle Developer
(SQL, PL/SQL, Forms, Reports)
Unix/Linux, Windows server
JAVA, C++, C#, PHP
HTML,XML, CSS
Professional Experience
Montreal college, (Montreal, Quebec) 2014
Oracle Database Administrator
Creates and maintains all databases required for development, testing, education and production usage.
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.
Implements and enforces security for all of the Oracle Databases.
Performs the capacity planning required to create and maintain the databases.
Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.
Ministry of Health 2005-2011
Oracle Database Administrator (2007-2011)
Played a lead role in enterprise-wide database optimization and instance and resource monitoring. Performed root cause analysis on failures. Resolved performance tuning related issues, reports, and queries. Worked actively on 11g features such as AWR, ADDM, performance statistics collection, and fine tuning database wait events. Provided on-call support for enterprise databases. Tasks included:
Installation of the Oracle database software
Planed the database
Create and open the database
Back up the fully functional database
Started and managed biweekly optimization meetings with enterprise user groups to address and resolve performance-related issues with a high degree of success.
Identified, led, and established automation of repetitive processes to minimize errors.
Completely eliminated space errors by implementing proactive space monitoring and effective space allocation.
Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.
Oracle Developer (2005-2007)
Developed and implemented financial medical health programs using ORACLE DEVELOPER FORMS & REPORTS
Browse, create, edit, and delete schema objects
Execute SQL statements
Edit and debug PL/SQL program units
Manipulate and export data
Create and display forms and reports
Achievement:
Accomplished the first project developed by ORACLE program
Depositing and registration certificate of a computer program to record patients named cure, ( a patient registration system & costs of medications by international codes) (ICD-O & ICD-10) for names of diseases (Intellectual Property registration #00174, July 26, 2006) Designed
Education / training /certification
Vanier CEGEP/college, (Montreal, Quebec) 2015
Web and Database programming (AEC)
Oracle university 2014
Oracle certified Professional (OCP-DBA)
Montreal college, (Montreal, Quebec) 2014
Diploma in Oracle Database Administration
John Abbott CEGEP/college, (Montreal, Quebec) 2013-2014
Computer science
The American University 2005
Certificate in Oracle System Modeling and Tools
Hobbies and Interests
Playing chess
Soccer
Ping-Pong
References available upon request