Database Administrator System

Mohamed Ahdab

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

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

www.linkedin.com/in/mohamed-ahdab-2b139619

AREAS OF EXPERTISE

oOracle Database.

oOracle Cluster ware.

oData guard.

oRecover Manager.

oInterfacing with other Applications.

oBackup Database.

oDisaster &Recovery Database.

oClone Database.

oPatch Update.

oOracle Installation.

oOracle RAC installation.

oE-Business Suite administration.

oGolden gate.

oAix / Linux / UNIX.

oWindows.

Profile

• Oracle DBA with 17 years of experience in database administration,

3 years’ administration E-Business suite, providing 24x7 production support

and development support 12c, 11g R2, 10gR2, 9i databases on different platforms

with practices for Oracle database infrastructure, standards and implementation.

• Extensive experience in Installations, configuration, cloning, security, patching, upgrades.

• Database backup and recovery using RMAN including duplicating, cloning databases.

• Installation and configuration of Oracle 10g, 11g, 12c using cluster ware and ASM.

• Strong experience in RMAN.

• Experienced in installation and configuration of Oracle primary and standby (Data guard)

database and switchover/switchback of database in 10gR2 /11gR2, 12c.

• Experience in multi-node and RAC environments.

• Created development, testing, staging, production, RAC and standby databases enabling

load balancing.

• Monitor database backup Jobs and necessary actions for failed backup jobs

Including script corrections, disk space monitoring and database availability.

• Setup procedure for database statistics gathering – frequency, best time of the day to

execute stats gathering jobs.

• understanding of oracle utilities SQL Trace, ASH, SQL Tuning Advisor Explain Plan, TKPROF, AWR, ADR.

• Creating roles, profiles, privileges and assigning roles to users.

• Extensively worked on monitoring and optimizing the database by performance tuning.

• Hands on experience with various tools like SQL*Loader, TOAD and Oracle Enterprise Manager (OEM).

• Developing shell scripts and SQL scripts to carry out routine checks on databases.

• Implemented proactive monitoring scripts for production databases.

• Troubleshooting for slow performing SQL by enabling database tracing including session

Specific tracing. performed SQL tuning using Explain Plan.

• Create database trigger, stored procedure and packages PL/SQL coding.

• Knowledge of Oracle Support Process for Technical requests using Oracle Metalink and

their support procedures.

• Identifies server hardware, software and configurations necessary for running databases.

• Result oriented, Self-motivated, Team Player, Ability to work independently and can work

during weekends and on-call rotations for support and maintenance activities.

•Technical support for client, configuration, install software, install application

, update patch, fix problems and troubleshooting.

Work experience

Oracle Database Administrator Desjardins Technologies Group

2020 Current

Installation and configuration of Oracle 110g, 12c, 19 using Cluster ware and ASM.

Configuration security, installation database and upgrade database.

Backup and recovery database using RMAN including duplicating, cloning Databases.

Installation and configuration of Oracle primary and standby (Data guard).

Work with multi-node and RAC environments.

Created development, testing, staging, production, RAC databases enabling load balancing, failover.

Monitor database backup Jobs and necessary actions for failed backup jobs.

Monitor database activity, disk space monitoring and database availability.

Troubleshooting.

Technical support for client, configuration, install software, install application,

update patch, fix problems and troubleshooting.

Oracle Database Administrator Fourth Dimension Computers

Mississauga, Canada 2017-2019

Building database structure for any new project.

Installation and configuration of Oracle 10g, 11g,12c.

Configure Oracle RAC.

Troubleshooting for slow performing SQL.

Creating roles, profiles, privileges and assigning roles to users.

Work with multi-node and RAC environments.

Configuration security, installation database and Upgrade database, cloning.

Understanding of oracle utilities SQL trace, ASH, SQL Tuning Advisor, Explain plan, TKPROF, AWR, ADR.

Technical support for client, configuration, install software, install application,

update patch, fix problems and troubleshooting.

Senior Oracle Database Administrator &Apps King Fahd Armed Forces Hospital Jeddah

Jeddah, Saudi Arabia 2006-2017

Installation and configuration of Oracle 10g, 11g, 12c using Cluster ware and ASM.

Configuration security, installation database and upgrade database.

Backup and recovery database using RMAN including duplicating, cloning Databases.

Installation and configuration of Oracle primary and standby (Data guard).

Work with multi-node and RAC environments.

Created development, testing, staging, production, RAC databases enabling load balancing, failover.

Monitor database backup Jobs and necessary actions for failed backup jobs.

Monitor database activity, disk space monitoring and database availability.

Understanding on oracle utilities SQL trace, ASH, SQL Tuning Advisor, Explain plan, TKPROF, AWR, ADR.

Creating roles, profiles, privileges and assigning roles to users.

Extensively worked on monitoring and optimizing the database by performance tuning.

Hands on experience with various tools like SQL*Loader, TOAD, Oracle Enterprise Manager (OEM).

Developing shell scripts and SQL scripts to carry out routine checks on databases.

Implemented proactive monitoring scripts for production databases.

Troubleshooting for slow performing SQL by enabling database tracing including session Specific tracing. Performed SQL Tuning using Explain Plan.

Create database trigger, stored procedure and packages PL/SQL coding.

Knowledge on Oracle support process for technical requests using Oracle Metalink.

Make procedures to interface with another applications and databases.

Technical support for client, configuration, install software, install application,

update patch, fix problems and troubleshooting.

Senior Oracle Database Administrator System Data Software (SDS)

Jeddah, Saudi Arabia 2002-2006

Installation and configuration of Oracle 10g, 11g, 12c using cluster ware and ASM.

Configuration, cloning, security, installation database and upgrade database.

Backup and recovery database using RMAN including duplicating, cloning databases.

Installation and configuration of Oracle primary and Standby (Data guard).

Work with multi-node and RAC environments.

Created development, testing, staging, production, RAC databases enabling load Balancing, Failover.

Monitor database backup Jobs and necessary actions for failed backup jobs.

Monitor database activity, disk space monitoring and database availability.

Setup procedure for database statistics gathering - frequency, best time of the day to Execute stats gathering jobs, correct level of gathering statistics.

Understanding of oracle utilities SQL trace, ASH, SQL Advisor, Explain plan, TKPROF, AWR, ADR.

Creating roles, profiles, privileges and assigning roles to users.

Hands-on experience with various tools like SQL*Loader, TOAD, Oracle Enterprise Manager (OEM).

Developing shell scripts and SQL scripts to carry out routine checks on databases.

Implemented proactive monitoring scripts for production databases.

Troubleshooting for slow performing SQL by enabling Database tracing including session Specific tracing. performed SQL tuning using explain plan.

Database trigger, stored procedure and packages PL/SQL coding.

Make procedures to interface with other applications and databases.

Technical support for client, configuration, install software, install application,

update patch, fix problems and troubleshooting.

Education/training:

Oracle Certified Database Administrator 12C(OCP12C).

Oracle Certified Database Administrator 10G(OCP10G).

Oracle Certified Database Administrator 9I(OCP9I).

Oracle Certified Database Administrator 8I(OCP8I).

Microsoft Certified Systems Engineer Messaging (MCSE).

Hadoop Administrator.

Project Management(PMI) course.

Bachelor’s degree in computer engineering – Aleppo university.

Contact this candidate