Work Hours: MondayFriday 35 hours/week (not including mandatory unpaid meal break after 6 hours of work).
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:
ADABAS IPIS Natural IPIS CICS TAS MAS COBOL TAS MAS VSAM and flat files
IBM utilities (IDCAMS SORT File Manager) to see what is in the files.
JCL to run the programs compile programs to extract MAS data.
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.
SQL server
SQL server management studio
SQL queries
SQL server integration services
Kingsway soft data tools can be quickly learned by a developer knowledgeable in integration services
Microsoft Visual Studio integration services projects
Microsoft Azure/Git
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.
Mandatory Skills/Experience:
Note: Candidates who do not have the mandatory skills will not be considered
Minimum of 5 years of handson experience transitioning legacy systems into new technology
Full software lifecycle experience from requirements through implementation and production support
Minimum of 5 years of handson 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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.