Manager Oracle

Ali Sharif

Oracle DBA

Phone: 1-920-***-****

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

Skills Summary

* ***** ** ****** *** experience

Real Application Clusters (RAC)

Managed 9i, 10g, 11g and 12c Databases

Performance Tuning

SQL Query Execution Plan

Security Administration

Replication

Distributed Databases

Disaster Recovery Solutions

Database Design

System Design

Data Modeling

TOAD

24/7 on call support

Tablespace Management

User Management

One off, CPU and PSU patches

Data Center Migration

Recovery Manager (RMAN)

Standby Database Solutions

Oracle Enterprise Manager (OEM)

Automatic Storage Management (ASM)

11g Grid Control

12c Cloud Control

Unix Shell Scripting

PL/SQL

Windows.

RHEL, OEL, CentOS

UNIX, HPUX, Mainframe, AIX

Database troubleshooting

Network troubleshooting

Coordination with Offshore DBAs

Extent Management

Segment Management

Database Upgrade

Cross platform Migration

Work History

Oracle DBA

Nordic, Madison, WI

Jan 2013 to Present

Responsibilities:

Involved in 24x7 support for production RAC databases with on-call pager

Managed database on 11g R2 RAC

Setup Data Guard between multiple data centers

Installed 12c Databases

Upgrade to 12c Multitenant databases.

Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities

Performed converting single node instance to RAC and Adding instance to the existing RAC

Create and manage Enterprise Manager jobs, alerts and notifications

Analyzed and wrote various Stored procedures, Functions, Triggers to be created at the backend database to cater for the entire application

Managed ASM instance and ASM disk groups

Installing ASM environment and migrating database from NON-ASM to ASM

Worked on several Shell scripts to maintain the database activities

Configured the Flash Recovery Area

Monitor performance through Grid control

Cloned databases using Export Import, Data Pump and RMAN Duplicated Databases.

Created and maintain users, roles and privileges.

Perform Backup and Recovery thru RMAN.

Migrated database from non-ASM to ASM

Clone databases using RMAN duplicated

Worked on database security.

Provided technical troubleshooting and give consultation to development teams.

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

Conducting sizing & capacity planning for Oracle databases.

Applied High priority, security patches downloaded from Meta link

Oracle Database monitoring, troubleshoot and resolve the issues.

Management of schemas, objects partitioning the tables & indexes

Performed various tasks along with offshore Team.

Performed database maintenance tasks using scripts

Worked closely with the developers in resolving performance issues

Used Oracle Enterprise Manager to monitor database health and check log files for errors.

Checked for Alert log and Trace files for errors and monitored the hit ratios.

Monitor servers and application performance and tuned I/O memory

Installed operating systems, patching, upgrading managing configurations

Setup RMAN backup and recovery using Flashback Technology

Managed User accounts and granted directory permissions to secure UNIX systems in meeting industry practices

Was on-call rotation on weekly basis

Environment:

Oracle 10g/11g and 12c databases, Active Data Guard, 10g/11g RAC, Data pump, Export/Import, Cloud Control

Oracle DBA

Vantage Point, Hartland, WI

April 2011 to December 2012

Responsibilities:

Installation, configuration and maintenance of Oracle 10g/11g databases.

Installing & configuring 11.2.0.2 RAC database on RHEL 6

Upgrading standalone and RAC databases from 10.2.0.4 to 11.2.0.2.

Applied CPU/PSU patches.

Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS_STATS package

Manage users, privileges and profiles, schemas using Oracle 12c Cloud Control.

Refreshing application schemas using data pump export/import

Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.

Monitoring & giving recommendations tuning SQL Queries, tracing sessions using DBMS_MONITOR package, analyzing explain plans.

Administer databases using OEM grid control, installing OMA to configure new targets.

Configured shell scripts for job/process automation.

Provide on call support on rotation basis.

Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.

Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports

Environment:

Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Data Pump, STATSPACK

Oracle DBA

BT Group place, NJ

July 2009 to March 2011

Responsibilities:

Installing, creating 10g, 11g databases.

Upgrade from Oracle 10g to 11g

Create, maintain and support Oracle 11g databases

Administer database with Oracle Enterprise Manager 10g Database Control

Performed database stats pack reports automation, stress test on production copy for scalability, resolving production performance issues

Experience on RAC Installation and Administration on Oracle 10g environment

Administer ASM storage for multiple databases.

Logical Backup/Restoration strategy of Export and Import.

Monitoring sql sessions, using dbms_monitor package, dbms_system packages

Security Administration and Creation of Users, Managing their roles and privileges.

Control user access and ensure database security through privileges and roles in Oracle 11g

Installed Golden Gate as a high availability solution.

Creation and maintenance of high availability databases using Data Guard.

Implementing physical standby databases in maximum performance mode.

Customizing & implementing scripts to automate monitoring & scheduled jobs.

Configured oracle net using Netca, lsnrctl to set up access to the database over network.

Space management involving issues with redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.

Implementation of backups.

Education

Bachelors from University of Illinois, 2008

References

Available Upon Request

Contact this candidate