Sql developer Jobs in Kingston, ON

Opening Statement

The City of Kingston is grateful to experience the traditional territories of Anishinabek (Ah-nish-nah-beg), Haudenosaunee (Ho-den-o-show-nee) and Huron-Wendat (huron-wen·dat). Kingston is a smart, livable city in the heart of eastern Ontario. Its stable and diversified economy includes global corporations, innovative start-ups and all levels of government.

At the City of Kingston, we believe that diversity and inclusion are essential elements of a thriving workplace. We value the unique perspectives and experiences that each individual brings to our team. As we continue to grow, we are dedicated to creating an environment where all employees feel welcomed, respected, and empowered to contribute their best work. The City of Kingston views diversity as its strength and we encourage applications from individuals of all backgrounds, including those from underrepresented communities.

As staff, you play a pivotal role in enhancing people's lives by delivering exceptional, customer-centered services of the highest quality. Within our highly ethical environment, you'll embrace accountability by consistently going above and beyond, actively listening to our customers, creatively addressing their needs, and maintaining unwavering respect for all individuals you serve. As a result, you'll become an integral part of our qualified and dynamic team, recognized for its compassion, excellence, integrity, inclusivity, and adaptability.

Position Summary

Reporting to the Manager, Digital Transformation, Architecture, and Planning, the Senior Full Stack Developer is responsible for the design, development, and maintenance of the City’s internal and external cloud-based communication, transaction, collaboration, and service delivery platforms.

Working under the Product Owner / Manager, this senior position contributes to setting standards for development, maintenance, architecture, and implementation strategies, and guides junior staff during project and product development.

KEY DUTIES AND RESPONSIBILITIES:

Uses expertise in system development methodologies and coding to design, develop, and maintain web-based applications using a variety of technologies.

Participates in strategic development and setting standards and technical architecture (including information architecture).

Provides expert analysis and feedback relating to the development and use of web technologies in meeting corporate objectives, improving external and internal communication and service delivery, and improving information and knowledge management.

Works with business units and external stakeholders to understand operational and informational needs and devise technology enabled solutions.

Provides operational support for production systems as required.

Other duties as assigned.

Qualifications,Competencies

Degree or diploma in Computer Science or Software Engineering, or a related program.

5 years of recent and related experience in systems development methodology and software application development in an organization with over 200 employees required. 7 years of recent and related experience preferred.

Web Application Development: proven experience building large‑scale, production web applications using modern JavaScript frameworks required, such as React or Angular. Experience integrating with multiple backend systems (e.g. payments, property, licensing, recreation) required.

Identity, Authentication, and Security: hands‑on experience with OAuth 2.0, OpenID Connect, and familiarity with SAML required.

Cloud & Platform Integration: experience building and deploying applications in cloud environments required, like Azure or AWS, including containerized deployments and environment separation.

DevOps & Operational Readiness: strong experience with CI/CD pipelines, automated builds, deployments, and code/security scanning required.

Must demonstrate corporate values of Belonging, Collaboration, Accountability, and Innovation.

Skills, Abilities,Work Demands

Web Application Development:
- Strong skills in API integration (REST and event‑driven), including secure consumption, versioning, error handling, and resiliency

Identity, Authentication, and Security:
- Ability to integrate with staff and citizen identity platforms (e.g. Azure Entra ID)
- Strong understanding of secure session management, access control concepts, PII protection, and privacy‑by‑design

Cloud & Platform Integration:
- Understanding of platform‑style architectures and integration with shared services (e.g. search, notifications, payments, GIS)

DevOps & Operational Readiness:
- Ability to build systems with clear error states, auditability, and observability

Accessibility & User‑Centered Design:
- Proven ability to develop accessible by design solutions, with a focus on user experience
- Ability to deliver accessible, WCAG‑compliant applications
- Strong grasp of responsive design, plain‑language content, and inclusive UX principles

Data & Integration Awareness:
- Understanding of data exchange patterns and experience with SQL, NoSQL, and diverse data sources
- Familiarity with data lake concepts, structured / unstructured data, and ETL processes

Technical Leadership:
- Ability to set development standards, review code, mentor developers, and make architecture recommendations
- Comfortable working within cross‑functional product teams

Required to obtain and maintain a satisfactory criminal record check.