Oracle Data

ANNA BANGEB

240-***-**** *******@*****.***

Summary

An Oracle DBA with over 6 years of IT experience in Oracle ( 12C, 11gR2, 10gR2) 11gRAC, 10gRAC, installation, upgrade, backup, recovery, migration, performance tuning, streams, data guard etc. in a variety of environments like UNIX (Solaris, HP-UX, AIX), LINUX & Windows NT 4.0/2000/2003 in production, test as well as development databases.

I also have a degree from Cameroon.

Experience Summary

Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.

Replication (snapshots/materialized views)

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks

Performed FLASHBACK features to handle efficient database recovery.

Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.

Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.

Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN.

Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top SQLs/Sessions and Tuning.

Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.

Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.

Experienced in loading data from flat files using SQL Loader and External Tables.

Knowledge on Oracle Support processes for technical requests through Meta link.

Monitoring & Reorganizing Tablespaces/Tables/Indexes.

Skilled in using tools such as SQL Developer and TOAD.

Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Bulk loads and data migrations (using SQL*Loader, data pump import/export)

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools

Experience in upgrading and configuring OEM Grid Control from 11g to 12c.

Experience in utilization of 11g,12c Oracle Enterprise Manager (OEM), Grid Control to manage users, privilege profile, and schemas.

Technical Skills

Databases

Oracle 9i, 10g, 11g

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Remedy

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Remote Tools

Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

Professional Experience

US Dept. of Labor, Washington DC March 2012 – Present

Role: Oracle Database Administrator

Oracle DBA for two major projects involving administration, troubleshooting & tuning of multiple Oracle databases ( 10g & 11g instances running on LINUX, IBM AIX 5.3and SunOS 5.8).

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

Created standby databases using RMAN Duplicate in order to reduce downtime for the PROD database during the migration process.

Backup/Recovery monitoring and reporting using Oracle RMAN

Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.

Extensive use of PL/SQL to create Stored Procedures, Packages Functions and Triggers

Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Extensive use of ERwin for database design and data modeling.

Experience in upgrading and configuring OEM Grid Control from 11g to 12c.

Experience in utilization of 11g,12c Oracle Enterprise Manager (OEM), Grid Control to manage users, privilidges, profile, and schemas.

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).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Application of Oracle software patches when/where necessary.

Create oracle databases on configured servers using both the DBCA & Database creation scripts.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan for Oracle).

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Cox Communication Inc., Atlanta, GA Mar 2010 – Feb 2012

Role: Oracle Database Administrator

Cox Communications carries the complete collection of cable capacity. The company provides basic cable service to more than 6 million customers, including 2.7 million digital cable subscribers and 3 million Internet access subscribers, making it the third-largest US cable company.

Responsibilities:

Provided Primary architectural and administrative support for new projects

Installed Oracle 10 and 11g database on HP-UX 11.0, Red hat 4.x

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

Use of database Oracle Warehouse Builder for data intergration, create data Warehouses, migration and consolidation

Capacity planning and informing storage for next quarter disk space estimate, used tools like EM, Toad, package like dbms_space and other criteria defined by DBAs over the time.

Tuning database pro-actively for future needs, Monitor rate of archive logs generated daily, RMAN backups, alert log

Troubleshooting error, reading trace file using tkprof utility etc

Refresh non production full/small size database from production database. Gold Copy of database taken, resizing down tablespaces and datafiles, excluding some of the data and truncating tables which are absolute as per business requirement

Proficient in using PL/SQL to create stored procedures, packages, functions and triggers

Build new database, decommissioning old out of scope database and reclaim space

Freeing up companies resources from historical database by archiving out old data to tape then removing or shrinking tablespace to high water mark if reasonable, shrinking undo/temp/other existing tablespace if reasonable by analyzing current and past usage from the time they obsolete

Extensive use of ERwin for database design and data modeling

Used to run the 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.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Performance Tuning i.e., Tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Oracle Grid Control Management Server Installation

Installed and configured Oracle 10g database on a test server using Oracle standard procedures for performance testing and future 10g production implementation

Cloned schemas, objects and data on new server using exports from 9i database and impo

rted in 10g using Oracle data pumps.

Developed UNIX shell scripts to perform the above tasks efficiently

Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Duke Energy Corporation - Charlotte, NC Nov 2009 – Mar 2010

Role: Jr. Oracle DBA

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.

Proficient in using PL/SQL to create Stored Procedures, Packages, Functions and Triggers

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

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

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

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.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

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.

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Contact this candidate