Database Administrator

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 (ie: 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.

Bachelor's Degree 3 Years Related Experience /(MPEX Grade 05) $71,890.00 - $89,860.00 - $107,830.00

Job Profile:

MPEX-IST2F - IT Infrastructure & Operations - Professional 233.75 (Full time)Portfolio Manager System Management & Integration Infrastructure2026-09-30