Position : Mainframe DB2 Database Administrator

Position : Mainframe DB2 Database Administrator/ IBM IMS DB2 Systems Programmer

Location: 5 Manhattan West, New York, NY (Hybrid) need near by location candidate

Visa: H1B/USC

Duration: 6+ Months

Position: Contract/W2

Job Details:

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.

Required Skills:
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.