Senior Development Database Administrator

---

Come showcase your technical expertise in database administration with the GovTechON-Justice Technology Services Division at the Ministry of Public Business Development and Procurement.

As a crucial member of our team, you will play a pivotal role in developing and deploying mission-critical Police applications, leveraging your expertise in Microsoft SQL databases to drive excellence and innovation.

---

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 role, you will:
• design and develop data management structures and large-scale database administration
• provide data management expertise in the development of information technology plans and strategies
• develop methodologies, techniques, and tools for reactive and proactive, and manual and automated database performance monitoring
• troubleshoot and repair problems arising from mission-critical production databases
• lead corporate projects for building, maintaining corporate data model, database design or developing Windows-based and Unix-based database systems
• develop and implement policies, standards, and procedures for management and use of ministry data
• 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

---

What you bring to the team

Technology Knowledge

You have:
• knowledge of information engineering methodologies, tools, techniques, and database management system design, information architecture, data modelling, database design and warehousing concepts and practices
• knowledge of Windows -based computer system technologies, understanding of database management using Windows operating system, and knowledge of data management and applications software
• knowledge of database development methodology, programming languages, database concepts, data types, data dictionaries, and data storage and retrieval techniques
• knowledge and experience in coding, testing and implementation of SQL, PL/SQL, triggers, stored procedures and others
• You have proven knowledge and experience in supporting, administration and tuning of all versions of SQL Server database
• knowledge of Windows system administration, and database and system backup and recovery
• knowledge of Windows host scripting, Visual Studio and .NET programming, database replication, and enterprise backup and recovery solutions
• the ability to prepare technical documentation and build books, and provide technical support
• proficiency in using testing tools and test, and implement the solution to various environment

Analytical, Research and Problem-Solving Skills

You can:
• review and analyze data management issues, concerns, and initiatives
• research and analyze data management requirements such as integrity, security, and recovery issues
• develop recommendations on database design and data organization
• analyze and develop proposals for data management component of information technology plan
• develop technical design features and alternatives
• identify components subject to data corruption
• assess, evaluate and recommend new methods, technologies and techniques

Communication and Interpersonal Skills

You can:
• prepare reports, briefs and papers on database management policies and standards
• explain technical solutions and deliver presentation on data management and information technology plans and strategies to technical and non-technical audiences
• discuss database design with client groups
• negotiate provision of services or acquisition of hardware and software with vendors

---

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.
• C-SL-224362/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.