Net PL SQL Developer - Rensselaer, NY - 24 Months - # K18341/180745

The Division of Juvenile Justice and Opportunities for Youth (DJJOY) Juvenile Justice Information System (JJIS) is a web-based application using .Net technology. It tracks juvenile justice youth through detention facilities into OCFS placement where they go through Intake, Residential, and CMSO (community multi-service organizations) programs and services, and also provides an automated financial/billing module.

JJIS moved into Phase 4 development in April 2010. The first three phases included a full system re-write (deployed in July 2007) based on the legacy system developed in the 1970’s, plus many functional enhancements. Phase 4 is defined by the priority system enhancements required to support program improvements in DJJOY facilities as required by the federal Department of Justice (DOJ) settlement agreement, as well as many additional functionality enhancements to support case management and other operational processes throughout OCFS’ juvenile justice system.

Examples of priority work to be completed in JJIS Phase 4 include, but are not limited to: a comprehensive youth interventions/counseling module to include individual and group interventions, single working diagnosis, and psychotropic medications tracking support; Imaging; Unusual Incident Report (UIR) system re-write and integration; Treatment Team form automation; transitional planning support; additional restraint reporting from the Automated Restraint Tracking System (ARTS, which is integrated with JJIS); HIPAA compliance; and more.

Duties include but are not limited to:
1. Work in coordination with a team of developers to expand the current system.
2. Work with Business Analyst on analysis and logical design.
3. Perform unit testing and correct all identified bugs.
4. Perform complex VB.Net coding in a CSLA environment.
5. Assist with responding to Juvenile Justice data requests.
6. The individual in this position will work under the direction of a Technical Lead/Project Manager.
7. Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL