Database Administrator Job at Red Deer College
Please see Special Instructions for more details.
This position will remain open until filled; however the next review of applications will begin on November 9, 2022.
Posting Details
Position Information
Position Title
Database Administrator
Position Summary
Red Deer Polytechnic is seeking a permanent full-time Database Administrator to join the Information Technology team.
This role provides expertise in Oracle and SQL Databases, Oracle Application Servers and the ERP system (Banner) to the Red Deer Polytechnic Community.
This role provides expertise in Oracle and SQL Databases, Oracle Application Servers and the ERP system (Banner) to the Red Deer Polytechnic Community.
The primary responsibilities of this role would include:
- Tracking and resolving database related incidents and requests
- Fulfilling requests and resolving incidents
- Reviewing service-related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved
- Responding to database related alerts and working with the ITS team to come up with solutions to recurring problems.
This position requires an individual with strong customer service focus and initiative in order to ensure that problems and requests assigned are managed and resolved in a timely manner.
The incumbent must establish and maintain communication with end-users, IT staff, Contractors, vendors and other industry contacts to keep them updated on their requests, initiate and perform changes on production systems and proactively deal with any issues that occur.
Position Responsibilities
Oracle and
SQL
Database Support
- Monitor performance of Oracle and SQL Databases & database servers.
- Perform maintenance, upgrades, patches & defect fixes as needed/requested in test and production environments.
- Troubleshoot and resolve issues as they arise with assistance of ITS staff and/or vendors
- Collaborate and communicate with end-users to ensure maintenance, upgrade and problem resolution is carried out effectively and in a timely manner.
- Ensure Data Integrity and Reliability including a Disaster Recovery Plan by maintaining/monitoring daily backups and data recovery procedures.
Banner Support
- Ensure Banner ERP components are properly maintained, upgraded and available on all servers supporting the Banner ERP.
- Perform upgrades, maintenance, patch & defect fixes for Oracle that affect the Banner ERP.
- Create and Maintain Oracle accounts for Banner Application security and access.
- Collaborate and communicate with end-users to ensure maintenance, upgrade and problem resolution is carried out effectively and in a timely manner.
- Act as Subject Matter Expert on all Oracle and Banner ERP technical aspects.
Third Party Software Support
- Perform upgrades, maintenance, patch & defect fixes for any third-party software components that lives within or interacts with the Oracle databases or the ERP (banner).
- Ensure connectivity and security of the application to Oracle is properly maintained, upgraded and available.
- Collaborate and communicate with end-users, IT staff and vendors to ensure implementation, maintenance, upgrades and problem resolutions are carried out effectively and in a timely manner with all systems and applications that touch banner in any way.
Required Qualifications
- Two (2) years of post-secondary training, completion of a community college certificate including trades apprenticeships or equivalent
- Required to have a minimum of 5 years Oracle Database and Apache Tomat Administration experience
- Experience with Linux server administration and scripting
Preferred Qualifications
- Four (4) year undergraduate degree, or three (3) year undergraduate degree plus one full additional year of university in a related program representing four years of study or equivalent
- Banner experience an asset
- Oracle Certified Professional (OCP) Designation an asset
- Experience with Automation tools an asset
Salary or Hourly?
Salary
Salary
$77,716 - $90,914 annually
Benefits and Compensation Information
Red Deer Polytechnic offers a comprehensive benefits package including extended health and dental care through Blue Cross, access to a health spending account, pension plan, Employee & Family Assistance Program, generous vacation allotments, credit tuition waivers and opportunities for professional development funding. Additional time off due to Institution closures between Christmas and New Year general holidays. *Eligibility to access the above mentioned benefits dependent upon the AUPE Collective Agreement and related RDP policies.
About Red Deer Polytechnic
Red Deer Polytechnic has been a pivotal part of central Alberta for nearly six decades. Since our story began as Red Deer College in 1964, we have proudly served our learners and communities with diverse programs, as well as impressive learning spaces and facilities.
In the spring of 2021, our institution was officially granted status as a polytechnic, and our
new name and
brand were announced soon after. As Red Deer Polytechnic, we will continue to offer the same breadth of credentials and mix of
programs in a variety of subject areas that we currently offer. This means we will continue to offer apprenticeships, certificates, degrees, micro-credentials, and collaborative degrees, in addition to our own applied and baccalaureate degrees.
We welcome you to further your career with Red Deer Polytechnic. We also welcome you to join us as a vibrant gathering place creating connections in our community. With
two campuses and impressive
facilities, Red Deer Polytechnic is an ideal place to learn,
work,
conduct research and enjoy
events.
Whatever brings you to Red Deer Polytechnic, we are glad you are here. And we look forward to having you as a valued member of our polytechnic community.
Posting Detail Information
Competition Number
2022-A-114
Employment Type
Permanent Full-Time
Number of Vacancies
1
Desired Start Date
11/28/2022
Position End Date (if term-certain)
FTE
1.0
Hours of Work
8:30 a.m. to 4:30 p.m., Monday to Friday, 35 hours per week
Open Date
09/15/2022
Close Date
Open Until Filled
Yes
Note to Applicant
All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority.
This position is eligible for a combination of on-campus and remote work.
This position is eligible for a combination of on-campus and remote work.
Special Instructions to Applicants
This position will remain open until filled; however the next review of applications will begin on November 9, 2022.
Required Documents
Optional Documents
- Cover Letter
- Resume
- References Names and Contact Information
Please Note :
nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.