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.