Uploaded File
Catherine
catherine.mercado@gmail.com
650-302-8199
Pacifica, CA 94044
DBA
26 years experience W2
2
Recommendations
Average rating
128
Profile views
Summary

Hardware: IBM MainFrame (z/OS), Novell / Unix File Servers, FACOM V-830 (Mini-Frame), PIIs, Pentiums, 486s, 386s, 286s, GEAC MainFrame, HPLJ Printers, Xerox Printers, Ethernet & Token Ring Cards, Internal & External Modems

Operating Systems: z/OS, OS/390, VM/ESA, TSO, AIX UNIX, WIN XP, WIN ME, WIN ’98, WINDOWS NT, WIN ’95, WINDOWS 3.11, MS-DOS, NOVELL 4.10/3.12/3.10, SCO UNIX

Software: DB2 v11; v10; v9; v8; v7; v6; v5; v4 on z/OS, IBM Admin & Object Compare Tool, Analyzers & Catalog Facility, QMF, OMEGAMON, CA-Insight, ErWin Tools, Lotus Notes, CHANGEMAN (Change Management Tool), FileAid, SAR, QuickRef, CA7, VI Unix Editor, DB2 Connect, MQ Series, QuickRef, SDSF, DBArtisan, Embarcadero, MS Frontpage, Netscape Mail, Expert Advisor, MS Mail, MS Word, MS Excel, MS Access.

Languages: COBOL, Visual Basic, SQL, JCL, REXX, C/Korn/Bourne Shell Scripting, PC/Focus (4GL)

Skills: Software Installation, Hardware Upgrade (PC), Software & Hardware Configuration, Network Installation, Design Methodology, Structured Programming, Telephone Switch Configuration, Data Recovery, Data Migration, Logical to Physical Modelling, Performance and Tuning, SQL Optimization, DASD Management, Disaster Recovery, Database Monitoring for Optimization

Experience
DB2 Utilities Software Engineer / DBA
Information Technology
Sep 2005 - present
  • Re-create and resolve customer issues as L2 for DB2 Utilities
  • Re-create and resolve customer issues as L2 for Optim / Guardium S-TAP Tools
  • Provide technical know-how of the product use via PMR, Email or telephone
  • Discuss with DEVELOPMENT issues found and open APARs on behalf of customers
  • Create REXX programs to facilitate edit of huge DDLs from customer or create DDLs needed to recreate a customer scenario
  • Coordinate with Rocket any S-TAP PMRs opened by the customers
  • Update PTF Listing pages for Optim / Guardium Tools
  • Tested the functionality of CMDB (Change Management Database)
  • Make recommendations to developers on how to improve product
  • Train new personnel on testing standards and act as a Consultant to resolve / teach DB2 issues encountered
  • Installed DB2 Administration Tool for z/OS, DB2 Object Comparison Tool for z/OS, SQL Performance Analyzer for z/OS, DB2 High Performance Unload for z/OS
z/OS DBA DB2 EDI CMDB Software Engineer SQL IBM Guardium
Remove Skill
References
Average Rating

1 recommendation
Senior Analyst, DBA
Information Technology
Jun 2004 - Jul 2005
  • Performance and Tuning Siebel SQL’s for faster access with constant interaction with IBM to resolve new issues with DB2 v8
  • Used CLI Bench to benchmark SQL timings and tune SQLs which perform longer than 1 second
  • Performed reorgs on objects that were in extents and runstats on tables / indices
  • Installed and maintained WebSphere Application Monitor / Rational Profiler for monitoring WAS Applications using AIX Unix
  • Installed new applications in WebSphere and tested them for functionality
DB2 DBA Performance Tuning SQL IBM WebSphere UNIX AIX
Remove Skill
References
Average Rating

1 recommendation
Consultant - Database Management Services
Banking/Financial
Aug 2000 - Oct 2003
  • Primary DBA for Cross Sell Project which amalgamated 10 data warehouses
  • Assisted in developing standards and methodology for company-wide use
  • Provide skeleton JCL to Application Developers for Test / Production use
  • 24x7 DB2 Production Support
  • Update, Create, Reverse Engineer Logical/Physical Models in ERWin
  • Analyze Logical Models and created Physical Objects
  • Monitor non-SMS managed Objects and migrate non-SMS to SMS managed packs
  • Bind, rebind of Plans / Packages to alter access paths
  • Use REXX programming to facilitate JCL creation and create customized CALL programs to automate JCL jobs
  • Support UDB for Websphere for Household Auto Finance using AIX UNIX
  • Assisted in the successful completion of DB2 Connect and MQ Series for UDB
  • Provide DB2 support to Application Developers (on-site and off-site)
  • Repartition, Create, Alter, Migration of Production/QA/Development Objects
  • Refresh/Reload/Unload data in different environments for Compare/Upload in another environment
  • Monitored System Integration Testing to determine if databases are optimized and if not, make the proper recommendation to optimize databases
DB2 UNIX DBA JCL Production Support Rexx AIX Logical Modeling Physical Modeling IBM Websphere MQ Systems Integration DB2 Connect Data Warehousing DB2 LUW Erwin Data Modler Quality Assurance
Remove Skill
Database/Systems Analyst / DB2/Informix Database Administrator
Government
Aug 1999 - Aug 2000
  • Repartition, Create, Alter, Migration of Production/Development Objects
  • Alter Tablespace/Indexspace using Stogroup instead of VCAT
  • Refresh/Reload data in Test Objects from Production Imagcopies
  • Alter Type 1 Index to Type 2 in preparation for version 6
  • Bind, rebind of Plans / Packages to alter access paths
  • Use REXX programming to facilitate JCL creation
  • Provide DB2 support to Application Developers
  • Monitored Data Packs & reorganized objects when required
  • Changed DBA WorkBench using PL/1 code
DB2 DBA Rexx JCL PL/1 System Analysis
Remove Skill
DB2 DBA
Retail
Mar 1996 - Jul 1999
  • DBA support for SPOT Team using INFORMIX database o/s AIX UNIX
  • Used DBIMPORT/DBEXPORT to load/unload data into ASCII files.
  • Performed DLL compares for tables & indices using UNIX Shell Scripts for versioning
  • Monitored User Activity to check locks, table contention & size of temporary tables
  • Installed & populated an instance for testing purposes.
  • DBA support for CARR’S in Alaska using both DB2 & INFORMIX
  • Assisted in creation of Test DB2 for the integration of DOMINICK’S in the system
  • Create Test Data for Dominicks
  • Provide DB2 support for VONS in Los Angeles
  • Create & Populate database for WCSS (Worldwide Chain Store System)
  • Create Documentation for JCL for VONS
  • Repartition, Create, Alter, Migration of Production Objects
  • Bind, rebind of Plans / Packages to alter access paths
  • Provide DB2 support for Application Developers
  • Review and approve Platinum Strategies prior to implementation
  • 24x7 DB2 Production Support
  • Create customized Platinum Model Services for Developers
  • Created MS Access Database to track creation of temporary tables for users
  • Created a Scheduler in Visual Basic for the Secret Shopper Department
  • Created a Payroll/ATO Excel/E-Mail Application
  • Provided backup support for Peregrine Systems (PNMS)
  • Provided backup support for LAN
  • Provided support for WIN 3.11, WIN ’95, WIN ’98, Word, Excel, & Netscape Mail
DB2 DBA Production Support Peregrine Shell Scripts Database Backups JCL
Remove Skill
Support Analyst / Database Administrator
Manufacturing
Jan 1995 - Mar 1996
  • Provide initial training regarding Network and Telephone use
  • Provide hardware and software support to users
  • Provide telephone support to users
  • Reconfigure hardware and software to meet user requirements
  • Create, update & revise Client Database using Access for various departments
  • Reconfigure phone switches and generate reports on various phone billings
  • Installed Network & Telephone cable connections when required
  • Acquire quotations for hardware and software requirements
DBA Switches Billing
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Managing and Optimizing Informix Dynamic Server Databases
Franklin TimeQuest Time Management Course 1998
DB2 for MVS Database Administration
Langara College 1993
Computer Information Systems
AUTOMATION CENTER OF THE PHILIPPINES 1986
Accounting
UNIVERSITY OF SANTO TOMAS 1984
IBM Tech Seminar
DB2 UDB Family Fundamentals DB2 UDB Advanced SQL Workshop
IDUG Seminar
Certifications
IBM Certified Solutions Expert DB2 UDB v7 Database Administrator for OS/390
On-Line Programming (Data Communications Management)
Graduated: Computer Programming (COBOL)
Skills
DBA
2021
24
DB2
2021
23
SQL
2021
15
CMDB
2021
14
EDI
2021
14
IBM Guardium
2021
14
Software Engineer
2021
14
z/OS
2021
14
JCL
2003
7
Production Support
2003
6
AIX
2005
4
Rexx
2003
4
UNIX
2005
4
Data Warehousing
2003
3
Database Backups
1999
3
DB2 Connect
2003
3
DB2 LUW
2003
3
Erwin Data Modler
2003
3
IBM Websphere MQ
2003
3
Logical Modeling
2003
3
Peregrine
1999
3
Physical Modeling
2003
3
Quality Assurance
2003
3
Shell Scripts
1999
3
Systems Integration
2003
3
Billing
1996
1
IBM WebSphere
2005
1
Performance Tuning
2005
1
PL/1
2000
1
Switches
1996
1
System Analysis
2000
1
CHANGEMAN
0
1
Cobol
0
1
Data Migration
0
1
Data Recovery
0
1
Database Design
0
1
Disaster Recovery
0
1
File-Aid
0
1
IBM Mainframe
0
1
OS/390
0
1