SKILL KEYWORDS - Senior Oracle DBA, SAP R/3 Basis Administrator, SQL Server DBA, Data Modeling, Oracle Financials, PeopleSoft, Oracle9i, Oracle8i, Oracle Designer & Developer, Project Management, Business Process, System Engineer, System Analysis & Design, UNIX, Sun Solaris, HP, MS Windows 2000 & Windows XP, Resume of Howard A. Woods Full Time, Consultant, Contractor, Contract
Oracle DBA and SAP Basis Administrator on SAP Release 4.6D. Performed database installations, upgrades, monitor, performance tune and support operations of mission critical high available Veritas clustered Oracle8i and Oracle9i Enterprise databases running in a heterogeneous environment along with SAP R/3, Microsoft SQL Server 2000 and mySQL databases on Sun Solaris Unix servers for Adobe Systems new Internet e-business initiates: Adobe Store, Adobe Studio, Network Publishing and BW. Provided architecture, design and development support, such as validating schemas in the early stages of the project life cycle to ensure sound relational database application designs that are performance tuned and optimized from inception. Supported the production systems using world-class best business practices and solutions to guarantee 24x7 availability of databases for internal and external systems. Performed SAP Basis administration using SQLDBA, user administration/authorizations and Transports on a large SAP R/3 implementation on Sun E10, 000. Performance tuned production systems using Oracle Statspak and Oracle Enterprise Manager (OEM) Expert Tuning pack for optimal SQL and database performance. Created procedures, policies and wrote several documents and plans for backup and recovery, monitoring, fail over and capacity planning of database servers using Oracle Recovery Manager (RMAN), BMC Patrol and OEM. Evaluated and predicted hardware and software needs to support rapid growth, performance and availability needs of multi million user Internet database systems for Adobe Studio and Adobe Store. Planed and implemented data migrations and conversions on SAP R3 from Oracle to SQL Server. Provided technical leadership and consulting to development teams and support personnel in the implementation and maintenance of distributed Oracle databases.
Provide 24x7 automated lights out mission critical production support for the AllAdvantage.com Internet Web Site. Setup a Distributed and Replicated Clustered High Availability Active and Stand-by cross country database environment using Quest SharePlex and Oracle Replication. Create, design, and maintain physical/logical databases and resolve database errors as well as performing database backups/recoveries. Review operating system configurations on DBMS to ensure optimal performance and availability. Work very hard and very smart in solving the challenges and issues of keeping systems up and running in a fast-paced Web environment consisting of Unix Sun Solaris, Oracle 8i Databases and Application Web Servers.
Designed, configured and installed several distributed replicated high availability production, QA and development Oracle and MS SQL database environments on Sun Solaris and Windows NT platforms for all PG&E Energy Services database applications. Applications included Oracle Financials 10.5 and SAP R/3 Financials, Human Resources, Baun/Aurum Salestrak, ALTRA GMS, ETRM, Meter and Pricing and Data Warehouses. Responsible for the successful definition and design of all SAP R/3 BASIS processes and procedures, including the design and operation of SAP's CTS (Configuration Transport System) to ensure secure and reliable transport of configuration and other data between SAP environments. Also prepared and refreshed clients for SAP developers. Provided second line technical support to the Help Desk staff and other Oracle DBA's and UNIX System Administrators both in San Francisco and in Houston data centers. Mentored and provided oversight and backup for the production Oracle DBA's in Houston. Industry best practices, standards and documentation were applied to all normal Oracle DBA functions and tasks, including database backup and recovery, performance tuning, database modeling and application review, capacity planning and server side application administration and support. Contributed to the "big picture" technical vision and architecture as well as worked at the detailed technical level "hands on". Priority technical support was provided to all business applications systems project managers and developers, to ensure their mission critical business projects and processes were successful. Worked closely with the Architecture & planning function to ensure conformance with selected technology standards, methods and tools. Acted in various project roles including project team member, team leader and Project Manager. Designed and implemented a full lifecycle production, development and test environment for start-up de-regulated electric meter reading and customer billing system using Oracle 8 Server, Oracle Designer 2000, Oracle Developer 2000, PL/SQL, C++ on Sun UNIX and Compaq 7000 NT Systems. Installed and implemented a production, development and test SAP R/3 System on Compaq ProLiant 8000 and 8500 NT RAID and Oracle 8 with Cheyenne ARCServ RAID Tape Array. Supported Aurum SalesTrak 6 & 7, Quintus Helpdesk, EDI and Inter/Intranet applications. Installed and managed several Oracle 7 and 8i Database Servers and MS SQL Server 7 databases ranging from corporate application to internet and internet Web servers on Sun Sparc Servers and Compaq 8000/8500 servers, NT and NT clients. Migrated several MS SQL Server and MS Access applications to Oracle. Installed and maintained Oracle Application and Web Server, MS IIS and Netscape Commerce Web Servers. Wrote Unix Korn/Bourne shell scripts, NT scripts for Oracle backup and wrote disaster recovery and standby database failover procedures.
06/93 - 9/97 Octel Communications Corporation, Milpitas, CA
Implemented the full suite of Oracle Applications across all Octel's operations from Release MPL 9.3 to 10.7, including finance, manufacturing, revenue accounting, purchasing, alert, receivables, general ledger, payables, assets, order entry, forms, reports, oracle application object library programming. Other applications included Scopus Helpdesk, Business Objects, Crystal Reports, PeopleSoft HR, Quintus CustomerQ Helpdesk, Clarify, RS/1 and Manugistics. Database responsibilities included Logical and Physical Data Modeling using Oracle CASE Designer and System Development Life Cycle - Oracle CASE Methodologies, tuning and performance, problem determination and resolution for several large databases. Because of my robust development background, I worked with the project managers & developers to implement databases & products properly in oracle. Planed, installed, reorganized, upgraded, rebuilt and migrated several Oracle version 6 & 7 database with an emphasis on tuning. Installations included Oracle Financials 9.3 to 10.7, incorporating the full suite of Oracle financials and manufacturing packages, on several systems ranging from HP9000 T500 to HP9000 servers. Coordinated, reviewed and assigned work to other operations DBA's. Mentored other non senior and junior DBA's. Installed and configured Oracle using the ORACLE Optimal Flexible Architecture (OFA) Rules. Duties included implementing procedures and processes for automated lights out backups, recovery, space allocation reports, capacity planning, troubleshooting and performance. Also, designed, developed and managed a large Oracle Data warehouse database.
Application Developer & Database Programmer on the Space Station Freedom Project. Developed Drawing Review & Annotation System Database Application in ORACLE RDBMS Version 6 & Forms 3.0, PL/SQL, Pro*C precompiler and VAX C compiler. Used Knowledgeware CASE Designer tools. Developed the database for Engineers to enter, review, annotate approve, and submit drawings for the Space Station design to Rocketdyne.
Performed all major tasks of ORACLE DBA. Researched and determined which ORACLE products meet the organizational data processing needs. Wrote proposals, purchased and installed ORACLE RDBMS and Application Tools on VAXcluster 4000-650, MicroVAX 3300 and IBM PC. Developed a Configuration Control Application in ORACLE RDBMS Version 6 using Forms 3.0, PL/SQL, Pro*C precompiler and VAX C compiler. Developed a Malfunction database for Instructors to enter Malfunction data into, using Forms. Developed a Nation Wide Computer Configuration Database, listing various configurations of other Specialized Computer Systems. Wrote interactive and batch 3GL programs to access databases using ORACLE data structures. Developed, debugged and enhanced 3GL programs using PL/SQL, VAX C, and Pro*C.
UC Berkeley, San Francisco, Business Management courses
Wayne State University, Detroit, MI Bachelor of Engineering Technology - (Pending)
Henry Ford Community College , Dearborn, MI Associate of Science
| SAP R/3 Basis Technology | SAP R/3 Windows NT 4.0 / Oracle Technical Core Competence |
| SAP R/3 Database Administration Oracle | SAP R/3 Workbench Organizer Transport System and Upgrade |
| Masters Certificate in: Oracle Database Admin | Masters Certificate in: Oracle Appl. Development |
| Oracle Designer 2000 System Modeling And Tools | Masters Certificate in: ORACLE Technical Support |
| Oracle CASE Tools | Oracle Financials: System Administration |
| Data Modeling and Relational Database Design | Oracle7: New Features & Options |
| Advanced ORACLE for Developers (SQL*Forms) | Introduction to ORACLE for Developers (SQL*Forms) |
| Tuning ORACLE Applications | ORACLE Database Architecture |
| Microsoft Windows NT Workstation & Server | ORACLE Database Administration |
| Advanced Assembly Language Programming | Novel Netware Basics & RS/1 Statistical |
| System Administrator Functions & Internals | Advanced FORTRAN 77+ |
You are visitor
This page was last updated on April 17, 2002