Description
OKANAGAN COLLEGE
Okanagan College transforms lives and communities. We are one of Canada’s leading colleges. We create outstanding educational experiences for our learners, both students and employees. We work and learn in a welcoming and caring culture. We are a catalyst for change through collaboration with our learners and partners. We serve, lead and anticipate the social, economic and environmental needs of communities.
Position Title:
Database Administrator
Competition Number:
C002778
Division/Portfolio:
IT Services
Department/Program:
IT Solutions
Campus/Centre:
Kelowna
Flexible Work Options:
Eligible for Hybrid Work
Your Opportunity:
Education and Experience:
- A 4-year university degree in Computer Science, Information Technology, or a related field.
- Six years and up to and including 8 years of progressive directly related experience.
Functions and Duties:
- Manages the structure and content of the various Databases.
- Monitors and manages Databases and Operating Systems to maximize application performance.
- Formally plans and schedules upgrades to the Databases and the applications residing within them in conjunction with operational and user staff. Formally plans and schedules upgrades to the operating systems hosting the Databases.
- Formally documents all changes to Database structure, gaining appropriate sign-off.
- Develops design, coding, and testing applications for planned system enhancements, codes, tests, and readies for implementation of the recurring system changes, including data integration processes with other systems, to ensure seamless flow of information, as well as recurring jobs for data synchronization and reporting.
- Formally documents each stage of the design, coding, testing, implementation, and change process, gaining appropriate sign-off at each stage.
- Uses agreed coding standards in the development of systems; recommends changes to standards.
- Participates in the determination of management information system’s needs, coordination of user requirements, and development of an overall management system plan.
- Participates in the ongoing maintenance of a strategic plan, development of detailed specifications, and the selection and acquisition or development for computerized management information systems.
- Participates in and provides advice to implementation teams for specific management information systems projects.
- Provides effective administration and operation of SQL Databases and supporting operating systems in support of management information systems, ensuring high availability and performance, through regular performance tuning, troubleshooting, and proactive monitoring of Database systems.
- Ensures that security procedures are maintained and followed with respect to Databases, operating systems, management information systems and user data.
- Participates in the provision of training and support for users of management information systems. This includes the development and maintenance of manuals, documentation, and operating instructions.
- Participates in the planning and installation of computing facilities, Databases, and operating systems required to support management information systems.
- Participates in the coordination of Okanagan College Management Information System activities with the activities of other Colleges and Institutions, Centre for Education Information Standards and Services, software vendors and in the management of standards and vendor contracts.
- Provides technical expertise, advice and consultation to peers and others, including senior managers of the organization, regarding Database systems and management information systems.
- Actively engages in training activities and courses in order to maintain technical currency.
- Performs other related duties as required.
Skills and Abilities:
- Relational Database Administration.
- Proficiency in SQL query development and fine-tuning.
- Experience with data integration and daily job management.
- Ability to manage database backups and restorations.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration skills.
- Proficiency in PL/SQL jobs and Operating System scripting.
- Experience supporting Ellucian Banner ERP upgrades and the installation, configuration and validation of new modules and underlying data.
- Data Lake implementation and operations.
- Familiarity with administrating both on-prem and Cloud hosted Databases.
- Experience in AWS Relational Database Service & Backups, and Non-SQL Databases
Appointment Type:
Support – Regular Full-time
Appointment Start Date:
05/13/2024
Schedule:
Annual Salary/Hourly Rate:
$64,100 – $73,200. NOTE: In addition to the annual salary, a $10,000 annual labour market stipend applies to this position.
Special Instructions to Applicants:
Posting Opening Date:
04/16/2024
Posting Closing Date:
04/28/2024
How to Apply
APPLICATIONS:
To apply for this position, please go to our employment site: https://www.employmentopportunities.okanagan.bc.ca and complete an on-line application.
All applications must be submitted through our employment site to be considered.
Okanagan College is committed to increasing the equitable and inclusive participation of marginalized people in all aspects of college life. We welcome and encourage applications from Indigenous Peoples, Black People, members of racialized groups/visible minorities, people with disabilities and people with diverse gender identities or expressions. People with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, AccessibilityHR@okanagan.bc.ca