Objective: To serve as a DBA or Developer in an information systems department and participate as a valued contributor to the success of the company.

Experience: I began my career as an entry-level programmer at a large utility company, where I quickly distinguished myself as a reliable, self-motivated, and foresightful team player, leading the initial deployment of real-time CICS transaction-based systems and designing and implementing programmer diagnostic tools. I was soon promoted into database administration and have continued to serve IS managers in the effective utilization of DBMS technologies to meet organizational objectives for over 35 years.

As a DBMS vendor representative

• represented Cullinet with all levels of client management
• taught public classes
• performed logical and physical database design reviews
• conducted system performance reviews
• performed initial software installation
• mentored client DBA staff

Oracle DBA

• protect corporate data from accidental or malicious damage while ensuring availablility
• do logical and physical database design
• monitor and manage system performance
• identify and monitor capacity constraints
• manage the timing and installation of upgrades
• perform application migrations
• write and enforce development standards
• interface with vendor representatives to protect and advance the interests of my company
• evaluate new products and technologies and determine how they might further corporate objectives
• incorporate selected new products and technologies into departmental operations
• investigate and solve problems related to DBMS software and developer use of software interfaces
• provide consulting services to developers
• teach classes to new developers
• mentor DBA staff

As a Developer, I:

• develop both OLTP and database best practices
• create program diagnostic tools
• document 4th GL language standards

Technologies: IDMS, DB2 LUW Data Warehousing , COBOL, SQL, Unix scripting

Employment

• As the DB2 migration architect authored scripts to move database objects from Development to QA and SIT and into Production.
• Authored SQL to report differences between environments for tables and views, including view text.
• Managed decommissioning of database objects including impact analysis.
• Performed fix pack upgrades.
• Provided general consulting services to LL Bean DBA staff and analysts.

Confidential

• Led intiative to switch from periodic data purges based on script logic to range partitoned tables enabling weekly partition detachment.
• Initiated project to eliminate licensed DB2 Connect installations on hundreds of workstations by installing one license on z/OS.
• Championed objective to eliminate all manual periodic maintenance tasks in new data warehouse the old datawarehouse was a Rube Goldberg Machine of year-end creation/alteration of tables, views, aliases, and scripts.
• Led effort to replace a plethora of poorly written instance specific DB2 backup scripts with one universal script that functioned across DB2 releases from 9.1 to 10.1 and accommodated various DB2 editions and both single and multiple database partitions DPF .
• Architected and wrote scripts and tables to support the maintenance of summary tables in new data warehouse.

Confidential

Led the database support effort for a project to move operations for a purchased business unit from Unum's data center to Lincoln's. This project was under a tight schedule with severe financial penalties for a missed deadline.

• Managed coordination of move with Unum's DBA staff.
• Established test, acceptance, and production environments.
• Mentored the Lincoln DBA staff on all aspects if IDMS.
• Reauthored development standards.
• Authored DB2 training for developers and worked on IDMS to DB2 conversion.
• Did upgrades, capacity management, problem resolution, and developer support.

Confidential

• Wrote justification for and led integration of Performance Monitor and VISIO into department operations.
• Led the project to upgrade IDMS from 10.213 to 12.01.
• 17 IDMS regions, 5 CICS regions, 44 dictionaries, 345 databases, 17,000 users
• Authored software for a databridge project chartered to provide data bridging services to replicate updates between IDMS and SYBASE within a few seconds with 100 certainty. There were no two-phase commit services available, so the design involved providing a functional equivalent.
• Designed permanent run unit facility for a new CICS/IDMS system that would be requesting several hundred thousand run units per day for a single function.

Confidential

• Did logical and physical database design and performance tuning on VAX-RDB for A.O. Smith.
• Co-authored Student Housing System for UK. This involved client interviews, application design, database design, application coding, and testing and production implementation all within an emergency six-week deadline.

Confidential

• Provided support for customers in five states as a Customer Service Representative and Customer Service Manager.
• Product installation.
• Logical and physical database design reviews.
• System performance reviews.
• Class instruction.
• Mentoring client DBA staff.
• Selling and scheduling the activities of vendor CSRs at client sites.
• Designed and implemented programmer diagnostic tools.
• Performed senior DBA responsibilities.