Previous Job
Programmer Expert High
Ref No.: 18-00671
Location: Albany, New York
Start Date: 06/20/2018
 Agency: Department of Health

Is this a Project or Program specific request (e.g., Connections, SFS)? Yes
If yes, please list the Project or Program Name: Congenital Malformation Registry Application

Please provide a short description of the project: The Congenital Malformations Registry is an archive for case reports of children born or residing in New York State diagnosed before the age of two with any structural, functional or biochemical abnormality determined genetically or induced during gestation and not due to birthing events.  This position will redesign the existing application to  meet new business requirements through coding and will perform maintenance functions.  

Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
1. Design & Develop Java web applications for Oracle WebLogic Servers.
2. Providing Maintenance & Support for live applications & services.
3. Application Server Tasks: Deploying Applications & Web Services, Creating Data Sources etc.
4. Develop object relational mapping using Hibernate frameworks to access back-end Oracle databases.
5. Develop Oracle WebLogic applications using Java Server Faces, HTML5, JavaScript libraries and template frameworks.
6. Designing and developing Oracle database objects such as tables, triggers, and stored procedures for the applications.  Write PL/SQL against Oracle RAC for use by web applications.
7. Communicating with Users & Stake Holders.  Communicate with Business Analysts to acquire and understand requirements.
8. Documentation: Preparing various documents like User Documents, Process Flow Diagrams and Database Schema Diagrams.
9. Performs Black Box testing of web applications developed by other staff members. 
10. Design, develop and call SOAP and REST web services as needed.
11. Lead joint application design sessions with other staff members.   

Which Service Group is required?
What is the number of staff being requested? 
(maximum of 5) 1
Which Job Title Category is required? 
Which Skill Level is required? 
Which Skill Demand is required? 
How many Candidate Response Forms are being requested per Contractor per position?     (1 or 2) 1
When is the Target Start Date?
(30 Business Days minimum from date of request) August 2, 2018
How long is the engagement? (in months) 12 months
When is the estimated completion date? August 1, 2019
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)? Full Time
If  Part-Time, enter approximate number of hours per week:
What are the daily work hours? (note if negotiable or list preferred start and end time): Negotiable, 8 hour paid work day.  Lunch is unpaid.
Where is the Home Base Region? 
Region 1
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP 800 North Pearl, Menands, NY or Empire State Plaza, Albany NY
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”) Agency is an Oracle/WebLogic shop
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”) Agency is a mixed use shop.

Position Mandatory Qualifications
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 Level:  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

Requested Qualifications 
84 Months hands-on experience in application development using modern JavaScript frameworks such as Angular.
84 Months hands-on experience using SPRING or a similar Java development framework.  
48 months hands-on experience using Hibernate, myBATIS or other Object Relational Mapping framework.
60 Months hands-on experience in programming Oracle WebLogic Java applications from specifications expressed by use cases, class diagrams, interaction diagrams and sequence diagrams.
60 Months hands-on experience coding web applications with web technologies in a Java/JEE environment, including experience in Servlets, JSP, HTTP, HTML, XML, XSLT, SQL, JQuery and PL/SQL on a WebLogic Application Server.
36 Months experience in a government information technology development environment
60 Months hands-on experience in developing Oracle database schemas, tables, procedures and permissions.
36 months hands-on development of Web services in both SOAP based and RestFul based implementations.

Additional Information Requests:
Are there additional security requirements for the Authorized User? Yes.  Authorized user must sign confidentiality forms.  May be subject to fingerprinting.
Will additional training possibly be required during the Engagement? Yes
If Yes, provide description of anticipated training. Confidentiality and IRB training are required, as are routine workplace required trainings such as Workplace Violence Prevention, Security Awareness, and Preventing Sexual Harassment.
What type, or manner, of Knowledge Transfer is requested during the engagement? a. Conducting technical training sessions.
b. Conducting one-on-one technical training.
c. Developing programming guidelines / standards.
d. Developing coding examples and distributing them to co-workers.
e. Conducting code review and critique.
Is travel anticipated during the Engagement? No