PowerBuilder Technical Lead-Location:Saskatchewan, Canada

Job Overview

Job Description

PowerBuilder Technical Lead Multiple Openings
Location: Onsite in Regina, Saskatchewan, Canada
Work Type: Part-time
Long Term Contract

The PowerBuilder platform is still key software used in the delivery support and enhancements of existing business applications for internal ministry programs and external programs to the citizens of
Saskatchewan. These applications will also connect to the new centralized Procurement, Financial and Human Resources GEM system for GOS that will be implemented over the next couple of years.
ITD supports 30+ PowerBuilder applications of varying complexity for performing specific Ministry program functions across GOS.

For this role, GOS defines lead as having worked independently, mentoring other team members, working with clients and vendors, as well as having had designed and supported PowerBuilder solutions in full, based on customer requirements and technical best practices. This role is responsible for leading the development and implementation of our ongoing projects in PowerBuilder such as Enterprise Business Modernization (EBMP) to enhance existing applications to connect to the system which will be the new centralized Procurement, Financial and Human Resource system for GOS called Government Enterprise Management (GEM).

The individual in this position will also provide guidance to ITD staff and support the enhancements of GOS ministry-driven changes and releases of the PowerBuilder software platform hosted by our datacenter partner, Kyndryl. There are 30+ applications on ITD’s PowerBuilder platform that are key to the daily operational of ministries, delivering internal and external services to citizens of Saskatchewan. The individual in this position will also assist in sustaining and improving the current PowerBuilder applications working closely with ITD staff.

Additionally, this position requires offering specialized guidance on the governance and enhancement of the PowerBuilder platform for the technical analysis, planning and successful implementation of software upgrades which demands extensive understanding of both the PowerBuilder and Oracle/SQL database technologies.

The successful candidate will be responsible for, but not limited to, the following duties:

A.1 Solution Design and Implementation:
• Collaborate with cross-functional ITD teams and ministry business stakeholders to gather requirements and design innovative solutions using the PowerBuilder Platform.
• Design solutions, customize and configure platforms to align with business needs, including creating workflows, forms, dashboards, and reports.
• Assist in developing custom solutions in other ITD technologies leveraging .NET, Azure Cloud and Functions, Git, HTML, Java, .Net, MySQL PL/SQL, Web Services, DevOps etc.
• Migrate data from other database sources such as SQL Server or Oracle.
• Develop application specific reporting using Power BI and other Enterprise reporting tools.

A.2 Technical Leadership:
• Lead all technical aspects of projects related to the implementation and enhancement of PowerBuilder Platform solutions.
• Ensure projects are delivered on time, according to agreed upon requirements and technical specifications, while meeting quality standards.
• Provide and implement recommendations to ensure overall PowerBuilder platform stability, maturity and ongoing improvement.
• Recommend, design and build tools and utilities to manage the PowerBuilder platform.

A.3 Platform Administration and Support:
• Manage user access, permissions, and security settings for PowerBuilder Platform.
• Perform routine maintenance, updates, and troubleshooting technical issues to ensure optimal platform performance.
• Offer responsive support and guidance to resolve user queries and technical challenges.
• Continuously refine and enhance existing solutions to increase efficiency and productivity.
• Engage with external vendors and Appeon Power Builder support as necessary to resolve complex technical issues or obtain guidance on best practices.
• Leading application releases and refining releases of technical processes, typically leveraging Azure DevOps pipelines.

A.4 Integration
• Integrate PowerBuilder Platform with other enterprise systems to ensure seamless data exchange.
• Design and build data flows, transformations, and integrations to enhance data accuracy and availability.