Apply By: Tuesday, November 28, 2017 11:59 pm EST
Competition Status: Position Filled

Approximately 155 individuals applied for this opportunity.

We have completed the recruitment process and successfully hired the top candidate into the position.

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 Service Integration Cluster, Enterprise HR Systems Branch
Job Term:
1 Permanent
Job Code:
17162 - Systems Officer 6
$82,657.25 - $103,260.30 Per Year*
*Indicates the salary listed as per the OPSEU Collective Agreement.
Posting Status:
Job ID:
The Government Service Integration Cluster (GSIC), Enterprise HR Systems Branch requires a highly skilled and innovative database administrator to support the installation, maintenance, change management, optimization, trouble-shooting and planning of PeopleSoft environments.

What can I expect to do in this role?

You will:
• provide technical direction to application developers
• support production and development systems to ensure integrity and performance levels
• support critical business operational requirements for current/future database systems, installations, maintenance, optimization, trouble shooting and back-up and recovery services
• research, evaluate and recommend innovative solutions
• perform daily administration functions and change management in support of IT operations

How do I qualify?

Database Administration Knowledge:

• Demonstrated knowledge of database management technologies and database design methods, techniques and practices (e.g. PeopleSoft HCM 9.0, 9.1, and 9.2, application, database using Mainframe, DB2, v10 & V11)
• Demonstrated knowledge and experience with mainframe z/OS operating system platforms, database backup/recovery and security requirements
• Knowledge of data and information architecture (e.g. logical and physical architectures) to develop data architecture and models
• Knowledge of application database and software installations (e.g. scripting, SQL and programming), configuration, upgrades (e.g. application and database change management, capacity management)
• Demonstrated knowledge of technical performance and monitoring software to ensure database integrity and performance standards are met

Communication, Analytical and Problem Solving Skills:

• Oral and written communication skills to prepare business cases, conduct feasibility studies, and to prepare and present findings and recommendations to senior management
• Demonstrated negotiation and conflict resolution skills
• Analytical and problem solving skills to lead the development of IT solutions

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 life-cycle using the appropriate methodology

Project Management and Technical Leadership Knowledge and Skills:

• Demonstrate knowledge of project management methodology and techniques to lead a project team and to oversee all phases of projects from concept to implementation
• Demonstrated technical leadership skills to provide direction and support to team members

Additional Information:

  • 1 Permanent, 222 Jarvis St, Toronto, Toronto Region
Compensation Group:
Ontario Public Service Employees Union
Information Technology
Posted on:
Friday, November 10, 2017
  • C-MG-114173/17
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 Tuesday, November 28, 2017 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 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