Database Administrator

McGill University

  • Canada
  • 71.890-107.830 $ par an
  • Permanent
  • Temps-plein
  • Il y a 1 mois
Please refer to the 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 locationSummary: 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 DegreeExperience: Three (3) years’ related experienceSkills & 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 .Minimum Education and Experience: Bachelor's Degree 3 Years Related Experience /Annual Salary: (MPEX Grade 05) $71,890.00 - $89,860.00 - $107,830.00Job Profile: MPEX-IST2F - IT Infrastructure & Operations - Professional 2Hours per Week: 33.75 (Full time)Supervisor: Portfolio Manager System Management & Integration InfrastructurePosition End Date (If applicable): 2026-09-30Deadline 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, .

McGill University