SUMMARY:

Seeking a position where I can use my skills to help the company achieve their overall goals. I have over 7 years’ experience on Z/os Mainframes using JCL, TSO/ISPF, SPUFI, QMX, and various other mainframe tools.

TECHNICAL SKILLS:

• DB2 Version 9,10, IMSDatabase AnalysisCOBOL (I & II)
• SQL
• Teradata
• JCL
• Visual Basic
• EASYTRIEVE Plus
• Micro Focus Cobol
• RC Secure, RC Migrate
• Catalog Manager
• Catalog Tools
• Guardiam Encryption
• Job Scan
• FTP
• File Aid
• RACF
• IN Sync
• VSAM
• CHANGE MAN
• SYNCSORT
• Compare X
• Pan Valet
• Expeditor
• Flat Files
• CA7
• TCP/IP
• TSO/ISPF/SDSF
• Project Management
• Agile
• VISIO
• Lotus Notes
• Confidential 3270
• OS/MVS
• Windows NT/XP
• System Analysis
• Flowchart
• Modular Planning Development
• Test Script
• UAT Test Plans
• Manual/Automated Testing
• Medical/Clinical Billing Records
• Functional Testing
• Integration Testing
• Unemployment Insurance
• Accounts Receivable & Payable

EXPERIENCE:

Senior Db2 Data Base Admin

Confidential, Atlanta, GA

Responsibilities:

• Monitor Databases for reliability and performance.
• Use Confidential ’s DB2 Utilities to perform Image copies, Reorgs, Display the claimers to a Database.
• Use Confidential 's SPUFI and QMF to write SQL queries.
• Add /Rename Columns on existing Db2 Tables.
• Create Db2 Tables, Views, Indexes and other DB2 objects.
• Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Experienced in z/OS mainframe environment using JCL and SQL including DDL, DML, and DCL.

Confidential

Operations Manager/Senior DB2 DBA Admin, Richardson, TX

Responsibilities:

• Monitor Databases for reliability and performance.
• Use CA's DB2 Utilities to perform Image copies, Reorgs, Display the claimers to a Database.
• Use Confidential 's SPUFI and QMF to write SQL queries. Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Created and reviewed SQL queries in TOAD.
• Created and maintain DB2 tables for client.
• Perform Database Benchmarks.
• Mentor junior DBA's in the duties of Data Base Administration.

Confidential

z/OS DB2 DBA Admin, East Moline, IL

Responsibilities:

• Created and maintain DB2 tables for client.
• Use BMC DB2 Utilities to perform Run stats, Image copies, do Reorgs ect.
• BMC Catalog Manager to create Foreign, Primary keys and Indexes.
• BMC Change manager to plan and deploy migrations from Development to QA, and finally Production.
• Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases
• Use BMC Apptune to tune SQL queries that have performance issues.
• Use z/OS DB2 Native Mainframe daily to perform DB2 DBA functions (Display database).
• Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Created and reviewed SQL queries in TOAD.
• Load Plus and Recovery Plus for Db2.
• Reorg Plus, UnLoad Plus and Copy Plus for Db2.
• The BMC Suite of Utilities for DB2 10 & 11.
• Performed DBA security functions using Computer Associates RC/Secure tools.

Confidential, Deerfield, IL

IT Technical Associate - DB2 DBA Admin

Responsibilities:

• Monitor Databases for reliability and performance.
• Use Confidential ’s DB2 Utilities to perform Image copies, Reorgs, Display the claimers to a Database.
• Use Confidential 's SPUFI and QMF to write SQL queries.
• Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Experienced in z/OS mainframe environment using JCL and SQL including DDL, DML, and DCL.
• Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases
• Use Omegamon to review the health of the Databases.
• Use Content Manager to design databases and its objects.
• Perform Backup and Recovery using SQL to recover Databases.

Confidential

DB2/IMS DBA

Responsibilities:

• Develop lesson plans to help train international student in DB2/IMS.
• Review documentation that is used to instruct students in India in Mainframe zOS skills.
• Used cloud based software to share documents across countries.

Confidential, St. Louis, MO

DB2 DBA

Responsibilities:

• Research, design, develop, and/or modify enterprise-wide systems and/or applications software.
• Performed Data Analytics on Confidential mail to determine the effectiveness of direct mailings to the clients.
• This was a position of Public Trust with Sensitive Information.
• Create Tables/Database Schemas in z/OS Mainframe environment with DB2 using both SPUFI and BMC's Catalog Manager.
• Create Tables/Database Schemas in a LUW environment on a Windows system then moved developed product to Mainframe zOS Sandbox site for further testing before deployment to Production system.
• Be involved in the planning of system and development deployment as well as responsible for meeting software compliance standards.
• Develop and maintain database schemas to include normalization and de-normalization
• Monitor Databases for reliability and performance
• Use Confidential ’s DB2 Connect to write SQL queries to perform critical Legal requests from Washington D.C
• Created VIEWs and TABLES in test region using BMC Catalog Manager

Confidential, Piscataway, NJ

DB2 DBA

Responsibilities:

• Experienced in zOS mainframe environment. Currently use application tool File Aid to browse DB2 Tables in the effort of building SQL queries.
• Created VIEW in test region using DDL.
• Used DML to Insert and Update data into Test region so Java & Spring Developers can test their updates to Confidential webpages.
• Wrote JCL to run NATRAS system when updates are need.
• Experienced with physical and logical data modeling, database normalization and de-normalization, etc.
• Developed spreadsheets thru Micro Soft query to create Legal reports to send to appropriate agencies.

Confidential, Columbia, MO

DB2/IMS DBA

Responsibilities:

• Updated and maintained DB2 tables for multiple clients. Experienced in zOS mainframe environment using JCL and SQL including DDL, DML, and DCL. Performed Image Copies, Recovery, REORG, RUNSTATS, Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases. Used DB2 to create, alter and drop tables.
• Created and updated JCL so jobs can be tested before they go into production. Use Zos Mainframe daily to perform DB2 DBA functions.
• Performed Data Analyti cs on DB2/IMS Databases to keep track of percentage used for storage requests.
• Issued Grants and Revokes of users and Table as part of my Computer Security role using DCL in QMF.
• With IMS used Mainview/Omegamon for running IMS PSB Gens.
• Run reorgs and Pointer checkers on IMS Databases. Performed Database Security for main client Caterpillar to grant access for users/jobs to Tables, Views and Lids. On-call for 3 clients with their own unique systems.
• Received Letter of commendation from Caterpillar praising my work as a DBA.
• Used z/OS 2.0 Mainframe Operating System. Trained in LEAN methodologies thru Confidential classes
• Use Maximo tool to update, create and close my tickets. Updated Excel spreadsheets for my Manager.
• Trained offshore Database Administrators in the maintenance of Tables, Table Spaces, Views, and Indexes.
• Received a rating of 2+ on my Confidential 's (Personal Business Commitment).
• Trained co-workers on performing DBA security functions using Computer Associates RC/Secure tools.
• Was On-call 4 week rotation for three years with multiple clients,. Including one client who required response within 15 min of being paged.

Confidential, Jefferson City, MO

Consultant

Responsibilities:

• Performed unit testing and QA testing on programs written by myself and other associates. Developed and executed system test plans for the purpose of performing full system integration. Tested on-line mainframe screens for correct functionality
• Reviewed code wrote by fellow consultants. Used VPN soft token to remote into client's system.
• Developed code for Unemployment agency.