Obj***

AUDREY MANIKE

ORACLE DATABASE ADMINISTRATOR

acxdyd@r.postjobfree.com T EL: 3-01-917-****

PROFESSIONAL SUMMARY:

Over 4 Years of total Oracle Database Administration experience in implementing, Design,

Development, Testing and Production support in all industry verticals exclusively Energy,

Financials and Insurance Industries.

Installation, upgrade, patching and management of oracle 11g/12c database. Management of

container databases

Experienced with Unix, Solaris, AIX, NT, RedHat, Windows.

Installed, configured, migrated and maintained RAC databases with ASM

Expert in systems analysis, architecture and capacity planning

Implement backup/recovery procedures with RMAN, Netapp and other third party tools.

Database Installation configuration and troubleshooting, including Performance monitoring

and Tuning.

Design, development, and testing of backup and recovery to ensure complete recoverability .

Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM,

TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.

Extensive experience in 7*24 production database support.

Security management for database, network, and operating systems.

Administer database security by creating users, granting necessary permissions as defined by

SLA, creating security roles and profiles and assigning those to users

Creating and maintaining the audit trail.

Managing the audit Vault using the Oracle Vault Technology.

Experienced in Installing, maintaining Standby DR servers using Dataguard

Design and implement of database backup strategy and performed full, incremental and

Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.

System resource management including bottleneck detection, contention tuning on SGA, CPU,

Memory and I/O etc.

Ability to prioritize and meet operational deadlines in fast paced environment with good stress

management skills.

Storage Management including fragmentation detection, tablespace growth ratio.

Excellent interpersonal and strong analytical, problem-solving skills.

Monitored the alert logs and troubleshot the errors.

PROFESSIONAL EXPERIENCE:

US Dept. of Transportation SE Washington DC May 2015 - Present

Role: Oracle DBA

Responsibilities:

Backup / Recovery methodology specification for mission critical databases.

Installation and configuration of Oracle 10g and 11g and 12C, OEM.

Data migration between databases using both Oracle 10g and 11g export/import utility and

Oracle 11g exp/imp data pump.

Monitored and performed database sizing, tablespace management and rollback tablespace

management, transaction management and security administration

Created the database objects such as Tables, Indexes, Views, Database Triggers,

Procedures, Functions, etc.

Monitor database systems and provide technical support for database system issues

and application performance enhancement/improvement using Toad, Oracle Grid

and Cloud Control & SQL*Plus, as well as UNIX shell scripts.

Performed hot and cold Backups.

Implementing Oracle ASM and resolving ASM related issues

Set up and configured SQL*Net and on servers and client machines.

Administration of 3-node RAC and Active DATAGUARD databases in Oracle 11g and

Oracle 12c.

Experience Golden Gate, for data replication.

Excellent Team Player with great interpersonal communications skills.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL

TRACE, TKPROF, EXPLAIN PLAN

Morgan State University, NW Washington DC March 2012

April 2015

Role: Oracle DBA

Responsibilities:

Worked on large databases in Oracle 11g with multiple instances using Oracle RAC Cluster.

Performed cold and hot backup using Oracle's Data pump.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases

that were poorly designed for heavy hits.

Design of databases following OFA: Creating Databases schemas, profiles, database links,

Snapshots and Synonyms of objects as required to ensure data quality and security to comply

with company's business rules. Oracle scripting in Windows/ Solaris and UNIX platform.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Scheduled daily Exports/Imports to serve as temporary backups.

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle

Diagnostic and Tuning packs.

Install client/server Oracle and MS SQL Server database Software

Cloned databases using scripts as well as RMAN.

Involved in design and enforcing of standards in place to ensure that all application design

and code is produced with proper integrity, security and performance

Refreshed schemas using Export/Import Datapump.

Data migration between databases using both Oracle 10g and 11g export/import utility and

Oracle 11g exp/imp data pump.

Used Exadata: Using Exadata to support ACFS running Grid Infrastructure version

12.1.0.2

Worked on in house installation of Oracle on different platforms, loaded user data to

reproduce the problem, applied new Oracle patch, managed database backup using RMAN,

Upgraded Oracle database 10.2.0.4 to 11.2.0.1

Database reorganizations and refresh schema-using Export/Import. Creating the database,

table spaces, tables, indexes, setting privileges and user logins.

Prepared scripts to tune developer SQL codes to maximize result return time.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases

that were poorly designed for heavy hits.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle

Diagnostic and Tuning packs.

Capacity planning and creating databases for development, staging and production.

Database and Data Migration using Export/Import, Migration Utility.

Performed bulk data loads using SQL Loader.

Implementing Oracle ASM and resolving ASM related issues

Set up and configured SQL*Net and on servers and client machines.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier

Architecture.

Experience in Golden Gate, for data replication.

Designed, tested and documented Oracle RAC database procedures

Created, relocated and removed Services as needed in an Oracle RAC configuration

Adding and removing nodes to existing Oracle database RAC configurations

Resolving RAC specific issues such as node evictions

Detailed analysis of the business and user requirements by doing various information

gathering techniques.

Environment: Oracle 11g, Oracle 10g, Oracle 9i, RMAN, Datapump, SQL TRACE,

TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

TECHNICAL SKILLS:

Database: Oracle 10g, 11g, 12c

Operating Systems: Windows NT /2000/XP, RHEL (RedHat Linux), UNIX, Solaris

Database languages & Grid Control, Cloud Control, TOAD9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS,

Tools: SQL* LOADER, VBA,JAVA, SQL, SQL*Loader, Database Links Utilities, RMAN,

Datapump, OAM, OEM, EXP, IMP, expdp, impdp, TOAD, SQL*Loader,

EMC, Veritas NetBackup, OSB

EDUCATION:

BS Information systems Technology, University of Maryland (UMUC), College Park

MD

Contact this candidate