Key Responsibilities:
- The target systems are PMS and PPMS, the City's payroll and pension payroll applications.
- Ensure that all installation, configuration, and tuning of DB2 databases are completed efficiently
- Author and validate procedures for all database processes
- Identify potential issues and deliver modifications / updates for DB2 programs
- Communicate with and deliver to Tech Support all elements to be migrated with specific instructions to be performed during the production migration
- Assisting the Systems areas with tool upgrades and participating in Disaster Recovery drills.
Mandatory Qualifications: CANDIDATES MUST MEET ALL THINGS LISTED BELOW and BE DOCUMENTED IN THE RESUME.
- Experience with IBM IMS V12 database management or higher.
- Ability to perform all database admin duties (backup/recovery, reorgs, DB trouble shooting).
- Experience with CICS transaction server.
- Ability to author REXX scripts.
- Ability to troubleshoot assembler code.
- Ability to troubleshoot issues with DB2 embedded within COBOL programs
- Ability to design solutions using Oracle Transparent Gateway
- Ability to design, develop and implement BMC BPPM Monitoring software solution
- Experience installing and troubleshooting IBM Tivoli LDAP server product running on AIX.
- Candidate must have demonstrated experience working with application teams to build and maintain data propagation solutions - using "IBM lnfoSphere Replication Server". Ability to install and manage DB2 on AIX platforms.
- Deep experience supporting large scale, enterprise wide, financial and payroll applications built on the framework of off-the-shelf 3rd party solutions.
Education:
- Bachelors or Master's Degree in Computer Science