|
Primary Experience
|
|
|
|
DB2 UDB DBA
The Kroger Company, Cincinnati OH
From: 7/2001 To: Present
|
|
 Served as Technical Lead for the Open Systems UDB Team
|
|
 ·
|
Implemented Kroger's first udb data replication environments.
This included an enterprise jounaling system that moved large amounts of data from
mainframe DB2 tables to the database server. Established numerous reporting
databases that moved data from OLTP systems to reporting databases.
|
|
·
|
Implemented Kroger's first Websphere applications using udb.
These included the internet based Home Shopping application for King Sooper's
stores as well as intranet applications for manufacturing, finance,
and merchandising.
|
|
·
|
Implemented Kroger's first federated environments.
This included a strategy to allow multiple development environments to
share large fact tables from the Data Warehouse conserving resources for
required for disk space, data movement, and loading.
|
|
·
|
Implemented a shared database server environment
for Websphere applications on IBM Regatta LPARs. This strategy allowed
small to medium applications to economically buy a 'slice' of a database
server, reducing server setup and installation tasks enhancing DBA productivity.
|
|
·
|
Developed new scripts and alias' to exploit V8
functionality such as table functions and online reorgs.
|
|
·
|
Performed technical evaluations of new releases/fixpacks
and developed migration strategies and schedules. Tracked and evaluated
PMRs opened by the team.
|
|
·
|
Technical lead responsibilities included technical
interviews, resource planning, project costing, and technical design.
|
|
|
Supported the Kroger Enterprise Data
Warehouse
|
|
·
|
Provided system tuning, operational, and on call
support for Kroger's multi-terabyte DB2 EEE Data Warehouse. IBM SP2
production complex is composed of 24 physical nodes, 96 processors, and
48 database partitions as well as five test environments. Tablespaces allocated
as SMS and use 22 terabytes of space on IBM SHARKs.
|
|
·
|
Provided SQL tuning and application design support
to the ETL team. Familiar with db2batch, dynexplain, db2exfmt and other
explain tools to analyze queries going against fact tables containing
up to 20 billion rows.
|
|
·
|
Provided change control and object management
support for modifications and additions to the Data Warehouse.
|
|
·
|
Wrote scripts to monitor activity, administer
security, control utilities, and cycle database.
|
|
|
|
|
|
|
Database Administration Manager
Fred Meyer Inc.,
Portland OR
From: 7/1997 To: 6/2001
|
|
Managed a team of five to seven
database professionals.
|
|
Responsible for both the development
and operational support of database applications on all corporate
platforms.
|
|
Managed the database integration of
300+ Smith's Food and Drug and QFC Stores into existing Fred Meyer DB2
applications, which included:
|
|
·
|
Rolling out DB2 for AIX to approximately 300
stores with direct store delivery, scales, and time scheduling database
applications.
|
|
·
|
Installing DB2 for AIX on an SP2 complex to
support centralized functions for in-store applications.
|
|
·
|
Growing the Fred Meyer OS/390 DB2 databases to
approximately 3 terabytes and servicing over 7 billion SQL calls a day
|
|
|
Implemented an intranet database
service request system that allowed the prioritization, assignment and
tracking of DBA tasks.
|
|
Led the customization of Method/I data
and database documents to satisfy the needs of the
development organization
|
|
Maintained my hands-on skills and
remained as a full DBA team member in the on call rotation
|
|
|
|
|
|
Database Administrator
Fred Meyer Inc., Portland OR
From: 3/1992 To: 6/1997
|
|
Developed, implemented, and supported
a number of merchandising applications from the database perspective
including Store Ordering, Purchase Orders, Receiving, Direct Store
Delivery and Replenishment.
|
|
·
|
Participated
actively in application design by suggesting where utilities should be
used by applications in order to handle very large volumes of data which
could not be processed in a timely manner using programs and SQL.
Educated developers on how to use loads and unloads to accomplish insert
and delete processing.
|
|
·
|
Helped
design and maintain a complex data bridging system to keep applications
on old and new systems synchronized during application migration.
|
|
|
Developed, implemented, and supported
a number of merchandising applications from the database perspective
including Store Ordering, Purchase Orders, Receiving, Direct Store
Delivery and Replenishment.
|
|
·
|
Led
data modeling sessions, creating logical data models which were then
transformed to physical models for implementation. Used Bachman
diagramming and tools for forward and reverse engineering.
|
|
·
|
Provided
SQL tuning guidance to development teams. Coordinated database
aspect of stress testing to make sure database structures and SQL were
tuned to provide the best possible performance.
|
|
·
|
Worked
closely with application managers planning data requirements to avoid
data redundancy and provide a highly integrated data environment.
|
|
·
|
Supported
all database environments. Migrated new databases and changes from
test to production ensuring that all test, scheduling, and support
requirements were in place and fully documented.
|
|
|
|
|
|
|
Technology Consultant
First Interstate Bank, Portland OR
From: 5/1991 To: 2/1992
|
|
Reviewed DB2 database tool suites from
various vendors. Worked with legal on the purchase of the Platinum Tool
Suite.
|
|
Developed white papers on various
emerging database technologies
|
|
|
|
|
|
Account Systems Engineer
IBM Corporation, Portland OR
From: 4/1985 To: 4/1991
|
|
Provided DB2 and application enabling
support to various IBM customers in the Los Angeles and Portland area.
|
|
Assisted customers with MVS DB2 V1 to
V2 migrations.
|
|
|
