Previous Job
Programmer Expert High
Ref No.: 17-00804
Location: Albany, New York
Start Date: 06/29/2017
Agency:    Information Technology Services (ITS)

Is this a Project or Program specific request (e.g., Connections, SFS)?     No
If yes, please list the Project or Program Name:  
Please provide a short description of the project:    Staff augmentation to provide technical expertise for ColdFusion development and administration.

Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):    
Daily Tasks will include but not limited to the following:
Meet and work with end-users to assess their user needs and translate them into application requirements.
Develop application specifications and use specifications to architect, develop, test, document, maintain and provide technical support for agency ColdFusion applications.
Documentation of application business rules, implementations and dependencies.
Perform server upgrades / patches as needed and ensure security vulnerabilities are identified are addressed.
SQL-Server database administration / database design and development for backend support of ColdFusion applications.
Migrate existing MS-Access databases to ColdFusion and/or to another technology to be determined.
Which Service Group is required?
Service Group 1 - Standard Titles
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)    7/27/2017
How long is the engagement? (in months)    24
When is the estimated completion date?    7/26/2019
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)?    Full
If  Part-Time, enter approximate number of hours per week:    n/a
What are the daily work hours? (note if negotiable or list preferred start and end time):    9:00am – 5:30pm 
Where is the Home Base Region? 
Region 1 – Capital Area
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP    1450 Western Ave Albany, NY 12020
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)    Adobe ColdFusion with Dreamweaver IDE. SQL-Server database(s).
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)     Agency is Windows servers 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
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.    Pass/Fail

Requested Qualifications 
84 Months   Demonstrated experience ColdFusion administration / programming
84 Months   Demonstrated experience Microsoft IIS web server administration
84 Months  Demonstrated experience SQL-Server administration / database design & development
84 Months   Demonstrated experience SQL-Server development tool set including; Management Studio and Business Intelligence Development Studio (BIDS) for Integration Services (SSIS).
48 Months   Demonstrated experience working with end-users to assess business needs, translate needs into application requirements and use those requirement specifications to architect, develop and maintain ColdFusion applications.
48 Months  Demonstrated experience mentoring and training staff
84 Months experience coding ASP.NET / VB.NET 
Migration of MS-Access and ColdFusion to .NET technologies.
84 Months  experience using source code controller like VSS, CVS, GITHUB.
48 Months  experience coding Drupal / PHP
Bachelor's Degree in Computer Science

Additional Information Requests:
Are there additional security requirements for the Authorized User?    HIPAA and OASAS Confidentiality Agreement 
Will additional training possibly be required during the Engagement?     No
If Yes, provide description of anticipated training.    n/a
What type, or manner, of Knowledge Transfer is requested during the engagement?     During the term of this assignment, knowledge transfer from the consultant/project team to State employees will be mandated. The knowledge transfer will be a written plan. Details will be determined by the State Project Manager in collaboration with the selected contractor according to the specific program needs.
Is travel anticipated during the Engagement?    No