New York State Civil Service Project Assistant, Ref. #18637 in Albany, New York
Six years of experience as follows:
Leading the development and implementation of .NET applications which leverage the MVC Core framework using Oracle or SQL Server databases
Writing SQL code to create and maintain database packages, procedures, functions and triggers
Writing SQL and PL/SQL code to analyze data and execute scheduled data extract requests, especially requests involving large data sets which return 10 million or more rows of data
Developing, implementing and maintaining HL7, XML and other interfaces to send and receive data between systems as needed
The following degrees may substitute for the general experience as indicated:
Associate’s degree and five years of experience
Associate’s degree including 15 semester credit hours in computer science and four years of experience
Bachelor’s degree and four years of experience
Bachelor’s degree including 15 semester credit hours in computer science and three years of experience
Master’s degree in computer science or related field substitutes for an additional year of experience
Doctorate in computer science or related field substitutes for an additional 2 years of experience ## Duties Description Under the direction of a Manager of Information Technology Services 1, SG-27, within the Behavioral Health Portfolio/Business Solutions/Office of Mental Health Section, this project position will serve as an Application Development Specialist supporting the Mental Health Automated Record System (MHARS) Rewrite project. Duties include, but are not limited to, the following:
Leading the development and implementation of .NET applications which leverage the MVC Core framework using Oracle or SQL Server databases.
Writing SQL code to create and maintain database packages, procedures, functions and triggers.
Writing SQL and PL/SQL code to analyze data and execute scheduled data extract requests, especially requests involving large data sets which return 10 million or more rows of data.
Developing, implementing and maintaining HL7, XML and other interfaces to send and receive data between systems as needed.
Creating data conversion and migration load scripts as needed.
Completing unit testing.
Creating and/or providing input for infrastructure as well as application and database architecture design.
Creating technical documentation including architecture diagrams and code comments based on industry standards.
Actively adapting to changing technology needs and frameworks to best serve the technical and business needs of the organization.
Collaborating with business analysts to translate requirements into system designs which meet business objectives, adapting more efficient processes where possible.
Leveraging the Secure Software Development Life Cycle (SSDLC) for all activities.
Leveraging middleware solutions like BizTalk as a means of establishing and maintaining standard interfaces that send/receive data between systems.
Leveraging best practices, patterns and standards for development of new and existing systems.
Mentoring and training staff, enforce programming standards, and coordinate work assignments.
Performing peer code reviews for other application developers.
Creating accurate time estimates for the completion of technical documentation, programming, code reviews, unit test creation and execution tasks.
Mentoring junior developer staff in the creation of accurate estimates for application development tasks.
Mentoring junior developer staff in code writing techniques which leverage best practices, patterns and standards for development of new and existing systems.
Working with other support teams as needed to ensure application health including patching, monitoring and upgrades as appropriate.
Working with Release Management to create deployment packages for application upgrades.
Assisting in the coordination of application migrations.
Assisting with system integration, load and performance test planning and validation efforts.
Assisting in the completion of system integration tests and remediation of issues as needed.
Assisting with the creation and maintenance of functional documentation.
Debugging, troubleshooting and remediating application break/fix issues as needed.
Maintaining excellent written and oral communication.
Performing supervisory related tasks for state and/or contract staff. ## Additional Comments Selected candidates who are new or returning to NYS service may be required to pay for fingerprinting fees.
This position is pending DOB approval. ## Notes on Applying Please submit a clear, concise cover letter and resume indicating that you are applying for Project Assistant, Ref. #18637, and clearly describe how you qualify.
Mail to: Ann-Marie Frank NYS Office of Information Technology Services Human Resource Services Empire State Plaza PO Box 2062 Albany, NY 12220
Or email: HR.Recruitment@its.ny.gov
Date Posted: 12/06/18
Applications Due: 12/17/18
Vacancy ID: 62214
Agency: Information Technology Services, Office of
Title: Project Assistant, Ref. #18637
Occupational Category: I.T. Engineering, Sciences
Salary Grade: NS
Bargaining Unit: PS&T; - Professional, Scientific, and Technical (PEF)
Salary Range: From $0 to $102661 Annually
Employment Type: Full-Time
Appointment Type: Temporary
Jurisdictional Class: Competitive Class
Travel Percentage: 0%
Hours Per Week: 37.5
From: 9 AM
To: 5 PM
Flextime allowed?: No
Mandatory overtime?: No
Compressed workweek allowed?: No
Telecommuting allowed?: No
Zip Code: 12220
Name: Ann-Marie Frank
Email Address: HR.Recruitment@its.ny.gov
Street Address: 44 Holland Avenue
Street: NYS Office of Information Technology Services Empire State Plaza, PO Box 2062