OBJECTIVE:

System Programming / Product Support

SUMMARY:

• Experienced z/OS DB2 Systems Programmer.
• Performed, supported and documented storage, communications and security evaluations for new DB2 installations and subsystems maintenance.
• Maintained DB2 dataset alias, systems symbolics and Unix System Services data to perform and support DB2 maintenance.
• Perform SMPE for DB2 for z/OS installations and maintenance.
• Maintained installation verification programs (IVP) to verify successful installations and maintenance.
• Functioned closely with application development groups and application DBAs to ensure positive utilization of new DB2 features, processes and performance improvements.
• Maintained, documented and performed DB2 disaster recovery.
• Experienced in DB2 Product Support, performing product installations, maintenance upgrades and problem resolution.
• Maintained CA - Unicenter DB2 product suites and BMC DB2 product suites.
• Performed product support for QMF, PRF and other DBMS products.
• Instrumental in performance and tuning at the subsystems level as well assisting application DBAs with performance issues.

TECHNICAL SKILLS:

SYSTEMS: IBM z/OS, z/OS USS, IBM compatible personal computers.

SOFTWARE SUPPORT: DB2 for z/OS, DB2 Disaster Recovery specialist, IBM DB2 High Performance Unload, IBM DB2 Automation product, DB2 Log Analysis tool, DB2 System Performance and Tuning, SPUFI, SMP/E, Omegamon for DB2, Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, Confidential DBA-XPERT, UNIX systems services, BMC Recovery Manager for DB2, Performance Reporter, REXX, Princeton Softech Relational tools for DB2, CA Unicenter Products, Confidential File-Aid for DB2, Information Builders Focus for Mainframes, SQL, IBM JCL & utilities, TSO, MVS, ISMF, DFSMS, DFHSM, Storage GUARD, DFdss, FDR, CA-7, HTML, IBM Catalog utilities, CSAR, Centura SQLTalk, DB2 Connect, Parallel Sysplex implementation and COBOL, Pascal, FORTRAN, DEC Assembler.

EXPERIENCE:

Confidential

DB2 Systems Programming / DB2 Product Support / Team Support

Responsibilities:

• Install DB2 v12 (V12R1M100).
• Prepared DB2 v12 for z/OS 2.3 by using fix category reports for SMPE zones, confirming all fallback PTFs are applied, converted BSDS to 10 byte RBA and process pre-migration jobs etc.
• Performed DB2 V11 installations and support.
• Converted DB2 subsystems to conversion mode and NFM.
• Lead efforts to successfully convert to 10 Byte RBA on single image and data sharing DB2 subsystems.
• Installed and maintained DB2 Automation Tool, DB2 High Performance Unload and DB2 Log Analysis support products.
• Facilitated DB2 systems team project updates and change management meetings.

Confidential, Birmingham, AL

Systems Programmer / Third Party Product support

Responsibilities:

• Provided expert administration and support of third party vendor products.
• Installed and support Confidential, CA and IBM software products.
• Confidential Enterprise Server, Host Communication Interface, Enterprise Common Components.

Confidential, Birmingham, AL

DB2 Systems Programmer

Responsibilities:

• Provided system programming support for DB2 subsystems.
• Provided performance tuning and assisted in Database Administration (DBA) support for all z/OS applications.
• Perform maintenance upgrades to DB2 for z/OS and conversions to new function mode for various DB2 versions.
• Provided expert administration and support of database technology.
• Undertaking complex projects requiring specialized technical knowledge and makes decisions on ambiguous administrative and support issues.
• Communicates common goals and direction for the team. Interfaced with management to provide project updates.

Confidential, Atlanta, GA

DB2 Systems Programmer / Applications DBA

Responsibilities:

• Designed automated DB2 disaster recovery system.
• Provided system programming support for DB2 subsystems.
• Positioned DB2 subsystems for version 8 upgrade.
• Provided performance tuning and Database Administration (DBA) support for all mainframe applications.
• Convert DB2 application databases to Oracle on UNIX platform.

Confidential, Austin, TX

Senior Systems Engineer / z/OS DB2 Support

Responsibilities:

• Provide consultation on the feasibility of replacing traditional backups with hardware specific copies for SAP Applications on DB2 z/OS.
• Evaluated DB2 and systems capacity requirements required to support applications to reduce resource utilization.
• Support maintaining software requirements to sustain applications.
• Provide user and technical support for DB2 and DB2 System products.

Confidential, Indianapolis, IN

DB2 Systems Support / Product Support Specialist

Responsibilities:

• Provided product support for PrincetonSoftech Relational tools for DB2 product suite.
• Consultant for DB2 version 8 and Data sharing performance and tuning.

Confidential, Birmingham, AL

DB2 System Support / Product Support Specialist

Responsibilities:

• Responsible for account’s DB2 subsystems.
• Provide Business Analysis expertise by effective requirements gathering and documenting to ensure an accurate and effective end solution.
• Efficient design, development, and testing of simple and complex reports.
• Proactive time management to ensure production of accurate and timely business queries and reports.
• Performed various special projects and analysis.
• Responsible for disaster recovery implementation, testing and documentation.
• Managed installs and refreshes of new versions of DB2 subsystems.
• Perform problem resolution for DB2 Responsible for DB2 SMP/E.
• Managed logs, reorgs, performance tuning and backups for DB2 system data.
• Performed installations of DB2 support software, perform maintenance for system software, create change control for software installation and refresh process, training end users in DB2, SQL, QMF, PC, testing and evaluating new software and client server applications, acquiring resolutions from Confidential for DB2, SQL/DS and QMF.
• Install and maintain Focus for Mainframes (formerly Focus for s/390).
• Provide software support for CA Unicenter products for DB2 and Confidential File-Aid for DB2.

Confidential, Birmingham, AL

Storage Management System Analyst

Responsibilities:

• Responsible for Confidential Telecommunications account’s Testbed datacenter Storage DASD management.
• Saved dollars by managing leased and owned DASD storage.
• Provides technical support and training to end users.
• Worked with outside vendors and internal customers with complex modifications and testing of vendor systems before installation to production systems.

Confidential, Birmingham, AL

Storage Management System Analyst

Responsibilities:

• Responsible for Testbed datacenter Storage DASD management.
• Provides technical support and training to end users.
• Worked with outside vendors and internal customers with complex modifications and testing of vendor systems before installation to production systems.