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

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

Location:  Rensselaer, NY

Duration: 24 Months 

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

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

Candidates should have at least 60 months experience, and following should apply:

Experience developing .net web applications

Experience developing applications utilizing .Net 2.0 or above.

Experience writing and developing Web Services or WCF.

Experience developing N-Tier applications.

Experience developing applications utilizing CSLA.

Experience with PL/SQL writing packages, stored procedures and triggers.

Experience with Team Foundation Server.

Experience utilizing Infragistics or similar control library.

Experience design & deployment of complex SQL objects and relational databases design.

Bachelor’s Degree. Proof of education is to be submitted with all responses.

Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects

3 references are must with the resume.

Please note that our client does allow Skype/remote interviews.  However they reserve the right to require an in-person interview.

Contact mvkramarao@mitresource.com or Ph # 203-567-0129 for further information.