Candidates About

Abbas

PROFESSIONAL SUMMARY:

·                     Over 7 years of IT experience, 7 years of extensive experience as an Oracle DBA on10g, 11g and 12c.

·                     Worked on Oracle 10g and 11gStandalone and Cluster Environment.

·                     Build RAC from scratch on Red Hat Enterprise Linux

·                     Experience in Data Center Migration.

·                     Experience in setting up Oracle Data Guard.

·                     Experience in setting up Grid Control and 12c Cloud Control.

·                     Experience in setting up ASM disk groups.

·                     Experience in setting up Golden Gate.

·                     Experience in Setting up Materialize View Server.

·                     Worked with the many new features of 11g

·                     Worked with Data Pump to clone tables, schemas and databases

·                     Worked on Table space/Extent/Segment Management

·                     Worked on Backup and recoveries using user managed and RMAN.

·                     Setup Oracle Enterprise Manager (OEM) and worked on 12c cloud control.

·                     Worked on Database monitoring / performance / diagnostics via dictionary views and cloud control.

·                     Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).

·                     Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)

·                     Worked on Oracle Tuning Pack

·                     Worked on Oracle Flashback / Flash Recovery Area (FRA)

·                     Proficient in Oracle RDBMS – including SQL, PL/SQL and all areas of database Administration.

·                     Experience monitoring Oracle RDBMS availability, database exports, Data Pump, tablespace, and extents fragmentation.

·                     Worked on Automated Storage Management (ASM) for 10g/11g databases.

·                     Worked on much performance tuning including SQL tuning and instance tuning.

·                     Worked with Oracle on open issues.

·                     Provided On-call support on 24/7 basis.

·                     Have written shell scripts to automate database management tasks.

·                     Pose strong administrative skills in RHEL.

·                     Build RAC clusters from scratch.

·                     Worked on Migration project

·                     Worked on Upgrade project.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Devon Energy,                                                                                               Feb 2014 - Present

Oklahoma City, Oklahoma

Title: Oracle DBA

Responsibilities:

·         Add new nodes to RAC 11g Cluster to distribute the load.

·         Installed and implemented 10g RAC with 4 nodes with ASM.

·         Upgraded Databases from 10g to 11g and applied patches as per requirement.

·         Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.

·         Responsible for installing and configuring Golden Gate on Oracle Servers.

·         Database migration from 9i to 10g to 11g.

·         24x7x365 administrative support staff.

·         Configured Data Guard to provide high availability by implementing Physical stand by database.

·         Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.

·         Cluster Installation and Configuration, Administering databases in RAC for high availability.

·         Installation, Configure, setup of 11g RAC on Linux.

·         Designed, configured and maintained backup and recovery policies including RMAN backups.

·         SQL, PL/SQL Tuning and Monitoring.

·         Compared and contrasted multiple snapshots using AWR.

·         Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.

·         Responsible for setting up Oracle Golden Gate to help in propagating information between databases.

·         Recovered databases and clone applications Using RMAN.

·         Proactive performance monitoring, and capacity planning for future database and server growth.

·         Performed Range Partitioning as a cause to improve the performance of the database.

·         Performed Cross platform migration using transportable tablespaces and RMAN.

·         Performed Import and Export using Oracle Data pump utilities

·         Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.

·         Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.

·         Used external tables and SQL*Loader to import data from flat files.

·         Monitored database space requirements and adjusted for future needs.

·         Performed version upgrades and patch installs.

·         Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.

·         Strict adherence to policies and procedures - specifically in regard to change management.

·         Perform database administration tasks as part of a scheduled change management task.

·         Solid discipline in providing end-users timely updates on their problems. Installing server software.

·         Configured and managed agents to work efficiently with Grid Control.

Environment:

Oracle 11g databases,  Data Guard, 11g RAC, Data pump, Data Pump, 12c Cloud Control, Offshore Team, 24/7 on-call support.

Sahara Management, Rolling Meadows, IL

May 2010 – Jan 2014

Chicago, IL

Title: Oracle DBA

·         Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning  queries and providing support to developers.

·         Performing Hot/Cold backups of the database through RMAN or User Managed method.

·         Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.

·         Review alert logs and dump files to check for any problems related to the database.

·         Perform database cloning/exp/imp to setupidentical databases in the production and development environments.

·         Discoverer Administration including the design and administration of Business areas.

·         Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.

·         Developed PL/SQL based program for loading Data Mart.

·         Oracle Applications server including OID.  Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.

·         Create and maintain users, roles and privileges.

·         Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2

·         Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.

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

·         Involved in Database sizing, Capacity Planning.

·         Perform Space Management & Troubleshooting the database issues.

·         Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.

·         Configured and managed agents to work efficiently with Grid Control.

·         Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists

·         Generated ASH, AWR, ADDM reports from Grid Control and command line.

·         Setting up privileges to create local and remote objects

·         Create materialized views to refresh data at regular intervals.

·         Using materialized view logs to reduce the replication time costs for fast refreshes.

·         Upgrading/Migration from Oracle 8i databases to 9i and to 10g.

·         Installing of quarterly security patches on all non-production and production servers.

·         Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

Environment:

UNIX, Oracle 10g/11g, Oracle, Sun Solaris, Veritas Net Backup