Database Administrator

McGill University; Victoria; Hybrid; CAD 71,000 - 108,000; Full time

Job summary

A leading Canadian university in Victoria is looking for a Database Administrator to support all Database Management Systems. The candidate will manage databases, perform troubleshooting, and ensure data integrity, with an emphasis on hybrid work. Requirements include a Bachelor's degree and three years of experience in a related field. Bilingualism in English and French is preferred.

Benefits

Competitive benefits package

Defined contribution pension plan

Tuition waiver for employees and dependents

Paid time off over the December holiday period

Up to two days of remote work per week

Qualifications

• Bachelor's degree and three years related experience required.
• Experience with database management and optimization is necessary.
• Bilingualism in English and French preferred.

Responsibilities

• Troubleshoot and maintain database systems.
• Manage development, test, and production databases.
• Perform backup and recovery on Database Management Systems.

Skills

Oracle databases

Microsoft SQL databases

MySQL

Postgres

Performance tuning

Benchmarking

SQL tuning

English (spoken and written)

French (spoken)

Education

Undergraduate Degree

Job description

Overview

Please refer to the How to Apply for a Job (for External Candidates) job aid for instructions on how to apply.

If you are an active McGill employee (i.e., currently in an active contract or position at McGill University), do not apply through this Career Site. Login to your McGill Workday account and apply to this posting using the Find Jobs report (type Find Jobs in the search bar).

1 year TERM position • HYBRID mode MANDATORY

When applying please specify your current location

Summary: Support all Database Management Systems (DBMS) with specific emphasis on the daily operational administration, maintenance and security. Ensure database integrity and consistency. Establish and maintain security integrity controls.

Duties and Responsibilities

• Troubleshoot, recover, tune the database, perform software installation and upgrades, resolve errors and failures, audit activities, and resource utilization.
• Manage and maintain all development, test, and production databases.
• Assist in the design, creation, and maintenance of all on premise databases.
• Develop and support standards and physical data storage design, as well as maintenance, access, and security administration.
• Provide database quality control and auditing to ensure accurate and appropriate use of data.
• Perform backup and recovery on Database Management Systems (DBMS).
• Configure database parameters and design prototype logical data models, as well as define data repository requirements, data dictionaries, and warehouse requirements.
• Possess the ability to optimize database access and allocate/reallocate database resources for optimum configuration, database performance, and cost.
• Conceptualize, design, construct, test and implement business and technical IT solutions through application of appropriate software development life cycle methodology.
• Participate in business and technical IT solution implementations, upgrades, enhancements, and conversions.
• Prepare system documentation, establish and maintain security, integrity, and business continuity controls and documents.
• Optimize and automate routine tasks and jobs.
• Provide Level 2 and 3 technical support.
• Perform other duties as assigned.

Requirements

Education: Undergraduate Degree

Experience: Three (3) years’ related experience

Skills & Expertise

• Experience with Oracle databases, RAC and OEM.
• Experience with Microsoft SQL databases in a clustered configuration.
• Experience with MySQL, MySQL replication and clustering, Postgres and other RDBMS
• Understanding of high availability topologies such as database clusters and standby databases
• Experience with performance tuning, benchmarking and load profiling
• Experience with performance optimization including SQL tuning
• English (spoken and written), French (spoken).

Knowledge of French and English: McGill University is an English-language university where day to day duties may require English communication both verbally and in writing. The level of English required for this position has been assessed at a level # (qualifier) on a scale of 0-4.

As one of Montreal's Top Employers, here is what we offer:

• Competitive benefits package (Health, Dental, Life Insurance) (if eligible)
• Defined contribution pension plan (with employer contribution up to 10%) (if eligible)
• Group Registered Retirement Savings Plan (RRSP) and Tax Free Savings Account (TFSA)
• Competitive vacation policy
• Two (2) personal days
• Two (2) floating holidays
• Nine (9) "Summer Fridays" - paid days off between the St-Jean Baptiste holiday and Labour Day
• Paid time off over the December holiday period
• Tuition waiver for regular employees and their dependents
• Up to two (2) days of remote work per week where the position permits

Before applying, please note that to work at McGill University, you must be both authorized to work in Canada and willing to work in the province of Quebec at the campus where the position is based / located.

Knowledge of English: McGill University is an English-language university where day to day duties may require English communication both verbally and in writing. The level of English required for this position has been assessed at a level # (qualifier) on a scale of 0-4.

For a definition of our language proficiency levels, please click here.

Minimum Education and Experience

Bachelor's Degree 3 Years Related Experience

Annual Salary: (MPEX Grade 05) $71,890.00 - $89,860.00 - $107,830.00

Job Profile: MPEX-IST2F - IT Infrastructure & Operations - Professional 2

Hours per Week: 33.75 (Full time)

Supervisor: Portfolio Manager System Management & Integration Infrastructure

Position End Date (If applicable): 2026-09-30

Deadline to Apply:

McGill University hires on the basis of merit and is strongly committed to equity and diversity within its community. We welcome applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to productively engage with diverse communities. McGill implements an employment equity program and encourages members of designated groups to self-identify. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, [e-mail].