PROFILE:

• Results - driven DB2 Database Administrator / Developer with more than 20 years of proven expertise installing, configuring and administering database solutions.
• Experienced in administering all aspects of DB2 database, including logical/physical database design and migration, security/auditing, disaster recovery, capacity planning and performance tuning.
• Extensive experience designing, installing, customizing and supporting DB2 databases under AIX (9 years) and Z/OS based platforms (11 years).
• Proven success in designing, installing and supporting technologies and tools to increase database capabilities and automate administration functions.
• Extensive qualifications in software development life cycle, from initial feasibility analysis and design through testing, implementation and support.
• Skilled project manager; able to communicate effectively with management and staff at all skill levels.

TECHNICAL SKILLS:

Platforms: Windows, AIX, Z/OS, LinuxSoftware DB2 Utilities, DB2 Performance Monitor, Platinum DBA Tools and Utilities, OS/390 Utilities, SQL REP, MQ REP, Unix Scripting, Relational Modeling Tools, DBArtisan, BMC Database Suite, Quest,DB2PD, DB2 Compression, partitioning

Languages: SQL, REXX, CICS, PL/1, APL, shell scripting KSH, CSH

Databases: DB2/UDB V8, V9,V10.1 DB2 Z/OS V8, V9.5, V10.1

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Responsible for full range of DB2 DBA activities from server/software installation, application install, hadr and replication install.
• Accountable for system tuning, cluster setup, system-wide monitoring, and automation of all DB2 maintenance and job entry scripts.
• Performed DB2 subsystem configuration as well as SQL turning.
• Responsible for major systems on a 24/7 basis. Areas of control.
• HADR, MQrep, HACMP, database & data partitioning, DB2 Compression and HSM

Confidential

Consultant

Responsibilities:

• Established a complete SQL Replication environment to provide proof of concept for V9.1Capture to V9.7 Apply success.
• Responsible for the maintenance and restoration of the Maximo production Stress Test environment. DB2 V9.7 installation and debug on two environments .
• Provided index analysis and SQL performance tuning.
• Responsible for DB2 Utility schemes and implementation for responsible instances.
• Responsible for server builds from OS install to application installation. HADR QREP

Confidential

Database Administrator

Responsibilities:

• I was responsible for the schema modification, implementation and maintenance of 5 Confidential applications within the FPCMS core accounting business group.
• The application scope was a spread of AIX OLTP and Z/OS OLTP environments. MQ Replication and CICS transaction processing was concerned.
• My tasks include user and application liaison, database creation, database utilities, application rollout, database restores, DB/DBM optimization and application and SQL tuning and maintenance in Production and Test environments.
• Performed database utility automation and am on the production on-call rotation for DB2 AIX-Z/OS, Sybase & SQL/Server

Confidential

Z/OS Database Administrator / Remote System Support

Responsibilities:

• I am responsible for logical/physical design and modification, data movement and content verification for a high profile DB2/AIX Web application that is deployed worldwide 24x7.
• The ONTARGET data source was mined from a Z/OS mainframe source.
• Responsibilities included the writing of the SQL to extract and formulate the data from the Z/OS source, interaction with development, tech support, worldwide end users and project management.
• Created a prototype environment with DB2 on Windows as a guest O/S under VMWARE for a project feasibility study.
• Also I am responsible for application deployment and version upgrades across highly complex server networks.
• Additionally, I provide application technical support on a rotating basis

Confidential

DB2/OS390 & AIX Database Administrator / Consultant

Responsibilities:

• Responsible for structure definition and modification, SQL tuning and development support.
• Multiple test bed maintenance was performed to satisfy off-shore application development. Performed roles of production job control, SQL tuning, problem determination and resolution, logical - physical design and general maintenance in a highly complex data-sharing environment.

Confidential

DB2/UDB AIX Database Administrator / Consultant

Responsibilities:

• Provided on-call coverage for a worldwide 7x24 online distributed OLTP application on an AIX platform.
• Performed roles of production job control, problem determination and resolution, backup and recovery and general maintenance for a multiple node fully distributed system.

Confidential

DB2/OS-390 Database Administrator / Developer / Consultant

Responsibilities:

• Under contract to contribute an Application Integration Project to define strategy to successfully convert and merge data from various DB2 systems into a unified database solution.
• Developed DB2 application and utilized DB2 Utilities and BMC Utilities to appropriately migrate and integrate data. Insured all activities adhered to project scope and time lines.
• Designed and delivered status reports to team members.
• Credited with successfully integrating data from numerous systems into a unified database.
• Designed testing procedures to appropriately test the results of the conversion effort to ensure greatest degree of accuracy.

Confidential

DB2/OS390 & AIX Database Administrator / Consultant

Responsibilities:

• Challenged to introduce new performance tuning strategies into existing SQL stream to reduce 28 hours of elapsed time and allow the deployment of new release of a high visibility claims processing system.
• Designed new logic and data - flow solution and presented to Application Management and Technical Staff.
• Collaborated with QA Technical staff to determine requirements for the design of the new data structure and data requirements for the creation of new test environment.
• Performed day-to-day administration of DB2 databases, including security, backup/recovery, capability planning and performance tuning.
• Interfaced extensively with Lead DBA to coordinate all workloads.
• Recognized for designing new data structure to allow the entire batch application to process data as multiple parallel events, reducing batch job stream elapsed time by a factor of four.
• Spearheaded the deployment of partitioning strategy into multiple data structures and the creation of balanced partitioned index schedules to allow optimum concurrent workload flow.

Confidential

Lead DB2 Database Administrator / Developer

Responsibilities:

• Provided strategic and tactical DB2 leadership to ensure appropriate support of the Development, Engineering and Customer Support organizational functions for all KRONOS DB2 applications and platforms.
• Initially brought in to successfully migrate company s existing KRONOS application from SQL Server to DB2 under multiple Windows 2000, AIX and OS/390 environments. Planned and converted all data to ensure appropriate operation within all 3 environments.
• Provided DBA support to the Development staff to ensure appropriate implementation of weekly code installations. Installed DB2/UDB client and to allow the communication from application servers to server onto Developers workstations on all support environments. Configured DB2 Connect and options database servers. Coded and tested SQL stored procedures, triggers and define objects.
• Performed DB2 product upgrades and back - up procedures onto servers and clients on all 3 platforms. Implemented and performed local design of security processes on all 3 environments.
• Collaborated with Confidential DB2 Consultants to analyze and resolve all DB2 performance, throughput and product constraint issues.
• Coordinated all application changes with Data Modelers and Data Architects.
• Presented all change requests and status of open issues to management. Trained Customer Service Staff.
• Successfully ported Kronos SQL Server product to DB2/UDB V7.2 EEE under Windows, AIX and DB2 V7 on an OS/390 environment.
• Played critical role in the on-time installation of the DB2 Kronos product into the targeted customer environment, without error.
• Managed and supported a DB2 environment that was not engineered to accommodate constant structural change to allow the total elimination of all system datasets and the refresh of the system software on a weekly basis on all 3 platforms.
• Chosen to participate in a product presentation and detailed overview to Kronos largest prospective client. Developed a series of white papers on DB2 product settings and options necessary to satisfy Kronos application.