Manager Oracle
Resume:
David V. WILSON (Dave)
Houston Tx. 77007
Cell 832-***-****
Email: **********@*****.***
KEY SKILLS
DBA
AIX
Oracle
SQL SERVER 2012
SQL SERVER CERTIFIED
(SQL 2008 R2)
SQL Server
SAP HANA CERTIFIED.
GreenPlum (HADOOP)
OLTP
OLAP
RMAN
Oracle Enterprise Manager
Scripting
Oracle RMS
Peoplesoft
RAC
Dataguard
Veritas Foundation Suite
PL/SQL
Korn Shell
Performance Tuning
Linux
Clustering
HADOOP(Postgres)
Erwin
SQL Loader
SAP HANA
TOAD
ODBC
Neteeza DBA
WebLogic
RETEK(RDMS)
SQL 2008 R2 Clustering
EXPERIENCE
15 years +
15 years +
10 years +
9 years
4 years
7-8 years
7 years
1 year
1 year
4 years
20 years
4 years
7 years
10 years
7 years
4 years
15 years +
5 years
6 years
10 years
7 years +
5 years
5 years
5 years
2 years
2 years
EDUCATION
University of Texas at Arlington - Arlington, Texas
Control Data Institute MS System Engineering
Oracle 12c Certification 12/2015
Oracle Certified Database Engineer - Oracle 11g
Oracle Certified Database Engineer – Oracle 10g
Oracle Certified Database Engineer - Oracle 9i
Oracle Certified Database Engineer - Oracle 8i
Oracle Certified Database Engineer - Oracle 7x
IBM AIX Certified
EXPERIENCE
HESS CORPORATION
Manager, Global Database Services for Enterprise Computing
2009 - Present
Leader and Manager of the Entire Worldwide Database Administration Team and Database practice for Hess Oil Corporation. The team included 7 U.S. Based DBA’s and 17 DBA’s outsourced in INDIA. Responsible for all Oracle, SQL SERVER, and SYBASE databases used by Hess’s Exploration and Production Unit and it’s
Marketing and Retail Corporation. Trained and on boarded the entire staff and sanctioned all database architecting, maintenance and administration responsibilities. Responsible for licensing all facets of databases and database license activities. I also led all database architecting activities at Hess. Responsible for all budgeting and manpower projections for Hess’s Database Services Operation. Also responsible for mentoring novice DBA’s to the professional ranks. Team delivered a 99.81 uptime for the database computing unit. Implemented and configured the SAP HANA appliance into our new SAP environment. I am now training and mentoring the entire team on administration of HANA. Capacity Planning and Capacity management is also part of my duties. I am also implementing and HADOOP Big Data environment with a POSTGRES DB engine.
CONSULTANT
2005 to 2009
NORTHROP-GRUMMAN(8/2007-2009)
Installed and configured a 3 node Oracle RAC suite. Migrated and configured the 9i instances to a 10g RAC system. Set up the RMAN recovery system, established security procedures, and set up monitoring and performance tuning procedures. Afterwards acted as the main DBA and implemented the production suite. Architected the new database layouts to take advantage of the new EMC SAN systems. Acted as the Systems San Storage administrator and performed the entire SNAP/CLONE processes to duplicate the databases. Migrated and reloaded data from SQL Server, MySQL and Sybase databases using different loading and partitioning techniques to repositioning of metadata and legacy data to Oracle 10g databases. I have also taken the 11g OCP test for Oracle.
CIBER Oracle DBA Consultant (4/2007 – 8/2007)
Performed Data migration for the Dot.com databases, MySQL and Sybase to work and merge with BOEING’s Dot.com databases under 10g RAC. Adjusted applications and reports to execute with the migrated database. I also acted as lead Data Architect in redesigning the database for optimum efficiency.
American Airlines Oracle DBA (2/2007-4/2007)
Installed Oracle 10g and RAC failover systems to facilitate the HAV failover system for faster failover..
COMSYS, Oracle DBA, Architect Consultant(12/2006-2/2007)
Migrated MYSQL databases to Oracle 10g databases. Set up the RMAN backup environment and implemented the failover for the 10g RAC suite.
OCBF, Oracle DBA Consulting (1/2006 to 11/2006)
Responsible Oracle 10g database management consulting and support. Installed and configured ORACLE financials. Set up all operational scripts to run the entire financial suite. Also provide general IT management direction.
Elexis Inc., Oracle DBA Consulting (9/2005 to 1/2006)
Defragged and migrated multiple Oracle 9i and 10g databases to an EMC Storage Area Network. Merged all company databases into one and divided them by table spaces.This reduced ORACLE SGA memory space and allowed for migration to a 10g RAC structure. Architected and logically redesigned all databases to fit and take advantage of the clustered system. Implemented performance testing and data validation procedures. Also implemented the RMAN backup recovery procedures and was Sr. DBA in day to day general procedures and supported the J2EE development. Migrated the entire E Business Suite 9i database to Oracle 10g RAC failover Database.
Michael's Stores, Inc.
2001 to 2005
Manager of Database and Technical Services
Responsible for the day-to-day management of the Oracle production databases and midrange servers. Responsible for the logical and physical layout of all AIX systems. Worked with Linux as well. Responsible for architecture of all production databases. Worked with some SQL Server databases. Act as the purchasing agent for all midrange servers. Logically architected the E Business Suite database and led the applications implementation for the project. Managed a staff of six System Administrators and seven Database Administrators. Logically and physically architected the migration of the RMS database to an EMC SAN. Trained and mentored several computer operators into the System and Database administration ranks. Led and managed two administrators through the ORACLE 9i RAC migration. Worked with Oracle Designer. Tools used included Oracle Enterprise Manager (OEM). Worked with ERwin. Managed the WebLogic design project as well. Monitored and tuned databases in both OLAP and OLTP environments. Tasked with manpower and systems estimates and manage a budget of $12M. Guided the entire enterprise in the upgrade of all 48 Oracle databases from 8.1.7 to 9i and from 9i to 10g. Worked with RMAN. Development with PL/SQL. Worked with the Veritas Foundation Suite. Led the Retek and PeopleSoft Financials upgrade. Responsible for implementing the Oracle HRIS Human Resource System. Architected all databases for a migration from a SHARK SAN to an EMC Symetrics SAN. This was an e-Commerce environment at Michaels. I also set up the entire backup and recovery scenarios using BMC SQL Backtrack system to make for more reliable backups over RMAN in an AIX environment.
Lante Corporation
2000 to 2001
Sr. Oracle/Sybase Database Architect
Led a team of four Database Administrators in consulting web applications and database construction projects. Client list included Bank One, Johnson Products, and Chase Bank. Environments included Oracle, Sybase, UNIX, AIX, OLTP, PL/SQL, Korn Shell, etc.
EmCare, Inc.
December 1998 to February 2000
Enterprise Database Administrator and Systems Manager
Manager of the Database and System administration staff. Responsible for the logical and physical design of 12 production databases including the payroll and financial systems. Responsible for the logical and physical layout of the AIX systems. Extensive Korn Shell scripting. Prepared budgets for the Database and Systems groups, prepared budgets for the maintenance of all hardware and consultants used throughout the company. Trained and tutored junior members of staff toward certification in SYBASE, SQL Server and AIX. Responsible for maintenance and performance tuning for databases and midrange AIX servers. Responsible for all manpower and project estimates. Responsible for Server and Storage purchases.
FootStar, Inc./FootAction USA
March 1998 to December 1998
Principal Database Administrator
Responsible for the logical and physical redesign of all databases used by Footaction USA and its 592 apparel stores. The Oracle databases resided on the S7A RISC 6000, it also consisted of the Lawson Human Resources/Payroll databases and EDI electronic commerce databases. Responsible for the maintenance, tuning and management of all databases. After the relocation and institution of the combined Footstar/Footaction MIS multicenter, was the project manager for migrating Oracle Databases to the IBM SP2 Multi Process Platform database. Worked with ERwin.
Computer City
December 1997 to March 1998
Senior DBA
Responsible for maintaining all databases used by Computer City. Led the implementation of the PeopleSoft Human Resources and Payroll systems. Provided resolution of congestive problems with the Oracle Database running with the RETEK merchandising system.
Brinker International
December 1996 to November 1997
Senior DBA
Logically designed, physically modeled and maintained the Oracle databases used in the development implementation of the PeopleSoft Human Resources and Payroll system. Led the DBA team in the first benchmark that proved PeopleSoft Oracle and Windows NT would work in high volume processing mix. Some of the findings resulted in PeopleSoft updating its software with queries and database structures developed by the benchmarking team.
Consultant - Contract
1989 to November 1996
Chicopee, Inc., Oracle DBA (March 1996 to November 1996)
Solved runtime errors associated with financial applications and in-house developed reports. Instituted a new database model and coded scripts that would allow hot online automatic backups for Oracle running on the DEC ALPHA using open VMS.
Texas Instruments (October 1995 to March 1996)
Worked in the DMOS Wafer Semiconductor Engineering Software Development Department. Contracted to analyze the performance of software interfacing with Oracle Database. Resolved all software issues; the result being developing a patch which became part of the Oracle Corp. patch set.
MCI (January 1994 to September 1995)
Contracted to do Netexpert rule development for MCI’s DLxx line of communication switches.
Coopers & Lybrand (April 1993 to November 1993)
Contracted to port Texas Instruments IEF Development Software kit to NCR’s 3550 UNIX system. Redesigned the database tables to allow the Oracle database to run in fewer cycles. Recoded the C portions of the software that would not port successfully.
Dallas Independent School District (June 1992 to March 1993)
Designed the Wide Area Network used by the DISD. Successfully connected Novell LANS, UNISYS development networks and UNIX networks. Did pre-analysis of every user groups needs and specifications. Taught Oracle development classes for the software development group.
IBM (January 1991 to April 1992)
Contracted to rehost the Oracle Database (Ver. 6.0) on IBM’s RISC processors. Designed and developed a benchmarking tool to simulate database cycle usage on the machines. This software assisted the marketing organization in making recommendations to its customers on which version the RISC machine it should purchase.
McDonnell Douglas
Contracted to perform a decompositional analysis of their entire cadre of Inertial Navigational System Simulation Software which was installed at their KC-10 training facilities. Solved all of the runtime Oracle execution errors occurring in the system.
DSC Communications Corp
Charted, modified and enhanced the Circuit Subsystem of DSC’s Centralized Management System (CMS) for it Digital Cross Connect communication switch. Redesigned the entire circuit subsystems using Booches’ OOD model as a template.
Chrysler Technologies Airbornes Systems//Electrospace Systems (1984 to 1989)
Manager of the Electronic Warfare Software Group & Computer Based Simulation
TECHNICAL SUMMARY
Database Disciplines: Oracle, SQL Server, Sybase, Informix, DB2, ObjectStore, ESSBASE, Advanced Revelation
Software Disciplines: C, Visual C++, PL/SQL, SQL, ADA, BASIC, FORTRAN, PowerBuilder, PeopleCode, Perl
Design Disciplines: Object Oriented Design, Structured Design, MIL-STD-2167A, Structured Database Modeling, Structured Fundamental Systems Architecture, Instructional Systems Design, Multi-Media Systems Design, BMC Patrol, BMC Control SA, BMC SQL Backtrack
Operating System Environments: AIX, HP-UX, SCO UNIX, ULTRIX, SUN (OS) Windows (all environments), Open VMS
Storage Systems: EMC DMX Symetrics, IBM SHARK, SAN Design and Implementations, Net App.
Certifications: Oracle Database Masters Certification; 2 AIX Certifications; Object Oriented Design Certification; C & C++ Certifications
Contact this candidate