Database Administrator (temporary)

Njoyn; Oakville; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading college in Ontario is seeking a Database Administrator to design and maintain databases in a hybrid environment. This role requires a strong background in database management and specific experience with Oracle and Microsoft SQL Server. The ideal candidate will have analytical skills and a collaborative spirit, supporting both administrative and academic systems.

Qualifications

• 8 years of experience in administering relational databases.
• 5 years of experience with Oracle and MS SQL Server.
• 3-4 years of PeopleSoft admin experience is an asset.

Responsibilities

• Design, maintain and operate critical database environments.
• Install and maintain database and application products.
• Provide technical support for troubleshooting database issues.

Skills

Database Management

Analytical Thinking

Problem Solving

Collaboration

Education

Minimum 3-year diploma/degree in Computer Science

Tools

PeopleSoft

Oracle

Microsoft SQL Server

SQL

Unix

Linux

Windows

Job description

The Database Administrator is a highly skilled member of an enterprise database and system administration (DBA) team, who design, implement, maintain and support Sheridan’s administrative and academic databases as well as the application system environment. The incumbent installs, maintains, upgrades and supports Sheridan’s many database and application server environments and addresses requirements for database and application efficiency, security issues and performance issues.
Sheridan’s ERP applications are running on PeopleSoft in a four-tier architecture. The main database platforms supported are Oracle and Microsoft SQL Server.

What You’ll Be Doing

• Performing a variety of highly technical duties involved in the design, maintenance and operation of all database and related application system environments critical to the operation of the College’s administrative and academic system applications.
• Reviewing new system initiatives including major application upgrades to determine database and server requirements and meeting with system owners to clarify resource needs including number of users, concurrency and system availability.
• Advising supervisor of significance, impact on existing database and application environment and new resource requirements for storage and servers.
• Installing database and application products including any related tools for web based services and batch processes and related components for the web server, the application server and the database server.
• Developing and maintaining system utilities and procedures for administering the database and application systems, including backup and recovery procedures to ensure reliability and availability of the databases and applications.
• Enforcing policies and procedures to control access to administrative and production database(s).
• Developing and maintaining policies and procedures to ensure data access, integrity, and availability when changing the production database.
• Ensuring the non-production databases and application environments are maintained and available to support the development and testing activities of other IT staff and users through periodic refreshes from the production systems.
• Applying system patches and release upgrades to the database and application environments. Promotes application changes to the quality assurance and/or production environment.
• Reviewing technical release documentation relating to system patches and upgrades and advises the application team of the impact of the system changes.
• Providing specialized technical support for trouble shooting database and application performance issues
• Proactively monitoring the database and application performance to detect system problems as they arise; trouble-shoots performance issues reported through the College’s helpdesk; tracks and monitors resolution of all the reported issues.
• Performing other related duties as assigned.

About You
You are an analytical thinker and have a knack for?thinking critically?about how processes flow and how to build systems.

You have a highly?collaborative?spirit and interpersonal skills?with the?ability?to work with others to support establishing and achieving collective goals.

Your?research?and?analysis?skills will help to facilitate the measurement, interpretation and presentation of information in the most impactful way.

You enjoy balancing many different tasks, staying organized and planning and have the ability to integrate multiple streams of information, prioritize and track multiple projects to meet a demanding workload and keep things running smoothly.

You enjoy a?start-up environment?where you can support the day-to-day work while also seeing the bigger picture vision and strategy. You are comfortable with entering unchartered territory and spotting new opportunities.

The successful candidate will also meet the following qualifications:

• Minimum 3-year diploma/degree in computer science or information technology related field.
• Minimum of 8-years experience working with information systems is required, including a minimum of 5-years of administering relational databases including but not limited to Oracle within a PeopleSoft environment, and/or Microsoft SQL Server. (equivalencies to be considered)
• 3–4 years PeopleSoft Admin experience (managing the administration, configuration, and maintenance of the application server; monitoring process schedulers; monitoring the release of patches, upgrades and fixes and assessing the impact on the current environment) would be an asset.
• 2-years minimum development experience working with database technical tools and knowledge of database backup and recovery techniques, Peoplesoft Internet architecture, SQL, Unix, Linux, and Windows is an asset.
• Formal certification in Oracle or MS Sql Server database administration is desired.

Who We Are:

Every member of the Sheridan community is passionate about the transformational role we play in people’s lives. Our strategic plan, Sheridan 2027: Forging the Future (https://www.sheridancollege.ca/sheridan2027), charts a path towards a new ground-breaking model of higher education that reshapes post-secondary education and better prepares students for the future. We are committed to demonstrably advancing equity, diversity, and inclusivity. Diversity is our strength and fuels our commitment to excellence. Across our campuses, we’re making meaningful strides towards developing an equitable and inclusive community.

• For more information, visit: Why Work at Sheridan

Other Details
Faculty/Department: Information Technology
Primary Work/Campus Location: Trafalgar (may be assigned activities at any Sheridan campus)
Work Categorization: Hybrid Position – On-site at least 3 days/week
Reference #: J0424-0655
Employee Group: Support Staff
Payband: J
Hourly Range: $42.56 - $49.34
Hours/Week: 40
Hours: 8:30 am – 5:00 pm
Application Deadline: June 19, 2025
Application Details: This is a temporary position that may continue until June 28, 2027.

Sheridan is deeply committed to implementing the Calls to Action framed by the Truth and Reconciliation Commission. We acknowledge that we live and work on the traditional territory of the Mississaugas of the Credit First Nations, Anishinaabe Nation, Huron-Wendat and the Haudenosaunee Confederacy. Sheridan is situated on these lands, and it is our collective responsibility to honour and respect those who have gone before us, those who are here, and those who have yet to come. We are grateful for the opportunity to be working on this land.

Sheridan values the diverse and intersectional identities of its students, faculty, and staff. Sheridan regards equity and diversity as an integral part of academic excellence and is committed to accessibility for all employees. Sheridan seeks applicants who embrace our values of equity, anti-racism, and inclusion. As such, we encourage applications from qualified candidates who have been historically disadvantaged and marginalized, including those who identify as First Nations, Métis and/or Inuit/Inuk, Black, members of racialized communities, persons with disabilities, women and/or 2SLGBTQ+.

Sheridan will provide job applicants with accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. To request accommodation, please contact Human Resources.

You may be asked to provide copies of your educational credentials at the time of interview. Upon hire, we require official confirmation of educational credentials and Canadian equivalency assessments, if applicable.