Senior Oracle DBA

Brian R. Lee

Email: ****.******@*****.***

Cell: 602-***-****

Brian has over 10 year’s experiences in implementation and supports of Oracle

systems. He has experience in installation, maintenance and upgrading complex

Oracle systems both single tier and multi-node architecture. He also has

experience in implementing RAC (Real Application Clusters) technologies and

setting up Physical Standby with Dataguard. He has worked in both EBS

Financial and OBIEE Datawarehouse systems. Brian also has experience in

implementing and managing Oracle RAC Database in Exadata X2-2 machines

and Exadata X3.

SUMMARY OF ORACLE SKILLS

• Automatic Storage Management

• 10g,11g RAC,12c (Real Application Cluster)

• 10g,11g,12c Grid control

• Oracle E Business Suite ( ORACLE 11i Financials)

• Oracle 8i,9i,10gR1, 10gR2,11gR1,11gR2,12c

• Oracle Export and Import (Datapump)

• Oracle Enterprise Manager

• Oracle Installs including client, database, patches

• Oracle Application Server (OAS)

• Oracle OBIEE Datawarehouse

• Informatica and DAC installation and configuration

• Oracle Golden Gate

• Oracle Streams

• Oracle Materialized Views

• Physical Standby and Dataguard broker

• Performance Monitoring

• Replication and Cloning

• RMAN backup and recovery

• Schema & User management

• Unix-Sun Solaris 9, Solaris 10 (sparc & x86)

• Linux Red Hat 4, 5, 6, x86-64

• Unix shell scripting

Professional Experience

11/2007 - Present Apollo Group Inc. (University of Phoenix) Phoenix, Arizona

•

Senior Oracle

Database

• Installed 11gR2 Grid Infrastructure and RAC databases

Administrator

• Installed 10gR2 Grid Infrastructure and RAC databases

• Upgraded databases from 8.1.7, 9i,10g, to 11gR2

• Managed OEM 10g Grid control

• Managed OEM 11g Grid control

• Managed OEM 12c Grid control

• Install and configure High Availability solutions for RAC and

physical standby using Dataguard

• Scripted automated backup solutions and created backup testing

solutions by recovering databases in test servers

• Cloned and automated cloning/refresh process of test and

development databases

• Patched the RAC databases using Exadata Machine.

• Created and managed backups using 7420 storage on Exadata

Hardware

• Implemented backup strategy on Exadata X2-2/X3 machine using 7420

storage

• Installed and configured materialized views replication

• Installed and configured streams replication

• Managed Golden Gate

• Installed and configured Hyperion database

• Installed and configured Essbase Application

• Installed and upgraded Oracle Application Server

• Installed and managed Weblogic Server

• Installed and configured OBIEE 11g, Informatica, and DAC

• Assist application developers with performance tuning of application queries

• Data migration including RAC database, schema, and standalone

database.

• Performed disaster recovery of the database using recovery manager

• Supported data migration of existing RAC environment with ASM to another

datacenter

• Supported databases from 90GB to 20TB

• Build 2,3,4 node RAC databases.

•

•

•

•

•

• Oracle EBS Applications 11.5.10 upgrade

• Upgraded the Oracle EBS Applications from 11.5.9 to 11.5.10.

• Applied RHEL30 Interop patches

• Applied Cumulative Update Release patches

• Upgraded applications database 9i to 10gR2

•

•

Oracle EBS Applications from 11.5.10 to R12 upgrade

• Upgraded the Oracle EBS Applications from 11.5.10 to R12.1.3

• Applied Interoperability Patch for EBS R12 with Database 11gR2

• Applied Cumulative Update Release patches

• Upgraded applications database to 10gR2 to 11G.

Experienced work with the following environments

• Oracle Financials EBS in 11i and R12

• Oracle Peoplesoft Financial Aid

• Oracle Peoplesoft HR

• Oracle OBIEE Datawarehouse

• Oracle Hyperion

• Oracle Essbase

•

Professional Experience

07/2002 - 11/2007 Total System Services Columbus, GA

Oracle Production Database Administrator

• Applied critical patches updates to Oracle Database as they

became available from Oracle.

• Applied one off patch to RAC databases and single node

databases

• Assist application developers with performance tuning of

application queries

• Communicate with Oracle Support (Metalink)

• Created and maintained database system documentation and

standards

• Created and managed Datawarehouse

• Developed database monitoring and administration scripts with

Korn Shell such as an alert log checker specified by error

message, listener checker, and service check

• Established and maintain sound backup and recovery policies

and procedures

• Installed 10gR1 and 10g2 real application cluster databases with

ASM and patched to the appropriate patch level

• Installed 10g Gridcontrol and deployed management agents

target database servers

• Implemented and maintained database security (create and

maintain users and roles, assign privileges)

• Installed single node and RAC databases such as 9i and 10g

• Implement database link to remote database

• Implemented "Proof of Concept" for Split Mirror backup strategy.

• Managed and supported production database systems

• Managed Oracle on 8i,9i, and 10g

• Managed Oracle Real Application Cluster and ASM

• Managed Real Application Cluster on 10g

• Patched database servers up to the new release

• Perform physical database administration duties.

• Participated in 24x7 on call rotation for production support of

databases

• Supported ASO (All system outages)

• Setup Tablespace monitoring

• Team player willing to work closely and share knowledge with

peers

ADDITIONAL PROFESSIONAL ACTIVITIES

Professional Oracle Courses: Oracle Database 10g: Administration Workshop ll –- Oracle

RAC 10g – Oracle RAC 11g Administration Workshop Oracle Enterprise Manager 10g

Grid Control Release 2 Exadata Adminstration and monitoring - Sitescope

Setup/Monitoring

EDUCATION

Columbus State University, Columbus, Georgia

Bachelor of Science in Computer Science, January 2002

ICAPP, BS in Applied Computer Science January 2003 Sponsor by TSYS, Inc.

Contact this candidate