Apply By: Wednesday, January 26, 2022 11:59 pm EST
Competition Status: Posting Cancelled

Fewer than thirty individuals applied for this opportunity.

Due to operational reasons the recruitment for this position has been cancelled.

To look for other job opportunities that match your skills and experience go to Job Search. You may also subscribe to our Job Alert service to receive emails when new jobs open up that match your determined search criteria.

Thank you for your interest in the Ontario Public Service.


Ministry of Government and Consumer Services
Government Services Integration Cluster
Job Term:
1 Temporary assignment up to 18 months
Job Code:
17162 - Systems Officer 6
$1,687.30 - $2,107.87 Per Week*
*Indicates the salary listed as per the OPSEU Collective Agreement.
Posting Status:
Open Targeted
Job ID:
The Opportunity
The Enterprise Financial Services and Systems Division, requires a highly skilled and innovative database administrator to provide senior-level technical support for the design, development and operations of current and future IT Cluster database and application systems. You will provide technical leadership in the configuration, customization, implementation, and maintenance of Oracle Hyperion EPM and other application systems.

Who we are:
The Office of the Corporate Chief Information Officer (OCCIO) leads the Information and Information Technology (I+IT) organization of approximately 4,100 staff, which is responsible for all the IT infrastructure, systems and support for the Province. I+IT is a complex organization that balances corporate and ministry business needs. Made up of corporate areas that focus on training, reporting and outreach; infrastructure; service management; cyber security; and architecture and standards, the OCCIO is the owner and overseer of the government's I+IT strategy. I+IT clusters enable technology solutions to support the strategic objectives of currently 24 ministries and deliver a broad scope of products and services in the face of changing and competing priorities, policy changes, and government directives.

Enterprise Financial Systems Branch (EFSB)
The EFSB is the I&IT team responsible for the operation and support of the IFIS Application Suite and related Business Intelligence (BI) and Enterprise Performance Management (EPM) systems.

EFSB is accountable for the ongoing technical operation of IFIS and its stability, security and reliability. EFSB also leads the development, sustainment and maintenance of the IFIS application and other extensions and modules to enable financial users to conduct financial business transactions and reporting.

About the OPS
The Ontario Public Service (OPS) is one of the largest employers in the province, employing more than 60,000 people. Every day, we are modernizing government operations and improving public services. We have a wide range of meaningful and rewarding career opportunities in communities across Ontario. We welcome new ideas and new people, encourage learning and development, and reward achievement. No matter the position, we live the core values of trust, fairness, diversity, excellence, creativity, collaboration, efficiency and responsiveness.

What a career in the OPS can offer you
The OPS is committed to be an employer of first choice, creating a positive and inclusive work environment.

In addition to flexible work arrangements, a collegial and professional work culture, career growth and development and on-the-job training to help you succeed, we offer a competitive total compensation package.

What can I expect to do in this role?

You will:
• Support production and development systems to ensure availability, integrity and performance levels
• Support critical business operational requirements for database and application systems, installation, maintenance, optimization, monitoring, trouble-shooting and back-up and recovery services
• Provide technical guidance and expert advice to application development teams
• Research, evaluate and recommend innovative solutions
• Perform daily administration functions and change management in support of IT operations
• Provide on-call and after-hours support services, including weekends and holidays, to resolve systems-related problems, as required.

How do I qualify?

Database Administration Knowledge:

• Demonstrated knowledge of database management theories, principles, techniques and practices to design, develop and test systems solutions.
• Extensive hands-on experience in, and expert knowledge of, Oracle RDBMS on Unix.
• Expertise in database creation, upgrade, monitoring, troubleshooting, performance tuning, backup and recovery.
• Hands-on experience supporting OBIEE installation, configuration, maintenance, performance tuning and troubleshooting.
• Hands-on experience supporting WebLogic Application Server configuration, monitoring, performance tuning and troubleshooting.
• Knowledge of Unix (Solaris) and Windows Server OS, using Unix and Windows utilities and commands to troubleshoot issues; perform installation, maintenance and monitoring of Oracle products.
• Hands-on experience in configuring and supporting RAC, ASM, Data Guard, OEM.
• Knowledge of Oracle OAM/OUD implementation and SSO integration of OBIEE and Hyperion.
• Experience and knowledge of IT Service Management best practices (Change, Configuration, Problem and Incident Management).

Communication, Analytical and Problem-Solving Skills:

• Oral and written communication skills to prepare business cases, conduct feasibility studies, and prepare and present findings and recommendations to senior management.
• Proven analytical and problem-solving skills to provide technical solutions for business requirements; diagnose Oracle performance problems; provide technical solutions to infrastructure-related issues.

Application Development Knowledge:

• Knowledge of the theory and principles of business design, systems analysis, design and development, acceptance and performance testing and related methods, including the application development lifecycle using the appropriate methodology.
• Knowledge of data and information architecture.

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:

We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.

Visit the OPS Anti-Racism Policy and the  OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the application instructions below if you require a disability-related accommodation.

Additional Information:

  • 1 Temporary, duration up to 18 months, 222 Jarvis St, Toronto, Toronto Region, Criminal Record Check
Compensation Group:
Ontario Public Service Employees Union
Information Technology
Posted on:
Wednesday, January 12, 2022
  • In accordance with the Ontario Public Service (OPS), Employment Screening Checks Policy (ESCP), the top candidate(s) may be required to undergo a security screening check. Refer to the above to determine the screening checks that are required for this position.

    Required security screening checks along with your written consent, will be sent to the Transition and Security Office (TSO), Talent Acquisition Branch (TAB), HR Service Delivery Division (HRSDD) to evaluate the results. If applicable, the TSO, with your written consent, will request and obtain any additional employment screening checks that were not obtained directly by you.

    A record under the Criminal Code and/or other federal offence record(s) does not automatically mean you will be ineligible for the position. The employment screening check(s) will only be reviewed and evaluated by the TSO for the purpose of making a security clearance decision. The details of an individual's employment screening check(s) will be considered in specific relation to the duties and responsibilities of the position being filled. Employment screening check records will be maintained by the TSO and kept strictly confidential.
  • T-MG-174054/22
    The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures, including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.
    Effective October 1, 2021, the OPS COVID-19 Safe Workplace Directive requires all Ontario Public Service employees to provide proof they are fully vaccinated, meaning they are fully vaccinated as defined by the Ministry of Health (refer to: COVID-19 Fully Vaccinated Status in Ontario), including 14 calendar days have passed since receiving their final dose of the COVID-19 vaccine.

    Employees who do not provide proof of full vaccination will be deemed ‘not vaccinated' under the Directive and will be required to attend a vaccine education program and undergo regular rapid antigen testing. Employees who are not vaccinated under the policy with a valid medical exemption will not be required to attend a vaccine education program but must undergo regular rapid antigen testing.
Please be advised that the results of this competition may be used to form an eligibility list of qualified candidates to potentially fill future vacancies represented by the Ontario Public Service Employees Union (OPSEU). In accordance with the Collective Agreement, eligibility lists are shared with OPSEU representatives. By applying to this competition, you are providing consent that your name may be shared with OPSEU representatives.
All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.
Remember: The deadline to apply is Wednesday, January 26, 2022 11:59 pm EST. Late applications will not be accepted.

We thank you for your interest. Only those selected for further screening or an interview will be contacted.

Job advertisements for positions that have been designated bilingual will be provided in both English and French on the website. Positions that are not designated bilingual are not translated and are displayed in English only on both the English and French versions of the website.

Les annonces d'emploi pour les postes désignés bilingues sont publiées en anglais et en français sur le site Web. Les annonces pour les postes qui ne sont pas désignés bilingues ne sont pas traduites et elles figurent en anglais seulement, tant dans la version française que dans la version anglaise du site.

The Ontario Public Service is an inclusive employer.
Accommodation is available under the Ontario's Human Rights Code.
Note: The only website where you can apply on-line for positions with the Ontario Public Service is

You must enable JavaScript in your browser to access full functionality on the OPS Careers website.

Vous devez activer JavaScript dans votre navigateur pour avoir accès à toutes les fonctionnalités du site Carrières dans la FPO.

Ontario Logo / Logo de l'Ontario
This site is maintained by the Government of Ontario
Ce site est mis à jour par le gouvernement de l'Ontario

Privacy | Important Notices
Confidentialité | Avis importants

© Queen's Printer for Ontario, 2007
© Imprimeur de la Reine pour l'Ontario, 2007