Oracle Sql

Gamal Ali

Phone: 647-***-****

Email: **********@*******.***

CORE COMPETENCES

Senior Oracle Developer with over 18 years of experience in Information

Technology (IT) with specialization in the Analysis Design, Development, Testing, and

Database Development of Oracle PL/SQL based applications in the IT sector.

Written and modified number of stored procedures, functions, packages, triggers

to handle logical units of work at a back-end side using PL/SQL.

Oracle Forms (6i, 9i, and 10g), Oracle Reports.

Extensive experience in writing/debugging Oracle Back-end PL/SQL development

i.e. Packages, Stored Procedures, Functions & Triggers.

Strong knowledge in using Oracle built-in packages, Cursor management and

Exception handling.

Experience in Oracle (SQL, PL/SQL, Stored Procedures, SQL Loader)

Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.

Involved in all phases of the SDLC (Software Development Life Cycle) from

analysis, design, development, testing, implementation and maintenance with timely

delivery against aggressive deadlines.

Experience with Data flow diagrams, Data dictionary, Database

normalization theory techniques, Entity relation modeling and design

techniques.

Expertise in Developing UNIX Shell Scripts to call the newly build PL/SQL

programs through shell scripts for automating batch programs.

Extensive experience in creating and maintaining Database Objects like Tables,

Views, Materialized views, Indexes, Constraints, Sequences, Synonyms and Database

Links.

Effectively made use of Table Functions, Indexes, Table Partitioning,

Collections, Analytical functions, Materialized Views, Query Re-

Write and Transportable table spaces.

Strong experience in Data warehouse concepts, ETL.

Good knowledge on logical and physical Data Modeling using normalizing

Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function

Based).

Highly skilled in Performance tuning - analyzing query plans and query tuning

using the tools such as EXPLAIN PLAN and use hints wherever required.

Experience in advanced PL/SQL concepts like Bulk collect and forall.

Expertise in Dynamic SQL, Records, Arrays and Exception Handling.

Supported primary production on call for critical applications for good amount of

time.

Well versed with onsite-offshore model with close customer relationship.

Experience in database design and performance tuning.

1

Proficient in Banking, Financing, Telecom and medical.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL,

DBMS_JOB and UTL_FILE.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Good knowledge of key Oracle performance related features such as Query

Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain

Plan and HINTS.

WORK HISTORY

Canadian Career College – Instructor of Oracle Administration & Development

from 2nd January 2014 – present

Instructor for: -

Oracle 11g database administration fundamental [I]

Oracle 11g database administration fundamental [II]

Oracle forms developer 10g – build internet applications

Hewlett-Packard HP Nonstop SQL/MX, SQL/MP, and Oracle Database

Consultant from 12th June 2013 – 27th December 2013

Implement change on SQL/MX & SQL/MP databases

Install and configure Oracle Golden Gate: Manger, Data Pumps, extract and

replicate between HP SQL/MX, IBM DB2 and Oracle EXADATA

Debugging GG issues such as abending, trace and troubleshooting

Administrate the users privileges on the database

Monitor the database and engine growth & performance.

Support CMA data migration and ATM switch development projects for CIBC

Bank.

Sheridan College - Professor of Enterprise Database Management, Oakville –

from 2nd Feb 2012 - Present

Teach Oracle Administration Fundamentals [1] and [2] including Oracle 11g R2

performance tuning, troubleshooting and RMAN Backup /Recovery

Research In Motion (RIM) - Database Consultant – (short term contract) –

Waterloo - from 20Th August 2012 - 16th November 2012

Analyzed project data requirements.

Determine Service Level Requirements, Analyze & Plan Capacity for current and

future processing requirements to ensure that the organization will be prepared for the

future, ensuring that service level requirements will be met using an optimal

configuration.

Developed Entity Relationship Diagrams (ERDs) USING ERWIN as part of overall

data tier model to support project requirements.

Developed/modified Packages/Stored Procedures/Functions/Database

Triggers, also worked on Forms, and Tuning the SQL queries.

2

Documented designs in database design/CASE Tool (Oracle Designer)

Developed physical database designs based on logical ERDs

Generated and writing data dictionary language (DDL) statements in SQL to build

database objects

Built database structures and programs in Oracle

Developed security procedures and programs to protect sensitive data

Followed established configuration management (CM) practices and procedures

Analyzed project database performance requirements including Oracle 11g tuning

performance through utilizing Advisors Framework.

Performed bug fixes and technical enhancements.

InTech – Database & Development Consultant, Toronto - from 10th April 2011 -

30th July 2012

Developed business applications for keeping tracking records for customers,

suppliers, items, and the movement of items in the store.

Developed Packages/Stored Procedures/Functions/Database Triggers

related to Oracle R12 functionality, modified some Forms/Reports

Facilitated companies to email their customers’ bills.

Enabled inserting items data through bar-code device.

Oracle technologies used: SQL/PL-SQL used to develop the business logic to be

stored as procedures, functions, and triggers inside the database.

Assisted a number of companies in maintaining their databases via monitor the

systems’ performance, measure the Hit/Ratios using EM-Advisors Frameworks, review the logs (e.g. Oracle-alert log & Trace logs, transactional-logs e.g. POS log, ATM

log) daily to diagnose and fix problems.

Environment: Oracle EBS R12, ORACLE 11g, PL/SQL Developer, TOAD, SQL,

PL/SQL, Mercurial, Windows XP, UNIX, MS Office.

Collected Oracle Database statistics e.g. Tablespace sizes, Data files sizes, etc.

Kuwait Finance House (KFH Bank) - Database Administrator / Database

Analyst/Database Senior Compliance Officer - from 21st November 1998 – 10th

February 2011

Database senior compliance officer (from 1st December 2008 10th February

2011)

Technical Team leader in the project of (IDMP) Identity Management Project

that is for managing user-access over wide-range of transactional system under one

system, designed & developed integration-packages with underlined databases

Sybase, Oracle, MS SQL Server 2005/2008, and Non-Stop SQL (HP Tandem)

Practiced database security assessment (Oracle, Sybase, and MS SQL Server)

i.e. Penetration testing plan and implement hardening procedures and fixes.

Prepared and analysed risk along with compliance-related information and

3

reports, especially those pertaining to data breaches involving the Systems Division.

Compiled and reviewed materials for external and internal IT audit or compliance

reviews.

Ensured audit findings in order to work with systems teams to develop action

plans to mitigate risk and to update policies as appropriate

Investigated and accurately recorded the details of data privacy events ensuring

that all compliance requirements are met.

Applied ITIL concepts and processes per comply with ITIL Standards e.g.

when an incident occurs, identified and recorded the immediate causes as well as the

root causes of the incident. When an incident is repeated, raised it to be problem. If

problem, user/business consultant/support system consultant should issue problem

request (PR) that should assigned to development section or vendor for permanent

solutions.

Banking - Database Analyst from 11th March 2004 to 20th December 2008

Installation, Creation and support of Oracle 8i database environments.

Involved in the maintenance and enhancement of the application.

Maintaining Logical and Physical structure of the database.

Creating scripts for automatic operations of the database activities.

Coded various stored procedures, packages and triggers to incorporate business

logic into the application.

Used the technical document to design the database tables.

Data conversion from flat file to intermediate tables using SQL*Loader, Data

mapping

Created control files for SQL*Loader.

Gather Database and User Level Statistics and Analyze Overall System

Performance.

Designed/developed tables, views, various SQL queries, stored procedures,

functions.

Monitor database and system backups, developed Oracle Stored procedures,

functions, packages, and triggers that pull data for reports.

Develop UNIX shell scripts to administer the system.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary

Tables.

Responsible for purging and archiving the production databases.

Used UTL_JOB to automate the PL/SQL procedures and packages.

Involved in Interacting with users, error fixing by enhancing PL/SQL packages,

stored procedures & functions.

Data conversion from flat file to intermediate tables using SQL*Loader and also

created control files for SQL*Loader.

Communicate issues and progress to project manager.

Performed logical backup using export and import utilities.

4

Developed database objects including tables, Indexes, views, sequences, packages,

triggers and procedures to troubleshoot any database problems.

Involved in Unit Testing Stored Procedures and Functions

Created SQL*Loader scripts to load data into the temporary staging tables.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Involved in uploading of the data from flat files into Databases and validated the

data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database

structures, according to the requirements

Created various SQL and PL/SQL scripts for verification of the required

functionalities.

Developed complex SQL queries for data retrieval from various database objects

including tables and views.

Worked on various backend Procedures and Functions using PL/SQL.

Database Administrator /Systems Analyst – from 21st November 1998 - 10th

March 2004

Performed database administration, monitoring, and tuning for 25 large

databases (VLDB) running under varied windows versions and UNIX (Sun-Solaris) within

team.

Developed Advance PL/SQL packages, procedures, triggers, functions,

Indexes and Collections to implement business logic using SQLNavigator. Generated

server side PL/SQL scripts for data manipulation and validation and materialized

views for remote instances.

Key person in implementation of Oracle Financial Application and Oracle

Human Resources systems as well as implemented the encryption for securing

business transactions

Supported integration application between KFH and Central Bank of Kuwait

(.net technology, asp.net)

Key member in the project of integration between KFH and first Data Europe

(FDE)

Key member in the project of developing integration between KFH and

Central Bank of Kuwait (CBK system)

Developed an integration interface application between KFH and First

Data Europe (VISA)

Developed data integration, transfer, and conversion processes between

Oracle10g database on windows and non-stop SQL database on Tandem

(Mainframe)

ACADEMIC AND TEACHING EXPERIENCE, to 2009

Arab Open University (AOU) - Kuwait Branch Associate Lecturer – from 14th

September 2006 - 26th June 2009

As an Associate Lecturer with the AOU, I have tutored up to 25 students in CS490

- Business Application Development, (Oracle/MS SQL Server 2005) and T171-

electronic Learning.

5

Tutor for T320 (e-business Technologies), Quality and economic Institute –

Kuwait

As a tutor for e-business technologies I educated the e-business concepts and the

internet protocols, the basic of XML. How the Internet and web technologies are

driving fundamental changes and the way that businesses interact.

Web services, examines the technical and business motivations behind the

development of web services.

Orchestration: Real web services perform small discrete tasks, implementing a

business process.

Oracle instructor at number of institutions in Egypt and Kuwait

Presented a wide range of Oracle Corporation certified DBA classes covering versions

7, 8i, 9i, 10g, and 11g. The classes included Introduction to SQL and PL/SQL,

Database Architecture & Administration, Backup & Recovery, Performance Tuning,

Networking, and Database Access (total 32 classroom days).

During my employment with these institutions, I was also responsible for sundry

development projects, including a web based course reservation systems and

instructor scheduling systems.

Zima International - Senior Database Consultant (Part Time) Oct 2007 - Feb

2011

Developed Packages/Stored Procedures/Functions/Database Triggers

DATA MIGRATION from legacy systems (Mainframe) to Oracle

Created UNIX shell scripts

Actively took part in meetings with the client

Environment: ORACLE 11g, PL/SQL Developer, Oracle SQL Developer Data

Modeler, SQL, PL/SQL, XML, Mercurial, Windows 7, Office 2010

EDUCATION & CERTIFICATES

Degree

Graduation Date

Master of Computer Science –University of Huddersfield - UK Oct 2006

Postgraduate Diploma of Computer Science in Commercial Fields – May 1996

Ain Shams University

May 1993

Bachelor of Business Administration

Certified ITIL v3 Version Foundation Aug 2011

Certified Oracle 10g (OCP) DBA – Oracle Corporation June 2008

Certified Sybase Professional (CSP) Oct 2004

Certified Oracle Internet Application Developer – Oracle Corporation Dec 2001

Certified Oracle 8i (OCP) DBA – Oracle Corporation May 2001

Postgraduate Course (Business Administration) – Sadat Academy Nov 1998

Accomplished PMP course July 2012

I work now on upgrading into OCP 12c

References available upon request

6

7

Contact this candidate