Previous Job
Technical Architect Expert High
Ref No.: 17-00805
Location: Albany, New York
Start Date: 06/29/2017

Is this a Project or Program specific request (e.g., Connections, SFS)?
If yes, please list the Project or Program Name:
SSP Application
Please provide a short description of the project:
    The New York State (NYS) Office of Temporary and Disability Assistance (OTDA) Center for Employment and Economic Supports (CEES) took responsibility for administration of New York's Supplemental Security Income (SSI) State Supplement Program (SSP) from the Federal Social Security Administration (SSA) in October 2014.  Bringing the administration of the program in-house to OTDA yields a cost savings to NYS of approximately $90 million annually.
The main source of Federal and NY State Supplement information is the Social Security Administration's State Data Exchange file (SDX).  Various versions of the file are received daily, monthly, quarterly, and yearly.  Currently, the State Supplement Program (SSP) receives the file, processes SSP-related information found in the file, and at the end of the day builds a new version of the file, containing both SSP and SDX data, and delivers it to the Welfare Management Solution (WMS) for further processing and delivery to other agencies that require the information. By creating the OTDA Consolidated Data Exchange (CDX) as the third phase of the SSP project, Federal and State Supplement Information is brought into alignment with both OTDA business goals and ITS enterprise goals.  Moving forward SSP will have many technically complex changes needed within the core functionality of the application to begin utilizing the federal data from the CDX application.  Due to the nature of the application these changes require a high level of expertise to insure the program bares no negative impact.    
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
Work with the SSP team on pre-conversion activities to get SSP ready to use CDX in place of SDX
Designs, modifies, develops, writes and implements database design and SQL coding for applications following established architecture standards as well as software development and project management methodologies.
Writes and improves PL/SQL code for applications to adhere to designs supporting business requirements and customers.
Perform code reviews and mentoring of development teams.
Lead troubleshooting abilities in multi-tier enterprise environment as issues are reported.
Start new application projects from scratch or fix / debug / update existing projects to complete enhancements from change requests and correct identified defects.
Collaborates with the business product owners, business analysts, application developers, and testers to refine the requirements and specifications.
Lead the work process using an Agile Methodology for development activities.
Create automated unit tests for both existing code and new projects.
Work with ITS database & EIM teams
Which Service Group is required?
What is the number of staff being requested?
(maximum of 5)
Which Job Title Category is required?
Technical Architect
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)
How long is the engagement? (in months)
When is the estimated completion date?
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):
M-F, flexible between 7:30a and 5:30p
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
40 North Pearl Street Albany, NY
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)
Microsoft Visual Studio(.Net), Oracle, Client mainframe
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)
Microsoft Shop/Unit
Position Mandatory Qualifications
 - Technical expert centered around a technology, technologies or a portfolio of applications
- Designing and implementing Information Technology solutions
Requested Qualifications 
84+ months Oracle SQL programming and database design experience showing increasing level of responsibility and technical ability in job duties over time.
84+ months experience building service based software solutions
84+ months experience with OOD, design patterns, software architecture, systems integration concepts and frameworks.
84+ months experience with oracle programming including performance tuning activities, and data load batch processing
84+ months experience with Production level debugging and troubleshooting skills
60+ months experience with at least 2 of the following: ETL, validation, Data warehousing, Data marts experience, master data management
60+ months experience with data analytics
84+ months experience with secure coding principles
84+ months experience with .net (VB or C#)
Bachelors degree
Additional Information Requests:
Are there additional security requirements for the Authorized User?
Will additional training possibly be required during the Engagement?
If Yes, provide description of anticipated training.
What type, or manner, of Knowledge Transfer is requested during the engagement?
By working with state staff on a day to day basis, vendor is expected to provide guidance and mentoring to raise skill level of state staff. They will provide documentation as requested.
Is travel anticipated during the Engagement?
If Yes, please list anticipated frequency and locations for travel: