Resume
Kevin P. Meade
103 Wonham Street
Clifton, New Jersey 07013
Home: (973) 773-4688
Mobile: (201) 723-1570
Email: meade752@optonline.net
SUMMARY
As a seasoned Oracle DBA who has performed the traditional functions of a Database Administrator for the past 20 years, I have participated in a wide array of activities in support of multi tier production and development environments. These activities include the installation and configuration of Oracle RDBMS versions 5 through 10 on Windows 2000/3000 Servers and a wide variety of unix platforms, support of PC, LAN and web based applications in FDA validated and non-validated environments. In addition, supported numerous Production database backup and recovery scenarios using SQL*Backtrack and RMAN utilities. Also developed DBA maintenance and productivity tools that manage Oracle databases, and established Oracle security and configuration guidelines and procedures for Unix development and production database environments.
EDUCATION
1975 Montclair State College, Upper Montclair, NJ
B.A. Mathematics
TECHNICAL SKILLS
Hardware
HP/UX , SUN SPARC 10/20 Servers, SUN Ultra 250/450 Servers, Sun Enterprise 250/450 Servers, SUN E3500 with RSM 2000 Storage Array, SUN E5500/6500 with 5x00 Storage Array, Compaq, Dell, Compaq/DEC, VAX, PC?s, AT&T Servers, RS/ 6000. EMC SAN Storage Arrays
Software
Oracle Enterprise Manager, Oracle 8i, 9i, SQL*Net, SQL*Backtrack, Oracle RMAN, SQLLoader,Veritas Cluster Server, Unix Shell Scripts, TCP/IP, ADSTAR Distributed Storage Manager, SQL*Back Track Backup & Recovery
Operating Systems
WIN 2000/3000, WIN XP, Solaris 2.7/7/8, HP-UX 9.x/10.x/11.x, AIX, AT&T/SVR4, WIN 95/98/NT
EXPERIENCE
10/02 ? Present Pfizer Inc. 201 Tabor Road, Morris Plains, NJ
Database Administration Group?Consultant (Volt Services Group)
Hardware
HP 9000 K/M/N Class, Sun SPARC ES Servers, Compaq, Dell.
Operating Systems
: Windows 2000/3000 Server HP/UX 9.x/10.x/11.x, Sun Solaris 2.7/7/8, Windows 95/98
Software
Oracle RDBMS 8i, 9i, SQL*Net, Oracle Enterprise Manager,
Oracle Database Replication, Oracle RMAN Unix shell scripts, Veritas BCV
Projects
Participated in evaluating databases for security problems prior to internal
and external audits. Prepared Standard Operating Procedures (SOP?s) for
database installation, configuration, and user security.
Research & Development Environmental Monitoring System (RDEMS
Configured and installed Oracle 9i QA and Production Databases and
Executed Installation Qualification (IQ) procedures for this Validated system.
Data Warehouse. Provide Production, QA, and Development support for several
Oracle 9i databases. Also support the ongoing migration of data warehouse
databases from HP/UX to Sun platforms and the upgrade of Oracle from 8.0
and 8i to 9i. Developed Unix shell scripts to purge log and trace files from the
Unix Database server.
OASIS Web based order entry and management system Provide Production
support for two 8i databases which operate in a high availability INTEL cluster.
Configured Oracle Multi-Master Replication to synchronize the databases.
Skill Set
Database configuration analysis & planning
Database performance tuning
Unix shell scripting for pro-active database monitoring
Oracle software installation & upgrade
Veritas High Availability Clusters
Oracle RMAN Vackup & recovery
SQL*Net configuration ( TCP/IP clients)
3/96 ? 1/02 Public Service Electric & Gas Inc., Newark, NJ
Database Administration Group?Consultant
Hardware:
HP 9000 K/M/N Class, Sun SPARC ES Servers, Compaq, Dell.
Operating Systems
HP/UX 9.x/10.x/11.x, Sun Solaris 2.7/7/8, Windows 95/98, NT 4.0,
WIN 2000, WINDOWS XP
Software:
Oracle RDBMS 8i, SQL*Net, Oracle Enterprise Manager,
ESRI ArcSDE Server 8.0.2, Arc FM, M3i Systems Pragma Line,
Pragma CAD, Vetitas Oracle Database Replication, Veritas Cluster Server,
Projects
Electric Utility Outage Management System. The Production environment consists of three Oracle 8.0 databases instances on two Sun ES5500 servers and utilizes the Veritas Cluster Server high availability software for redundancy. This 24x7 mission critical system identifies outage conditions in the electric network, anticipates potential failures, tracks the dispatching of repair crews to damaged facilities, and interfaces with a call response system to provide up to the minute service restoration times to customers.
Administered Production, Development, Test, Training and Disaster Recovery environments.
Enterprise Land Base and Electric Facilities Geo-Databases. These geodatabases utilize two Oracle 8i database instances on a Sun ES5500 server. The geodatabase utilizes the ESRI ArcSDE Server 8.0.2 engine to manipulate electric facilities on the network. This system is a primary interface to the Outage Management System mentioned above.
Administered Production, Development, Test, and Training environments.
Enterprise Meter Data Repository This 140 GB database is the enterprise clearinghouse for all PSEG &G electric and gas meter readings as well as readings foom external sources such as water. The system features a ?replication? server supported by Veritas Database Replication. This product keeps the backup server in sync with Production on a daily basis.
Administered Production and Development environments.
Skill Set
SQLBacktrack Backup and Recovery (BMC)
Database configuration analysis & planning
Database performance tuning
Unix shell scripting for pro-active database monitoring
Oracle software installation & upgrade
Veritas Database Edition with Database Replication Option
ESRI ArcSDE 8.0.2 Server installation and support
Oracle Names Server
SQL*Net V2 configuration ( TCP/IP clients)
1/95 ? 3/96 AT&T Global Information Solutions Inc., Union, NJ
Oracle Database Administrator
Hardware
AT&T System 3000, AT&T Globalyst 486 PC
Software
AT&T SVR4 Unix V2.0.3, Windows for Workgroups 3.1.1.Oracle RDBMS V7.1.4, SQL*Net 2.1.4, Oracle Objects for OLE
Project
Supported the migration of a CICS-IDMS rental & leasing application to a client/server architecture. Duties included the configuration, installation, and tuning of the Oracle7 Server with multi-threaded server support, and SQL*Net V2, on an AT&T System 3000 server running AT&T SVR4 Unix. Installed and configured Visual Basic clients for use with the SQL*Net V2 TCP/IP Protocol Adapter. Migrated the database server to a Netware platform for client acceptance testing.
Provided ongoing support for the development environment:
Skill Set
Oracle software installation & upgrade
Database configuration analysis & planning
SQL*Net V2 configuration (MTS, TCP/IP clients)
Database performance tuning
Unix shell scripting for pro-active database monitoring
4/91 ? 12/94 BASF Corp., Mount Olive, NJ
Oracle Database Administrator
Hardware:
HP 9000, Sun SPARC, IBM RS6000, Intel x86
Software
HP/UX 8.x-9.x, SunOS 4.x, Sun Solaris 2.x, AIX 3.x, Windows NT, Netware 3.1, OS/2, SCO 3.x
Oracle RDBMS V6.0.33-7.1.3, Oracle CDE Tools (Windows), Oracle CASE 5.0-5.1
Configured and installed the first production Oracle databases at corporate headquarters on HP, Sun, RS6000, Intel (SCO, OS/2, Netware, Windows NT) platforms and established configuration, security, and backup & recovery guidelines for these databases. Provided ongoing administrative support for over a dozen databases:
Oracle Site License Administrator: Monitored and prepared quarterly usage reports for all Oracle databases in the region. Coordinated the purchase and upgrade of all Oracle software for the region. Coordinated the semi-annual purchase of Oracle Training Units for all of BASF Corp (US).
Skill Set
Oracle software installation & upgrade on all platforms
SQL*Net V2 configuration (MTS, ORACLE Names)
Database performance tuning
Database configuration analysis & planning
Database V6 - V7 migration
Unix shell scripting for pro-active database monitoring
Oracle CASE 5.0 - 5.1 Administration
Corporate wide in-house technical support for Oracle products
------------------------------------
11/85 ? 4/91 Janus Systems Inc., NY, NY
Software Development Manager
Hardware:
VAX 8350, VAX 6410, Sun360
Software
VMS 4.7 - 5.2, SunOS 3.5,Oracle RDBMS 5.1.22 - 6.0.27 CMS
Established development schedules and tracked 5 -7 programmers, analysts, and consultants. Determined clients? business requirements. Prepared functional, technical, and user interface specifications. Guided and reviewed technical specifications preparation. Coordinated VMS Oracle application migration from V5 to V6. Performed system integration and QA testing. Coordinated client site installation support.
103 Wonham Street • Clifton, New Jersey 07013
• H:973-773-4688 • W:973-723-1570 • M:201-723-1570
