Job Description

Position Details

Job Category: Information & Technology
Division & Section: Public Health, Operations & Business Services
Work Location: Union Station- 65 Front Street West, Toronto
Job Type & Duration: Full-time, Permanent Vacancy
Hours of Work: Monday to Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 13-Oct-2026 to 28-Oct-2026

Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, the Systems Integrator 1 (Data Warehouse Administrator) will support the administration, sustainment and ongoing improvement of Toronto Public Health’s Oracle-based data warehouse environment.

The role requires strong hands-on experience with Oracle Analytics Server (OAS/OAC) or Oracle Data Integrator (ODI), with experience in both considered an asset. The successful candidate will support related Oracle technologies and services, including OBIEE, Oracle WebLogic, Oracle databases, RPD administration, security, performance monitoring and troubleshooting within a multi-tier, high-availability environment.

The position will also support implementation, testing, documentation, system upgrades and migrations, troubleshooting and continuous improvement activities. The successful candidate will work closely with TPH IT, business clients, Corporate IT partners and vendors to support reliable and effective data warehouse services in accordance with established City of Toronto and Toronto Public Health policies and procedures.

Major Responsibilities

Administers, sustains and supports Toronto Public Health’s Oracle-based Enterprise Data Warehouse environment across Development, Test/UAT and Production, including Oracle Analytics Server (OAS/OAC), OBIEE, Oracle Data Integrator (ODI) and related Oracle technologies.
Monitors system performance, availability and logs; troubleshoots technical issues and supports proactive problem detection, performance tuning and recovery within a multi-tier, high-availability environment.
Installs, configures, patches, upgrades and supports Oracle analytics and middleware components, including Oracle WebLogic, within Linux/Unix environments.
Maintains Oracle Analytics repositories (RPD), including subject areas, metadata and semantic layers, and supports user access and security configuration, including LDAP/Active Directory integration.
Supports the ongoing operation and maintenance of ODI/ETL processes, including job monitoring, troubleshooting, error recovery, data validation and data integrity.
Uses Oracle RDBMS, PL/SQL and shell scripting to support Data Warehouse administration, automation, troubleshooting and ongoing sustainment activities.
Maintains and supports OAS/OBIEE reports and assists with the migration of reports and related components between environments or platform versions.
Reviews system performance, logs and technical issues; conducts root-cause analysis, identifies risks and recommends corrective actions and improvements to processes, standards and service delivery.
Liaises and coordinates with TPH IT, business clients, Corporate IT partners and external vendors to support technical deliverables, resolve issues and provide updates on Data Warehouse activities.
Supports the development and execution of test strategies, test cases and test scripts for system, performance, usability and acceptance testing.
Leads or supports implementation, upgrade, migration and rollout activities, including technical walkthroughs, implementation planning and Go/No-Go cut-over decisions.
Prepares and maintains technical documentation, procedures, status information, lessons learned and training materials for staff and end users.

Key Qualifications

Your application for the role of Systems Integrator 1 (Data Warehouse Administrator) should describe your qualifications as they relate to:

Considerable experience administering and supporting OAS/OAC, OBIEE and/or ODI, with strong hands-on expertise in OAS/OAC or ODI. Experience with both is an asset, along with Oracle WebLogic administration, performance tuning and troubleshooting in high-availability environments.
Considerable experience with Oracle RDBMS, PL/SQL applications and shell scripting.
Considerable experience maintaining and migrating reports using Oracle Analytics Server (OAS) and/or OBIEE within a Data Warehouse environment.
Considerable experience with the BI Administration Tool (RPD) and OAS security setup, including LDAP integration with e-Directory and Active Directory.
Post-secondary education in Computer Science, Information Technology or a related discipline, or an approved equivalent combination of education and experience.

You must also have:

Knowledge of Oracle database environments, including OLTP and OLAP, and familiarity with Oracle Data Integrator (ODI) administration and development.
Technical knowledge of Oracle Analytics Server (OAS/OAC), OBIEE, Oracle WebLogic and related security components.
Ability to support the installation, configuration, administration, sustainment and migration of Oracle analytics technologies in UNIX/Linux environments.
Ability to support performance monitoring, troubleshooting, proactive problem detection and disaster recovery activities within enterprise Data Warehouse environments.
Strong analytical and problem-solving skills, including the ability to investigate technical issues and identify root causes.
Ability to work effectively with multidisciplinary technical and business teams and coordinate with internal and external partners.
Strong verbal and written communication skills, including the ability to prepare technical documentation and explain technical issues to different audiences.
Strong customer service orientation and the ability to manage competing priorities and meet deadlines.