Overview
Skills
Job Details
Job description
The DB2/IMS Systems Programmer is a senior-level systems programmer who provides software and operational support for all production and test/development DB2 and IMS mainframe database environments. This will involve installation, maintenance, configuration, and tuning of all DBMS and database-related software products. He/She works in a DB2 data-sharing environment supporting several production and test/development subsystems and tools.
The DB2/IMS Systems Programmer must possess the ability to communicate his/her knowledge effectively to application DBAs, management, and other technical teams (i.e. CICS, communications, security/RACF, MVS, storage), as well as be able to interface with vendors on software usage and problem analysis.
Desired Skills and Experience
Education:
- Bachelors degree or equivalent work experience
Experience:
- Minimum 10 years as mainframe Systems Programmer
- Minimum 5 years as a DB2 for z/OS Subsystem Administrator
- Minimum 5 years as an IMS Database Administrator
Knowledge:
- Strong z/OS experience from a systems programming perspective.
- Software installation/maintenance best practices using SMP/E.
- Ability to quick help diagnose technical issues and respond rapidly to vendor requests for supporting documentation/traces/dumps.
- In-depth understanding of access path selection and the DB2 optimizer.
Competencies/Skills:
- Strong written and oral communication skills
- Strong presentation skills
- DBD/PSB/ACB/database changes in an IMS/CICS DBCTL/DBRC environment.
- Must be flexible and able to work in a team environment or alone with same degree of integrity and professionalism throughout
- DB2 for z/OS v9/v10
- Buffer/EDM pool monitoring/tuning
- Data sharing, DDF, onsite recovery, business continuity planning
- DB2 subsystem and application performance analysis
- Performance monitoring, reporting, tuning – DB2PM and Tivoli Omegamon
- Experience with any of the following would be a plus:
- BAL
- Infosphere Replication Server (aka Data Propagator)
- DB2 for LUW
- DB2 Query Monitor
- BMC database tools – Catalog Mgr, Change Mgr, Log Master, Mainview
- Compuware File-Aid tools – DB2, IMS, RDX, DS