Ontario Public Service Careers - Job Preview
headDivide.jpg
Apply By: Wednesday, November 27, 2013 11:59 pm EST Print this pagePRINT
 

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.

SENIOR DATABASE ANALYST
Organization:    Ministry of Transportation
Division:    Architecture, Information Management and Labour Solutions Branch
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:    58122
 View Job DescriptionView Job Description
 

Are you experienced in database management with demonstrated ability to provide database and systems solutions?

Consider this opportunity to demonstrate your expertise!

What can I expect to do in this role?

In this role, you will:
• provide leadership to the solutions team in the areas of database structures, policies, standards and operating processes
• co-ordinate the development, implementation and maintenance of databases and database administration activities
• provide advice and guidance to clients on use of data management techniques and technologies
• improve on the delivery of programs and services and enhance efficiency of operations for clients

How do I qualify?

Data Management Knowledge
• you know data management and information architecture theory, principles and techniques
• you can use your knowledge to analyze client data management requirements, assess options and conduct feasibility studies on hardware and software and data management standards
• you know data modeling techniques using computer aided software and can use information engineering tools to advise clients on short and long term strategies

Computer Systems and Software Knowledge
• you know micro and personal computer system technologies, application and database management software and database development methodology
• you know programming languages and database concepts to co-ordinate design and development of databases and data management structures, data dictionaries, data storage and retrieval techniques
• you can co-ordinate data dictionaries, data storage and retrieval techniques

System Testing Knowledge
• you know testing and implementation methods and practices to design testing procedures and co-ordinate acceptance testing and consultation with clients
• you can use your knowledge in order to design test procedures using Oracle and MS SQL server

Analytical and Problem Solving Skills
• you can use reasoning and problem solving skills to co-ordinate analysis and development of data management systems that meet client requirements and facilitate improvement of operational efficiency
• you can analyze client requirements by identifying parameters, method and scope for review of data flow, data management and decision-making processes
• you can identify options, conduct feasibility studies and cost-benefit analysis and provide advice and guidance to clients on strategies for data management
• you can identify opportunities for integration with other areas or programs and the use of new technology and techniques
• you can use analytical and evaluative skills to develop project plans, data management structures and overall database design requirements and standards
• you can build datawarehouses, datamarts and developing cubes for data analytics and data mining

Communication Skills
• you can interview clients about program operations, decision making processes, goals and objectives and discuss business strategies
• you can explain database design and development process and review technical considerations with clients and project team
• you can present formal and informal training sessions to information system and database users and make presentations to senior management
• you can write systems documentation, draft database management policies and standards
• you can write user manuals, operating procedures, training materials and prepare reports on analysis, such as cost benefit summaries and conclusions

Additional information:

Address:  
  • 1 Permanent, 400 University Ave, Toronto, Toronto Region
Compensation Group:   Ontario Public Service Employees Union
Schedule:   6
Category:   Information Technology
Posted on:   Wednesday, November 13, 2013
 
Note:
  • T-MT-58122/13
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 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 applying and/or accepting a position with the Ontario Public Service for a specific time period (e.g. one year), or from applying and/or accepting 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, November 27, 2013 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 http://www.gojobs.gov.on.ca

 
*Indicates the salary listed as per the OPSEU Collective Agreement.
 
 
 
Greater Toronto's Top Employers Canada's Best Diversity Employers Canada's Greenest Employers Best Employers for New Canadians The Career Directory: Canada's Best Employers for Recent Graduates Canada's Top Employers for Young People