PROFESSIONAL PROFILE:

• Ten years experience of Application tuning including ERP, SAP, Lawson, Cognos, Business Objects, Oracle Applications and proprietary software applications.
• Successful IT professional with over 23 Years of diverse and extensive experiences focusing on Oracle Database Team Management, Infrastructure Architecture, Database Engineering and Administration, development, systems design, analysis, documentation and systems migration
• 25 Years of experience as an Oracle Database Administrator for large-scale corporations implementing healthcare, financial, manufacturing, engineering and auto systems on Oracle databases. Extensive Clustering experience using sun cluster 3.1, Veritas Cluster Server and Oracle OPS Oracle Parallel Server to Oracle 11.2.0.3 RAC
• 15 years experience in infrastructure architecture and design with an emphasis on data integrity and stability.
• 7 Years experience installing and setting up Sqlserver for Dr. Offices and clinics.
• Implementations of modules like HR, Payroll, Financials, Accounts Receivable, General Ledger and Fixed Assests.
• Proven achievements in database management with client-server based systems, web based systems and Oracle ERP applications and Oracle UPK.
• Unix Administration experience on Solaris, AIX, Linux and HP-UX to manage Oracle installations and server monitoring.
• Extensive experience in: Database Backup / Recovery Database Upgrades and Tuning Database Creation / Replication and Database and User Security

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Analyst/DBA Database Architect

• Creating physical standby databases for HA.
• Converted standby database into RAC Clusters.
• Training DBA's.
• Implementation of 12C OMS Enterprise Management for Data Centers
• High Availability/DR implementation between data centers and server migration.
• Setting standards and procedures and creating library for problem resolution.
• Problem management identifying and resolving implementation problems
• Wrote standards and procedures for proactive monitoring of a Production databases and oversaw the implementation and testing of monitoring using Foglight, Spotlight and Solarwinds..
• Analysis and implementation of Database tools for performance tuning and database management.
• Provide High Availability and disaster solutions to support 24/7 Oracle databases.
• Reduce cost and profit margins by implementing VM test and lab with HP 3 Par storage,
• Reduce cost by using HP DL380 Quad core servers replacing older servers.
• Expert in Oracle Internals for optimum performance.
• Extensive support of Project Managers, Implementation Managers is a complex application environments using VLDB's and Data migration from Informix and Sqlserver databases.
• Responsible for setting new RAC environments for high profile clients and implementing Advanced compression to reduce storage costs.
• Goldengate proof-of-Concept.
• Data migration, Physical Logical design, ad-hoc reports using PL/SQL and SQL.
• Problem Management team adding databases to clusters, adding nodes, extending clusterware, creating RAC environments using OCFS and ASM, creating disk groups, setup of ASM.
• Responsible for database migrations to new servers.
• In charge of company major imitative 800 store conversion.
• Implementation of Oracle Financials 11.10.5, upgraded to 11.10.5.2 and responsible for performance tuning, patching and cloning to UAT environments.
• Database administration of Oracle, SQL Server and DB2 monitoring standards.
• Responsible for implementation of Strategic Planning for large Oracle customers setting monitoring standards, server rollouts and disaster recovery strategies for large databases.
• Implementation of Oracle12c OMS.
• Writing scripts of RMAN backups with improved performance.
• Responsible for Database Automation effort using BMC software.

Confidential

Sr. Oracle Database Subject Matter Expert Perm

• Data Migration using data pump.
• Analyze and recommend Oracle Best Practice in Full-Life-Cycle development processes.
• Liaison between business and technical team and design implementation.
• Implement RMAN to reduce backup and restore times with TSM.
• Support Sql Server to Oracle ETL processes.
• Supported IBM Oracle Financial upgrade.
• Subject Matter Expert on Oracle Internals for performance tuning and set standards in performance tuning.
• Data modeling for new energy applications.
• Migration from Informix to Oracle10g.
• Implementation of 11.2.0.3 RAC for all Tier -1 Databases
• Energy Data conversions.
• Implemented Oracle Advanced Compression combined with Oracle Database 11g to help businesses manage more data in a cost effective manner while providing for storing and auditing of historical data.
• Provide business analysis and weighted methodology matrix to outline needs in 4 keys areas for performance improvement.
• SAP reporting database administration.
• Implemented Oracle upgrades and patching.
• Designed and monitored ETL processes from SQL Server to Oracle10g.
• Oracle upgrades.

Confidential

Sr. Oracle Database Architect Consultant Contract

• Implement new flight information central database for DFW airport, wrote scripts to test code and alert process implementation and UPK development
• Selected IBM Servers and Hitachi 9500 Disk Arrays for North South Data Centers.
• Implemented Data Replication between sites and implemented contract for off site data center
• Managed Project for implementation of new networking, fiber installation with new switches.

Confidential

Sr. Oracle Database Consultant Contract

• Performance and Application tuning of Oracle and SAP environment using AWR, ADDM, Netweaver and BRTOOLS.
• Creation of technical requirements for Oracle, Unix platform and SAP reporting.
• Refreshing cloning of DEV and TEST environments from Production.
• Setup RMAN environment for training.
• Setup monitoring of Oracle databases and server using Foglight and Oracle DBA Suite by Quest.
• Design, develop and implement data models and database designs, and data access
• Unix scripting for data migration and scheduled jobs CRONTAB admin duties include creating volume Groups, mount points, adding memory, storage monitoring using Spotlight by Quest, HP Openview.
• Assisted with pulling data from SQLServer to SAP.
• Migration of data from legacy Oracle Financials to SAP Financials.
• Implementing security and auditing using Cisco AAA, Cisco Catalyst 6500 Series/7600 Series Wireless Services Module WiSM connecting to Oracle and SAP auditing.
• Planning Grid control implementation.
• Support of normalization and denormalization of data to support OLTP and Data Warehouse.
• Preformed analysis to identify deficiencies in application supporting business requirements
• Shell scripting for maintenance processes and business workflow using Oracle Designer and Visio.
• PL/SQL tuning and writing AD-Hoc reports.
• Upgrade Dev and Pre-Prod environments from 10g to 11g.
• Documentation of Best Practice and methodologies in database optimization and monitoring.
• Extensive SAP development support.
• Implementation of SOX compliancy in Oracle10g
• Team Lead training of SAP Basis administrator and Oracle DBA 's on Oracle/SAP Best Practice.

Confidential

Director of Database Technologies

• Responsible for administering 212 databases supporting various GMC business units.
• Upgrading and patching 100's of Oracle databases.
• Migrating data from tower servers to new RAC/ASM environment.
• Implementation of ETL process to mine data for data mart and DSS environments supporting supply chain.
• Implemented compression methodologies on operating system and database to reduce storage costs.
• Wrote upgrade and patching document for patching and upgrading Oracle Databases.
• Reduced 14 million dollar budget to 8.7 million procurement and development life cycle environments.
• Data conversions and migrations
• Backup and recovery processes supporting SAP environment.
• Wrote scripts to export/import SQL, shell scripts and parfile data to RAC environment from remote databases using pipes.
• Application tuning of propriety software for engineering.
• On Data Modeling team.
• Simulation Onstar testing using Bridgewater AAA Service controller for GM.
• Extensive support of development team.
• Created Volume Groups, added space to volumes as needed for database growth, created groups, added users, responsible for patching on Operating system Unix for security updates.
• Performed System Admin functions on HP-UX, SUN and LINUX in support of GM supply chain.
• Creation of technical requirements for Oracle and Crystal Reports.
• PL/SQL functions for temp table and Oracle external tables.
• Responsible for ensuring successful RMAN backups on databases overseen.
• Perform RMAN backups on databases before and after patching.
• Performances tuning and lite shell scripting.
• Implementation of RAC on Linux.
• Installation of SQLServer and wrote ETL process to push data to Oracle databases.
• Resolve performance issues, database capacity issues, replication, and other distributed data issues for all production/test databases
• Refreshing of DEV and Test environments from Production.

• Gathered information to provide technical solutions to business problems.
• Used Oracle Fine Grain Auditing.
• Implemented Oracle Database monitoring using Foglight and problem resolution using spotlight and OEM.
• Used weighted methodology matrix to ascertain and rate business needs and desires.
• Designed database and objects to support software implementation.
• Wrote PL/SQL procedures that populated tables that keep track of advanced queues.
• Setting up Physical standby on Oracle10G with Data guard and Streams.
• Performance tuning multi-Cluster multi-node RAC environment.
• Implementing Oracle and SQL Server database security using Roles and Privileges for SOX compliance.
• Architect and oversee the design, maintenance and implementation of the organization production/tests databases
• Managed 8 DBA's 5 Oracle and 3 SQL Server DBA's for project duration.
• Development Support testing engineering software after upgrade from Oracle 10.2.0.4 to 11g.

Confidential

Senior Database Analyst Applications DBA Company sold I.T outsourced

• Responsibilities include managing databases across U.S. performance tuning, major implementation of 11.5.10 Financials-fixed Assets, GL.
• Performed all Database Engineering functions addressing sizing, hardware specifications, memory requirements and logical and physical design of all databases.
• Major development support preforming data modeling and physical designs for Oracle Reports, Forms and PL/SQL
• Unix System admin duties included patching, capacity planning, creating user groups, and adding users, monitoring performance using HP Openview, Tops and Quest Spotlight.
• Architect and oversee the design, maintenance and implementation of the organization production/tests databases.
• Data conversion from TXI to Chaparral.
• Resolve performance issues set standards for Oracle Internals database performance, capacity issues, replication, and other distributed data issues for all production/test databases
• Met regularly with business units to provide information technology base for plants profits.
• Support Cisco AAA WiMAX implementation for plant management and data access using Cisco Aironet.
• Implementation of Physical and Logical standby databases with Data Guard, software testing, moves to Production and SQL Server 2005 administration.
• PL/SQL Tuning with development team.
• Performed cross-platform data migration between Oracle and SQL Server.
• Supported .NET development team and plant control data on SQL Server.
• Upgrade from SQL Server 2000 to 2005.
• Database design and structure, upgrades and roll out of Oracle 10G on Linux.
• Design of Data marts to roll into Warehouse using Oracle 9i.
• Ensured SOX compliance implementing data security and auditing for company.
• Responsible for Application performance and tuning of third Party applications, Financials, Gains, Millsystem systems.
• RAC proof of concept using Oracle 9i.
• Managed 40 Oracle databases on Sun Linux and manage 2nd tier Oracle Applications Server and Oracle Financials GL, FA and currently planning implementation of AR /AP in multi-terabyte environment using Net-Apps.
• Experience with Oracle 11.5.10 includes implementation, patching, performance tuning and upgrade to 11.5.10.2 on both single and multi-node environments.
• Managed Cognos 8.2 reporting effort.

Confidential

Sr Oracle Database Engineer /Oracle Team Lead Contract

• Met with Vice President and Director to discuss migration from IBM mainframe to Oracle 9i.
• Responsibilities include performance tuning, capacity planning, training and database design teaming with vendors to provide both logical and physical designs of future implementations.
• Outline of standards and procedures and implementation of database monitoring methods, security, auditing defining roles and privileges.
• Designed and implemented a Sun Cluster 3.1/RAC environment to support AIG web business processes.
• Architect and oversee the design, maintenance and implementation of the organization production/tests databases
• Setup Sun V880 servers for Oracle installation.
• Managed data migration and conversion from IBM Mainframe to Oracle.
• Created test environment for Oracle 9i data mart.
• Designing disaster recovery and backup using Netback up with RMAN. Using Verities Volume Manger for disk management.
• Application and development tuning rewrite of PL/SQL, SQL code. Using Discoverer, Oracle Forms and Reports the Developer Suite.

Confidential

• Director of Database Technologies Database Worked with Siemens , IBM and Benchmark Data as a Senior Database Engineer to design business process flow, billing processes for DFW Airport Terminal D International . Designed the databases on IBM AIX server using Hitachi 9500 storage systems.
• Responsible for redesign of other Production databases and solving major performance issues with development, Business Objects, Oracle Forms, PL/SQL and clustering.
• Logical and Physical design of multi Tera-byte database to support airport.
• Unix Admin duties included setting up AIX servers for RAC using HACMP, creating user groups, adding users, selecting and implementing high capacity storage Hitachi 9500 thunder storage arrays.
• Environment consisted of a 3-node Sun server Veritas Cluster, Veritas Volume Manager and Oracle9i Data Guard with RAC using Netbackup
• Business Objects Application and performance tuning.

Confidential

Sr. Database Manager and Database Technology Team Lead

• Implementation and application tuning of Quality Assurance System ECATS in Nationwide rollout for Ford Motor Company.
• SAP R3/Basis Database Administration of ECATS reporting.
• Performance tuning of DSS Data Warehouse and development coding PL/SQL and Ecats.
• Training DBA's.
• Architect and oversee the design, maintenance and implementation of the organization production/tests databases and Ford QA Rollout.
• Provided 3rd party support to servers adding memory, disk, back channels, mount points etc.
• Oracle Financials performance tuning and auditing
• Korn shell scripting from check process testing.
• Upgraded SQLSERVERS from 200 to 2005.
• Redesign of present databases and implementation of nationwide monitoring system.
• Migrated data from SQL Server to Oracle10g.
• Data Modeling and Implementation of Advanced replication in a Multi-Master Extraction from Teradata database and migrate data to an Oracle 9i database on HP-UX, Solaris and Windows environments.
• Implement OPS, Physical and Logical standby at plants throughout the U.S.

Confidential

• Environment - Oracle 9iAS and Oracle 9i on Linux
• Installed 9iAS on Linux platform using Dell hardware.
• Support of 11i Financials, General Ledger.
• Design of Dallas new data center.
• Configured portals and Web for 3rd party application.
• Data modeling both logical and physical.
• Oracle 8-8i support for SAP R/3.
• Data Migration from SQL Server 7 to Oracle.
• Designed and implemented Oracle 9i database to support 2nd tier.
• Identified network issues that aborted previous installations.
• Managed Applications Help Desk.

Confidential

Sr. Consultant

• Environment - Oracle 8.1.7 on NT, 9.0.1 on Solaris 8
• Upgrade 25 NT Instances to 4 Instances running on 9i Solaris 8.
• Logical Design of new database and Oracle 11i General Ledger Modules.
• Unix admin duties included adding a 2nd back channel to V880 Sunfire Sun Server for redundancy, defining mountpoints for database installation and creation.
• Physical Design of new database and backup strategy using Netbackup and RMAN.
• Assisted in upgrade of Hardware Added controller to V880 Sunfire
• Redesign of databases to be OFA compliant.
• Implementation of Physical Standby with Data Guard
• Performance tuning Oracle databases and Applications.
• Identified issues that prevented future growth of infrastructure.
• Outlined standards and procedures for future data migrations.
• Designed template for future database creation.

Confidential

• Environment - Oracle 8.1.7, Sun Solaris 8
• Redesign and implementation of Development and Production Databases.
• Solve poor performance problems in Production.
• Implement Advanced Replication and RAC Proof-of-Concept.
• Data modeling both logical and physical.
• Implemented performance monitoring tools.
• Implemented OFA compliant RAC design
• Environment - Oracle 8.1.7, PeopleSoft HRMS Module
• Provided performance tuning.
• Supporting Human Resources at Concentra Corporate HR.
• Managed technical support Help Desk
• Redesign of Production database supporting PeopleSoft HRMS module.
• Implemented performance monitoring tools.
• Oracle 11i Financials.
• Performed database health analysis.

Confidential

• Environment - Oracle 8i, ATG Dynamo
• Sr. Oracle DBA responsible for new database design and implementation.
• Responsible for data migration from old website to New AA.COM.
• Wrote procedures to extract and load new database with over 99 million rows of data.
• Provided support for ATG Dynamo environment.
• Data conversion from Sabre to AA.
• Planned implementation of RMAN, and Performance monitoring of production.
• Design Star schema database for OLAP using DSS construct Data warehouse

Confidential

Senior Database Architect Staff Reduction 11/01

• Environment Three-Tier Client Server. Database Oracle 8i, 9i. Applications Oracle Financials, Dynamo, WebSphere and Marcole consisting of 9 Databases in Test, Development and Production using Solaris.
• Responsible for redesign of some development databases to support application tuning effort.
• Optimize Oracle based processes and implement backup strategy using Netbackup.
• 3rd Level Technical support for Web sites and Databases.
• Perform Logical and Physical design and Capacity Planning.
• Database Project Lead on Gift Registry Project designed both physical and logical and implemented new database.
• Migration of data from Teradata, Informix and DB2 databases to Oracle 8.1.7.
• Sr. Oracle DBA responsible for production support of Neiman Marcus online in a Veritas Clustered environment using WebSphere and Dynamo.
• Migration from Informix to Oracle 8i and Data Modeling using Erwin 3.5.2
• Testing of Oracle Financials vs. PeopleSoft in Oracle Labs.
• Performed business analysis to solve performance and database availability issues.
• Implemented ORACLE 8i automated standby database to provide disaster recovery.
• Wrote and automated scripts to monitor performance using crontabs and dbms jobs.
• Implemented StatsPack and Quest Spotlight for performance monitoring
• Responsible for data migration from Test and Development environments.
• Outline Proof-of Concepts for disaster recovery and Oracle Financials.

Confidential

Sr. Manager of Database Technology company closed on 4/2/01

• Environment - 30 Sun Servers running Oracle8i and Wireless Technologies.
• Served as Database Engineer performing all ORACLE 8i physical and logical designs, installations and upgrades, applying patches, auditing and security, creation and management of database schemas, storage management, application tuning, database performance tuning, and backup/recovery on SUN platform in a multi-terabyte environment.
• Served as Project Lead, responsible for the activities of 8 team members consisting of DBA's and developers.
• Data Conversion from Pepsico to Vast Solutions.
• Implemented Foglight by Quest for Monitoring and Quest Central for Problem resolution.
• Supervised Help Desk Support of Telecom and Wireless Technologies related to databases.
• Extract data from Teradata software deposits and import into Oracle 8.1.7 to meet CLA.
• Implemented Remote database monitoring for Metroplex clients.
• Responsible for Data Modeling physical and logical design with development team.
• Design of Data mart to support GPS.
• Performed testing of ORACLE databases using 6i tools within a lab environment.
• Implemented Veritas Cluster Server and NetApps SnapMirror and Snap Restore.
• Used Netbackup and RMAN for major backup strategy
• Performed business analysis to solve performance and database availability issues.
• Responsible for training 4 Junior ORACLE DBA's within team.

PEPSI, FORD and BMW

• Responsible for the physical and logical design and implementation of the ORACLE 8i automated standby database to provide 24/7-availability to clients.
• Solved performance issues by increasing hits rates from 59 to 100 .
• Implemented Standby databases and Replication in multi-terabyte environment using Net-Apps.
• Implemented Advanced Replication using SharePlex by Quest proof-of-concept .
• Implemented function based indexes to eliminate full table scans while provisioning.
• Wrote PL/SQL scripts and used JDeveloper 3.1 and 3.2.3 for troubleshooting provisioning system. Tested with SQLSERVER.
• Created new primary database structures table spaces , primary objects tables, views, indexes, and constraints .
• Promoted to New Product Development Manager overseeing GPS project with BMW.
• Migrated data between test and production databases using import/export and SQL Loader.
• Installed and implemented the use of monitoring tools such as OEM diagnostic, tuning packages using Spotlight by Quest.
• Performed business analysis with and evaluation matrix for database availability solution.
• Responsible of all new products and their application conforming to the Logical and Physical model and began testing with Oracle 6i Forms and Reports.

Confidential

Senior Oracle DBA Consultant Staff Reduction

• Texas Instruments
• Responsible for the physical and logical design, implementation and performance tuning, of ORACLE 11i, 8i, and database software packages on SUN for multiple Texas Instruments installs, including Oracle Manufacturing Modules for Advanced Planning, Bills of Materials, Cost Management, Engineering, Flow Manufacturing and Quality.
• Application tuning of Oracle, Lawson environment.
• SAP R/3 Basis installation and support.
• Migration of data from Teradata database to Oracle 8.1.7.
• Team Lead for Database implementation and New Server roll-out for Texas Instruments.
• Unix Admin duties included defining and creating mount points for OFA. Oracle Flexible Architecture creating users groups, application install points, fail over and cloning of DEV, TEST and Prod environments.
• Data Conversion from Texas Instruments to MEMC.
• Support of Lawson financials and reporting.
• Database design, modeling and upgrades of Oracle 10i to Oracle 11i.
• Installed consolidated patches to solve various bugs in Oracle Manufacturing package.
• Setup Oracle Parallel Server for client Texas Instruments .
• Setup Automated Standby database.

Blockbuster

• Worked as part of data warehouse team.
• Performed business analysis and workflow using Oracle designer.
• Principal in testing code and data warehouse performance.
• Tested data gathering and data load processes.

Confidential

• Responsible for the physical redesign of 5 Oracle databases and ORACLE Financials, Performed Senior level ORACLE and System Architect duties for client.
• Implemented database monitoring for performance in Solaris environment.
• Installed MetaSolv software 4.0 thru 4.2 in support of Ernest and Young Group to go live.
• Implemented new processes for data migration between Development, Test and Production.
• Implemented partitioning of large tables.
• Disaster Recovery using Veritas and Oracle Replication.
• American Heart Association
• Performed business analysis for American Heart Association outlining single point of failure for primary database, and oversaw the implementation process to resolve issues.
• Trained Jr. DBA's in creating database storage structures and insuring OFA compliance.
• Co-Responsible for Data Warehouse model utilizing ORACLE Designer/2000 and Erwin.
• Tested some applications in SQLSERVER test bed before Oracle testing.
• Worked on projects with databases up to 4 terabytes in size.

Confidential

• Performance tuning and database monitoring. Migration of data from SQLServer and Teradata Database to 8.1.7.
• Support of Lawson.

Confidential

Senior Consultant

• Responsible for installation, modifications, upgrades and support of ORACLE database schemas as well as newly created databases for a telecommunications company.
• Responsible for design of database storage on EMC Symmetrix creating volumes groups and logical volumes in a V-Class HP 9000 Unix environment.
• Implement disaster recovery procedures.
• Rollout of Apple laptops to Kaiser Permanente Harbor City.
• Sqlserver Installation and Cisco switches in Kaiser Permanente Santa Monica.
• Sqlserver installations in Kaiser Permanente Pasadena.
• Wrote scripts and procedures that monitored the performance of the database.

Confidential

Senior MIS Manager /Senior DBA/Interim Director of M.I.S

• M.I.S Manager/ Interim Director of I.T.
• Responsible for Operations, Network, Technical Support and Help Desk. Reporting Team included in a 1200 server multi-terabyte environment using EMC.
• Manager of Operations, Supervisor of Networking, Supervisor of Technical Support at Corporate Operation in Mexico City Development Team and UK.
• Reverse engineering using Erwin and physical and logical design using Erwin.
• Optimized Oracle and ERP application processes and ERP modules application tuning..
• Migration of DB2 to Oracle,
• Supported initial internal Microsoft environment Microsoft Exchange, SQLServer 7 and 2000 for corporate office.
• Data Center move from one city to another consisting of 1200 servers.
• Implementation of Glovia SAP reporting with Oracle 3rd tier.
• Responsible for software performance comparisons between Baan, SAP, Oracle's ERP packages and Glovia's ERP package within a test-bed environment and installation of SAP Oracle ERP TEST.

Confidential

• Member of four 4 man SWAT team responsible for saving ERP installations when first, second and third level support failed on HP, SUN and NT platforms.
• Performed ORACLE implementations and upgrades.
• Responsible for software performance comparisons between Baan, SAP, Oracle's ERP packages and Glovia's ERP package within a test-bed environment.
• Migrated data from test and production staging system to NT and/or UNIX box for turnkey operation by customers using Glovia's ERP package.
• Responsible for training 3 Jr. DBA's within the group.
• Designed Reports using Developer/2000 assisting development team.
• Data modeling for clients as well as corporate environments.
• Wrote PL/SQL procedures to improve implementation of Glovia's ERP package.
• Wrote PL/SQL scripts for troubleshooting and testing for memory leaks between Glovia modules and PROIV code.
• Directed database technologies related to implementation of ORACLE databases on both NT and UNIX platforms supporting databases up to 3 terabytes in size.
• Performed logical/physical implementation and reverse engineering utilizing Designer 2000 and implementing of new backup strategy using Netbackup for entire environment.
• Worked on special project with Dell on the development Enterprise capable servers running ERP systems and large databases on NT.
• Forecast database growth and plan and test new database tools for business enhancement.
• Tested ERP Modules on SQL Server and Oracle.
• Revising of backup strategy using Netbackup with EMC Symmetrix and BCV's.
• Implemented OPS Oracle Parallel Server with version 8.0.5.