Ms/db2 Dba Resume
0/5 (Submit Your Rating)
SUMMARY:
- Experienced seasoned Database Administrator/ Project Leader with over 17 years of information technology experience, specializing in large project environments.
- Energetic self - starter who thrives in a fast-paced environment.
- Committed to customer satisfaction, both external and internal.
- Works well in team and individual environment.
TECHNICAL SKILLS:
Technology and Tools: IMS, DB2, Informatica ETL,OS390/Z/OS, MVS/ESA/XA, Parallel Sysplex, TOS/ISPF, JCL, SQL, COBOL, Assembler, REXX, BMC, CA, NEON & IBM database UTILITIES, SYNCSORT, EAYSTRIEVE, STROBE, SMP/E, MAINVIEW, CICS, TELON, FILEAID, XPEDITER, ENDEVOR, MQ Series, PANVALET, LIBRARIAN, MS tools
PROFESSIONAL EXPERIENCE:
Confidential
MS/DB2 DBA
Responsibilities:
- Maintained, supported and upgraded DBCTL for IMS to version 11
- Provided application support for developers and business users
- Administer, design and maintain IMS databases(HALDB, full function and fast path)
- Maintained DB2 on ZOS and LUW on Federation server
- Worked with ETL tool (Power Exchange from Informatica)
- Maintained 20 + IMS environments, provided on-call support.
Confidential
Database Management Specialist, Lead
Responsibilities:
- Converted full function logically related IMS databases to HALDB
- Maintained, supported and upgraded DBCTL and TM for IMS version 5 thru 11
- Discovered and helped IBM to resolve issues with implementation HALDB logical rules
- Designed and developed IMS/DB2 databases/tables
- Developed procedures to reorg, image copy, monitor and analyze IMS/DB2 objects
- Generated DBD/PSB/ACB for all IMS environments
- Bind new packages and collections for DB2 environments migrated DB2 objects to production environment using Platinum(CA Unicenter) migrated IMS objects(PSB, ACB, copybooks) thru Endevor. provided application support for developers and business users provided 24X7 on-call production support for both IMS and DB2 environments responsible for tuning and maintenance of IMS/DB2 databases to improve performance and space usage.
- Developed and maintained DR recovery procedures
- Wrote a few IMS database utilities to improve recovery and database refresh process in shared IMS environment with multiple subsystems
- Evaluated and advised upper management on third-party utilities from IBM, CA, NEON, BMC
- Provided for new IMS/DB2 DBA.
Confidential
Lead IMS/DB2 database administratorDatabase/system specialist
Responsibilities:
- In charge of the integration/conversion team supporting CICS/IMS/DB2 environments at various locations nationwide. Supported Phoenix Confidential data center (IMS & DB2 functions), prepared IMS/DB2 databases for consolidation with the Confidential corporate data center.
- Supported large IMS/DB2 production and test environment.
- Converted MSDB to DEDB with VSO option
- Performed tuning and maintenance IMS fastpath and full function databases.
Confidential
IMS DBA, senior
Responsibilities:
- Supported IMS database environments for large domestic and international banking clients.
- Responsible for production support (24X7) and maintenance of IMS Fast Path(DEDB) databases
- Responsible for tuning and performance IMS databases
- Performed DBD/PSB/ACB gens in support of applications group.
- Successfully completed several conversion projects into TS2 platform
- Developed DR procedure for complex shared IMS environments and participated in DR drills.