Database Administrator

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. 

CANDIDATE MUST MEET ALL LISTED QUALIFICATIONS BELOW AND BE DOCUMENTED IN 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 or in a Technical/Business Discipline is required