Customer Service Management

*********@*****.***

Cell : +1-403-***-****

Calgary, Alberta

Ahmed Mohamed

Brief

Canadian Citizen, 9 years experience Administer, Develop, install, Upgrade, Backup, Recovery and trouble shoot Oracle & SQL Server database problems, areas of expertise include database Analysis, Design,Development, Administration, Performance, and tuning as well as Support and Training. Holds an OCP ADMINISTRATOR and OCP DEVELOPER from ORACLE University plus SQLserver 2012.

Technical Skills

Highly motivated, skilled communicator, team player and ability to work in fast-paced & dynamic environment.

Support & Customer service oriented and Team Management Skills.

Willing to learn any new or special knowledge, tools skills or technologies .

Installation/Configuration & Upgrade/Migration/patching Oracle databases ORACLE 8i/9i/10g/11g through different platforms.

Hands on experience DB reorganization, performance maintenance & statistics Plus advanced features like FLASHBACK, AWR, and ADDM.

Performance tuning for database, instance, SGA, I/O, using Enterprise Manager (OEM), TOAD, STATSPACK, SQL Trace, TKPROF and Explain Plan.

RAC (Real Application Cluster) management . & Standby database management .

RMAN, Sql Loader, export/import and Data pump utilities for Database migration, backup, recovery, refresh, moving data and snapshot replication .

shell scripting & Crontab schedules.

Oracle (8i/9i/10g/11g), Developer/2000 (Forms 6i/10g, Report 6i/10g), SQL and PL/SQL.

System Architecture Design and Application Design logical & physical based on Business Logics.

Develop PL/SQL stored procedures, functions, Packages and Triggers for administering and maintaining database and for application development

Analyze Oracle diagnostic reports, trace files and alert logs.

Experience

CGI http://www.cgi.com/en/canada

May 2013 – Present Oracle & SQLSEVER DBA

RDBMS installation, patching & configuration

Clint account management through Proactive system monitoring, Backup & recovery procedures & methods using RMAN, data pump & cold OS backup.

Identify failure modes to assist in timely maintenance, Investigation and follow up on root cause analysis to avoid service disruption.

Install, backup & restore, migrate data and maintenance for SQL SERVER

Perform 24x7 on call rotation services for clients systems.

Stored procedures development (PL/SQL and TSQL)

Materialized view and database link

Refresh database using snapshot technology

Database security and hardening

Database performance tuning and monitoring

SQL server management studio

Indexing, partioning, hints & optemizers

Data migration though different OS or database versions

Experience

Mount Royal University http://www.mtroyal.ca/

Mar 2011 – May 2013 Oracle DBA

Upgrading and patching of Oracle products.

Upgrading and patching of third party software (i.e. Banner).

Participate in database design, data migration and conversion, and vendor product evaluations for applications running on RAC database .

Ensure stable operating environment for clients and developers.

Monitor databases and reviews performance logs.

Monitor/setup data base backup and recoveries.

Facilitate Oracle access.

Recommend actions and provide analysis and troubleshooting for possible hardware, software, network,

process, and system failures.

Assist in the development/deployment of data warehouse

Maintain an awareness of system usage, departmental projects and users.

Liaise with Client Support, Networking and Server Groups to schedule necessary infrastructure changes.

Liaise with third party vendors.

Support analysts in application development activities.

Experience

Talisman Energy (6 month contract) http://www.talisman-energy.com/

OCT 2010 - Mar 2011 Oracle Database Administrator

Analyze, design, develop, deploy and implement new database systems

Support applications development in areas requiring database skills

Provide support in database modifications and design structures

Install and maintain database software with upgrades or patches

Develop and maintain data backup and recovery systems

Develop and maintain database design documentation and meta data

Provide after-hours on-call support of production environment

Analyze and performance tune databases

Assist in helpdesk calls using Remedy

Experience

Critical Mass (6 month contract) www.criticalmass.com

Mar – Sep 2010 Oracle Database Administrator / Developer

• Project participation in (Nissan Leaf) USA & internal database applications .

• Convert system designs and technical specifications into program code

• Work with disparate clients to identify and implement data management processes

• Write SQL, PL/SQL and UNIX scripts to fulfill data management requirements

• Assist in planning logical and physical database architectures

• Install and configure database management systems

• Participate in project meetings to focus on and identify database requirements

Experience

ITWorx www.itworx.com

Nov 2007 – Nov 2009 Oracle Database Administrator

Internal support and customers support .

Project participation in (SYNGENTA SEEDS) SWISS & (United Technologies UTC) USA .

Installing and maintaining Oracle database.

Work closely with developers in designing schemas .

Providing 24x7 support to production customers.

Experience

FUJITSU Services http://www.fsegypt.com/eg/about/about.html

JAN 2006 – Nov 2007 Oracle Developer

Worked as Oracle developer at the (E.R.P.) section.

Participate in development of H.R. module.

Performing oracle forms creation and amendments.

Performing oracle reports creation and amendments.

Database Logical Design .

Database Physical Design .

Data management.

Technical Qualifications

2006 ORACLE ( O.C.P ) Developer & Administrator FUJITSU Training Center

RAC (Oracle Real Application Clusters) .

Performance Tuning.

SQL Tuning.

Grid Control.

Administration workshop1

Administration workshop 2

Oracle 10g Reports.

Oracle 10g Forms

Oracle 10g PL/SQL.

Oracle 10g SQL.

Oracle Advanced PL / SQL.

Physical Data Base design

Logical Data Base design.

Data Modeling.

Soft Skills

2006 FUJITSU Training

Communication Skills .

Presentation Skills .

Team Working .

Customer Service.

Sales Fundamentals .

Marketing Essentials .

Technical & Business Writing.

Problem Solving and Decision Making .

Business Studies

2003 American University in Cairo (AUC)

Preliminary studies of Business Administration (3 courses).

Principals of Management .

Principals of Marketing .

Principals of Organizational Behavior .

Contact this candidate