SoftwareDeveloper_Expert (15051)

Provide a short description of the Position:
ITS requires an Expert-level Software Developer to serve as lead developer for NYS Homes and Community Renewal's (HCR) portfolio of mission-critical PowerBuilder applications following the unexpected loss of the agency's lead and only PowerBuilder developer. The selected candidate will develop, enhance, and support these applications, which are built on the PowerBuilder Foundation Classes (PFC) framework with an Oracle database, until they are replaced through the agency's modernization efforts. No in house PowerBuilder expertise remains, so the candidate must be able to work independently in a large, mature codebase with minimal onboarding and without disrupting production operations.

Provide a list of the day to day tasks to be performed by the Selected Candidate:

1. Serve as lead developer for HCR's PowerBuilder applications, responsible for their day-to-day development, maintenance, and support.
2. Design, develop, test, and implement enhancements and fixes to large, mature PowerBuilder applications built on the PowerBuilder Foundation Classes (PFC), including PFC ancestor objects and services, DataWindows, and PowerScript.
3. Develop and maintain the Oracle database components that support these applications, including PL/SQL stored procedures, packages, and triggers, and the PowerBuilder code that calls them.
4. Diagnose and resolve production issues across the application and database layers; serve as the primary escalation point for PowerBuilder application problems.
5. Analyze business processes and requirements with HCR program staff and translate them into application changes.
6. Document the applications, including code structure, business rules, and build and deployment procedures.
7. Support modernization efforts by providing knowledge of the existing applications' business rules, data, and integrations to modernization teams, and keep production systems stable through the transition.
8. Transfer knowledge to designated State staff throughout the engagement.

Position Mandatory Qualification (Per Attachment 7, Section 1.2.4)
Position Job Title: (Per Attachment 4) Software Developer
Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software. Pass/Fail

OGS HBITS Determination
Award 23158
Position Skill Level: (Per Attachment 4) Expert
84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Position Requested Qualifications (Per Attachment 7, Section 1.2.5)

1. 84 months practical, real-world application of the PowerBuilder Integrated Development Environment (IDE) and its associated technologies to design, build, maintain, and modernize enterprise level applications, using PowerBuilder, PowerScript, and PowerBuilder DataWindow technology.
2. 84 months of experience developing and maintaining PowerBuilder applications built on the PowerBuilder Foundation Classes (PFC) framework, including extending and customizing PFC ancestor objects and services.
3. 84 months of experience developing PowerBuilder applications that use an Oracle database, including writing Oracle Procedural Language/Structured Query Language (PL/SQL) stored procedures and packages and calling them from PowerBuilder.
4. 12 months of PowerBuilder development experience within the last 36 months.
5. 84 months of experience as the lead or primary developer responsible for production support of PowerBuilder applications, including diagnosing and resolving production issues across the application and database layers.

Additional Information Requests:
Are there additional security requirements for the Authorized User? Yes

If YES, include the additional security requirements:
Mandatory ITS Security Agreements and Fingerprint-based Background Check.

Will additional training potentially be required during the Engagement? Yes
If YES, provide description of anticipated training: State mandated trainings

What type and/or manner, of knowledge transfer is requested during the Engagement?
The consultant will document the architecture, design, code structure, configuration, and build and deployment procedures for each application supported, and keep that documentation current throughout the engagement. The consultant will provide walkthroughs, paired work sessions, and training so that designated State staff can support, troubleshoot, enhance, and deploy the applications without consultant assistance by the end of the engagement.

Is travel anticipated during the Engagement? No