Ontario Public Service Careers - Job Preview
Apply By: Wednesday, October 30, 2013 11:59 pm EDT Print this pagePRINT

Competition Status: Position Filled

Approximately 154 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.

Organization:    Ministry of Education
Division:    Community Services I & IT Cluster
City:    Toronto
Job Term:    1 Permanent
Job Code:    17160 - Systems Officer 5
Salary:    $1,357.77 - $1,753.98 Per Week*
Posting Status:    Open
Job ID:    56897
 View Job DescriptionView Job Description

Do you have technical expertise in large-scale database administration? If so, consider this opportunity with the Community Services Cluster where you will lead the design, implementation and maintenance of databases to support the delivery of services from the Ministry of Education and the Ministry of Training Colleges and Universities.

What can I expect to do in this role?

You will:

• act as technical expert in the field of advanced database technology
• assume lead responsibility to complete and maintain the logical and physical design for multiple ministry database
• provide specialized expertise in all areas of existing database design and administration
• provide expert consulting and advice to management and clients

How do I qualify?

Technical knowledge and skills:
You have:
• expert knowledge in the theories, principles and techniques used for large-scale data management
• strong knowledge of information management (IM) analysis, logical and physical data modeling, relational database management system (RDMS) design and development, data warehouse (DW) design and development, and disaster recovery
• knowledge and demonstrated experience using one or more industry standard RDMS (e.g. Oracle 10g or later, MS SQL Server 2005 or later) and their toolsets
• demonstrated skills to support standard Software Development Lifecycle activities in RDMS design, development, unit testing, integration testing, user acceptance testing, deployment, support, and administration
• experience using specialized tools for data modeling (e.g. Erwin, PowerDesigner)

Problem-solving and evaluative skills:
You have:
• proven ability to implement major application database modifications and to conceptualize approaches to new business requirements
• demonstrated evaluative skills to identify problems and solutions

Project management, coordination and leadership skills:
You have:
• planning and coordination skills to coordinate and lead all technical activities and coordinate data management analysis and design
• demonstrated project management skills to ensure technical guidance and leadership on all plans
• demonstrated leadership skills to coordinate and manage multiple projects

Communication and interpersonal skills:
You have:
• superior communication skills to liaise and translate non-technical terms with internal and external stakeholders
• demonstrated consulting and interpersonal skills to prepare project reports, lead discussions, translate technical analysis into non-technical terms and communicate advantages and disadvantages with clients
• consultation skills to prepare project reports detailing impacts on client services and ability to provide recommendations

Additional information:

  • 1 Permanent, 777 Bay St, Toronto, Toronto Region
Compensation Group:   Ontario Public Service Employees Union
Schedule:   6
Category:   Information Technology
Posted on:   Wednesday, October 16, 2013
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, October 30, 2013 11:59 pm EDT. 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 http://www.gojobs.gov.on.ca

*Indicates the salary listed as per the OPSEU Collective Agreement.
Canada's Top 100 Employers Greater Toronto's Top Employers Canada's Top Family-Friendly Employers Canada's Best Diversity Employers Top Employers for Canadians Over 40 Canada's Greenest Employers Canada's Top Employers for Young People