BARBARA FOMBANG

ORACLE DATABASE ADMINISTRATOR

acqb3x@r.postjobfree.com TEL: 301-***-****

PROFESSIONAL SUMMARY:

Over 4+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries.

Providing 24/7 support of non-prod(STG,DEV,QA,INT) and PROD databases on UNIX/LINUX and Windows environments.

Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation. Performed planning, installing, and upgrading Oracle 10g, 11g R1 and 11g R2 databases to meet variety of business needs for the databases

Active involvement in database upgrades, applying Patches across enterprise databases to enforce Database environment integrity and security standards

Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.

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

Solid experience in disaster recovery, routine maintenance for Oracle databases.

Maintained Databases by evaluating high availability options and disaster recovery plans implementing DATAGUARD with different protection modes according to business requirements.

Experience in shell scripting for various CRON jobs to be run for automating DBA tasks.

Proficient in SQL, PL/SQL, stored procedures, packages, triggers. Involved in Database Performance tuning and analyzing AWR, ASH and ADDR reports on regular basis to resolve performance bottlenecks

Gathered and implemented optimal Database performance using SQL Performance Advisors.

Monitor and Manage Database through OEM

Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM

Expert level of using diagnostic utilities like SQL Trace (SQLT), Trace Analyzer (TRCA), Cluster verification Utility(CVU) SQL Net installation/configuration/troubleshooting (Server and Client side

Database Refresh from Production to Development and from Development to Test environments.

Replication of tables to cross platform and Creating Materialized Views.

Experience in maintain of production and Non-production batch servers using Autosys scheduler.

Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Planning and scheduling Physical Backups (offline/online) and Logical Backups.

Experience in implementing Flash Back Pointing Time Recovery.

Experience in maintaining ETL tools for Reporting Solutions.

Experience in User Management by Granting, Revoking Privileges according to requirement.

Experience in Space Management by Monitoring and Managing Tablespaces.

Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.

Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.

Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views. Excellent interpersonal and strong analytical, problem-solving skills.

EDUCATION:

BSc. Social Work Prince George’s Community College, Largo, Maryland

TECHNICAL SKILLS:

Database:

Oracle 10g, 11g

Operating Systems:

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

Database languages & Tools:

TOAD9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL, SQL*Loader, Database Links Utilities,

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

EMC, Veritas NetBackup

PROFESSIONAL EXPERIENCE:

Howard University, Washington DC March 2012 – Present

Oracle DBA

Responsibilities:

Install client/server Oracle and MS SQL Server Software

Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs. Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.

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.

Creating physical databases with multiple table spaces from logical and physical data model

Worked with different utilities like DATAGUARD broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.

Configured ASM and worked extensively with ASMCMD for managing ASM environment.

Implemented shell scripts, which monitor database health check and to maintain the database activities at regular interval.

Created and managed tablespaces monitored the datafiles space, resizing and adding new datafiles etc.

Coordinating with the teams during maintenance activities and system reboots.

Database monitoring and maintenance activities which include checking alert logs, space management, database locking issues, gathering database statistics, scheduling of jobs, creation of users, schemas, tablespaces and other database objects.

Database Reorganization regularly for removing row migrations and fragmentation using export and import utilities Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.

Cloned databases and Implemented 11gR2 DATAGUARD using RMAN duplicate. 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.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

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 schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

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

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.

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

Administration of RAC and DATAGUARD databases in Oracle 11g.

Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, and AWR reports, ADDM, TKPROF, TOAD and Oracle Enterprise Manager.

Understood the concepts of AMS (Archival Management System) and implemented successfully in production environment to archive historical data. Resolving RAC specific issues such as node evictions

Performed proactive and reactive tuning/managing database space utilization and growth

Implementing Oracle ASM and resolving ASM related issues

Detailed analysis of the business and users requirements by doing various information gathering techniques.

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

US Dept of Commerce, Washington DC Jun 2010 – March 2012

Oracle DBA

Responsibilities:

Managed Oracle Databases on Windows and Linux platforms.

Performed activities like monitoring the database and provide maximum uptime.

Created and granted users the privileges and roles and resizing the datafiles to manage database growth.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems. Resizing Tablespaces, Tables, indexes, Rollback segments.

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.

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Monitored the alert logs and troubleshot the errors.

Scheduled the backup jobs such as export through cron job in UNIX environment.

RAC Troubleshooting(worked on RAC REIP, SCAN IP issue and DB Unknown issue).

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

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.

Experience in creating and managing physical and logical Standby database using Data guard for HIGH AVAILABILITY. Performed up-gradation of 9i to 10g.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8),RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

Trover Solutions. Louisville, KY April 2009 – June 2010

Role: Junior Oracle DBA

Environment: Windows 2003, Oracle 10g/11g, TOAD, Database Tools/Utilities

Responsibilities:

Responsible for administering and supporting production and development Oracle 11g databases

Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance

Designed backup and recovery procedures for OLTP system

Partitioned large tables to increase the performance. Configured scripts to monitor activity with database

Responsible for optimizing the queries and application tuning

Implement Hot, Cold and Logical backup plans

Contact this candidate