Lead Z/os Db2 Dba Resume
Omaha, NE
PROFILE:
Lead Database Administrator (DBA) 7 years, software design, development, testing and maintenance and ongoing support with 25 years of continuous work history. Demonstrated expertise using background knowledge and utilizing the current resources to analyze and solve complex application problems. Through application programming, developed programs and subsystems that are maintained easily and run efficiently using performance coding techniques which not only fulfills all the functions required, but does it with the best utilization of resources.
TECHNICAL SKILLS:
Languages: COBOL, BASIC, VISUAL BASIC, C++, SQL, JCL, ASSEMBLER, JavaScript, XML.
Operating systems: MVS, UNIX, Windows, DOS
Tools: IBM Admin Tool, Query Monitor, Data Studio, Log Analyzer, Omegamon, Ascential/IBM DataStage 7.5.2, QualitiyStage 7.5, PUTTY, WINSCP, TSO/ISPF, SYNCSORT, DYL280, UDACS, JES2, CA7, IBM UTILITIES, DB2 UTILITIES, STROBE, ENDEVOR, FILEAID, ABENDAID, DUMPMASTER, INSYNC, VIASOFT, VISIO, MICROSOFT VISUAL STUDIO, Rational ClearCase and ClearQuest.
Databases: DB2, UDB, SYBASE, MYSQL, ACCESS
PROFESSIONAL EXPERIENCE:
Confidential, Omaha, NE
Lead z/OS DB2 DBA
Responsibilities:
- Assisted DBA team with migrating from DB2 v10 to DB2 v11 and then to DB2 V12.
- Provided technical leadership to development teams in migrating several mainframe applications from VSAM to DB2.
- Install, setup Change Data Capture
- Converted DB2 security control to RACF control
- Implemented real time statistics history for DB2 real time statistics.
- Designed and implemented Daily REORG, RUNSTATs, IMAGECOPIES, and MODIFY processes
- Maintained Bufferpool tuning. Analyzed, designed and implemented tables/indexes into sizing BPs to fit high getpage activity tables/indexes into memory.
- Implemented and ran Daily OMPE Accounting and Statistics reports
- Performed as an Application DBA and a System DBA.
- Daily performance monitoring of DB2 and applications using DB2.
Confidential, Omaha, NE
Senior Software Development Engineer
Responsibilities:
- Analyzed, designed and developed new and existing Financial and Billing programs for Cable, Internet and Telephony services.
- Software methodology UDM/AGILE
- COBOL, JCL, VSAM, MVS, TSO, STROBE, FILEAID, ABENDAID, CA7, SYNCSORT, SQL, ORACLE, DB2, Datastage, CDC, OMEGAMON, IBM DB2 TOOLs
Confidential, Omaha, NE
Senior Data Warehouse Developer
Responsibilities:
- Designed and developed OLAP and OLTP data marts, data warehouse and ETL applications for Actuarial, Marketing and Accounting departments.
- Responsible for the maintenance of the batch Vantage - One system.
- Proof of Concept for STROBE
- Software methodology AGILE / RUP
- COBOL, DB2, VSAM, JCL, MVS, DATASTAGE, UNIX/LINUX, SQL, UDB, TSO, STROBE, FILEAID, ABENDAID
Confidential, Omaha, NE
Senior Programmer and Analyst
Responsibilities:
- Analyzed, designed and developed new and existing Financial and Billing programs for credit card processing.
- Analyzed, designed and developed several client conversions.
- Designed and developed the Business Rules and ETL applications using advanced and complex COBOL DB2 and SQL coding techniques.
- Analyzed performance problems with new and existing software and then redeveloped the software to comply with performance standards.
- COBOL, DB2, VSAM, JCL, MVS, SQL, TSO STROBE FILEAID ABENDAID, ENDEAVOR
- COBOL and JCL instructor
Computer Operator
Confidential
Responsibilities:
- Responsible for nightly batch job runs and producing hard copy reports, student grade reports, accounting, and payroll.