Apply By: Tuesday, January 14, 2025 11:59 pm EST
Competition Status: Application Screening

Approximately 167 individuals applied for this opportunity.

We are screening ALL applications received on or before the closing date and rating them against the qualifications outlined in the job ad. Applicants whose resume and cover letter best demonstrate how they meet the qualifications to do the job will be invited to continue in the hiring process.

To learn about our recruitment process, visit our Hiring Process.

Senior Database Analyst

Job ID:
220131
Organization:
Ministry of Public and Business Service Delivery and Procurement
Division:
GovTechON - Labour and Transportation I&IT Cluster/Operations, Maintenance and Support Branch
City:
Toronto
Position(s) language:
English
Job term:
1 Temporary - up to 12 months with possible extension
Job code:
17160 - Systems Officer 5
Salary:
$84,698.64 - $109,415.28 Per year*
*Indicates the salary listed as per the OPSEU Collective Agreement.

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.

How we support diversity, inclusion and accessibility

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.

About the job

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

What you bring to the team

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:

Apply by:
Tuesday, January 14, 2025 11:59 pm EST
Position details:
  • 1 English Temporary, duration up to 12 months, 125 Sir William Hearst Ave, Toronto, Toronto Region, Criminal Record and Judicial Matters Check
Compensation group:
Ontario Public Service Employees Union
Work hours:
Category:
Information Technology
Posted on:
Wednesday, December 18, 2024

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


Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.


Strengthening Ontario, together