William Patrick Howlett
Senior Systems/Data Architect
Oracle/SQL Server DBA
Professional Resume
Educational Summary
Bachelor of Science in Computer Science - North Carolina State University
Oracle Certified DBA - Oracle 9i/10g
Certified Object Oriented Programming - Microsoft University
Professional Summary
Over 20 years IT experience working in leading-edge technological environments for the industry’s largest telecommunications, pharmaceutical, public utility and retail organizations. Held decision-making responsibilities over project management, budget, personnel and technological implementations. Successful in the design, management and implementation of high-transaction OLTP systems and of multi-terabyte decision-support data warehouses. Proven in 24x7 production settings, as well as, working in a full life-cycle development environment.
Skill Summary
Operating Systems & Tools | Databases & Tools | Middleware & Packages | Languages | Software Packages |
AIX | Oracle 11g, 10g, 9i, 8i Oracle 10gAS | Oracle Fusion/OIM, Bea WebLogic 8.1 Apache | Oracle Warehouse Builder 9i-11g Data Integrator | Business Objects XIR2 Data Integrator Crystal Reports |
HP-UX | SQLServer 2008/2005 DTS | Jboss 4.1 Tomcat | PLSQL, CrystalReports, Developer2000 | Oracle Financials 11i PeopleSoft |
Solaris | ServiceGuard, Replication, RAC, Oracle Management Server OMS/Grid Control, RMAN | MQ Series Oracle Advanced Queues | C, Pro-C, HTML, XML/XSL Dynamic SQL | BridgeGate EDI/B2B Manugistics Supply Chain |
Linux | TOAD, Erwin, Designer 2000, Embarcadaro/Sql Navigator | BMC Patrol, HP OpenView, HACMP | Perl, Unix Shell Script, Java | DataGuard, SharePlex, FogLight, SpotLight |
Windows | Oracle Enterprise Manager | Veritas NetBackup Integration | Powerbuilder | Vantive, Remedy, System Architect |
Professional Detail
Southwest Florida Water Management District
September 2007 – Present
Data Warehouse Architect – Oracle DBA
Software/Environment
Oracle 11g/10g/9i, Oracle RAC/OEL Clusters, HP-UX, OIM, Grid Control, Oracle Warehouse Builder 9-11g, Oracle Data Integrator, PLSQL, TOAD, Erwin, RMAN
Duties
Project lead for Data Warehouse initiative. Data architecture for warehouse and Operational Data Store – ODS. Designed and wrote Transformation Rules and ETL processes using PLSQL, Oracle Warehouse Builder, and Data Integrator. Other duties include Senior Oracle DBA in a RAC/Linux clustered environment. Upgrading Oracle databases and Oracle Warehouse Builder. Development and Production DBA support focusing on high availability, SDLC, backups, monitoring, tuning and reporting.
Duke Energy
Feb 2006 – September 2007
Senior Oracle DBA
Software/Environment
Oracle 10g/9i/8i, Oracle AS 10g, AIX 5.3, Oracle RAC, Grid Control, ServiceGuard, Oracle Management Server/OMS, PLSSQL, Erwin, Toad, Perl, Oracle Enterprise Manager, HACMP, EMC/SRDF/BCV, RMAN
Duties
Senior Oracle Production DBA. Participate in full-life cycle implementation of custom and 3rd party software environments. Responsible for capacity planning, performance tuning, ETL best practices, backups, trouble tickets, high-availability/RAC, Oracle AS, Grid Control, fail over/HACMP/Oracle ServiceGuard,. Member of a 12 DBA team that manages over 250 Oracle databases running on Oracle 10g-8i. Headed enterprise Oracle 10g upgrade project.
ProTel Communications
June 2004-Feb 2006
Senior Data Architect/Oracle DBA/.NET/PLSQL Developer
Software
Oracle 9i/10g, Grid Control, Oracle AS 10g, PLSQL, SQLServer 2003/2005, Java, VB .NET/C# .NET, RMAN, Solaris, RedHat Linux, Shell Scripting, Veritas NetBackup, TOAD
Description
Senior Oracle DBA for Production and Development environments. 24x7 Production support including performance tuning, Grid Control Monitoring/Configuration, backup and recovery, replication, security, capacity planning, installations, and scalability planning. Other duties including data design using Erwin, .NET/C# .Net development, and ETL processing using PLSQL, C#, and Pro-C.
Home Shopping
Feb 2003 - April 2004
Senior Oracle DBA/Developer
Software
PLSQL, Dynamic SQL, Oracle 8i/9i, Pro-C, TOAD, SQLServer, Bridgegate-EDI, MicroSoft .NET/C#, Solaris, Shell Scripting, MQ-Series
Description
Senior Data Architect for all of HSN’s B2B and EDI systems. Designed and built logical/physical data models for both EDI and B2B and authored the integration of both systems through a B2B-EDI interface within Java, PLSQL, MQ-Series and Oracle. Authored a Data Access Layor for strict access to data within Oracle via the online B2B applications. Responsible for entire life cycle of software development from Dev-QA-Production-Production Support. Also responsible for security, backups, and sizing of Oracle data files as well as the physical structure of the DB. Other key successes include performance tuning of existing applications.
MedUnite, Inc. September 2001 - January 2003
Senior DBA/Data Architect/ Oracle Developer
Software
Oracle 9i, PLSQL, Dynamic SQL, SQLServer 2000, SunOS 5.8, Shell Scripting, ERWin 3.5, Java, XML/XSL,
TOAD, RMAN, Veritas, InterSolv ODBC, Oracle Warehouse Builder, Crystal Reports
Description
Senior data architect of a OLAP Data Warehouse/Data Mart cluster, Oracle & SQLServer2000, and author of a 30,000 PLSQL data access control layer (DAC) of objects consisting of Packages, Stored Procedures, Functions, and Triggers. Designed the WareHouse using ERWin and built a star schema containing several FACT tables and multi-Dimension tables. The PLSQL DAC layer supported DataMarts for Oracle Financials, a J2EE Java Customer Service web portal application based on table-driven access methodology, and Crystal Report objects for management and customer reports. Installed/Configured Oracle RDBMS 8.1.7.3 and SQLServer 2000 and built the physical aspect of the logical design using Enterprize Manager, ERWin and Perl.
Affiliated Computer Systems
February 2001 - September 2001
Senior Oracle DBA/Data Warehouse Architect
Software
Oracle 8i/9i, Solaris 2.7, Windows NT/2000, Linux 6.2/7.0, Pro-C, PLSQL, SQL, Shell Scripting, ERWin, TOAD, Quest Foglight, RMAN, Veritas Netbackup, Oracle Warehouse Builder, Business Objects
Description
DataWarehouse architect, developer, production/development DBA for several Decision Support System databases ranging from 500GB to 3 Terabytes in size. Utilized ERWin, Embarcadar, TOAD, and Oracle Warehouse Builder to develop the logical design of the Datawarehouses/DataMarts including multi-dimensional tables and FACT tables. Responsible for tuning PLSQL & Business Object queries within the OLAP applications using Oracle Enterprise Manager, TOAD, Explain Plan and TKProf. Implemented a database monitoring system using Quest's Foglight and BMC Patrol and also configured Oracle's RMAN for a backup/recovery strategy. Performed physical tuning of the databases for better throughput by using table partitions, bitmap indexes, pinning tables into memory and distributing database files across I/O channels. Authored database monitoring utilities written in PLSQL.
Concert Global Communications
March 1999 - January 2001
Senior Oracle DBA
Software
Oracle 8i/8.x/7.x, SQLServer/Sybase 11, HPUX 11.0/10.2, Solaris 2.7, Informix 8.1,
PL/SQL, BMC Patrol 3.4, HP Openview, Oracle Financials, MC ServiceGuard, ERWin 3.5, Quest Instance Monitor, Quest Shareplex Database Replication, Perl/UNIX Shell Scripting, InterSolv ODBC
Duties Senior Oracle Production DBA/DataWareHouse DSS Architect
Description Senior production support/development DBA. Implemented backup and recovery procedures using PLSQL & UNIX shell scripts. Configured BMC Patrol to monitor Oracle/SQLServer production instances, automate corrective procedures, generate reports and implemented security. Extensive work with Oracle 8i/Sybase/SQLServer for use with a Decision Support System (DSS) DataWareHouse/DataMart, OAS 11i, HPUX, MC ServiceGuard high availability packages, Veritas net backup software, Oracle replication software, and ERWin data modeling tools. Heavily involved with upgrading system software and hardware platforms. Developed data migration stored procedures with PLSQL. Also involved with the implementation of a change control policy and ERP software (PeopleSoft & Oracle Financials).
Ruben H. Donnelley
June '96- March '99
Senior Oracle DBA
Software
Duties Oracle Database Administrator (Lead), Software Developer
Description
Provide 24-hour onsite support for Donnelley's worldwide production Information Systems as lead Oracle DBA. This Information System includes eleven production instances totaling 9 terabytes of data, six test instances and 4 development instances spanning several hundred disks attached to three VAX/Alpha clusters. Duties include monitoring system performance, monitoring available free space, upgrading, installing and configuring new Oracle DBs/SIDs. Other duties include estimating database sizes, debugging errors, performing backups and recoveries, assisting end-users, working with developers, and maintaining a security strategy.