DB2 UDB for Linux, UNIX and Windows Consultant Resume

PROFESSIONAL SUMMARY:

As an Confidential employee for over 16 years, installed and maintained DB2 databases on the mainframe for 14 years followed by 2 years working with DB2 on midrange platforms. As anCertified, DB2 Subject Matter Expert, provided consultation services to clients across North America: answered questions about DB2, helped tune, increased performance, debugged initial problems, and analyzed crashes for root causes. In addition, technical knowledge of Oracle through a series of detailed courses, and installed, maintained and tuned Adabas/Natural, and Focus.

KEY EXPERTISE INCLUDES:

DB2 Problem solving
Oracle Diagnosing defects
Adabas Performance and Tuning
Natural Customer Service focus
Focus Articulate in written and spoken English
REXX Oriented to always use best practices
JCL

PROFESSIONAL EXPERIENCE:

Confidential

DB2 UDB for Linux, UNIX and Windows Consultant

Responsibilities:

First - contact support for Database 2 Universal Database for Linux, Unix & Windows.
Questions ranged from how-to, more detailed analysis, tuning problems, defects, and root cause analysis of crashes.
Most required detailed product knowledge.
Within 6 weeks of being transferred to this new area was answering more questions than any other team member (4 in total including me). By the end of 2008 had answered 30% of all questions while achieving a 95% customer satisfaction rating. Articulate in both written and verbal contexts: 75% of the responses were via email, 25% by phone.
Approximately twice weekly answered high severity problems received from the UK, Australia and India.
Night and weekend on-call support for severity 1 problems on a rotational basis every 10 -12 weeks.
Handled 2-3 system-down situations per shift involving frantic customers. Invariably received good comments from those customers; always rated the highest on the satisfaction survey’s scale.
DB2 UDB for OS/390 Senior Subject Matter Expert
Night and weekend on-call support with duties as listed above.
DB2 for OS/390 Senior Systems Specialist
Systems Support for DB2 for OS/390 on 9 local and 2 remote companies.
At one point, for 18 months, there were only two of us in my group supporting 52 DB2 subsystems, tools and applications.
Migrated DB2 versions twice in 4 years for each of the 52 subsystems
Installed maintenance once a year on each of the 52 subsystems
Created and modified a REXX/JCL system of jobs to monitor performance on each subsystem
Tuned for performance as indicated by the above tool
Standardized every subsystem to make it easier to work with, except for business-specific exceptions
Resolved problems as they surfaced: analyzed the problem, discussed with the client, created a solution, and implemented it.
Extensive Year 2000 testing and monitoring
Disaster Recovery support and yearly testing for 5 customers
Assisted with basic administration functions as requested by DBAs or their companies
Installed and maintained various add-on tools including DataPropagator Relational and OAM/On-Demand.
Installed and supported 3 DB2 UDB for AIX environments
On-call support for all DB2 for OS/390 problems for all 20 Alberta and Manitoba companies outsourced to Confidential Canada.

Confidential

DB2 for OS/390 Junior Systems Specialist

Responsibilities:

Supported DB2 for OS/390 locally in a Systems and DBA function for 12 customers. Same functions as listed above.
Nightly and weekend on-call support for DB2 for OS/390 problems for 12 local customers outsourced to Confidential .
Installed, maintained and upgraded mainframe database systems including: DB2, ADABAS, Natural, FOCUS, Design4Data.
Designed Disaster Recovery procedures for DB2 for OS/390, permitting full recovery of all data to within one day's time.
This REXX/JCL system, suitably modified for changes in DB2, is still in use today, 16 years later.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship