Oracle DBA

CAROLINE GORE

Oracle Database Administrator

U.S Citizen

Phone: 240-462- 1497

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

Skill Summary

* ***** ** ***** ****** Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals.

Extensive hands-on experience in Installations, configuration, Cloning, Security, Patching, Upgrades of Oracle installed and configured on different platforms like Windows, Linux, RHEL, Oracle Solaris, HP-UX, IBM-AIX. Provide 24x7 production support and development support.

Experience in Installation of 12C Grid Control and experienced in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, datafiles and database recovery using RMAN and point-in-time recovery option.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)

Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.

Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.

Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC

Experience in very large-scale database environment and mission critical large OLTP and OLAP systems.

Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode

Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.

Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.

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

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

Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.

Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Installed patches using Opatch utility and expertise in applying Oracle PSU and CPU patches.

Multiple upgrades of Sun Solaris and Linux servers from 9i to 10g, 10g to 11g and 11g to 12c.

Experience with Oracle Support Service Requests for technical issues using myoracle support services.

Technical Summary

Databases: Oracle 10g, 11g, 12c

Database Tools: Toad, OEM Grid, RMAN, SQL*Loader, Data Pump, Log liner, AWR, DBCA, DBUA, ADDM

Operating Systems: UNIX (Solaris and AIX), LINUX

Work Experience

Abercrombie & Fitch - Columbus, OH

April 2014 – Present

Oracle DBA

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, SQL Developer, Data Guard, TOAD,

Responsibilities:

Involved in Installing, Configuring and Administration of Oracle 10g/11g RAC on ASM.

Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03 and to the new 12c.

Worked on 2 nodes and 4 node RAC databases from 200GB – 10 TB

Installed 10g /11g binaries on HP-UX and Linux servers and configured new production databases for the same.

Proficient in writing UNIX Shell scripts to automate business process and daily backups.

Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.

Implemented scripts to monitor and get information on free space, alert log errors. Provided maintenance of user accounts, privileges, profiles and roles.

1 Year experience using 11g and 12c Golden Gate, Director, including upgrading, setup and support in QA and production ODS.

Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and Goldengate director notifications.

Oracle Instance tuning, and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.

Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.)

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

Migration of database from one server to another server.

Responsible for configuring dataguard physical and standby database setup for high availability and handling synchronization issues between primary and standby.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Done migration of non ASM database to ASM database.

Created a stand by database by using RMAN Duplicate to reduce the down time for the PROD database during the migration process.

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

New York Times - Manhattan, NY

June 2012 – April 2014

Oracle Database Administrator

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN, SQL Developer, Data Guard, TOAD,

Responsibilities:

Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.

Performed disk and disk group management in ASM while installing 11gR2 RAC.

Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).

Ensured that oracle database systems operate securely and efficiently.

Managing databases from planning and testing stages through implementation and support.

Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.

Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and Perl based utility “opatch”.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.

Created Oracle Wallets and implemented Tablespace level TDE security.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Contact this candidate