Job Description

This is a 6 month contract in New York City (10007)
3 days/week onsite, 2 days/week remote.
Candidates must already live in the NYC area.
US Citizenship or a Green Card is required

MANDATORY SKILLS/EXPERIENCE
Note: Candidates who do not have the mandatory skills will not be considered
• Minimum of 5 years of hands-on experience transitioning legacy systems into new technology
• Full software lifecycle experience from requirements through implementation and production support
• Minimum of 5 years of hands-on with SQL server
• Demonstrate technical understanding of data and technical database design.

DESIRABLE SKILLS/EXPERIENCE:
• Experience in performance tuning, query optimization, and other performance and troubleshooting tools.
• Experience in system and data mapping and conversion preferred.
• Any experience with COBOL, SAS, REXX, or .NET may be helpful.
• Experience using project SharePoint and/or MS OneDrive site for project artifacts.
• DevOps/JIRA experience is preferred.

Job Description:

Senior System Administrator for Mainframe Application Support The Legacy system Administrator runs system processes, maintenance, integrations, and data imports and outputs in the Integrated Property Information System (IPIS). The system Administrator ensures that the system is functioning well and keeps the system running to allow the Real Estate Services (RES) users to:

• Generate monthly statements for our tenants
• Import and track payment information
• Maintain lease information up to date
• Tracking property acquisitions and dispositions
• Run reports to manage lease expirations and options
• Maintain and run Charter Space Use information
• Track Mortgage payments
• Manage tenant lease applications
• Manage and track enforcements
• Generate reports
• Track Charter Space Use

SCOPE OF SERVICES
Under the IT leadership, the Sr. System Administrator will be responsible for the maintenance of the current IPIS mainframe systems, support the management of data and processes to ensure system is operational for all users, Support the extracting of data as text files from mainframe applications using various programs, Conduct data transport from Mainframe to Windows server text files using UC4 file transfer, and Load data into CRM/Dynamics 365 from SQL servers, troubleshoot any system feature issues, and processes to ensure ongoing system operation. Candidate is to also support the transition from mainframe legacy system to new acres system by collaborating with internal resources, consultants and business users to ensure a smooth transition into new system. Candidate will participate in system analysis, system design, and requirements sessions as needed.

TASKS
Under the IT leadership, the Sr. System Administrator will be responsible for managing the maintenance of the current IPIS mainframe legacy systems to ensure Candidate will be responsible for the following:

 

• Provide system maintenance and administration for current IPIS mainframe applications.
• Support the development of new features and transitioning into new systems.
• Support the extracting of data as text files from mainframe applications using the following:

1. ADABAS- IPIS, Natural- IPIS, CICS- TAS, MAS, COBOL- TAS, MAS, VSAM and flat files
2. IBM utilities (IDCAMS, SORT, File Manager) -to see what is in the files.
3. JCL- to run the programs, compile programs to extract MAS data.
4. TSO- mainframe development environment- program in here.

• Conduct data transport from Mainframe to Windows server text files using UC4 file transfer
• Load data into CRM/Dynamics 365 from SQL servers.

1. SQL server
2. SQL server management studio
3. SQL queries
4. SQL server integration services
5. Kingsway soft data tools – can be quickly learned by a developer knowledgeable in integration services
6. Microsoft Visual Studio integration services projects
7. Microsoft Azure/Git
8. CRM/dynamics 365

• Troubleshoot any system feature issues, and processes to ensure ongoing system operation.
• 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.

Job Tags

Contract work, Remote job, 2 days per week, 3 days per week,

Similar Jobs