Summary





Over 20 years of experience in Information Technology. Areas of specialization include : Project Manager, Management IBM UDB DB2 Database Management, Database Administration, Database Design, Data Warehouse or Datamarts, Data Modeling, Data Normalization, Database Conversion, System Installation, Planning, Implementation and Migration. Solid experience programming Korn Shell scripts and writing SQL code to include ; SQL tuning, restructuring and optimizing SQL, tuning SQL applications. Superior communication skills, both written and oral.


Employment

July, 2008 -  July, 2009
ARCHITECT

Supported Blue Cross Blue Shield Medical Records Databases
Strong knowledge in DB2 UDB DPF or BCU environment Unix and enterprise warehousing.
DBA for a large BCU DB2 UDB DPF/ EEE environments - 13TB 57 partitions
Across 7 servers.
across 7 servers.

Experience in DB2 with table partitioning, database administration, Strong Knowledge on Database performance tuning through database physical design, configurations, reorg, runstats, event monitor, snapshots and implementations of data aggregations, MQTs, MDCs, Tables Partitioning and indexing.
Performed query performance optimization, tuning implementations
SQL tuning, import and exporting, cursor loads and data movement
Production support 24/7 on call rotation
Provided support for backup and disaster recovery processes and procedures.

Outstanding verbal and written communication skills.
Strong AIX/Unix scripting, TSM, Netbackup, BMC Patrol, DB2 governor

April, 2007 -  April, 2008
DATA ARCHITECT

Supported and Design Blue Cross Blue Shield Florida Medical Records Databases
Database Infrastructure, Planning Implementation, Design, Management, Administration
Hire to design logical and physical design of a multi-terabyte Partitioned Datawarehouse for Medical Claims Analysis application using UDB V9, Linux V9.2 32 bit, Erwin
DPF or BCU environment single partition and multi partition
Design AB Initio ETL tables
Created databases, bufferpools, tablespaces, tables, indexes, views
IBM UDB V9 utilities, reorg, reorgck, runstat, load, export, import, alter, Explains, Tuned DBM CFG, Database CFG and Registry Parameters
Design and implemented Database Backup and Recovery Plan

DPF, HADR, Replication and other high availability strategies 3rd party tools Todd, DBArtisian, Quest Central
IBM Performance Monitor or SQL tuning

November, 2006 -  November, 2007
DB2 UDB DBA/ ARCHITECT

Hire to migrate DB2 databases from Z/OS series machine to P series machine
Migrate DB2 databases from UDB Linux V8.2 32 bit to UDB Linux V9.1 or IBM 64 bit
Replication Version 8
Re-design database objects for Student Registration Database
Tuned DBM CFG, Database CFG and Registry Parameters
IBM DB2 UDB utilities, reorg, reorgck, runstat, load, export, import, alter, Explains, Programs will remain executing on the the Z machine and re deployed using alias names technology using the Z/OS DB2 Catalog Communications Database to access
UDB Linux V9.1
Set-up HADR high availability disaster recovery

September, 2006 -  September, 2006
DB2 UDB DBA

Hired as a consultant to migrate 80 databases from Sun 15K Solaris to Sun 6800 Solaris

June, 2006 -  June, 2006
DB2 UDB DBA

Hired as a consultant to migrate IBM UDB DB2 databases from Z/OS to Windows

December, 2005 -  December, 2006

September, 2004 -  September, 2005
ARCHITECT

Hired as a consultant to develop I2 Technologies DB2 UDB AIX or Linux databases in single and multi partition EEE or DPF environment

Design and created database objects for Merchandise Planner, Demand Manager, Promotion Optimizer, Replenishment Planner and Profile Manager sub-modules.
Design/Develop/Size Informatica Staging/DataWarehouse/Datamart repository database
Installation of DB2 UDB Server and Client Version 8.1 or 8.2
LDAP Database
Created databases, bufferpools, tablespaces, tables, indexes, Executed UDB utilities, reorg, reorgck, runstat, load, export, import, alter, explains, Tuned DBM CFG, Database CFG and Registry Parameters
SQL tuning single partition and multi partition
Design backup, restore strategy Disaster Recovery Plan Tivoli Storage Manager TSM

June, 2004 -  June, 2004
ARCHITECT

Hired as a consultant by IBM to work on the TSM No Fly Database account as Lead DBA at the Colorado location. Position required security clearance.
Created databases, bufferpools, tablespaces, tables, indexes, Design fail system using HACAMP.
Executed IBM DB2 UDB utiltiies, reorg, reorgck, runstat, load, export, import, alter, explains and SQL tuning
Tuned DBM CFG, Database CFG and Registry Parameters
Design backup and restore strategy

March, 2004 -  March, 2004
ARCHITECT

Hired as a consultant by TJX Companies, Inc to write Disaster Recovery Plans and implement the DR plans during a mock recovery drill using IBM s Recall facility
Wrote migration plans to migrate from DB2UDB version7.2 to UDB DB2 version 8.
Upgraded DB2 UDB fix pack 9 to DB2 UDB fix pack 11
Perform data migration using IBM s Replication/DATAprogation tools
Performed Websphere Deployments of java, JSP, HTML and javabean code
Executed, interpret and recommended codeing changes based upon Explain outputs.
Perform day-to-day DB2 UDB utilities, reorg, runstat, load, export, alter, etc.
Wrote a series of Korn Shell scripts to monitored the system and Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools events, table space events and tablescreate event monitor evmonal for statement and deadlocks. Monitored and tuned buffer pools, dbm cfg parameters, Database cfg parameters, registery parameters, lock escalation, etc.
Executed Text extender
Support the WorkBrain HR and time accounting application.
Executed Redirected Restore to build test databases using the production backups.

September, 2003 -  September, 2004
ARCHITECT

Hired as a consultant by Scholastic, Inc to perform DBA functions in an AIX 5.2.1 UDB DB2 7.2, EEE DPF, EE environment
Performed ER Data Modeling and Data Normalization using Erwin
Created tablespaces, tables, bufferpools, indexes etc.
Wrote a series of Korn Shell scripts to monitored the system and executed IBM DB2 UDB utilities, reorg, runstat, load, export, alter, etc.
Wrote Korn Shell scripts create DDL s, load data index creation, backup, FTP, etc., loading tables and backup and recovery of table spaces perform migration using DB2 UDB data movement utilities and data replication utilities

Wrote a serries of K shell scripts to perform Backup and restore Executed snapshot monitor to examine databases, table spaces, tables, locks, bufferpools, unit of work and dynamic SQL performance issues
Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools and created. event monitor evmonal for statement and deadlocks
Monitored and tuned buffer pools, dbm cfg parameters, Database cfg parameters, registry parameters, lock escalation, etc.
Executed Text extender Utilities

February, 2003 -  February, 2003
ARCHITECT

Programmed Korn Shell scripts to automate calling SQL Stored Procedures

Activities include table space, table design, executing load utilities, import and export, db2look, rebinds, reorgs, reorgcheck, index advisor, runstats, various snapshots and performance monitor and tuning
Enhanced the Instance and data base parameters and variables, monitored table space growth and performed SQL tuning
Set-up procedures to backup and recover databases, wrote run books and documentation and trained users
I worked with various DB2 third party tools.

October, 2002 -  October, 2003
ARCHITECT

Wrote scripts create DDL s, load data index creation, backup, FTP, etc., loading tables and backup and recovery of table spaces perform migration using DB2 UDB data movement utilities and data replication utilities
Developed a process to migrated BLOB data from Z/OS to OS/390 and wrote program in REXX to call stored procedures
Developed a process to migrated BLOB data from Z/OS to DB2 UDB AIX

May, 2002 -  May, 2002

Performed DB2 UDB RS/6000 and OS/390 DB2 performance and tuning of the on-line truck order application. Performed SQL program tuning by writing the SQL code, re-structuring and optimizing SQL

Created and optimized indexes, optimized buffer pool hit ratio, CASHE SQL statements, proper sizing of the MAXKEEPD, VPSEQT and other ZPARM parameter to alleviate CPU Deadlocks, concurrency, I/O concerns and etc.
Wrote static COBOL Stored Procedures SP .I utilized various DB2 performance and monitoring tools : CA Detector, IBM testing using INTERTEST Software and Stored Procedure Builder. Some data existed on SQL-SERVER 2000 databases.
Executed EXPLAINs to determine access path, tuned SQL, joins, utilization of indexes.

January, 2002 -  January, 2002
ARCHITECT

Hired to do DB2 UDB performance and tuning at the instance, database and application level for a AIX, UNIX, WebSphere, NT system
Used the IBM UDB DB2 data movement utilities and data replication utilities.
Tuned, reviewed, update various database manager configuration file instance and database configuration parameters for optimal performance

Executed snapshot monitor to examine databases, table spaces, tables, locks, bufferpools, unit of work and dynamic SQL performance issues
Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools events, table space events and tables .I executed predefined monitors of Visual Performance Monitor to observe monitor capacity, sort, locking, cache, deadlocks, prefetchers, disk performance, application global memory and long running queries
Tuned application SQL using various tools, explain, visual explain, index advisor, db2diag. log and db2alert. log and executed reorgck, runstats, reorg, backup and restore, index estimate size

June, 2001 -  June, 2001
DB2 UDB DBA

Performance and tuning, volume stress testing and performed capacity planning, drafted test plan and automated the increase the volume of data
Performed programming in DB2 UDB COBOL, CICS, VSAM on a OS/390 and Korn Shell scripting and DB2 UDB DBA tasks in an AIX or UNIX, RS/6000, EEE, EE
Tuned DB2 applications and DB2 sub-system by executing Explains and DB2PM Performance Monitor and reported on finding of the DB2PM Performance Monitor Accounting Traces/Statistical reports
Recommended optimal buffer pool utilization, monitored DB2 subsystem for performance, access paths and trade-off various access paths by reviewing DB2 internal as they relate to table space and index mechanics
Implemented, developed and choose the optimal DLL to implement efficient DB2 objects
Migrate DB2 objects from 1 sub-system to another, created the following : DATBASES, TABLES, INDEX, TABLESPACE, STOGROUP, SYNONYM, VIEWS, ALIAS
Loading tables and backup and recovery of table spaces, migrated DB2 UDB data movement utilities and data replication utilities.
Performed data was propagated from OS/390 to RS/6000 using Data Movement Utilities
Worked on both IBM OS/390 and RS/6000 DB2 UDB environments utilized DB2 EE/EEE.

September, 2000 -  September, 2001
DB2 UDB DBA/Systems Programmer

Performed physical Management of DB2 UDB objects, data structure and physical makeup of tables and upgrades or installed DB2 add-on software package IBM s QMF and DB2 PM and OEM CA S FileAid, Information Builders s EDA and others software products and tools.
Monitored DB2 subsystem for performance, access paths and trade-off various access paths
Monitored DB2 internal as they relate to table space and index mechanics and implemented and choose from the various SQL/DLL options to implement efficient DB2
Migrated DB2 objects from 1 sub-system to another utilized DSNCOPY and used DB2 UDB data movement utilities and data replication utilities
Migrated DB2 V3.1 to DB2 V4.1 and DB2 V4.1 to DB2 V5.1 using the install Clist and various utilities to verify the integrity of the installation IVP
Performed IMAGE COPY, QUIESCE, RECOVERY, REORG, REPORT, MODIFY, BIND, CHECK, LOAD
Performed backup and recovery of table spaces, catalog and directory and recovery of application Tablespaces and Index, package and plan administration, capacity planning, performance and tuning
Performed alter of DB2 objects, reorganizing, monitor DB2 Databases DB2 PM created databases, tables, index, table space, stogroup, synonym, views, alias, stored procedures, triggers

March, 2000 -  March, 2000
VP Software Development/Web Architect

Managed the daily activities of developers and DBA s for requirements gathering, systems analysis and design, data base design and administration, programming, testing, implementation, trouble shooting
Utilized Active Server Pages ASP, Java, Java Server Pages JSP, Servlets, WebSphere, DB2 UDB EE/EEE, SQL-Server 7, JDBC, Sybase, Javabeans, XML, HTML, Javascript and Homesite on NT Server and AIX RS/6000

February, 1999 -  February, 1999
ARCHITECT

Wrote conversion plans from a DBA point of view. Performed analysis and programming need to get migrated application working in MVS
Designed and developed a methodology to migrate and convert DB2 tables, COBOL II, FORTRAN, EZTRIEVE, QUICKJOB, ASSEMBLER, FOCUS, FOCEXECS, DB2, IMS and SQL/DS
Migrated DB2 objects sub-system to subsystem, create databases, tablespace, views, synonyms, table spaces, indexes, etc.
Wrote utilities to count datasets application programs, DB2 and applications.
Wrote utilities to move and convert datasets from VM to MVS, PC s, UNIX Solaris and IBM DB2 UDB AIX RS 6000. Utilities written in Rexx, Java, COBOL DB2 UDB, DSN1COPY, Unix Shell scripting
Wrote test plans, implementation plans and documentation capabilities

May, 1997 -  May, 1999
DB2 DBA/ ARCHITECT

Hired to support the Sales Monitoring System SMS that generated reports reviewed daily by the CEO of the company on call 24/7 to fix all production abends
Performed backup and recovery of table spaces and indexes and monitored performance/tuning
Converted system to make Y2K compliant
Designed, developed, created and installed a test environment to mirrored production
Performed systems analysis, wrote a requirements and a project plan for this effort
Performed image copy, quiesce, recovery, reorg, report, modify, bind check and loads

September, 1996 -  September, 1997
ARCHITECT

Hired to replace the original 5 developers in a Prudential down sizing and out source effort and assigned to the system to replace original developers
Performed the design and the programming to enhance the CRMS Client Request Management System a system used tracking calls used by Customer Service Specialist CSS and to log customer calls into a DB2
Wrote detail specifications and assisted in the DB2 design of a 12 table database and performed system analysis, developed user requirements, programming of adhoc reports and queries and production support using CICS, DB2, COBOL II, VSAM REVOLVE and QMF

March, 1996 -  March, 1996
Banker

Performed application DBA functions at Bankers Trust Company on the record management for 40K accounts system using Sunguard s 401K record management software provides 24 hour support
Performed analysis and programmed the ST file compaction system in an effort to allow for more diversity across all sub-systems and companies using various DB2 utilities and CICS, COBOL II and VSAM

January, 1995 -  January, 1996
ARCHITECT

Convert the 12 Federal District Software Systems into 1 system to execute at the New York District computer systems included : fedwires, funds transfer, government securities, remote logging, recreate site, startup systems and audit log
Performed application DBA functions DBD gens and PSB gens
Used IMS DB/DC Fath Path DEDB and MSDB, DB2 GSAM databases and Cobol and performed systems analysis, wrote programs to generate various banking reports.

May, 1994 -  May, 1994
Independent Consultant

Rehired to perform tax reporting enhancements for The Corporate Trust Securities, developed an Online securities processing and to clone parts of an existing system for an IVR Interactive Voice Response system for securities processing using CICS, IMS DB/DC and VSAM
Rehired to standardize the ACTION Systems Securities Processing Systems to meet Bank of New York and Federal Banking standards and setup the ACTION security system datasets in ENDEVOR.

March, 1994 -  March, 1993
Independent Consultant

Performed systems analysis for the package level detail system.

December, 1993 -  December, 1994
Independent Consultant

Performed the computer programming to up load data from PC environment data into FAST PATH DEDB using both SDEPs and DDEPs host system. Using the scan utility to remove from the DEDB and inserted into DB2 databases using CICS, DB2, IMS EXEC DLI, COBOL II, VSAM and INTERTEST

June, 1993 -  June, 1993
Independent Consultant

Performed systems analysis to enhance Merrill Lynch s securities trading system to make enhancement, designing and computer programming the same date trade corrections system for options, OTC and equities using CICS, IMS EXEC DLI, COBOL II, OS/2, VSAM and INTERTEST

October, 1992 -  October, 1993
Independent Consultant

Successfully enhanced the sub-accounting modules of the comprehensive security system CSSII that interacted with the proxy modules as part of the bank s share holder securities system/transfer agent system.

Responsibilities included systems analysis, database design, screen design, programming, testing and user training in an on-line system using IMS DB/DC

April, 1992 -  April, 1992
Banker

Designed and programmed a securities clearing system using COBOL II, IMS DB/DC, DB2, CICS, DESIGNAID and SMARTEST for a system was developed to change existing clearing system used throughout the securities industry
Incorporated extended systems features by converting from IMS databases to DB2 tables were some of the enhancements.

July, 1991 -  July, 1992
Project Manager

Management responsibilities include project planning and development of the complete re-write of the accounts receivables or general ledger back office systems for car rental systems and developed the requirements, performed the analysis, database design, programming specifications, coding and testing and implementation using COBOL II, IMS DB/DC DB2 and Microfocus WORKBENCH
Normalizing Data, E Modeling, Table design and performed the administrative and coordinating tasks for both IMS and DB2 database design.

October, 1986 -  October, 1990

Education

Skills


EXPERIENCE LEVEL UDB Linux Unix Windows LUW 10 years UDB UNIX Solaris 5 years DB2 on Mainframe Z/ OS 15 year UDB DB2 DBA or EEE or DPF 10 years UDB Federated Databases 3 years IMS Database or DC 10 year SQL Server 2000 2 year MYSQL 5 years Scripting Kshell Perl 10 years Data Modeling/Analysis 5 years SQL coding and optimizing 15 years
Hardware : P/690 or AIX, RS 6000 or AIX, IBM Z/OS, OS/390 Software : COBOL, VSAM, SQL, REXX, QMF, OS/JCL, CICS, Java, JSP, WebSphere Database : IBM UDB DB2, IMS/VS DB/DC, CICS and SQL/DS



Miscellaneous

Provided technical consulting of corporate level projects across divisions and subsidiaries as a DBA and manager by overseeing the daily activities DBA s to supported DB2, IMS, SYBASE, CICS and IDMS by supporting system software evaluated, supported and installed vendor software packages databases performing the following database functions : DBD gens, database, integrity, database backup and recovery, database change accumulations, reorganization, database performance copy, database allocation, database performance issues, database monitoring and tuning, database design, database support, created DB2 table space, DB2 tables, DB2 views and DB2 indexes
Developed an in-house time accounting systems and supported Health Claim Systems, full project life cycle using structured design methodologies coding through implementation for the Time Accounting Systems entity relational modeling, data normalizing, data analysis, data and paper flow diagrams and database design for the Time Accounting System using Timeline Project Management Software and NASTEC CASE 2000/Design Aid using COBOL, REXX, SQL/DS, DB2 and XMENU/E
Supported IDMS IDMS_R database and ADSO
Wrote a technical report outlining intricacies of the mainframe charge back and recommended improvements