kandidatu Canada

Systems Integrator 1 (Data Warehouse Administrator)

City of Toronto · Public Health, Operations & Business Services (Toronto Public Health)

This job in plain words

This full-time permanent job supports the running and improvement of Toronto Public Health's Oracle-based data warehouse. The job is at Union Station, 65 Front Street West, Toronto, and the hourly pay is $52.38 to $57.39.

Open to the public

Can you apply?

Anyone who meets the stated qualifications can apply through the public posting. City of Toronto employees must apply through the City's internal job posting portal instead. The posting does not state citizenship or work permit rules.

Education
Not stated · Post-secondary education in computer science, information technology or a related field, or an approved equivalent mix of education and experience.
Experience
Considerable experience with Oracle analytics tools, data warehouses and WebLogic. No number of years is stated.
Job type
Full-time, permanent. Monday to Friday, 35 hours per week. One position open.

What they ask for:

  • Considerable experience with OAS/OAC, OBIEE or ODI, with hands-on skill in OAS/OAC or ODI.
  • Considerable experience with Oracle RDBMS, PL/SQL and shell scripting.
  • Considerable experience maintaining and migrating OAS or OBIEE reports.
  • Considerable experience with the BI Administration Tool (RPD) and OAS security setup.
  • Knowledge of Oracle OLTP and OLAP database environments and ODI administration.
  • Strong analytical, communication and customer service skills.

What you would do

  • Administer and support the Oracle-based data warehouse in development, test and production.
  • Monitor system performance, logs and availability, and troubleshoot technical issues.
  • Install, configure, patch and upgrade Oracle analytics and WebLogic components.
  • Maintain Oracle analytics repositories and user security, including LDAP and Active Directory.
  • Support ODI and ETL job monitoring, error recovery and data validation.
  • Support testing, implementation, upgrades and migrations of data warehouse systems.

How to apply

Apply online through the official City of Toronto job posting. Your application should explain how your experience meets the key qualifications.

Good to know:

  • Amendment dated October 26, 2026 says the posting period has been extended.
  • The job is linked to union affiliation L79 (full-time).
  • The City is committed to providing accommodation on request during recruitment.
  • Permanent full-time City employees must use the internal job posting portal.

We wrote this summary automatically from the official posting. Only the posting on the City of Toronto career site counts: read it before you apply.

Similar jobs

  • Project Lead, Transportation Services

    City of Toronto · Transportation Services, Maintenance & Delivery Services · Toronto
    $89,337 to $132,880
    Open to the public Closes in 13 days

  • Project Manager 311

    City of Toronto · Customer Experience, Business Transformation & Sustainment · Toronto
    $105,241 to $160,649 per year
    Open to the public Closes in 13 days

  • Manager, Finance & Business Services

    City of Toronto · Customer Experience, Finance & Business Management · Toronto
    $126,000 to $176,140 per year
    Closes in 13 days

  • Property Accountant

    City of Toronto · Corporate Real Estate Management, Business Management · T
    $49.66 to $54.43 per hour (preliminary wage grade)
    Open to the public Closes in 14 days

  • Manager, Development Engineering

    City of Toronto · Development Review, Engineering Review (City of Toronto) · Toronto
    $126,000.00 to $176,140.00 per year
    Open to the public Closes in 14 days