SUMMARY:

• Accomplished and Certified Oracle DBA having 18+ years of experience with ORACLE (V5 through 12C) on AIX, HP - UX, VMS, NT, SUN-Solaris, SCO-UNIX, Redhat and Suse Linux in single and multi-tier environments
• In-depth knowledge of ORACLE database administration, also experienced in SQL-Server 200x, SQL-DS/DB2 and Sybase
• Excellent experience and skills in capacity planning and sizing for large scale systems.
• Experienced in Schema design, performance monitoring and tuning, Oracle Application Servers, Backup & Recovery techniques and strategies, Oracle Standby, Data-Guard, and Database-Replication
• Excellent written and verbal communications
• Highly skilled at performing logical and physical design of Relational databases
• Highly proficient in ORACLE and SQL-Server database installation, configuration and tuning in multiple environments on local servers and Cloud environments.
• Experience with AIX, Solaris, HP/UX, RedHat, and other flavors of Linux Systems Administration in both single node and Oracle Cloud environments.
• Experience with oracle Applications Servers using Oracle 9i and 11G application servers
• Experience in Web content presentation using Java script, HTML, PHP and XML and . Net environments
• Experienced in tuning, monitoring and configuration products such as Stats-pack, Spotlight, Foglight, TOAD, Solarwinds, AWR, ASH, Erwin, and DB-Artisan,
• Experienced in Large Scale SAP R2/3 environments with BW,CRM, SRM and SCM
• Experience in Oracle EBS 11i, R12 - RH-Linux/Sun Solaris. Upgrade includes modules GL, AP, AR, FA, PO, HR/Payroll, and iExpense
• Experienced as Lead DBA, Project Manager, and Mentor assisting clients with Defining, Securing and Executing projects as well as training in-house DBA and Applications staff
• Excellent understanding of SOX requirements and implementation as required by COBIT, PCAOB and COSO
• More than twenty years of experience as an I.T. instructor, including courses in Basic, C, Cobol, Database Design and Theory, 3GL-Languages, ORACLE programming, Developer 2000 and ORACLE Database Administration I and II

• Experienced in Oracle, MySQL, MS-SQL and other DBMS’
• Database migrations and upgrades planning and execution
• Disaster Recovery Strategies, Planning,Testing and Documenting
• Coordination of Application Design, Testing, Promotions and Migrations
• Plan, access and implement backup strategies
• Plan, implement and test security strategies
• Plan and coordinate Upgrade and Migration strategies
• Meetings and discussions with business owners for requirements gathering
• Planning and recommending implementing storage requirements based on estimated growth

TECHNICAL SKILLS:

• Solaris
• HP3000/9000
• Sun servers
• ORACLE VM/Cloud
• VMWARE/Cloud
• AIX
• MS SQL SERVER
• REALIA COBOL
• PEOPLESOFT
• ORACLE ERP
• REALIA-CICS
• SAP
• ORACLE DESIGNER
• MS ACCESS
• SQL
• ORACLE DEVELOPER
• MS ACCESS
• SQL*PLUS
• POSTGRES/SQL
• SQL/DS - DB2
• PL/SQL
• MYSQL
• HTML/JAVA
• ERWIN
• TOAD
• WINDOWS
• LINUX
• AVAMAR
• DDBOOST

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

Sr. Oracle DBA

Responsibilities:

• Duties include Performed duties as a Sr. level Oracle DBA and Oracle EBS DBA.
• Performance tuning, Backup and Recovery, Server and Database Provisioning on Oracle VMWare
• Oracle EBS R12 configurations, SSO and OAM environments
• Ensuring that all environments meet both PCI and GDPR Compliancy standards for protecting our clients dataSupport for large scale OLTP environments for TELCOM and Cable Communications billing, E-Care Services, E-Commerce and Mobile Services.
• Production support for Intec SinglE-view, including Multi-layered Physical and Logical Standby Databases
• Considerable experiences in performance tuning with AWR reports on more than 100 Database environments.
• Training Mid and Junior Level Oracle DBA’s to perform all aspects of database management and processes.
• Conducting meetings with customers and training sessions for other DBA’s for new technologies.
• Performing Database upgrades using standard DB upgrades techniques and Rolling upgrade techniques from 11G to 12C.
• Performed Database migrations using RMAN, DATAPUMP, Oracle Golden-Gate and VM’s V-motion technologies.

Confidential, Houston, TX

Lead Oracle DBA

Responsibilities:

• Working with many global users to provided ORACLE 11G- 12C, in and VMware with Red-hat and Oracle Linux environment.
• Performed duties as a Senior Database Administrator on a Data-Warehouse system for corporate level reporting.
• Installation and configuration in OBIEE.
• Performed Oracle and Linux installations and configurations and testing. Reconfigured server environments to take advantage of the Linux volume management processes.
• These duties included Performance tuning, migration and implementation. This environment I migrated from 11G to 12c and upgraded both Linux and Oracle versions. This effort resulted in a significant improvement in the overall Data Warehouse build time.
• Performed upgrade and migration of Data Warehouse databases from 11Gr2 to 12C, provisioned new servers with Oracle 12c. I was able to tune the environments and take advantage of Oracle’s parallel processing and in-memory technology to reduce the Data Warehouse load time by more than 10 hours.
• Implemented and SDLC process to control database and application updates to prevent application and DB failures.
• Performed live Oracle database clones to migrate databases between Production, QA and Dev environments.
• Installed and tested SPLUNK to for server and database log review to perform required security measures.

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Working with many global users to provided ORACLE 10G - 12C, MS-SQL 20xx in and VMware with RedHat Linux environment.
• Mentored onshore and offshore staff of DBAs to perform day to day tasks.
• I was also responsible for current physical sizing and forecasting to match the long-term plans of the organization based upon data-feeds from disparate corporate systems.
• Assisting with data transformations from Data-Landings from incoming feeds, designed and implemented Operational Data Stores for first layer transformations and further transformed for the primary Data-Warehouse and Marts.
• Responsible for DB Security using LDAP, and Oracle SSO technologies.
• Performed duties as a Development Database Administrator on a Data-Warehouse system for corporate reporting. Using Toad Designer, to perform transformations of a logical database design into physical database.
• Also responsible for the assisting the Informatica team for accessing all Oracle environments to perform all aspects of data-movement between environments.
• Responsible for 11G RAC environments support for Well Metering Systems, planned and performed rolling upgrades and patches for all RAC nodes.
• Installed and configured Oracle’s Business Intelligence (OBIEE) and WebLogic middleware software for use with the Informatica’s Master-Data-Management (MDM).
• Provided support for MS-SQL assisted in provisioning databases, SQL performance tuning as well as database backups and recoveries.
• Provided production database administration support duties, which responsibilities included production support for database environments with FlowCal for well metering data, Aries system for Well field data information and financials, GIS for well and field mappings, design and support, as well as many other O&G related systems.
• Other products such as EMC’s DD-Boost and Avamar Backup Utilities. Erwin and Toad Data Modeling tools, OEM12c and Spotlight and Oracle OS-Watcher were used in this environment for production support and performance monitoring and tuning.
• Working with HP’s High Performance Computing (HPC) and VMWare in a 100% virtualized environment for large-scale databases in this environment.
• Responsible for database auditing, Sarbanes-Oxley and Security reporting related to all environments for governance reporting and working with both onshore and offshore teams.

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Working with many global users to provided ORACLE 9i thru 11G, RAC and 11G Data Guard implementation and configuration as well as general Oracle maintenance and OEM and Grid.
• Implemented scripts and schedules for Backups, Recovery Scenarios, and SOX reporting, performance tuning as well as every day production and database management as well as Oracle Migrations and Regression Management.
• Automated Oracle database duplications for many database environments via Materialized Views in Sun Solaris and Linux to support many different environments including SCADA, FLOWCAL, Large Data-Mart’s and various ancillary Oil & Gas related systems.
• Responsible for Installation and Configuration for Oracle 10 and 11G in RAC and Non-RAC production environments and HP’s High Performance Computing.
• Responsible for all aspects for Oracle EBS 11i including Apps layer and Database Performance, Environment Upgrades and Application accessibility in the Canadian divisions as well remote Data-Guard and Regression environments in the located US.
• Installed and configured Oracle TimesTen environment as a Proof of Concept. I provided the systems Architecture, installation, build-out and test of the environment, Performed upgrades and patches to the environment as required until the organization decided to go in a different direction.

Confidential, Houston, TX

Lead Oracle DBA

Responsibilities:

• Provided ORACLE 10-11G, RAC and Data Guard as well as MS-SQL implementation and configurations as well as general Oracle and MSSQL*Server database expertise and support for this client
• Performed PeopleSoft 8.x Financials Upgrades, Administration, Implementation and Configuration of this environment
• Provided daily support for implementation and 1-off systems interface support; daily monitoring as well and maintenance of the PeopleSoft Process Schedulers and People Tools
• Supported Power-Tax and Power-Plant Database and Application implementation for Financial Data for Corporate Taxes
• Implemented scripts and schedules for Backups, Recovery Scenarios, and SOX reporting
• Automated Oracle database duplication for many database environments in AIX and Windows to support Financial Data mart’s and integrated testing schedules
• Installed and Configured Oracle APEX (Application Express) product on Windows 2003 Servers for Corporate Reporting capabilities for Finance, Supply Chain management, and contract management
• MS-SQL database provisioning, SQL performance tuning database backups, restores and recoveries.
• Assisted in training other DBA’s with the use of Oracle’s Data Guard and Standby databases

Confidential, Houston, TX

Lead Oracle DBA and Architect

Responsibilities:

• Provided ORACLE 10g and RAC database expertise and support for this client
• Installed and configured Oracle Database and Application Server
• DBA and Architect for DC5 system that controlled specialty printing for Confidential clients who were large Healthcare and Financial institutions
• Provided Microsoft-SQL*Server database support and transformations to Oracle environments via DTS and SSIS jobs defined for data migrations between multiple database environments
• Responsible for work assignments for development team and schedules for the project completion
• Reported directly to upper management for project phases and progress

Confidential, Houston, TX

Senior Oracle Applications DBA

Responsibilities:

• Provided ORACLE 9.x - 10g database support for this client.
• Installed and configured I-Flex financial and banking solutions database environments for Flex-Cube and Reveleus for the Private banking industry and Asset allocations and Risk management.
• Installed and configured Oracle Applications 11i/R12 for GL, AP, AR, HR, Time & Expense, iExpense, HR Business Intelligent modules.
• Performed product and Major EBS 11i to R12 release upgrades as well and 11i/R12 patch research, management and installations across multiple environments for both US and International based environments.
• Responsible for User Management, Web Services configurations, tuning and management and Virtual hosting for internal and external web-interfaces from the Oracle Applications Environments.

Confidential, Houston, TX

Lead Oracle DBA

Responsibilities:

• Lead DBA for Confidential (Employee Tine and Attendance) project, utilized to track employee schedules as well as traded schedules and provided data exchanges to the payroll application. Assisted with the Bio-Metric interface for time-clock information
• Lead DBA and Project Lead for 9iRAC installation on windows 2003 servers in support of the Staff Manager and Oversold systems, which provided 99.9% uptime of this application
• Lead DBA, Project Lead for 8i to 9i migration and integrating a new Employee Time Tracking system for “ Confidential ” food services division
• PeopleSoft Administration and upgrades, daily performance monitoring as well and maintenance for the all related systems using HP-SuperDome, HPUX and Windows 2003, and Linux (ES-4 )
• Translated MYSql database environment to Oracle 9i.
• Installed and configured Linux RH-ES4 and Oracle 10G for testing environments

Confidential

Oracle DBA/Apex Developer

Responsibilities:

• Provided daily support for implementation and 1-off systems interface support; daily monitoring as well and maintenance of all Development, Test and Production Databases for an Offshore project.
• Supported and assisted Developers with efficient query design for increased performance and throughput.
• Implemented scripts and schedules for Backups, Recovery Scenarios as required by local governments.
• Automated Oracle database duplication for many database environments in Sun Solaris to support Financial Data mart’s and integrated testing schedules
• Installed and Configured Oracle APEX (Application Express) product and designed many sub-applications for Government contract management.

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Provided ORACLE 8.x - 9.x database support for this International Waste firm
• Performed administrative tasks for 200+ oracle environments to support a wide range of applications. One of the most important Waste-Route, a GIS based tracking system utilized to track, assist and support the movement of thousands of the companies vehicles through out the US and Canada
• Performed the day to day support of Service and Repair system called Compass utilized to track the maintenance of all company vehicles as well as order parts from OEM’s as well as implementing Oracle Dataguard for high availability. This included configuration and maintenance of the JDK and JDBC interfaces using Webshere as the application Portal
• Implemented Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience
• Assisted in 9iRAC initiative to build simple cluster to perform proof of concept for UNIX clusters
• Performed PeopleSoft Administration in the form of upgrades, daily performance monitoring as well and maintenance of the Peoplesoft Process Schedulers and People Tools

Confidential, Houston, TX

Lead Oracle DBA

Responsibilities:

• Implemented Oracle 10G Database and Application Server environments on RedHat Linux.
• Instrumental in applications integration and implementation using Confidential ’s own product line with Oracle 10g Database and Application Servers and implementation of a Hybrid data-mart environment.
• Implemented multiple reports and applications using HTMLdb, 10G App. Sever and Apache to report monthly sales data to management from existing Excel Spreadsheets on 10G Linux application server.
• Augmented in-house staff by performing the role of a Linux Administrator to assist with server implementation and configuration and establish Best Practices for Database and Oracle Application servers.
• Installed and configured Oracle Application 11i for GL, AP, AR, HR, Time & Expense, Business Intelligent modules.
• Performed patch upgrades as well patch Environment cloning, researched and managed environments across multiple platforms

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Provided ORACLE 7.x - 8.x database support for this Energy/Chemicals firm in a Lead role
• Responsible for all aspects of Database Administration including, creation, performance tuning of all aspects of the Oracle environment, ranging from Memory and Process designation to internal object tuning
• Instructed the internal DBA staff many methods of backup and recovery of both transactional as well as Warehouse databases to decrease recovery time. Used SAP/Oracle backup (brbackup) and BCV backup technology using HP/UX and Supredome technology
• Defined and Tested backup and recovery strategies for several major SAP projects prior to production go-live and established XOM/Oracle Best Practices per XOM standards and requirements
• Managed multiple large Oracle/SAP environments utilizing SQL-PL/SQL scripts and as SAP utilities
• Performed Applications DBA duties on Oracle Financials using Oracle Applications Manager, Oracle Forms runtime and OA Administration and Apache servers
• Performed lead DBA duties, project breakdowns and assignments for World-Wide Implementation of multiple projects including GEMS, SAP-HR, BW, SCM, CRM and Web-based applications using HP-UX, HP-Superdome and HP’s Service Guard, AIX and Veritas
• Supported Siebel implementations and BSI Tax factory database and applications installation and upgrades

Confidential, Houston, TX

Oracle Database Administrator and UNIX Administrator

Responsibilities:

• Provided remote Database and UNIX administrative using Sun Solaris and Linux
• Responsible for all aspects of Administration on Sun Solaris 5.x, Redhat and Suse Linux, and Oracle V8.x through V9.x
• Responsible for UNIX and Oracle User Management for 15 to 20 Oracle courses taught by the college each Semester which typically includes two-four hundred user accounts and oracle access using both Oracle and Non-Oracle tools for course and administrative purposes
• Conducted training sessions with support staff and instructors each semester to address concerns and issues as well as to introduce products in the Oracle product line
• Designed and implemented Disaster Recovery for environment using standby databases and simple user environment replication

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Provided ORACLE 7x and 8.x database support for this Energy Trading firm
• Responsible for all aspects of Database Administration including, creation, performance tuning, as well as backup and recovery of both transactional as well as Data-Warehouse and Data-Marts
• Defined and implemented Disaster recovery strategy which included Standby databases for failover which reduced the overall meantime to recovery using custom written SQL, PL/SQL and shell scripts
• Performed migration Oracle 8i database utilizing raw devices to (JFS) file systems, this effort reduced maintenance time and cost by several hundred man-hours per month and simplified normal database maintenance
• Implemented Oracle’s Transparent Gateway to link to Sybase 11 databases for data feeds
• Configured and Implemented Oracle’s Inter-Media Data product to capture and feed news feeds from several news services such as Routers and CNN
• Performed duties as a Sybase 11 database administrator
• Performed Project Lead on several projects, concerning Automated Database failover and event management, which included Altra GMS, Tibco and Web-based applications using Sun’s High Availability Clusters

Confidential, Austin, TX

Lead Oracle DBA

Responsibilities:

• Provide ORACLE database administration support for this e-commerce company that specialized in On-line Customer Relationship Management
• Performed logical and physical database design for On-line help center products for Cellular Telephone Company to be used as a part of the customers CRM strategy in their call center
• Database administration duties included Installation of Oracle 7x and 8x Server and Products
• Defining backup and recovery, methodology to minimize data loss while maintaining high availability and low MTTR ratio.
• Defined and test multiple disaster recovery scenarios and techniques, to confirm recoverability incase of disaster
• Configuring Oracle 8i to support Internet front-end products. Used MTS and typical networking strategies
• Support and enhancement of SIEBEL systems products and several in-house products for various Eloyalty clients
• This environment utilized Oracle on Windows NT on Dell Servers