Sql programmer Offres d'emploi - Old toronto, ON

Posting Title: Senior Programmer

Job ID #: 7569

Salary: $112,397 - $130,067

Shift: Days

Hours: 35

Location: 40 College Street

Department: Policing Applications Unit

Vacancies: 1

Job Code: A11SMA

Opening Date: October 20, 2025

Must Apply By: October 31, 2025

The Toronto Police Service is looking for a candidate that shares our core values:

Service at our Core Do the right thing Connect with Compassion Reflect and Grow

The Toronto Police Service is the fourth largest municipal police service in North America. With over 5,000 police officers and approximately 2,500 civilian employees, we are dedicated to delivering best in class police services, in partnership with our communities by being where the public needs the Service the most, by embracing partnerships to create safe communities and by focusing on the needs of the City.

The Opportunity:

Are you passionate about serving your communities, supporting Police Officers and making the city of Toronto a safer place to live, work and play?

We are seeking highly technical and driven applicants who are looking for an exciting opportunity to join a team of high-performing IT professionals as a Senior Programmer and contribute to various exciting modernization projects.

The Unit has openings within Community Safety, Policing Delivery and the Digital Officer Departments.

What can I expect to do in this role?

In this role you will design and code complex new programs and enhancements and will support existing applications, some of which require 24x7 standby. You will analyse and correct complex application problems on existing systems and test and document new programs, enhancements and corrections. You will collaborate with business partners, police officers and colleagues to understand user needs, ideate solutions, develop solutions and validate those with users. You will also conduct research, liaise with vendors to integrate and customize COTS (Commercial off the Shelf) as enterprise IT solutions.

Furthermore you will act as a mentor and resource for junior members of the team. You will assign and check the work of others doing similar work, including the implementation of coding standards, code reviews, source control management, build processes, testing and operations.

Duties and Responsibilities

Designs and codes complex new programs and modifications to complex existing systems according to requirements.

Becomes the Subject Matter Expert by understanding existing platform s front and back end technologies, integrations with other platforms, common technical issues and understanding who the business owners are and how they support the Service.

Troubleshoots simple and complex production issues for supported platforms as they arise.

Determines requirements and feasibility of small to large-sized enhancements as required.

Analyses, plans, evaluates, documents and designs small to large-sized systems. Evaluates Requests for Proposals and development tools.Assists with the analysis, evaluation, documentation and design of complex systems.

Works closely with UI/UX designers to improve user experience. Determines requirements and feasibility of small to large-sized enhancements as required.

Develops test plans and test cases.Evaluates program efficiency and adherence to standards by conducting appropriate tests.Tests interaction of multiple programs and modules.Recommends solutions to problems.

Tests and documents solutions.May be required to recommend solutions and estimate person-hour requirements for large or complex problems.

Creates user documentation and technical program documentation for use by personnel.Trains small groups of users.

Maintains knowledge of new technology and industry trends and applies those which will improve the operations, productivity or efficiency of the Unit.

Acts as a liaison with the various ITS groups, Database Administrators, Data Management group and vendors.Collaborates with team members cross disciplines and departments.

May be required to participate in special projects including (but not limited to) the design, development, implementation, monitoring and testing of data base systems.

Provides technical guidance to junior staff.May be required to coordinate the assignments of junior staff.

Leads a triage team to evaluate, prioritize and assign the resolution of defects.

Updates job knowledge by using the latest development tools, programming techniques, and by participating in educational opportunities, reading professional publications, and participating in professional organizations. Learns various platforms and technologies and contributes to the development and support of products and services.

Adheres to IT Change Management Processes including but not limited to Change & Release processes, timelines and classification criteria.

Follows Project Management processes and participates in the creation of and maintenance of artifacts like RAID logs, project plans, project charters etc.

Performs typical duties inherent to the position.

Education/Experience:

• A three-year University or College degree/diploma in Computer Science or a related field, or an equivalent combination of education, training and experience.
• Minimum of five (5) years experience developing client-server applications with .Net, VB.Net, C#, Java, C++, JavaScript or other programming languages.
• Experience with relational databases (MS SQL Server, DB2/UDB, Oracle), including data modelling concepts.
• Experience with network concepts and Windows, UNIX, Linux operating systems.

Skills/Competencies:

Thorough understanding of GUI design concepts and development.

Ability to use IDE (Integrated Development Environment) tools like Visual Studio Code, Eclipse and version control management.

Understand HTTP protocol (GET/POST/PUT/DELETE, requests/responses and cookies/sessions), REST APIs, client-side caching, responsive websites.

Understand Cloud computing with Azure, AWS, or GCP, Machine Learning and Artificial Intelligence.

Understand emerging web and mobile development models.

Highly desirable experience with low-code/no-code development, Waterfall, Agile and DevOps processes, tools and methodologies.

Strong organizational, interpersonal and communications skills.

Demonstrate a high degree of creative thinking, big picture strategic thinking and problem solving.

Demonstrate ability to solve problems and make decisions using data/analytics.

Flexible to work both independently and within a team.

Probation Period:

6 months

Contact:

Lisa Petko, A/Senior Talent Acquisition Advisor

Talent Acquisition Unit

Notes:

Competencies may be measured through various selection tools such as test(s) and/or interview.