Requirement Detail/Qualifications:

General Duties:
Gathers and analyses data for the conduct of studies to establish the technical and economic feasibility of proposed computer systems, and for the development of functional and system design specifications.
Designs methods and procedures for small computer systems, and sub-system of larger systems.
Develops, tests and implements small computer systems, and sub-systems of larger systems.
Produces forms, manuals, programs, data files, procedures, and training material.
Controls and evaluates systems testing as a member of a systems test team.
Write user, operations and training manuals.
Trains user and operations personnel.

Supervision:
Provides guidance and work leadership to programmers.

Background

Service New Brunswick (SNB) provides application support services to the Department of Transportation and Infrastructure (DTI).  DTI use over 80 custom business applications on a variety of platforms and technology stacks.

 

DTI are in the process of being onboarded to Oracle Fusion as part of an overall Government of New Brunswick ERP transformation project.  Several areas of DTI’s business are impacted by the ERP implementation and there is an ongoing project to adapt many existing applications to be fully interoperable with Fusion.  There are several applications that have been identified for requirements gathering, solution design and specification development.  This work is to be carried out by a project team that includes solution architects, developers, QA analysts, business SMEs etc.  This particular contract will involve modifying the Buildings Group System (SBGS) application to directly consume and report Oracle Fusion data from a valid source in its native format. Currently, existing integrations perform translation, conversion, and/or mapping to make Fusion data usable by the DTI applications.

 

The SBGS application supports the Design and Construction Branch of DTI in the planning, design and construction of all new government buildings, capital improvements to existing buildings and construction management and coordination of various other government projects.  SBGS also supports the Facilities Management branch in the management of building space leases, inventory of government owned buildings, management of a service provider directory and the management of government parking passes. 

 

SBGS is a VB.net based application which has been machine generated from a previous Gupta SQLWindows incarnation.  While the application is stable and mature, it is a large application supporting many lines of business.  SBGS is currently supported by an experienced Programmer Analyst who will be a lead resource to this initiative and backed up by a Senior Programmer Analyst who was key to the SQLWindows - VB.Net migration project. 

 

Deliverables

The successful candidate must deliver the following to successfully complete the engagement:

 

1. Problem identification and solution proposal: Analyze bug reports and/or change requests for modifications to existing functionality and propose solutions for fixes and/or updates to the support team.
2. Solution development: Code and deploy approved solutions to problems throughout the appropriate areas of the technology stack (ie. VB.net,  C#.net, Crystal Reports, Visual Studio, Database, triggers, PL/SQL).
3. Application development: Develop new applications or components of applications to meet functional specifications as requested.
4. Technical Documentation:  Provide or update documentation per unit standards (to be provided as needed) to support bug fixes and/or implemented changes.    
5. Participate in team scrums

 

Services Sought

Service New Brunswick (SNB) requires a single Programmer Analyst – Level 3.

 

The Programmer Analyst should have a strong development background in VB.Net or C# .Net and Crystal Reports with comprehensive knowledge of PL/SQL components such as database packages, procedures, triggers, and functions.  They should also have strong understanding of Oracle database structures, schemas, and query building.  Experience managing large projects/codebases in Visual Studio and coordinating updates to those projects among multiple developers with version control software is also be required.  Experience developing SSRS reports would be an asset.

 

The successful proponent will be expected to produce the deliverables described in Section 11.

SNB will only consider proposals identifying one candidate to fill the requested role.  If bidding multiple candidates, they MUST be submitted as separate proposals to be scored individually.

 

 

Mandatory Requirements

SNB seeks a resource who demonstrates the following Mandatory Requirements:

 

No.	Requirement	Required
M1	Years of IM/IT Experience	7 Years
M2	Experience as a Programmer Analyst, focused in the .Net stack	5 Years
M3	Spoken and written competence in English.	Yes

 

Proposals that do not clearly demonstrate the capability to meet these mandatory requirements will be disqualified from further consideration.

Vendors are requested to respond to this section in the Vendor Response Matrix.
 

Scored Requirements

SNB seeks resources who demonstrate the following scored requirements.

 

No.	Scored Requirement	Required Experience
S1	Experience in developing and maintaining VB .Net or C# .Net code	5 years
S2	Experience in developing and maintaining Crystal Reports	3 years
S3	Experience in interpreting and defining Oracle database table and field specifications for complex systems.	5 years
S4	Experience in reading and analyzing complex database schemas.	5 years
S5	Experience managing large projects/codebases in Visual Studio and coordinating updates to those projects among multiple developers with version control software	3 years
S6	Experience in Oracle PL/SQL including creation, maintenance and debugging of advanced packages, procedures, function and triggers	3 years
S7	Experience in developing and maintaining SSRS Reports	1 year
S8	Experience working with a distributed team across multiple disciplines (Business Analysts, DBAs, Developers, and end users).	3 years
S9	Experience requiring strong verbal and written communication skills, able to target communications to audience (e.g., technical, non-technical).	3 years
S10	Experience working in a team environment with a focus on support and maintenance demonstrating strong interpersonal skills.	3 years

 

Duration/Effort

The successful candidate will be required on a full-time basis for up to 135 (7.25 hour) days, commencing September 15th, 2025, and ending March 31, 2026.

SNB reserves the right to extend this engagement as needed for up to 24 months (480 days), in 6-to-12-month extensions.
 

Work Location and Travel

While remote work is acceptable, the successful candidate could be required onsite, as needed, for engagement with SNB and DTI at 440 King Street, Fredericton, NB or at Brookside Place, Suite 30.  SNB will provide office space with access to pertinent information and resources as required, for the duration of the engagement.  Remote work may be coordinated with the reporting supervisor identified in section 7.

 

The work location is based in Fredericton and travel outside the city of Fredericton is not expected. If the candidate is based outside the Fredericton region, it is the vendor’s responsibility to pay for the employee’s travel to and from their place of business (or home) and the Fredericton area.  Additionally, the vendor will not charge SNB for employee travel time or expenses.