Senior Database Analyst

Do you have the project management skills needed to co-ordinate development, implementation and maintenance of databases and database administration activities? Do you have the communication and interpersonal skills needed to provide advice and guidance to clients on use of data management techniques and technologies? If so, please consider this exciting opportunity with the Information Management, Project Advisory & Labour Solutions Branch within the Ministry of Transportation.

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 "How to apply" section if you require a disability-related accommodation.

What can I expect to do in this role?In this job you will:
• Provide leadership to the solutions team in the areas of database structures, policies, standards, and operating processes and operating issues
• Liaise with service management on processes and standards that are interrelated with service management functions
• Consult with clients and analyze data processing and data management requirements
• Conduct or co-ordinate development and analysis of data management options
• Co-ordinate and participate on database design and development projects including developing project plans and identifying necessary resources
• Provide leadership and guidance to project team
• Plan and co-ordinate database system implementation, including establishing testing processes
• Establish and manage the database and data administration functions
• Provide technical advice and guidance in reviewing and developing recommendations on use of new information engineering and data management administration tools, techniques and methodologies
• Provide input into development and maintenance of ministry information technologies standards and plans
• Participate as technical advisor on committees

How do I qualify?Information Technology Knowledge• You have experience of current and emerging diverse database management (i.e. Microsoft SQL Server), Cloud (Azure SQL & Synapse) Tools, Automation (i.e. .NET Framework, C# (C-Sharp), PowerShell etc) , network (i.e. SQL* Net, JDBC and/or ODBC Connect) and data security, software and hardware architecture
• You have experience in Microsoft SQL Server database administration and working within a complex multi-technology (i.e Siebel & EBS, Oracle and/or DB2 RDBMS), Data Integration ELT/ETL (Informatica PowerCenter, Azure Data Factory (ADF), GoldenGate etc.), Scripting (PL/SQL, Perl and Shell), multi-platform n-tier integrated inter-dependent environment such as AIX, Unix and/or Linux, variant and/or MS Windows operating systems.
• You have knowledge of ITIL (IT Infrastructure Library) principles, roles and responsibilities of best practices for IT application support, including IT Service Continuity, Disaster Recovery, Incident, Problem, Change and Release Management
• You have knowledge of current IT methodologies (systems analysis, design, software development, testing and implementation methods, database management, change management, applications, integrated networking and security)
• Knowledge of data management and information architecture theory, principles and techniques
• Knowledge of data modelling techniques using computer aided software and use of information engineering tools
• Knowledge of micro/personal computer system technologies, application and database management software
• Knowledge of database development methodology, programming languages and database concepts
• Knowledge of testing and implementation methods and practices

Analytical & Problem Solving Skills• Ability to analyze client data management requirements by assessing options and conducting feasibility studies
• Ability to advise clients on short/long term strategies relating these to business plans
• Ability to develop policies, standards, procedures for administration of database systems
• Ability to design testing procedures, co-ordinate acceptance testing and consultation with clients
• Ability to research and assess potential use of new information engineering and data management techniques, methodologies, software and hardware
• Ability to develop and recommend policies, standards and procedures for operating issues

Communication & Interpersonal Skills• Written communication skills to prepare and draft technical reports, manuals, policies and procedures
• Oral communication skills to interview clients about technical needs, business plans and strategies
• Ability to present formal and informal training sessions
• Ability to discuss data management requirements and illustrate feasibility and advantages or disadvantages
• Ability to effectively negotiate contracts for services, hardware and software with vendors, within defined parameters

Project Management Skills• Ability to co-ordinate design, analyze and develop databases and data management structures, data dictionaries, data storage and retrieval techniques
• Ability to identify parameters, method and scope for review of data flow, data management and decision-making processes
• Ability to conducting feasibility studies and cost-benefit analyses
• Ability to develop project plans, data management structures and overall database design requirements and standards
• Ability to coordinate design, development and testing of databases

Additional Information:

Note:

• 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), Corporate Talent Programs Branch, Talent and Leadership Division 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.
• Less qualified applicants may be considered on an underfill basis.
• C-MT-220131/24

How to apply:

1. You must apply online.
2. Your cover letter and resume combined should not exceed five (5) pages. For tips and tools on how to write a concise cover letter and resume, review the Writing a Cover Letter and Resume: Tips, Tools and Resources.
3. Customize your cover letter and resume to the qualifications listed on the job ad. Using concrete examples, you must show how you demonstrated the requirements for this job. We rely on the information you provide to us.
4. Read the job description to make sure you understand this job.
5. OPS employees are required to quote their WIN EMPLOYEE ID number when applying.
6. If you require a disability related accommodation in order to participate in the recruitment process, please Contact Us to provide your contact information. Recruitment services team will contact you within 48 hours.

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, January 14, 2025 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.

Note: The only website where you can apply on-line for positions with the Ontario Public Service is http://www.gojobs.gov.on.ca

Apply Online