Location
Kelowna, BC | Canada
Job description
Position Information
Position Number S00430
Position Title Database Administrator
Division/Portfolio IT Services
Department/Program IT Solutions
Location Kelowna
Other Flexible Work Options Eligible for Hybrid Work
Your Opportunity Under the direction of Manager, Software & Enterprise Systems, the Database Administrator is responsible for the active management of Okanagan College’s Databases and support of associated applications. Responsibilities include support of systems development from the design phase through to delivery and management of the systems hosting the designated Databases and related applications; and performs other related duties as required
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.
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.
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
Preferred Qualifications Desired Start Date 03/11/2024
Position End Date (if temporary) Schedule Monday – Friday: 8:00am – 4:00pm (negotiable)
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
Appointment Type Support - Regular Full-time
Special Instructions to Applicants Shortlisted internal candidates must notify the current Support Staff Bargaining Chairperson and People Services if they want a Union Observer during interviews and final selection of candidates
Employee Group Support
Job tags
Salary
$64.1k - $73.2k per year