Database System Administrator

Make the most of your expertise in data management techniques and technologies! Join the Land and Resources I&IT Cluster as a Database System Administrator.

About Us
The Land and Resources I&IT Cluster (LRC) is one of eight clusters in the OPS formed to provide groups of ministry partners with all their information technology needs. LRC partners with the Ministries of: Indigenous Affairs; Agriculture, Food and Rural Affairs; Environment, Conservation and Parks; Northern Development, Mines, Natural Resources and Forestry; and Energy.

LRC works with program areas in each of the ministries to understand their business needs and develop technology solutions that enable business transformation and digital public service goals and objectives. Technology solutions range from new business applications to office productivity tools, from information management expertise to telecommunications support.

The LRC works closely with other clusters and the Office of the Corporate Chief Information Officer (OCCIO) within the Ministry of Government and Consumer Services to enable shared technology solutions (development tools) and common infrastructure for the benefit of all ministries.

About the Branch
The Digital Solutions Branch collaborates with cluster partner ministries to co-design, deliver and support digital solutions, providing leadership in emerging technologies and innovative delivery techniques to enable modern government services.

Why work for the Ontario Public Service?
We are re-thinking how we deliver services through various initiatives, modernization initiatives and how we access and deliver critical services remotely. We are striving to enable a future-ready OPS workforce through a technology-focused enterprise-wide strategies.

The Ontario Public Service (OPS) offers a competitive compensation package. We support career and leadership development, invest in learning opportunities, and recognize team and individual achievements, and support flexible work arrangements.

Want more Information?
Visit  Ministry of Northern Development, Mines, Natural Resources and Forestry  website for additional information about our ministry.

The current location for this position is at 40 St Clair Avenue West, Toronto. However, alternative work arrangements and locations will be considered at the following locations:

• 95 Ghost Lake Road, Dryden
• 1 Stone Road West, Guelph
• 300 Water Street, Peterborough
• 159 Cedar Street, Sudbury
• 70 Foster Drive, Sault Ste Marie
• Hwy 101 East, South Porcupine
• 435 James Street South, Thunder Bay

What can I expect to do in this role?

As a Database System Administrator, you will:

• monitor and execute database and system administration procedures
• identify and resolve user problems and incidents
• provide leadership and guidance to project teams and assist in the design and development of databases
• provide technical support and advice to users on database management systems and data administration tools, techniques and methodologies

How do I qualify?

Technical Knowledge

• You have knowledge of relational database management and administration, and information architecture theory, principles and techniques, and techniques of data modeling using computer aided software, and use of information engineering tools.
• You have knowledge of a wide range of computer system technologies, including server-based technologies and personal computer systems, application and database management software (Oracle, Oracle Enterprise Manager), and database development methodology, programming languages (SQL PL/SQL), and relational database concepts.
• You have knowledge of commercial software such as Use Cases, and UML modelling, to develop/record data. models and architectures, process engineering, word processors and graphics presentation software.
• You have the ability to interpret and apply information technology policies, directives and guidelines.

Analytical and Evaluative Skills

You can:
• design databases, analyse and develop project plans, data management structures and overall database operation efficiencies, requirements and standards
• identify user problems, system and information bottlenecks and feasible solutions, develop security levels and security procedures
• apply and adapt precedents to solve problems and design databases
• develop and recommend standards and procedures for operating issues such as user access, security measures, data storage and retention, data manipulation and reporting capabilities
• research and assess potential use of new information engineering and data management techniques, methodologies, software and hardware

Communication and Interpersonal Skills

• You can exchange information during development and operation of databases.
• You can advise on technical requirements and issues.
• You can collaborate efficiently.

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.

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, November 9, 2021 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.