Resume Details
W. H.

Location Tampa, FL  
Contact Click to View Contact
Source Vendor Candidate
Salary N.A.
Rate N.A.

Resume


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              

Oracle 7.4, Oracle Enterprise Manager, Open VMS 7.1, ERWin 2.5 Pro-C, Pro_COBOL,SQLForms, Perl

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.

 


S. E.
Skill: IT-Oracle DBA Location: NJ , NJ   
Description:
Summary Eleven years of experience in Oracle Datab.... more
B. S.
Skill: IT-Oracle DBA Location: NYC , NY   
Description:
Summary · Over 8 years of experience in the.... more
N. W.
Skill: IT-Oracle DBA Location: Houston , TX   
Description:
Oracle Database Developer A well organized and .... more
S. A.
Skill: IT-Oracle DBA Location: Silver Spring , MD   
Description:
Summary • Over 10 Years of diversified experience.... more
S. H.
Skill: IT-Oracle DBA Location: San Ramon , CA   
Description:
Summary: Over 20 years of experience in databa.... more
M. T.
Skill: IT-Oracle DBA Location: Dayton , OH   
Description:
SUMMARY Oracle DBA Certified Professional with .... more
S. W.
Skill: IT-Oracle DBA Location: Milford , OH   
Description:
OBJECTIVE To obtain a position as a Data Architect.... more
E. M.
Skill: IT-Oracle DBA Location: Taylors , SC   
Description:
SUMMARY An Oracle Database Administrator with t.... more
A. A.
Skill: IT-Oracle DBA Location: Harrison , NJ   
Description:
Summary • 12 years of functional experience i.... more
M. A.
Skill: IT-Oracle DBA Location: Minnetonka , MN   
Description:
Highly talented, systems and technology savvy, res.... more
B. M.
Skill: IT-Oracle DBA Location: Edison, NJ   
Description:
BALAKRISHNA Oracle DBA balakrishnadba@gmail.c.... more
S. A.
Skill: IT-Oracle DBA Location: Champaign, IL   
Description:
Siva Kumar Arza ­­­­­­­.... more
G. K.
Skill: IT-Oracle DBA Location: Cincinnati, OH   
Description:
   Gagan Kumar    &n.... more
S. K.
Skill: IT-Oracle DBA Location: Greer, SC   
Description:
SANTOSH KUMAR      &.... more
S. M.
Skill: IT-Oracle DBA Location: Tampa, FL   
Description:
Sudheer Kumar Mikkilineni    &.... more
R. R.
Skill: IT-Oracle DBA Location: Tampa, FL   
Description:
Rammohan Ramadoss EXPERIENCE SUMMARY:· &.... more
D. J.
Skill: IT-Oracle DBA Location: Stratford, CT   
Description:
Durdhana Sheraz Jafar SUMMARY:§  Seven&n.... more