Catherine
catherine.mercado@gmail.com
650-302-8199
Pacifica, CA 94044
DB2 Utilities Software Engineer / DBA
29 years experience W2
2
Recommendations
Average rating
207
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
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
OPTIM
2022
20
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
IBM WebSphere
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
Project Management
2003
3
Quality Assurance
2003
3
Shell Scripts
1999
3
Systems Integration
2003
3
Billing
1996
1
Performance Tuning
2005
1
PL/1
2000
1
Siebel
2005
1
Switches
1996
1
System Analysis
2000
1
C
0
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
Scripting
0
1
Visual Basic
0
1
Windows
0
1