Systems Programmer Resume Profile
3.00/5 (Submit Your Rating)
Experience: 30 years experience as System Programmer, DB Administrator, and Applications Developer.
- My responsibilities have included software installation, performance tuning, Disaster
- recovery, data modeling, data reorganization/recovery, technical training / support,
- data conversions, On Call support, problem determination / resolution.
- My IMS responsibilities include performing DBD, PSB and ACB gens. Data Base logical and
- physical design. Registering data bases in DBRC, application programming process reviews
- prior to production promotion. Data base reorganization using BMC utilities. Data Base
- forward and back out recoveries using BMC utilities. Full and incremental image copies,
- change accum using BMC IMS utilities. Creating secondary and spares indices. Data base
- partitioning using BMC's PDF.
- My DB2 responsibilities include SQL performance tuning. Data base design and
- implementation. Conversion / implementation of UTS PBG/PBR table spaces, Developing
- stored procedures native and external , catalog and user table space reorgs, catalog and
- user tablespace recoveries. Image copies all using BMC DB2 utilities.
- Developing MQT's and Temporal tables. Developing Recovery procedures. Buffer pool
- assignment and tuning. Developing catalog queries using RTS for reorg triggers. Design and
- developing indices PSI, DPSI, NPSI . defining referential integrity and application staff
- training.
- Software: DB2 v10 and earlier, OMEGAMON, BMC DB2 utilities, IBM DB2 utilities, QMF, PARALLEL
- SYSPLEX, Data Studio, IMS v12 and earlier, DBCTRL, IMS DB/DC, DBRC, IBM Utilities, BMC
- IMS utilities, MAINVIEW, BMC Recovery Manager IMS , BMC AR Control IMS , NEON
- PDF, SMP/E, VSAM, OSAM, SQL, SMS, RMF, SMF, RACF, CICS, COBOL , and JCL.
Work History:
Confidential
Position: DB2 / IMS Technical Support Contractor
- Provide systems and applications support of billing systems. Maintain and support 10 IMS
- DBCTRL regions. Provide applications team support. DBRC set up and maintenance. BMC
- utilities used for reorgs, copies and recoveries. BMC Mainview used for system monitoring.
- Provide systems support for DB2 migration from v9 to v10. Provide technical support to system
- and application staff. Develop ad hoc SQL Queries. Provide performance analysis and
- tuning recommendations.
Confidential
Position: DB2 / IMS DBA / Systems Programmer
- Provide support to clients with the installation, performance tuning, recovery procedures,
- disaster recovery, data base design, training, application systems support, SQL reviews, and
- Data Base design.
Confidential
Position: IMS Systems Programmer
- Provide technical support of IMS DB/DC production and test regions. Provide support to
- IMS DBA staff.
Confidential
Position: IMS Systems Programmer
- Establish maintenance and recovery procedures, performance tuning, disaster recovery,
- Tool installation, maintenance application and DBA staff support.
