Previous Job
Programmer Expert High
Ref No.: 17-00817
Location: Menands, New York
Start Date: 06/28/2017
Department of  Mental Health

Is this a Project or Program specific request (e.g., Connections, SFS)?
If yes, please list the Project or Program Name:
HIE – Health Information Exchange
Please provide a short description of the project:
The OMH HIE  Funding will address the creation of ADT Admit, Discharge, and Demographics Change messages as well as other non-ADT events from the MHARS system in real time to the Healthix RHIO by expanding transport mechanism to include support for UPHN Full Node  and Direct.
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
1. Develop and implement strategies that optimize efficiency and data quality at the Database level.
2. Develop and implement ways to efficiently distribute the data.
3. Designing and developing Oracle database objects such as tables, triggers, and stored procedures for the applications.
4. Documentation: Preparing various documents like User Documents, Process Flow Diagrams and Database Schema Diagrams
5. Attend and occasionally lead joint application design sessions with other staff members.
6. Assist in Data exchange between various systems.
Which Service Group is required?
What is the number of staff being requested?
(maximum of 5)
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)
When is the Target Start Date?
(30 Business Days minimum from date of request)
July 27, 2017
How long is the engagement? (in months)
When is the estimated completion date?
July 26, 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):
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 12204
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)
Agency is an SAS/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 – 84+ Months Experience -
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 developing Oracle database schemas, tables, procedures and permissions, along with developing complex SQL queries.
84 months hands-on experience in creating both SOAP and/or REST Services.
84 Months hands-on experience in programming Java applications from specifications expressed by use cases, class diagrams, interaction diagrams and sequence diagrams. 
24 months of the experience in Java applications from specifications expressed by use cases, class diagrams, interaction diagrams and sequence diagrams must be with Oracle WebLogic
84 months hands-on experience performing data analysis.
48 months experience using JavaScript or other scripting languages and an understanding of CSS and Responsive displays
60 Months hands-on experience using Hibernate, myBATIS or other Object Relational Mapping framework.
36 Months hands-on experience in WebLogic Remote Portal (WSRP) application development using WebLogic Portal Framework.
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?
If Yes, provide description of anticipated training.
Confidentiality training required, as are routine workplace-required training courses, such as Workplace Violence Prevention, Security Awareness, and Preventing Sexual Harassment.
What type, or manner, of Knowledge Transfer is requested during the engagement?
Conducting technical training sessions.
Conducting one-on-one technical training.
Developing programming guidelines / standards.
Developing coding examples and distributing them to co-workers.
Conducting code review and critique.
Is travel anticipated during the Engagement?
If Yes, please list anticipated frequency and locations for travel: