Data Sql Server

Mohi

Profession: Oracle Database Administrator

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

Phone: 619-***-****

Education:

B.Com

Certifications:

Certified Oracle Database Administrator

Career Summary

Experience in the following areas of Oracle Database Administration

Oracle 12c Multitenant Databases

RMAN

VMWare

Database Upgrade

Real Application Cluster (RAC)

SQL Loader

Linux, RHEL

User Management

Real Application Testing (RAT)

Export Import

Solaris

Oracle Security

Automatic Storage Management (ASM)

Data Pump

Windows

ASH, AWR and ADDM

Tablespace Management

SQL Trace

SQL Server

SPA, Hints, Indexes

CPU / PSU / One off Patching

Tkprof

Log shipping

12c Cloud Control / OEM

SQL Developer / ERWIN / TOAD

Shell scripting

On-call support

Oracle Data Guard

RMAN Backups / Restore / Recover

DB Cloning

Exadata

Oracle GoldenGate

PROFESSIONAL EXPERIENCE

HP Enterprise Services

Dec 2010 – present

Oracle DBA

Role & Responsibilities:

Build multiple 2 node RAC Clusters on Linux.Unix

Creating user Accounts

Alter user Accounts

Build 12c Multitenant databases

Worked on upgrade and migration projects.

Cloned database suing RMAN duplicate database feature.

Used data pump, RMAN duplicate database and export/import for data moment.

Set up grid control alerts and thresholds.

Build Linux servers and build 12c standalone database server.

Moved database from one data center to another using data guard.

Configured / Managed ASM disks and disk groups

Worked with Different teams to completed Build tasks.

Created documents to speed up future builds.

Upgraded databases from 10g to 11g R2 to 12c

Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor.

Implemented an efficient RMAN backup and recovery strategy

Performed data file and point in time recovery.

Refreshed data using exp/imp and data pump on a regular basis.

Build 2-node, 4-node RAC Cluster from scratch.

Helped in improving the performance by using the many techniques like Hints, Indexes, collecting stats, histogram tuning, sql tracing, explain plan, ASH, AWR, ADDM etc. Performed tuning of SQL statements using tkprof.

Installed databases on Exadata

Patched Exadata servers

Administered VMWare environments.

Used 12c Cloud Control to monitor and administer databases.

Create and maintain multiple databases.

Created servers to install multiple 11g databases on RHEL5.

Installed and Administer SQL Server 2008 R2

Manage Backups, Log shipping, Restores, Patching SQL Server on Windows clustering.

Set up 11g Physical standby Data Guard and Active-Active Data Guard.

Configure Application user accounts, user profiles and monitoring application security

Tablespace management including, adding/resize data files, allocated quotas to user

Setup and documented Oracle GoldenGate replication on 11g for support team.

Created, restore and duplicate database on oracle Exadata.

Perform Backup and Recovery thru RMAN.

Strong experience in Installing, configuring, maintaining Data Guard environment.

Strong experience in patching databases.

Worked on locking and issues with latches

Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.

Used ASH, AWR & ADDM tools to troubleshoot performance

Used TOAD, Grid Control, and SQL Developer as GUI tools aside from terminal.

Provided on-call support.

Conducting Installations of Oracle 10g, Oracle 11g on standalone servers

Worked on Migration Projects.

Saudi Soft

Jeddah, Saudi Arabia

May 2007 – Dec 2010

Oracle Database Engineer

Roles & Responsibilities:

Build and managed RAC databases.

Primary DBA for 20 database for 24/7 support.

Worked on OLTP and Data warehouse farms.

Refreshed multiple databases for Development and Testing upon short request.

Actively involved in designing/Testing of Disaster Crash recovery.

Created and maintain users, roles and privileges.

Perform Backup and Recovery thru RMAN.

Strong exposure in Installing / configuring / maintaining RAC, Data Guard

Applied Quarterly CPU patches on a regular basis.

Performed Export/Import through Data Pump.

Build Grid control for Monitoring 40+ database.

Provided technical troubleshooting and give consultation to development teams.

Implemented basic replication through Materialized Views.

Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.

Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Upgraded Databases from 10g to 11g R2.

Fully documented 11g Golden Gate installation for internal DBA team members

Build database servers on VMWare.

Performed work on Capacity planning

Applied patches

Worked on 11g grid control

Create and maintain multiple databases.

Create multiple 11g databases on RHEL5 in development.

Created and maintain users, roles and privileges.

Diagnosed Oracle bugs

Performed Export/Import through Data Pump.

Worked on basic replication through Materialized Views.

Al-Bukhari

Dammam, Saudi Arabia

Jan 2005 – Apr 2006

Jr. Oracle DBA

Responsibilities:

Performed RMAN backups (full backups, archived log backups and incremental backups).

Backed up/refreshed databases, schemas using exp/imp and data pump (expdp, impdp).

Installed and configured SQL Server databases based on documentation...

Performed Metalink research, opened tars, identified bugs, found technical solutions, etc.

Altering the Database objects and files during maintenance.

Load data using SQL*Loader

Scripts for Complete and Hot backup,

Create database-links

Create snapshots, views, remote procedure calls on the remote databases,

Granting roles and Security Management using roles and privileges.

Create and maintain multiple databases.

Perform client installation

Used TOAD for many database management tasks.

Contact this candidate