Mainframe Developer & Support

Title: Mainframe Developer & Support

Location: New York NY 10007

Duration: Long Term

Client: City of NY

35hrs per week

Mainframe System Maintenance & Administration:

Maintain and administer current IPIS mainframe applications.

Support the development of new features and transition into new systems.

Data Extraction from Mainframe Applications:

Extract data as text files using:

o ADABAS (IPIS) Natural (IPIS) CICS (TAS MAS) COBOL (TAS MAS) VSAM and flat files.

o IBM utilities (IDCAMS SORT File Manager) to review file contents.

o JCL to run programs and compile programs for MAS data extraction.

o TSO mainframe development environment for programming. Data Transport & Loading:

Conduct data transport from mainframe to Windows server text files using UC4 file transfer.

Load data into CRM/Dynamics 365 from SQL servers utilizing:

o SQL Server and SQL Server Management Studio o SQL queries

o SQL Server Integration Services (SSIS)

o KingswaySoft data tools (quickly learnable by developers familiar with SSIS)

o Microsoft Visual Studio Integration Services projects o Microsoft Azure / Git

o CRM/Dynamics 365

Data Archive Solution

Support the development of a data archive solution through data analysis migration testing and migration support.

System Support & Troubleshooting:

Troubleshoot any system feature issues and ensure ongoing system operation.

System Analysis & Design:

Participate in system analysis system design and requirements sessions as needed.

Demonstrate technical understanding of data and technical database design for system development and solutioning. Project Transition & Collaboration:

Support the transition from the mainframe legacy system to the new ACRES system by collaborating with internal resources consultants and business users to ensure a smooth transition.