Jobs
>
Kelowna

    Database Administrator - Kelowna, BC, Canada - Okanagan College

    Default job background
    Description

    OKANAGAN COLLEGE

    Okanagan College transforms lives and communities. We are one ofCanada'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:

    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.

    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:

    1. Manages the structure and content of the various Databases.
    2. Monitors and manages Databases and Operating Systems to maximize application performance.
    3. 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.
    4. Formally documents all changes to Database structure, gaining appropriate sign-off.
    5. 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.
    6. Formally documents each stage of the design, coding, testing, implementation, and change process, gaining appropriate sign-off at each stage.
    7. Uses agreed coding standards in the development of systems; recommends changes to standards.
    8. Participates in the determination of management information system's needs, coordination of user requirements, and development of an overall management system plan.
    9. 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.
    10. Participates in and provides advice to implementation teams for specific management information systems projects.
    11. 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.
    12. Ensures that security procedures are maintained and followed with respect to Databases, operating systems, management information systems and user data.
    13. 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.
    14. Participates in the planning and installation of computing facilities, Databases, and operating systems required to support management information systems.
    15. 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.
    16. Provides technical expertise, advice and consultation to peers and others, including senior managers of the organization, regarding Database systems and management information systems.
    17. Actively engages in training activities and courses in order to maintain technical currency.
    18. 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:

    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.

    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.

    Posting Opening Date:

    04/16/2024

    PostingClosing Date:

    04/28/2024

    APPLICATIONS:

    To apply for this position, please go to our employment site:

    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,

    #J-18808-Ljbffr


  • Seascape Advisory Inc Kelowna, Canada

    Education: College/CEGEP · Experience: 2 years to less than 3 years · Tasks · Design and develop database · Develop and implement data administration policy, standards and models · Research and document data requirements, data collection and administration policy, and data access ...


  • Seascape Advisory Inc Kelowna, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Develop and implement data administration policy, standards and models · Research and document data requirements, data collection and administration policy, and data access rules · Lead ...


  • Seascape Advisory Inc Kelowna, Canada

    Education: College/CEGEP · Experience: 2 years to less than 3 years · Tasks · Design and develop database · Design, construct, modify, implement and test data models and database management systems · Develop and implement data administration policy, standards and models · Researc ...


  • Seascape Advisory Inc Kelowna, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Design, construct, modify, implement and test data models and database management systems · Develop and implement data administration policy, standards and models · Research and documen ...


  • T-Net British Columbia Kelowna, BC, Canada

    Interior Health is looking for an experience Senior Database Administrator to join our team on a full time relief basis until Sept 30th 2024, working out of our Kelowna location. · In accordance with established vision and values of the organization, the Senior Database Administ ...


  • Okanagan College Kelowna, Canada

    Position Information · **Position Number** · - P02562**Position Title** · - Departmental Support Assistant**Division/Portfolio** · - Facilities Management**Department/Program** · - Facilities Administration**Location** · - Kelowna**Other Flexible Work Options** · **Your Opportuni ...


  • Mission Group Kelowna, Canada

    SALES GALLERY ADMINISTRATOR & HOST · At Mission Group we create places for people to flourish. We don't just build homes - we also work hard at building communities, careers, and opportunities. Our team members are not just employees, they are also the current and future workers, ...


  • Highstreet Kelowna, Canada

    **Are you an organized and efficient professional, known for their attention to detail?** Are you an excellent listener? Do you like taking initiative? Are you able to spot errors and inconsistencies? Do you take pride in figuring things out and solving problems? · If you answere ...


  • PHSA Kelowna, Canada

    **Clerical Support, Regional Programs,** · **Forensic Psychiatric Services - Minimum and Medium Security Units,** · **Kelowna, BC** · **As per the current Public Health Order, full vaccination against COVID-19 is a condition of employment with PHSA as of October 26, 2021.** · Und ...


  • Highstreet Ventures Inc Kelowna, Canada

    **Do you enjoy making a difference?** Are you an excellent listener who can "read between the lines"? Do you like taking initiative? Do you like to find a better way that isn't the typical way? Are you an organized and efficient professional with an interest and focus on payroll? ...


  • Blair Plumbing Heating and Air Conditioning Kelowna, Canada

    **Your Qualifications**: · - **Accounts Payable**: · - **Accounts Receivable**: · - **Data Entry**: · - Minimum 2 years administrative experience · - Positive & professional attitude · - Time management skills · - QuickBooks Knowledge (an asset) · - STRONG MS Word, Excel and Outl ...


  • Blair Plumbing Heating and Air Conditioning Kelowna, Canada

    **Your Qualifications**: · - **Accounts Payable**: · - **Accounts Receivable**: · - **Data Entry**: · - Minimum 2 years administrative experience · - Positive & professional attitude · - Time management skills · - QuickBooks Knowledge (an asset) · - STRONG MS Word, Excel and Outl ...


  • Okanagan College Kelowna, Canada

    Position Information · **Position Number** · - S00787**Position Title** · - Program Assistant, Health and Social Development**Division/Portfolio** · - Health and Social Development**Department/Program** · - Portfolio Dean's Office (P5)**Location** · - Kelowna**Other Flexible Work ...

  • Okanagan College

    Program Assistant

    12 hours ago


    Okanagan College Kelowna, Canada

    Position Information · **Position Number** · - S00640**Position Title** · - Program Assistant - Health and Social Development**Division/Portfolio** · - Health and Social Development**Department/Program** · - Portfolio Dean's Office (P5)**Location** · - Kelowna**Other Flexible Wor ...


  • Okanagan College Kelowna, Canada

    Position Information · **Position Number** · - S00379**Position Title** · - Internal Exam and Program Assistant**Division/Portfolio** · - Continuing Studies and Corporate Training**Department/Program** · - C/S Administration**Location** · - Kelowna**Other Flexible Work Options** ...


  • City of Kelowna Kelowna, Canada

    **Position Details**: · - Posting Information**Posting Number** · - CK53061P**Position Title** · - Police Services Records Clerk**No. of Staff Required** · - 5**Position Type** · - FT**If Term position, enter length of Term in months** · - N/A**Position Groups** · - CUPE Civic**D ...


  • Global Relay Kelowna, Canada

    **Who we are**: · For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveillance, eDiscovery, and analytics solutions. We securely capture and preserve the communications data of the world's most highly ...


  • Okanagan College Kelowna, Canada

    Position Information · **Position Number** · - S00379**Position Title** · - Internal Exam and Program Assistant**Division/Portfolio** · - Continuing Studies and Corporate Training**Department/Program** · - C/S Administration**Location** · - Kelowna**Other Flexible Work Options** ...


  • Kelowna Yacht Club Kelowna, Canada

    **Work Environment**: · At our lakefront location in downtown Kelowna, we provide our members with top-quality moorage in Canada's largest fresh-water marina, excellent food and beverage service, social events and opportunities to assist others in the community. As a not-for-prof ...


  • Interior Health Authority Kelowna, Canada

    Interior Health is looking for a permanent full time Manager, Housekeeping Services to join our vibrant team in Kelowna, B.C. If you are interested in expanding your career opportunities and develop your leadership skills, this is the position for you · **About the Role**: · The ...