Oracle Manager
Resume:
Angela Lum Mundi
**********@*******.*** Phone: 240-***-****
A Detailed and goal oriented Oracle Database Administrator with 5+ years of experience in designing,
implementing and maintaining Oracle 10g and 11g RDBMS. Supported a variety of mission critical
applications with Oracle 9i, 10g and 11g. Worked across a multitude of platforms (Solaris, UNIX, and
Windows) in production and development environments with responsibilities encompassing Installation,
Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication,
Database Security, Memory Management, Performance Monitoring and Tuning, auditing, RAC, Data Guard,
Grid Control and production support. Proven technical knowledge and outstanding leadership ability and
creative problem solving skills in both strategic and tactical areas. Excellent communication
/documentation skills and strong aptitude to analyze and resolve problems.
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.
• Managed Oracle databases in very large (over 3 TB) databases and Oracle Application
environment to support over 3,000 concurrent users.
• Good communication and cooperation skills with an aptitude to learn quickly, take
responsibility, work under pressure.
• Experience on Data Replication using Snapshot, Materialized views, and import/export.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle
11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and
performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods
including point in time, media recovery, full/partial, datapump export/import.
• Involved in each phase of life cycle ( SDLC) including requirement gathering, technical
design, development, system integration phase, quality assurance phase, development and
production support activities.
• Experience with Oracle Cluster ware, and configuration with Oracle 10g and 11g RAC.
Strong skills on Data guard.
• Developed database monitoring/health check alert scripts for database uptime/downtime
status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do
the daily tasks regarding the performance, maintenance.
• Configuration and Management of Data Guard on RHEL, OEL.
1
• Extensive experience with Database Cloning and Refreshing pre prod/dev databases with
prod/pre prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle
Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using
Storage area Networks (SAN) /Network Attached Storage (NAS).
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic
Manager (ADDM).
• Proactively monitoring the database's health and taking preventive or corrective actions
• Experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas
NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to
accomplish table level and full database de fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Automated many common tasks using crontab including Backups, exports and imports,
TECHNICAL SKILLS
Databases Oracle 9i, 10g, 11g
Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB
Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader,
Database
Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top,
Tools
DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Remedy
Operating
MS Windows, UNIX (Solaris 8/9/10, AIX, HP UX), LINUX
Systems
Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers
890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers,
Hardware
Compaq Servers 6000/3000/1600/800, HP/UX 9000, Red Hat
Linux 6.2
PROFESSIONAL EXPERIENCE
Howard University February 2012 – 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.3 & 6.1. Database sizes range from 20GB to 1TB (in ODS & EDW
environments).
• Backup Oracle DBA for two major projects involving periodic administration,
troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances
running on both IBM AIX 5.3, SunOS 5.8 & HP UX B.11.11.
• Database reorganizations and refresh schema using Export/Import. Creating the
database, table spaces, tables, indexes, setting privileges and user logins.
• Analyzed SQL queries causing performance problems.
2
• Supported Oracle DB backups (online/offline), logical backups and UNIX
scripts, created clone databases, configured standby database, performed DBA
day to day activities
• Troubleshoot installation errors both independently and with Oracle support (via
My oracle Support)
• 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 10g database control, oracle 10g Grid Control as
well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert
for Oracle).
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net
backup, EMC RAID, RAW Devices.
• 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.
• Analyzing schema of databases created to collect statistics using the DBMS STATS
package.
• Use AWR/ADDM for 10g Statistics management & database tuning following
creation of new databases and periodically thereafter.
• Cloned databases using scripts as well as RMAN. Installation, setup and
configuration of Data guard
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC
databases on ASM and NFS file systems.
• 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
• 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.1 to 11.2.0.3
• Monitor database systems and provide technical support for database system
issues and application performance enhancement/improvement using both OEM
(client), Oracle 10g database control & SQL*Plus, as well as pre developed UNIX
shell scripts.
•
Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF,
EXPLAIN PLAN
HMS HOST Bethesda, MD July 2009 – February
2012
Role: Oracle Database Administrator
3
• 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.
• 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 “runInstaller” and
perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS)
feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to
quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level)
using RMAN utility and Datapump, 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.
• 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.
• Worked extensively with Physical Standby database, troubleshooting,
switchover and switchback with Physical standby setup.
• 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.
Tools Used: Oracle 10.2.0.1, HP UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE,
TKPROF, EXPLAIN PLAN
Enterprise Holdings Inc Clayton, MO May 2008 – June 2009
Role: Oracle Junior DBA
4
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and
availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned
problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring,
Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day
management of the databases; pre empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in
the database.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for
loading data from external files into the Oracle database.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Write database documentation, including data standards, procedures and
definitions.
Tools Used: Oracle 10.2.0.1, Oracle 9i (9.2.0.8),RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
EDUCATION/CERTIFICATIONS
• University of Maryland, College Park, MD MS Health Administration
Informatics
• Howard Community College, Columbia, MD – ASN (Registered Nurse)
• University Of Yaounde Cameroon BA Post Secondary Education
5
Contact this candidate