Job Description :
Duration of engagement: 24 months
Location: Albany, NY
Incumbent position
Daily Tasks will include but not limited to the following:
1. Prepare database scripts for the purpose of creating new Oracle tables, modifying the structure of existing tables, creating indexes, constraints, triggers, etc
2. Create Oracle stored procedures and packages.
3. Use Microsoft Visual Studio 2012 and write code using C# .NET, Java, Ajax, HTML, XML, WCF, Angular JS, MVC and web API.
4. Use Team Foundation Server as a repository for the source code, for checking code in and out, branching off new versions of the source code, and for tracking project work items.
5. Use Crystal Reports version 13 to create new and enhance existing reports.
6. Prepare change requests with detailed instructions, and, using Client ServiceCenter software, schedule the deployment of new versions of the application to the Development, QA and Production platforms, and work with Database and Server Administration groups to facilitate these deployments.
7. Use agile development practices, attend scrum meetings, sprint planning and review meetings; Code the desired functionality, based on "user stories”, into the application.
8. Perform a large amount of testing of the application, especially after new versions are deployed.

Programmer: OMH Forensic Tracking System (FORTS) project
Analysis, design, coding, component and assembly testing of all application code owned by the Application Team
Maintenance (including production support), enhancement and development work
Write application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions
Expert 84+ Months
Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field.

1. 84 Months Demonstrated experience with Oracle: PL SQL coding, stored procedures, packages, indexes, triggers, creating tables etc.
2. 84 Months Demonstrated experience programming web based applications in C# .NET.
3. 84 Months Designing Crystal Reports and invoking them from web based applications.
4. 84 Months Demonstrated experience with Ajax/Java Script/Cascading Style Sheets/HTML/XML.
5. 48 Months Demonstrated experience with Team Foundation Server, using source code management, including branching, plus work items functionality.
6. 36 Months Demonstrated experience developing web services using Windows Communication Foundation (WCF
7. 36 Months Demonstrated experience working with data covered under HIPAA regulations
8. 36 Months Demonstrated experience developing/maintaining/supporting a criminal tracking system that uses Criminal Procedure Law and tracks events and legal statuses of people housed in a restricted facility.
9. 24 Months Demonstrated experience designing security protocols using LDAP with ASP.NET applications to protect patient health information for State or Local Agencies.
10. 12 Months Demonstrated experience working with modern JavaScript frameworks including both Angular JS and jQuery to build user interfaces for web based applications.