Steve Wagaman

Application DBA for SQL Server Products MedMeasures and STARSentinel from VIPS.

Developed, installed, and maintained client and vendor databases across multiple platforms. Implemented and supported customer requests and needs. Created and loaded 200M+ rows of claims data for new corporate product DB2 database for OLTP processing with index structure and job flow with no downtime to the claims system. Created parallel Oracle database for data reporting populated by trigged actions in DB2 working closely with applications to ensure accuracy and timeliness of data transfer. Upgraded and tested DB2 Connect V9.5 on 30+ UNIX servers connecting to 8 DB2 mainframes and 10 UNIX servers, scheduling time critical implementation dates with UNIX and WebSphere administrators and customer representatives at 4 sites to prevent out of service product issues. Developed SQL Server Integration Services (SSIS) routine to extract and purge data to be archived for applications to improve OLTP performance. Implemented and maintained backup and maintenance processes for over seventy 2005/2000 SQL Servers and migrated databases to next version for customers without loss of productivity. Discovered Sybase database corruption and quickly restored database with BMC SQLBackTrack backups with no loss of data and minimal product outage. Analyzed with customer the corrections needed to vendor product, STARS (Fraud and Abuse) database and implemented changes without additional vendor costs while not jeopardizing the integrity of the product. Planned and conducted the move of DB2 production and test databases to a Data Sharing environment. Learned the BMC DB2 Admin Tools to expedite and streamline the process. Saved $20K of professional services cost to install BMC Patrol for Sybase by installing and setting corporate monitoring parameters for SQL Server and Sybase databases.

Installed and maintained DB2 and Sybase databases. Managed department storage and security. Edited ALC and COBOL CICS modules. Volunteered to manage contractor to count lines of code for Gartner Study using Panvalet and EasyTrieve which provided an end product that was much needed by the application areas. Designed and implemented recovery strategy for SQL Server Secure Email to ship backups to alternate servers so that recovery could be performed immediately on new server if primary is lost without maintaining 2 servers. Designed for customer an extract process of selected Sybase data to FTP and load the extracts to DB2 on the mainframe within critical timeframe and no impact on OLTP performance. Upgraded to Sybase ASE system versions 12.0, 12.5. Designed batch methodology to upload to production DB2 data changes to aid customer. Created cloned DB2 database to separate OLTP processing from data reporting by moving data nightly and offline and developed purge process to prevent space problems. Developed recovery jobs and schedule for DB2 databases during disaster recovery and conducted offsite disaster recovery tests. Acted as RACF security administrator for mainframe dataset and DB2 access and conducted monitoring of departmental storage packs to efficiently use space. Established a departmental FTP process.