What are the responsibilities and job description for the Sr. System Administrator position at Crescens Inc.?
Job title: Sr. System Administrator
Location: New York, NY (Hybrid)
Duration: 12 Months
NOTES:
Normal business hours Monday-Friday 35 hours/week (not including mandatory unpaid meal break after 6 hours of work).
Days/hours of the week will change if after hour/weekend work is scheduled for the upgrade and deployment. (Weekly hours will be adjusted accordingly)
Job Description:
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.
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:
o ADABAS- IPIS, Natural- IPIS, CICS- TAS, MAS, COBOL- TAS, MAS, VSAM and flat files-
o IBM utilities (IDCAMS, SORT, File Manager) -to see what is in the files.
o JCL- to run the programs, compile programs to extract MAS data.
o 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.
o SQL server
o SQL server management studio
o SQL queries
o SQL server integration services
o Kingsway soft data tools – can be quickly learned by a developer knowledgeable in
integration services
o Microsoft Visual Studio integration services projects
o Microsoft Azure/Git
o 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.
Required Experience:
• 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.
Location: New York, NY (Hybrid)
Duration: 12 Months
NOTES:
Normal business hours Monday-Friday 35 hours/week (not including mandatory unpaid meal break after 6 hours of work).
Days/hours of the week will change if after hour/weekend work is scheduled for the upgrade and deployment. (Weekly hours will be adjusted accordingly)
Job Description:
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.
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:
o ADABAS- IPIS, Natural- IPIS, CICS- TAS, MAS, COBOL- TAS, MAS, VSAM and flat files-
o IBM utilities (IDCAMS, SORT, File Manager) -to see what is in the files.
o JCL- to run the programs, compile programs to extract MAS data.
o 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.
o SQL server
o SQL server management studio
o SQL queries
o SQL server integration services
o Kingsway soft data tools – can be quickly learned by a developer knowledgeable in
integration services
o Microsoft Visual Studio integration services projects
o Microsoft Azure/Git
o 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.
Required Experience:
• 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.
Salary : $94,100 - $127,500
