NICOLE AWASUNG

ORACLE DATABASE ADMINISTRATOR

646-***-**** acxfuw@r.postjobfree.com

Summary

5+ years of experience in the field of Database Technology with experience in designing, developing and configuration of Oracle databases.

Exceptional Knowledge of various states of Software Development Life Cycle (SDLC) i.e. System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 10g, 11g, 12c in Production, Staging, and Development environments.

Performed upgrade from 11g to 12c using manual method and transportable tablespace methods.

Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control. Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. table spaces, rollback segments) and auditing of users

Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM

Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager (OEM) 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.

Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.

Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).

Implemented automated backup strategy and monitoring of databases using UNIX shell script CRON UTILITY.

Expertise in overall tuning of Database using Automatic Workload repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) tools and tuning of SQL using STATSPACK, EXPLAIN PLAN and TKPROF.

Working experience on both OLTP and OLAP environments.

Experience in using OEM and tools like TOAD and ERWIN.

Very good knowledge of Oracle Database architecture, SGA, PGA, Background Processes, Listener and TNS Names configuration and Data Dictionary.

Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade oracle database 9i to 10g and 10g to 11g.

Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.

Experience translating business requirements into conceptual, logical, and physical data models

Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, auto trace and execution plan.

Management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.

Experience on Metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone database to RAC environment.

Experience in configuration and maintaining Oracle Physical Standby Database using Oracle Data Guard 10g and 11g.

Knowledge in configuring ASM (Automatic Storage Management) for both the standalone database and RAC database environments.

Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Implemented RMAN backup (Full, incremental and cumulative) and recovery. Incomplete recover and disaster recovery using Standby database.

Implemented Oracle10g Streams unidirectional on table level for replication between homogeneous environments.

Working experience of defining triggers events, cursors, stored procedures and packages.

Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.

Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.

Technical Skills

Databases

Oracle 10g, 11g, 12c

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBCA Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBUA, ADDM, Remedy

Operating Systems

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, HP/UX-9000, Red Hat Linux 6.2

Middleware

BEA Weblogic 10.2.3

Remote Tools

Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization.

Professional Experience

EOG Resources Inc - Houston, TX April 2013 – Present

Role: Oracle Database Administrator

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 40GB to 2TB (in ODS & EDW environments).

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.

Create database Objects, Tablespaces, Schemas as needed.

Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.

Implemented oracle 12c active standby database for test database environment.

Implemented oracle 12c flexi asm for pre-prod environment.

Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.

Installed, Configured Oracle 12c Goldengate on Oracle 12c Database. Developed SQL*PLUS&PL/SQL scripts for extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.

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.

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

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

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, SQL Developer, DB Artisan and DB Xpert for Oracle).

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

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

Analyzing schemas of databases created to collect statistics using the DBMS STATS package.

Use AWR/ADDM for 11g Statistics management & database tuning following creation of new databases and periodically thereafter.

Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)

Application of Oracle software patches when/where necessary.

Backup/Recovery monitoring and reporting using both BMC SQL Backtrack & Oracle RMAN

Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Automated RMAN backups for Production and Test Databases using Crontab.

Creating and Scheduling Oracle Backend Process jobs in Crontab.

Cloning & duplicating database using scripts as well as RMAN.

Expertise in recovering the database, Performed complete recovery, data file recovery, incomplete recovery.

Tools Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Bank of America Corporation - Charlotte, NC June 2011 – March 2013

Role: Oracle Database Administrator

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

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

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

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

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

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.

Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

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

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.

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

Cloning databases using scripts as well as RMAN and performed tablespace point in time recovery (TSPITR) using RMAN and user managed backups.

Implemented Streams replication between RAC and non-RAC database environments.

Installed Oracle 12c Enterprise Manager (Grid control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.

Assisted a team of DBA's in upgrade of databases from Oracle 10g Release 2 to Oracle 11g Release 2.

Monitoring and tuning using tools like Enterprise Manager GRID, Oracle Cost Based Optimizer (CBO) SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager and Statspack.

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

Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

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

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

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

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

EDUCATION:

Anna Maria College (AMC); Paxton, MA August, 2014

Master’s Degree (MPA): Health Care Administration

Dominican College, Orangeburg, NY. May, 2011

Bachelor’s of arts (BA): Social Science

Rockland community college. Suffern, NY June, 2009

Associate of arts, social science

Contact this candidate