Job Description :
PowerBuilder COM PL/SQL Developer
Troy, NY
Duration: 24 Months
Job Description:
The Child Care Facility System (CCFS) will continue to meet the needs of the Division of Child Care Services (DCCS) throughout 2017, 2018 and 2019. The Division seems to be moving in some new directions due to changing priorities as well as the dictates of changing statutory and regulatory requirements.
1. Modifications and new features within CCFS to support the new CCDBG regulations. Some of the anticipated areas affected are serious injury reporting, background checks, safety assessments, and inspections for Legally Exempt programs.
2. Changes within CCFS to support integration with the Child Care Provider Online Process project.
3. Potentially will be developing an integrated public child care web search incorporating both CCFS facilities and NYC Group Day Care programs
4. Development of an Enforcement component of the system
5. Development of a Pre-K indicator and potentially a web service with NYS DOE
6. Redesigning the renewal training component of CCFS, including the creation of a web service to interface with the Aspire system operated by CUNY.
7. Continuing the re-write of the application into .Net from PowerBuilder. This effort has been ongoing, but is a multi-phased project that is expected to span multiple fiscal years. The current projected completion date is 2020.
8. The Legally Exempt portion of CCFS will need to undergo rather extensive enhancements, to accommodate issues identified from user experience and Federal mandates coming to bear on the NYS subsidy program.
This position is for a 24 month period and will provide OCFS-IT support with skilled resource needed as well as follow the structure and standards to ensure better quality of service to the user community. Due to the ever changing Legal Mandates the system continues to require enhancements and updates.
Duties include but are not limited to:
1. Work in coordination with a team of developers to expand the current system.
2. Work with Business Analyst on analysis and logical design.
3. Perform unit testing and correct all identified bugs.
4. Perform complex PowerBuilder coding.
5. Assist with responding to Day Care data requests.
6. The individual in this position will work under the direction of a Technical Lead & Project Manager.
7. Convert reports using Aspose.
8. Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL
Candidates should have at least 84 months experience and a majority of the following should apply:
Each candidate should fill out the months of experience they have for each item in the table:
1. 84 months experience using PowerBuilder 8.0 or higher. 7.5 10
2. 84 months experience developing large complex 3 tier distributed client-server applications. 7.5 10
3. 72 months experience utilizing COM/COM+ 7.5 10
4. 84 months experience developing N-Tier applications. 7.5 10
5. 48 months experience designing and implementing Vs.Net solutions utilizing web services and XML. 7.5 10
6. 72 months experience with PL/SQL writing packages, stored procedures and triggers. 7.5 10
7. 36 months experience with Team Foundation Server. 7.5 10
8. 48 months experience design & deployment of complex SQL objects and relational databases design. 3.75 5
9. Bachelor Degree. 3.75 5