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
Language of Position(s):
English
Job Code:
17160 - Systems Officer 5
Salary:
$1,357.77 - $1,753.98 Per Week*
*Indicates the salary listed as per the OPSEU Collective Agreement.
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 English 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
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, 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.
All Ontario Public Service external job advertisements are posted in English and French. To confirm the language requirements of a job, check the "language of position" information at the top of each job ad. For all positions, candidates will be assessed in English, the business language of the Ontario Public Service. For English/French designated bilingual positions, candidates will also be assessed through French-language proficiency testing.
Toutes les offres d'emploi externes de la fonction publique de l'Ontario sont affichées en anglais et en français. Pour connaître les exigences linguistiques, vérifiez les renseignements sur la « langue du poste » figurant dans le haut de chaque offre d'emploi. Pour tous les postes, l'évaluation des candidates et candidats se fera en anglais, la langue usuelle de la fonction publique de l'Ontario. En ce qui concerne les postes désignés bilingues, la maîtrise du français des candidates et candidats sera également évaluée.