SYSTEMS INTEGRATOR 1

City of Toronto; Toronto; On-site; CAD 95,000 - 104,000; Full time

Job summary

City of Toronto's Toronto Children's Services division seeks a Systems Integrator 1 to join the Solution Development Services team at METRO HALL. You will collaborate with a cross-functional group of technology professionals to build and support innovative web and mobile-first solutions that deliver real value to clients.

This role covers requirements analysis, design, development, deployment, production support, and integration across Oracle and PostgreSQL databases, Oracle Forms and Reports,

Qualifications

• Post-secondary education in computer science, software engineering, or equivalent.
• Experience in systems analysis, requirements analysis, application design, coding, testing, deployment and support.
• Experience in database technologies, application integration, and data exchange techniques including SQL, Oracle Database, and PostgreSQL.
• Experience in Java development, Unix/Linux environments, Oracle Forms and Reports, and DevOps/CI-CD practices.
• Experience with Agile development and tools like Confluence and Jira.

Responsibilities

• Establishes and maintains business relationships with clients to discuss/assess client needs.
• Prepares project charters, statements of work and project plans.
• Identifies risks and develops mitigation actions.
• Leads teams in delivery of projects or work packages.
• Coordinates with internal and external groups to achieve deliverables.
• Prepares status reports and variance explanations for projects.

Skills

Java development

Unix/Linux

DevOps/CI-CD

Agile methodologies

Communication skills

Education

Post-secondary education in computer science or software engineering

Tools

Oracle Forms

Oracle Databases

PostgreSQL

Confluence

Jira

Job description

• Division & Section: Children's Services, ChildSvcs Strategic, Business & Fin Svcs
• Work Location: METRO HALL
• Job Type & Duration: Full-time, 1 Permanent Vacancy
• Hourly Rate and Wage Grade: $52.38 - $57.39
• Shift Information: Monday to Friday, 35 hours per week
• Affiliation: L79 Full-time
• Number of Positions Open: 1
• Posting Period: 02-OCT-2026 to 19-OCT-2026

This is an amazing opportunity to build a rewarding career at the City of Toronto by joining one of the most innovative teams in the City! The Toronto Children's Services (TCS) Division provides strategic leadership in digital client services and process modernization. Working in a highly collaborative environment, we help to leverage new Cloud technologies, use modern Agile, CI/CD, and DevOps approaches, collaborate with provincial and corporate stakeholders, and partner with business leaders on major transformational initiatives. We offer much more than just a salary. We offer you the opportunity to make a positive impact in the lives of children and families by using your talents and skills.
About the Role

Digital Transformation TCS of the City of Toronto is currently looking for a Systems Integrator 1 to join its award-winning Solution Development Services team. In this dynamic and fast-paced role, you will be a key member of a tight-knit, cross-functional team of technology professionals. We collaborate to build and support innovative web and mobile first solutions that deliver real value to our clients.

As a Systems Integrator 1, reporting to the Senior Systems Integrator, you will provide services across the application lifecycle, including business and system requirements analysis, application and integration design, database development, data modelling, coding, testing, troubleshooting, documentation, deployment preparation, production support, sustainment, and enhancement in a complex computing environment.

In this dynamic and technically diverse role, you will be a key member of a cross-functional team responsible for supporting critical Children's Services applications and integrations. You will work with business, application, database, infrastructure, security, and DevOps teams to maintain reliable data and document exchanges across different technologies.

The work includes supporting Oracle Forms and Reports applications, Oracle and PostgreSQL database solutions, application integrations, automation and deployment pipelines, system interfaces, and web application.

The role requires a combination of database, application integration, Oracle technology, DevOps, troubleshooting, and production support experience, as well as the ability to understand complex dependencies across applications, databases, file systems, web services, automation tools, and infrastructure components.

Major Responsibilities

• Establishes and maintains business relationships with clients to discuss/assess clients needs.
• Prepares project charter, statements of work and project plans.
• Identifies risks and prepares action plans to mitigate.
• Conducts or leads team in delivery of projects or work packages.
• Liaises and co-ordinates with internal & external groups on accomplishment of deliverables.
• Prepares and presents status report and variance explanation for projects or work packages.
• Prepares findings & "Lessons Learned" from post-implementation project reviews.
• Assesses, analyzes, evaluates and recommends process & policy alternatives for projects & work packages.
• Redesigns business principles, processes, policies and standards by recommending best practices and improvements to current processes.
• Determines business requirements and builds consensus amongst clients.
• Prepares Business Plans, Gap Analysis, Logical Data Models and Design documents for proposed solutions that leverage information & technology as part of the solution.
• Provides input to Data Management teams on transformation of clients' business requirements.
• Recommends improvements to current methodology, process, standards, and policies.
• Assists staff in understanding of business processes and logic.
• Liaises with staff in development of test strategy, test cases & test scripts for system, performance, usability and acceptance testing of system solutions developed.
• Leads team to draft implementation & rollout strategies and plans.
• Conducts walk-through of deliverables to identify potential problems.
• Prepares training material and documentation for use by clients and staff.
• Conducts training for client and their staff.
• Collaborates with clients on "Go / No Go" cut-over decisions e.g. roll-outs.

Key Qualifications

• Post-secondary education in computer science, software engineering, or the equivalent combination of education and/or experience.
• Considerable experience in systems analysis, requirements analysis, application design, coding and unit testing, troubleshooting, and production deployment and support.
• Considerable experience in database technologies, application integration, and data exchange techniques, including SQL, Oracle Database, and PostgreSQL.
• Considerable experience in one or more of the following areas: Java development, Unix/Linux environments, Oracle Forms and Reports technologies, and DevOps/CI-CD practices.
• Experience in Agile software development and related collaboration tools such as Confluence and Jira.

You must also have:

• Excellent communication skills to prepare and present technical materials and to work effectively with team members and stakeholders.
• Interpersonal skills to establish and maintain effective consulting relationships with clients and vendors.
• Teamwork skills to work with multidisciplinary staff in a project team setting.
• Knowledge of Oracle legacy technologies, such as Oracle Designer and Oracle Forms Builder, will be considered an asset.
• Technical knowledge of developing security components for web-based applications.
• Ability to prepare functional specifications, system documentation, and user documentation, and to provide consultation and training to users.
• Fundamental knowledge of establishing and maintaining appropriate technical programming and development environments.
• Knowledge of current and emerging technologies, including application security best practices and authentication and authorization principles.
• Fundamental knowledge and understanding of DevOps, Continuous Integration/Continuous Delivery, and test automation.
• Strong analytical and problem-solving skills.
• Time management and organizational skills to manage competing demands, prioritize work, and meet deadlines.
• Ability to communicate effectively, both orally and in writing.
• Knowledge of developing, deploying, administering, and managing cloud-based solutions and platforms.
• Knowledge of the Accessibility for Ontarians with Disabilities Act (AODA), the Occupational Health and Safety Act, and other regulations and legislation that apply to the job duties.

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City's commitment to employment equity.