Job Description

Description

Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

General Skills

Experience in programming and analysis at the specified experience level

Ability to collaborate with IT Professionals throughout the Software Development Life Cycle

Experience in structured methodologies for the development, design, implementation and maintenance of applications

Experience in design, code, test, debug and document applications

Experience in the use of object and/or third generation language development tools

Experience in one or more programming languages

Experience in application design, latest design patters, deployment and troubleshooting

Experience with relational and hierarchical database technologies

Experience in the use of information retrieval packages using query languages

Experience with one or more communications protocols

Experience in structured methodologies for the design, development, implementation and maintenance of applications

Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts

Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

A team player with a track record for meeting deadlines

Desirable Skills

Knowledge and experience with programming Internet-ready applications

Knowledge and experience in rapid application development (RAD) methodologies

Experience with middleware and gateways

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Ability to provide user and system documentation as required

NOTE

Extension/Amendment Attestation:

Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.

Assignment Type

: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Experience Requirements

Design and Development

Experience



10+ years of

experience with Microsoft SQL Server Reporting Services.
10+ years of

experience in database development with Microsoft SQL Server.
Demonstrated

experience with database architecture, data modeling, logical and physical

database design (OLTP, OLAP, Data Warehousing, ERwin, Visio, UML) and

database capacity planning.
Demonstrated

experience with MS SQL Server performance tuning (Profiler, Tracing,

Execution Plan Analysis), data and application integration (ETL, SSIS, OS

scripting) and data migration
Writing

Python and SQL script for custom Computer Aided Dispatch (CAD) installations
Demonstrated

ability to translate complex business requirements into technical solutions
Experience

with and knowledge of UI Design Principles
Experience in

SOAP and REST web services for processing real-time data streams
Demonstrated

experience in responding to and troubleshooting issues related to data

quality and performance and resolve them in a timely manner.
Experience

working with team-collaboration tools (Confluence and Jira)


35%




Technical Skills



10+ years of

demonstrated experience in development of enterprise-level information

technology solutions by analyzing, coding, configuring, testing, and

implementing new and by modifying/enhancing existing applications utilizing

Microsoft SQL Server.
Demonstrated

experience with development and maintenance of complex SQL queries, views and

stored procedures.
End to end

management of the Software Development Life Cycle (SDLC) for Computer Aided

Dispatch (CAD)
Developing

process models and ongoing analysis of program effectiveness for Computer

Aided Dispatch (CAD),
Demonstrated

experience in all aspects of the software development cycle (SDLC, Agile)
Experience

with designing and developing solutions for a 9-1-1 Public Safety environment
Demonstrated

experience in delivering and meeting project deliverable timelines.


35%




Communication Skills



Strong verbal

and written communication skills that enable to effectively communicate ideas

and concepts. Strong Interpersonal and negotiation skills.
Strong

consulting skills to engage with all stakeholders, lead meetings with

internal and external clients to gather and document business requirements.
Ability to

work with minimal supervision in an agile environment, be an effective

communicator with other team members and the business owners.
A

demonstrated team player with a proven track record for meeting deadlines
Demonstrated experience

in creating of conceptual, logical, and physical data documentation for

knowledge retention and transfer.
Experience in

working on multi-year projects


25%




Public Sector Experience



Experience in

working on multiple projects at the same time
Experience in

working on multi-year projects
Experience

with building enterprise level reporting solutions that protect

high-sensitive information
Demonstrated

knowledge and experience with OPS governance methodologies (e.g. UPM,

architecture gating)


5%





Supplier Comments

Closing Date - 2026-01-15, 9:45 a.m.



Maximum Number of Submissions - 1 (one)

Assignment Type: Onsite

This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.




MUST HAVES:


?10+ years of experience with Microsoft SQL Server Reporting Services.


10+ years of experience in database development with Microsoft SQL Server.


?10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server.


* Demonstrated experience with development and maintenance of complex SQL queries, views and stored procedures.