OBJECTIVE

• Leverage my skills and experience as a Data/Database/Information Management professional, Oracle SME, Collaborator, Content Creator, Presenter, Trainer and Mentor, to maximize revenue and minimize the cost of doing business, by facilitating the creation, implementation, support and continuous enhancement of IT products and solutions.

SUMMARY

• Designed, Protected and Managed the second most important corporate asset - Data, Databases & Information, for over 18 years, by partnering with Fortune 500, Startups & Big 4 Consulting companies.
• Architected, Implemented, Supported Data/Information Management Solutions, Created Design/Architecture Documents and Technical Reports, Mentored, Trained and acted as a Liaison between groups.
• Oracle Subject Matter Expert (15+ years) with SAS 9.4 Administration Skills. Highly skilled in Oracle Database Administration (including Data Protection, High Availability/Disaster Recovery using Data Guard), Database Development (Oracle SQL) & Data Analysis using SQL and Scripting Languages like the UNIX Shell.
• Proficient in Data/Data Warehouse Architecture (5+ years). Built OLTP and Data Warehouse data models utilizing ER Modeling and Dimensional modeling techniques. Familiar with Kimball Methodology.

TECHNICAL SKILLS

OS/Storage OS: RHEL 6.x, Solaris, HP-UX, AIX, Windows, MVS/ESA, OS/2, VMware, Confidential Clustered Data ONTAP 8.2

Confidential Storage: Snapshot, Snap Creator Framework, SnapManager for Oracle, OnCommand System Manager

Others: UNIX shell scripting, UNIX utilities, UNIX Internals

Languages: SQL, PL/SQL, ANSI C

App/Web Server: Oracle 11G/10G AS, Weblogic, Netscape Enterprise Server, Apache, IIS

RDBMS & Tools: Oracle 12c, 11g/10g/9i RAC, ASM, OEM 12c/11g, Oracle Clinical 4.5.1.2, Oracle TMS 4.5.2, Oracle AERS, SQL Server 2K, Oracle Intermedia, Developer 2K, Quest Database Toolset (Foglight, Foglight PA, SQL Navigator, SQL Lab Expert, TOAD, Spotlight), DBArtisan, SQL Developer

Oracle HA: Oracle 11g RAC

DR: Oracle 11g Data Guard

CASE Tools: Erwin, ER Studio, Designer 2000, Oracle CASE 5.0, LBMS (Systems Engineer)

ETL Tools: Informatica 9, Sagent, Oracle SQL *Loader

Analytics/BI: SAS 9.4, Business Objects, Microstrategy, Cognos, Brio, Sagent

CRM: Siebel 8.0

ERP: Oracle E-Business Suite R12, Sungard Banner Higher Education 7.x

PROFESSIONAL EXPERIENCE

Confidential, Chapel Hill, NC

Sr. Oracle DBA/Data/Database Architect

Responsibilities:

• Install and Configure SAS 9.4 on multiple tiers (Metadata, App/Compute and Middle) on Linux.
• Install and create new Oracle 12c databases.
• Manage all existing Oracle Databases with versions ranging from 10g to 11g R2.
• Troubleshoot Production Application, Database and Data issues.
• Work with the Data Warehouse team to build the ETL Reporting Schemas.
• Assist Development/Reporting Teams on multiple projects from a Data Model, Data and Database standpoint with tasks including Schema Design, Developing complex queries and Query Tuning.

Environment: SAS 9.4, Oracle 12c/11G R2/10G, Oracle Data Guard, Oracle Wallet, Oracle SQL/PL/SQL Developer & Data Modeler, SAS 9.0, MongoDB, RHEL 6.4, VMware ESXi 5.5.0, HP 3Par 8600.

Confidential, Durham, NC

Sr. Data Analyst

Responsibilities:

• Conducted data analysis/profile activities against source systems or data that resided within the Data Factory to ensure data quality, Reverse Engineered existing Data model for legacy applications.
• Triaged data issues reported by users in production Lab ODS systems.
• Worked with metadata solutions to ensure source to report data flows are documented and auditable.
• Conducted root cause analysis on data issues throughout the life cycle of the project.
• Defined and documented data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes.

Environment: Oracle11G R2, Oracle SQL/PL/SQL Developer & Data Modeler, Informatica 9.0, Informatica MDM.

Confidential, Durham, NC

Sr. Oracle Data/Database Architect

Responsibilities:

• Compiled and Maintained the Dictionary of Data elements.
• Implemented Physical Data Model Changes, generated and promoted DDL in Development and Test environments.
• Managed database Schema Objects.
• Developed Oracle Database code (Queries, Views, Stored Procedures, Functions, Triggers) for Data Management.
• Conducted peer reviews of database code and Tuned them.

Environment: Oracle11G R2, Oracle SQL/PL/SQL Developer & Data Modeler, Informatica 9.0, SVN, Oracle Web Center Suite 11g, Siebel CTMS.

Confidential, Raleigh, NC

Sr. Oracle DBA Consultant

• Implemented Oracle Enterprise Manager 12c Release 4 from the ground up for Enterprise wide Oracle database Management, Monitoring & Lifecycle Management.
• Presented OEM 12c benefits and Implementation Roadmap to Management.
• Migrated databases from RAC to non-RAC, Standard Edition to Enterprise Edition and from bare metal to a virtualized environment.
• Implemented a Proof-of-Concept Disaster Recovery solution with Oracle Data Guard.

Environment: Oracle11G R2, Oracle Enterprise Manager 12c R4, Toad, Spotlight, AWR, DB2, VMware ESX, RHEL 6.3, Confidential FAS Storage, Tivoli Storage Manager, CommVault, ITM, Hyperic, Solar Winds, Scom/Splunk, AlertFind, TelAlert.

Confidential, NC

Sr. Business Applications Solutions Engineer/Architect

Responsibilities:

• Created technical collateral including Technical Reports, presentations to implement applications with Oracle as a backend database, on Confidential storage.
• Setup Confidential NAS Storage volumes, Red Hat Linux 6.3, Oracle E-Business Suite 12.1.1 and Confidential Storage Management Tools in a Virtualized compute environment.
• Created Oracle E-Business Suite Hot Clones and documented (Technical Report) the high level procedure and benefits from using Confidential storage in terms of cost and time saved, optimum usage and efficient manageability of resources.
• Worked closely with Product Management as well as Product and Solutions Engineering on Confidential ’s future strategies and roadmap execution, related to Oracle database and Oracle ERP space.
• Identified and managed development of collateral in the Oracle/Oracle Applications space to highlight best practices and Confidential ’s value proposition.
• Reviewed/Approved/Maintained Content updates, revisions, removal of content in the Oracle/Oracle Applications segment to be consumed by Customers, Field Tech Teams and Partners. Materials subject to maintenance included, but not limited to Solution Modules, Solution Guides, Technical Reports, PPTs, Training Content, and FAQs.
• Responded to Oracle/ Confidential storage related queries (on various internal distribution lists) from Confidential field personnel.
• Contributed to Strategy discussions around increasing Confidential storage market share in the Oracle/Oracle ERP market segment.

Environment: Oracle E-Business Suite 12.1.1, Oracle 12c,11G R2, AWR, VMware ESX, RHEL 6.3, Windows, Confidential Clustered Data ONTAP 8.2, Confidential OnCommand System Manager, Confidential SnapCreator Framework, Confidential FAS Storage.

Confidential, NC

Sr. SAP Oracle DBA, Production/Development Support

Responsibilities:

• SME for Oracle, influencing Database Architecture, Backup & Recovery, Disaster Recovery, Performance Optimization and mentoring/training team members across multiple teams.
• Documented Procedure Documents and Best Practices related to Oracle Database Management.
• Migrated 14 TB SAP (ERP) Oracle database from parent company to new facility.
• Performed Oracle Database Recoveries, Database Clones/Refreshes utilizing Oracle incomplete recovery.
• Monitored, researched/resolved issues related to Backups, Space, Performance and other errors.
• Performed Database Installs, Upgrades/Patching using SBP (Sap Bundle Package).
• Reorganized the database and database objects for better performance.
• Utilized BR*Tools to perform various SAP/database maintenance tasks.
• Utilized various SAP transaction codes to monitor/manage SAP Databases.
• Installed and configure Quest Database Monitoring, Performance Tuning & Productivity Tools.
• Prepared database environments for Data Conversion and Archiving efforts.

Environment: SAP ECC 6.0, FI/CO, SD, MM, BW/BI, PI, Solution Manager, GRC, Portal, BR*Tools, Oracle 11G R2/10G/9i, AWR, Quest Tools (Toad, Foglight, Performance Analysis, Live Reorg), HP, Linux, Windows, HP Data Protector, HP Storage Essentials, HP EVA Storage, HP Service Guard.

Confidential, Raleigh, NC

Sr. Oracle DBA, Production/Development Support

Responsibilities:

• Documented Best Practices for Oracle Installs, Upgrades and Database Failover.
• Migrated databases from 9i/10g (on Solaris) to 11G R1 and 11G R2 (on AIX).
• Managed Backups/Recovery using RMAN, Database Clones/Refreshes using RMAN.
• Built 10G/11G standby databases with Active Dataguard, “Maximum Availability” and FSFO (Fast Start Failover).
• Monitored, researched/resolved issues related to Backups, Space, Performance and other errors.
• Performed Troubleshooting of Application/Database Issues and applied production change requests.
• Performed Database Installs, Upgrades/Patching.
• Worked with Functional/Technical teams to tune Oracle Demantra (forecasting engine) Data Warehouse database.

Environment: Demantra, Oracle 11G R2/10G/9i RAC, ASM, 10G AS, AWR, Oracle Reports Server, 10G OEM Grid Control, VPM (Fluke Networks), RMAN, Dataguard, Toad, EMC, Clusters, Oracle Ebusiness 11i, AIX, Solaris, Linux, Windows.

Confidential, Raleigh, NC

Principal Oracle DBA

Responsibilities:

• Managed Backups/Recovery using RMAN.
• Monitored, researched/resolved issues related to Backups, Space, Performance and other errors.
• Monitored and maintained 9i/10G RAC/ASM and Dataguard environments.
• Applied Change Requests to Oracle databases and Application Servers across multiple environments.
• Performed Database Installs, Upgrades, Refreshes, Clones.

Environment: Oracle 10G/9i RAC, ASM, 10G AS, AWR, Oracle Reports Server, 10G OEM Grid Control, RMAN, Dataguard, EMC, Clusters, SAP, Oracle Ebusiness Suite 11i, Remedy, Solaris, Linux, AIX, Windows.

Confidential, Durham, NC

Sr. Oracle DBA, Production/Development Support

Responsibilities:

• Managed Banner (ERP from Sungard Higher Education) ERP Production (INB, SSB), Test Databases.
• Performed Database/Application Clones, Refreshes, Applied Oracle/Banner Application Patches/Upgrades.
• Managed Application Security, Supported go-live efforts for HR and Alumni, Managed Appworx for job scheduling.
• Tuned (proactive/reactive) databases, Performed Troubleshooting for Application/Database Issues.
• Performed point-in-time recovery using RMAN.

Environment: Banner 7.x, Oracle 9i, 10G R2, 10G RAC, 10G AS, 10G OEM, RMAN, Dataguard, Appworx, Luminis, Solaris, Linux, Shell, Toad.

Confidential, San Mateo, CA

Sr. Oracle DBA

Responsibilities:

• Installed, Configured & Supported Oracle Pharmaceutical Applications.
• Planned, Tested and Documented Database Disaster Recovery scenarios
• Prepared Customer database environments for audit.

Environment: Oracle 9i, 10G AS, RMAN, Oracle Clinical, AERS, Oracle TMS, Oracle Portal, Solaris, Linux, Shell, Toad.

Confidential, San Francisco, CA

Sr. Data Architect/Oracle DBA

Responsibilities:

• Led the POC & Production database implementation efforts for Confidential Bank.
• Worked on improving the data model.
• Managed Day zero data loads utilizing shell scripts, SQL Loader, Packaged procedures and functions.
• Coordinated with Business Analysts and Designed complex batch report specifications.
• Participated in Technical Design Reviews and prepared Design and Architecture document.

Environment: Oracle 9i, SQL Loader, Solaris, Linux, Java, Perl, Shell, PL/SQL Developer, CVS, XML.

Confidential, San Jose, CA

Sr. Data/Database Architect

Responsibilities:

• Re-architected multiple Data Marts (Adaptive Network Care, NetAudit, LWC, Network Profiler)
• Managed change management for multiple data models in Oracle Designer.
• Generated DDL scripts as input to the OR mapping layer managed by Hibernate.
• Configuration Management: Reviewed and Implemented database changes (DDL and DML) in Production.
• Day-to-day management of databases, Capacity Planning, Troubleshooting Database issues, Server Consolidation, Participated in Technical Design Reviews.
• Devised and implemented database Schema Access Models for Development, Test, Pre-Production & Production environments, Database Change Management and Source Code Control, Release Build & Deployment Strategy.

Environment: Oracle 9i/8i, Solaris, Linux, Java, Perl, Oracle Designer, Toad, Apps Integrity, Jira, CVS, Hibernate.

Confidential, Harrisburg, PA

Sr. Data/Database Architect

Responsibilities:

• Developed ER Models, Logical and Physical Database Design for OLTP Applications.
• Prepared Data Dictionary for all data elements, Database Standards & Guidelines and Architecture documents.
• Designed and Implemented Data Architectures for Data Conversion.
• Installed, Configured and Tuned Oracle Production, Development, Integration and Test Database environments.
• Designed, documented and Implemented Database DR (Disaster Recovery) Plan.
• Designed routines to validate data quality, worked with Analysts and Developers to fix data quality issues.
• Improved Batch Architecture for better throughput and excellent monitoring capability.
• Designed and Built Data Warehouse Staging & Target environments.
• Configuration Management: Implemented Database Code Migration from Development to Integration to Test, Pre-Production and Production environments, Oversaw Application/Database Maintenance, Data fixes.
• Database Capacity Planning: Server Requirements, Database Sizing, EMC SAN RAID groups and LUN assignments for optimal Batch/OLTP performance.
• Performance Tuning: Optimized Database (SQL, PL/SQL) code, physical design using Indexes, Materialized Views, Oracle Partitioning.
• Prepared Database Technical Architecture documents as response to RFPs (Request For Proposal) for Confidential .

Environment: Oracle 8i (Win 2K Cluster), SQL Server, DTS, MS Access, EMC, Erwin, Toad, Managed Standby, Microsoft Development tools, VSS.