Sr. Database Administrator/analyst Resume
San Antonio, TX
SUMMARY:
Seeking a position where my IMS/DB2 DBA technical and software skills will be used to enhance the data processing flow in Mainframe or Network support.
HARDWARE / SOFTWARE KNOWLEDGE:
Operating Systems: Confidential Mainframe Z/OS, OS/390, MVS, Windows
Software: REXX, CLIST, DB2, SAS, CA7, CA11, NewD(Control M), DRVFI, Omegamon, JES, SMS, MICS, Enterprise, IMS DB/DC, JCL, Internal and External SyncSort, SAR, TSO/ISPF, PROCS, VSAM, DBRC, BMC Utilities, Confidential Utilities, Patrol, Remedy, IDCAMS, File - Aid, IMF, IRLM, Recons, Mainview (Boole and Babbage), Microsoft Office Suites, NEON Utilities, Confidential DB2ADMIN, Erwin, Data Studio, OPTIM, Apptune, RTC.
PROFESSIONAL EXPERIENCE:
Confidential, San Antonio, TX
Sr. Database Administrator/Analyst
Responsibilities:
- Responsibilities focus on the support (integrity and performance) of the IMS (V14) and DB2 (V10) datastores in a sysplex environment
- Supported multiple IMS Full function, Fast Path and HALDB databases on the Production complex with 10 shared control regions along with a TRAINING environment, Test complex with 4 shared control regions and 2 Development environment.
- Also support multiple DB2 databases with 10 DB2 subsystems across Production, Training, TEST and the Development environments.
- Other responsibilities included but not limit to are Disaster recovery, Backups, recoveries, reorganization of datastores, Change Accum, Pointer Checker, TRACES, DBDGEN, PSBGEN, ACBGEN and 24x7 oncall support.
- This work involves the use of MVS, IMS, DB2, IDCAMS, DBRC, VSAM, SQL, Microsoft Office Suite, Mainview, Confidential DB2ADMIN, and NEON Utility products in a Z/OS mainframe environment.
- Performed Manager on Duty (MoD) role in Chennai, India (2010) and Guadalajara, Mexico (2014) that focused on Return to Service and managing third party personnel to ensure issues were escalated in a timing fashion along with making sure the Offshore and Nearshore environment was secure.
Confidential
Computer Operator Specialist
Responsibilities:
- Responsible for second level problem analysis and resolution for networking troubles by utilizing diagnostic and reporting software tools including, but not limited to NCCF, TMON, JCL, Service Center, Big Brother, AUSM, CICS, CICS for DB2,Control-O, Control-M,Unisys console, Confidential master console and OSS; currently working on the Unisys and Confidential Master Console but am experienced with JCL, CICS, Control-O and Control-M.
Confidential, Atlanta, GA
Contractor
Responsibilities:
- Responsible for setting up Dell computers in class rooms and administrative offices purchased by the school systems; also responsilbe for imaging the computers when necessary and disassemble computers that were being replaced.
Confidential, Alpharetta, GA
Senior Systems Integrated Professional (DBA)
Responsibilities:
- Responsibilities focused on the support of IMS, DB2 and CICS data stores on the Confidential & Confidential Long Distance and Residence Billing System; supported seven MVS complexes, 11 production IMS control regions, 16 DB2 Subsystems, 15 Production Processing Entities (PE’s), more than 10,000 IMS/DB2 data stores, Performance Management Group homegrown toolbox and the Residence Billing Backout (RBBO) Clist, SAS, Disaster recovery, Backups, reorganization of data stores and 24x7 Tier 2 on- call support; provided Application Support to all production and testing applications batch and online environments; TIER 1 troubleshooting backup for problem resolutions with an Estimate Time of Repair (ETR) of 30 minutes, which enabled timely processing of critical deliverables going from one system to the next; applications used were JCL, PROCS (cataloged procedures), NEWD Scheduling System, JES, SAR, SMS, SCF, TSO, MVS, IMS, DB2, CICS, IDCAMS, DBRC, VSAM, SQL, Microsoft Office Suite, IMF, IMS and DB2 OMEGAMON, IMS File-Aid, EPILOG, Mainview for IMS, Platinum, and BMC products in an S/390 and Z/OS mainframe environment.
Confidential, Alpharetta, GA
Technical Staff Member (DBA)
Responsibilities:
- DBA responsibilities included Database, Performance and Tuning for the Residence Account Maintenance Platform (RAMP) applications; supported seven MVS complexes, seven IMS control regions, two CICS control regions, 10 DB2 Subsystems, seven independent Production onlines, 15 Production Processing Entities (PE’s), and more than 10,000 IMS/DB2 data stores; (Full Function databases)
- Performance Management Group homegrown toolbox and the Residence Billing Backout (RBBO) Clist, SAS, Disaster Recovery, backups, reorganization of data stores and 24x7 Tier 2 on-call support; provided Application Support to all production and testing applications batch and online environments
- TIER 1 troubleshooting backup for problem resolutions to ensure that “Onlines” were up on time (No Outages); coordinated identification of all functionality for the Residence Billing applications in the event of a site loss; utilized DFDSS, DR/VFI and ABARS tools to backup Confidential assets for off-site storage; utilized SAS programming language to create documentation with vital backup statistics for Disaster Recovery; applications used were JCL, PROCS (cataloged procedures), NEWD Scheduling System, JES, SAR, SMS, SCF, TSO, MVS, IMS, DB2, CICS, IDCAMS, DBRC, VSAM, SQL, Microsoft Office Suite, IMF, IMS and DB2 OMEGAMON, IMS File-Aid, EPILOG, Mainview for IMS, Platinum, and BMC products in an S/390 and Z/OS mainframe environment.
Confidential, Alpharetta, GA
Senior Technical Staff Associate (DBA)
Responsibilities:
- DBA responsibilities focused on the support of IMS, DB2, and CICS databases, as well as application support; Technical Project Leader for the Residence Billing Disaster Recovery project; responsible for coordinating the identification of all functionality for the Residence Billing family of applications in the event of a site loss by utilizing DFDSS, DR/VFI and ABARS tools for backing up Confidential assets to be sent off-site for vault storage; utilized SAS programming language to create detail report used to document vital backup statistics Disaster Recovery; applications used were JCL, PROCS (cataloged procedures), NEWD Scheduling System, JES, SAR, SMS, SCF, TSO, MVS, IMS, DB2, CICS, IDCAMS, DBRC, VSAM, SQL, Microsoft Office Suite, IMF, IMS and DB2 OMEGAMON, IMS File-Aid, EPILOG, Mainview for IMS, Platinum, and BMC products in an S/390 and Z/OS mainframe environment.