Database Administrator

About MRU

Founded in 1910 and located in Calgary, Alberta, Canada, Mount Royal University grew into a vibrant college in the 1930s and became a mid-sized university in 2009. Mount Royal has carved out a distinct niche by offering smaller class sizes, a robust liberal education and unique undergraduate programs. Currently, more than 15,000 credit students choose from 13 bachelor’s degrees and 38 majors.

Mount Royal University is located in the traditional territories of the Niitsitapi (Blackfoot) and the people of the Treaty 7 region in southern Alberta, which includes the Siksika, the Piikani, the Kainai, the Tsuut’ina and the Iyarhe Nakoda. We are situated on land where the Bow River meets the Elbow River. The traditional Blackfoot name of this place is “Mohkinstsis,” which we now call the city of Calgary. The city of Calgary is also home to the Métis Nation.

Mount Royal University is committed to removing barriers and fostering the inclusion of voices that have been historically underrepresented or discouraged in our society. In support of our belief that diversity in our faculty and staff enriches the work, learning and research experiences for the entire campus community, we strongly encourage members of the designated groups (women, Indigenous Peoples, persons with disabilities, members of visible minorities, and diverse sexual orientation and gender identities) to apply and self-identify.

 

About the Department of Information Technology Services

Mount Royal University’s Information Technology Services supports our mission by providing technical support, solutions, and diversified services to the Mount Royal community.

 

About the Role

The Database Analyst, with the guidance of the Database Administrator Lead, is responsible for all aspects of database management, including planning, implementation, configuration, support, usage monitoring and tuning. The position is responsible for internal support of data integrity, security and reliability issues within the Oracle and SQL Server database environments. The position is responsible for implementing backup and recovery procedures, maintaining system documentation and logs and assisting in troubleshooting and diagnosing production problems.

This person will work with the Application Services and Infrastructure teams to ensure that proper security and networking requirements are met to support the University’s ERP (BANNER) and all other administrative systems. This position will also be responsible for managing data access permissions to ensure the security of the University’s data.

This position is a full-time role working 35 hours per week.

Responsibilities

• Perform the administration and maintenance of databases in a Linux and Windows environment
• Establish and maintain sound backup and recovery procedures
• Monitoring databases and reviewing performance logs for issues before they become problems
• Assisting with scheduled operational disruptions
• Assist with the development and implementation of project plans
• Optimizing database performance where required
• Installation, configuration and upgrading of Oracle and SQL-Server server software and related products
• Evaluate Oracle and SQL-Server features and related products
• Capacity planning
• Training and professional development related to the position
• Work as part of a team and provide out-of-hours support when required
• Interface with vendors for technical support
• Develop metrics to evaluate system usage and effectiveness
• Implement/development of database management tools

Qualifications

• Post-secondary education with an emphasis on computer information systems or computer science
• Minimum one to three years experience or specific job training
• Education specific to database administration
• Knowledge of patching, upgrading, tuning, and supporting Oracle in a multi-instance database environment
• Knowledge of RMAN and SQL-Server backup and recovery
• Oracle Real Application Cluster experience is desired
• Oracle Grid Control experience is desired
• ASM storage management experience is desired
• SQL skills are desired
• Ability to multi-task and prioritize workload
• Professional integrity and behaviour
• Ability to create technical documentation
• Ability to learn new skills and how to most effectively deploy them
• Strong analytical and critical thinking skills to troubleshoot and perform root cause analysis on technical problems and solution design
• Ability to work effectively with a team or independently.
• Good communication so as to effectively interact with technical and non-technical peers
• Effective organizational skills to plan, prioritize and complete multiple concurrent tasks

Education

• Three or Four Year Bachelor Degree or Equivalent / Database Administration Program Graduate

What We Offer

Talented and committed employees are the driving force behind student success. We strive to be an employer of choice among Canadian post-secondary institutions.

At Mount Royal University, we recognize that people are a combination of many intersecting identities; we work to cultivate an environment that welcomes the whole person and harnesses the strength that is available in our diversity, creating a rich and inclusive workplace.

Investing in the learning and development of our employees benefits the individual and the University. A variety of services, resources and programs encourage a healthy, productive workplace. Mount Royal University offers a competitive total compensation package including health and dental benefits, pension, health and personal spending accounts, paid vacation, winter holiday closure, personal days and free membership in our fully equipped recreation centre.

Our campus offers the convenience of a full medical clinic, dentist and pharmacy, as well as a variety of wellness services such as physiotherapists and massage therapists. Campus Recreation offers many activities, including personal training, climbing, aquatics, sports and certifications for students, employees and the public.

Union: MRSA

Position Class: SDB01 Database Analyst I

Salary: $75,507 – $95,530 per year

Closing Date: Open until a suitable candidate found

A cover letter and resume should be submitted in one .pdf document. Please title your .pdf document as follows: [Last Name], [Requisition Number], [Document Title].pdf (ex. Smith, 999999, CV.pdf).

 

All qualified candidates are encouraged to apply; however, Canadian citizens and permanent residents will be given priority.

 

Recent Mount Royal graduates who are foreign nationals may be eligible to work on campus. Please refer to the Citizenship and Immigration Canada website under Post-Graduation Employment at http://www.cic.gc.ca/english/study/index.asp.