Database Administrator / Senior Database Administrator

---

Drive Change with Data!

The I&IT Enterprise Solutions and Justice and Public Safety Solutions Division is seeking 2 dynamic and innovative database professionals to join their team as they modernize the decision-making process for the Ontario government.

The first position available is a Senior Database Administrator who can provide technical consulting expertise in data management and database administration. If you are able to use your project management and team leadership skills in the design and development of data management structures and large-scale database administration, then this role may be for you!

The second position is a Database Administrator in which you will design, implement, tune, and sustain database management systems that are the foundation for Ontario's government decision-making process and reporting. You will also ensure compliance with security, cost optimization, and technology standards.

---

About the job

The Database Administrator role is an enterprise database design and architecture position. It focuses on:
• Database design and implementation
• Data modelling
• Technical standards and governance
• Providing expert advice to development teams
• Database optimization and performance monitoring
• Technical leadership and training

The role is centered on ensuring databases are designed, implemented, and maintained according to IT Cluster standards.

The Senior Database Administrator role is an operations-focused position supporting mission-critical environments. It focuses on:
• 24/7 production support
• Database administration and performance tuning
• Oracle and SQL database management
• Disaster recovery and backup/recovery solutions
• Incident, problem, and change management
• Enterprise data management and information architecture
• Database migrations, upgrades, and optimization

The role requires hands-on expertise with database platforms and operational support tools.

Want to learn more about this opportunity?
Click here to join us for an information session on October 19 at 11:00am – 11:30am where you'll have a chance to find out more about the job.
Be sure you add this event to your calendar so you don't miss out!

If you experience any issues with the link, please use the Microsoft Teams meeting details below:
Meeting ID: 243 611 617 510 947
Passcode: sB2gD9hd

If you can't make it - no problem. Attendance at the session is optional and will have no impact on hiring decisions.

---

What you bring to the team

Mandatory requirements

For the Database Administrator position:
• the successful candidate will be required to undergo a Criminal Record and Judicial Matters Check (CRJMC) and a Credit Check
• this position is located at 222 Jarvis Street, Toronto or 33 King Street West, Oshawa.

For the Senior Database Administrator position:
• the successful candidate will be required to undergo a Criminal Record and Judicial Matters Check (Fingerprint Based), Annual CRJMC, Canadian Border Services Check, Credit History Check, Driver's License History, Local Police Databases Search, Ontario Provincial Police Investigation/Background Interview, PIP/NICHE/RMS and Social Networking Search
• this position is located at 200 First Ave W., North Bay or 21 College St, Toronto

Technical Knowledge and Database Administration Skills

• You have knowledge of enterprise database management technologies, database design methodologies, data modelling concepts, database structures and database development practices.
• You have experience designing, implementing, maintaining and optimizing databases that support complex business applications and mission-critical systems.
• You can provide technical expertise and advice on database design standards, development approaches and database administration best practices.

Database Operations, Performance, Security and Recovery Expertise

• You have experience monitoring and maintaining database performance, availability and reliability within enterprise environments.
• You can troubleshoot and resolve complex production database issues and implement effective performance tuning solutions.
• You have knowledge of database backup, recovery, disaster recovery and security practices to ensure data integrity and operational continuity.

Technical Infrastructure and Emerging Technology Knowledge

• You have knowledge of database platforms, operating systems, tools and technologies used within large-scale enterprise environments.
• You can assess, evaluate and recommend database technologies, software and technical solutions to support business and operational requirements.
• You have experience supporting and implementing database solutions within complex multi-platform environments.

Analytical and Problem-Solving Skills

• You can analyze complex technical and business requirements and develop effective database solutions and recommendations.
• You can evaluate design alternatives, conduct feasibility assessments and identify risks, impacts and opportunities associated with proposed solutions.
• You can research emerging technologies, assess their applicability and provide recommendations that support organizational goals and service delivery requirements.

Communication, Consultation and Relationship Management Skills

• You can communicate technical information clearly and effectively to both technical and non-technical audiences.
• You can prepare reports, technical documentation, recommendations and presentations to support decision-making and operational objectives.
• You can provide consultation, technical guidance and collaborative support to stakeholders, project teams and clients while building effective working relationships.

---

Don't meet every qualification?

If you are excited about this position and meet most, but not all, of the listed qualifications, please still consider applying. We recognize that no one person might have every qualification in this job ad, and you just might be the right candidate!

---

How we support diversity, inclusion and accessibility

We are building an inclusive workforce that reflects the communities we serve. We encourage everyone interested in working with us to apply, including people with disabilities, Indigenous, Black and racialized individuals, as well as people from all ethnicities, cultures, sexual orientations, gender identities and gender expressions.

Our hiring process is accessible, consistent with Ontario's Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005. We are working to prevent and remove barriers in our hiring processes and can offer  accommodation to address specific needs related to Code-protected grounds such as disability, family status and religion. For more information about accommodation during the hiring process please  contact us.

Learn more about the work the OPS is doing to create an inclusive, anti-racist, accessible and diverse workplace:

• diversity, equity and inclusion initiatives
• accessibility
• Anti-Racism Policy

---

Additional information:

Note:

• About security checks:
  A criminal or other federal offence record does not automatically disqualify you from the position. We consider each situation based on the position's responsibilities.
  If a check is needed and you've lived outside of Canada in the past 5 years for 6 or more months in a row, or if you are not a Canadian resident, you'll need to provide an out-of-country police clearance certificate from the country you lived in.
  Employment screening checks are only reviewed and evaluated by the Transition and Security Office, which also maintains them and keeps them strictly confidential.
• C-MG-249189/26(2)

---

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.

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.