New York State Civil Service Project Assistant, Ref. #18637 in Albany, New York

Minimum Qualifications

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%

Workweek: Mon-Fri

Hours Per Week: 37.5

From: 9 AM

To: 5 PM

Flextime allowed?: No

Mandatory overtime?: No

Compressed workweek allowed?: No

Telecommuting allowed?: No

County: Albany

City: Albany

State: NY

Zip Code: 12220

Name: Ann-Marie Frank

Telephone: 518-473-0398

Fax: 518-402-4924

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