Senior Research Analyst (Database Administrator)

June 22 2022
Industries Public administration
Categories Database Dev. & Admin., Information Technology, System administrator
Toronto, ON

The Job

What is the difference between NoSQL and relational databases?

What is the difference between T-SQL and SQL?

How can you identify if a database server is running properly?

If you're still reading this, chances are you have an affinity for designing and developing data management structures, and large-scale database administration, and you might be a great fit for our team.

The Research and Analysis Unit in the Treasury Board Secretariat is seeking one Senior Database Administrator who can provide technical consulting expertise in data management and database administration.

This role will focus exclusively on database administration.

What can I expect to do in this role?

As a Database Administrator, you will:

  • Provide data management expertise in development of information technology plans and strategies
  • Develop methodologies, techniques, and tools for reactive and proactive, manual and automated database performance monitoring
  • Lead corporate projects for building and maintaining corporate data models or developing Windows-based database systems by providing technical direction and project leadership to teams
  • Evaluate and recommend technical design features and alternatives to ensure proper procedures for backup, recovery, and security of all ministry databases
  • Propose cost-effective use of new database products, data modelling tools and application development aids
  • Provide database backup and recovery expertise to develop procedures and perform Disaster Recovery Planning (DRP) exercise to ensure timely recovery of Justice Mission Critical Systems in the case of any disasters

Location: Toronto

How do I qualify?

Database Design and Development Knowledge:

  • You have experience working with Microsoft Azure Cloud databases, Microsoft SQL Server (all versions) and database replication.
  • You can provide data management expertise and advice on database design standards for the ministry.
  • You have working knowledge of Azure Data Factory (AD).
  • You have knowledge of Windows computer system technologies, an understanding of database management using Windows operating systems, and knowledge of data management and application software.
  • You have knowledge of database development methodology, programming languages, database concepts, data types, data dictionaries, and data storage and retrieval techniques to lead the design, testing, and implementation of multi-purpose and multi-client-based databases and data management structures.
  • You have knowledge and experience in coding, testing and implementation of SQL, triggers, stored procedures and others.

Database Monitoring and Technical Software/Hardware Knowledge:

  • You can analyze and maximize capabilities of databases using available technology, and advise on acquisition of new software/hardware.
  • You can monitor and maintain database systems performance through development of standards.
  • You can advise on solutions to data recovery, integrity, and security issues, and assess impact of data organization on systems performance.
  • You can evaluate database software and data management techniques/services for potential use by the ministry.
  • You have knowledge in SQL database administration and tuning, Windows system administration, and database and system backup and recovery.
  • You are proficient in Windows host scripting, Python, database replication, and enterprise backup.

Problem-Solving and Evaluative Skills:

  • You can apply project management principles and techniques to lead, and participate in, policy and research projects.
  • You understand research and data-gathering methodologies to analyze data management requirements such as integrity/security/recovery issues and develop recommendations for ministry standards on database design and data organization.
  • You can assess clients' requirements in relation to multi-purpose and multi-client database systems and lead project teams in design/development of corporate data models for systems, databases, data management structures, standards, policies and procedures.
  • You can conduct research, and assemble and analyze data and information.
  • You can identify and resolve issues and problems impacting the ministry and support the ministry in achieving its objectives.

Communication Skills:

  • You can explain technical solutions to non-technical personnel.
  • You can deliver presentations to senior management (systems and non-systems managers) on proposals for data management aspects of information architecture and information technology plans/strategies.
  • You can present and discuss benefits/drawbacks of proposals on data management strategies with senior managers and encourage support of the recommended approach.

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 application instructions below if you require a disability-related accommodation.

Salary Range: $74,877 - $110,338 Per Year

Additional information:

  • 1 Permanent, 315 Front St W, Toronto, Toronto Region


  • The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures, including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.

Please apply online, only, at, quoting Job ID 180650, by Thursday, July 7, 2022. Please follow the instructions to submit your application. Faxes are not being accepted at this time.

If you require accommodation in order to participate in the recruitment process, please contact us at to provide your contact information. Recruitment Services staff will contact you within 48 hours. Only those applicants selected for an interview will be contacted.

The Ontario Public Service is an inclusive employer. Accommodation will be provided in accordance with Ontario’s Human Rights Code.

Apply now! network