Senior analyst, database services #2024-0313

5 days ago


Guelph, Canada University of Guelph Full time
Home Careers @ Guelph Current Opportunities Senior Analyst, Database Services Senior Analyst, Database Services

Forbes Ranks U of G Among Canada's Top Employers
Professional and Managerial Group

Senior Analyst, Database Services Computing and Communications Services (CCS)

Hiring #: 2024-0313

Please read the Application Instructions before applying

Computing and Communications Services (CCS) is the central IT department at the University of Guelph, providing core IT services and technology solutions to the U of G community. CCS has a progressive organizational culture, including a strong learning and development focus, and is committed to its Core Values: Service Culture, Integrity, Individual Leadership, Teamwork, Agility, and Communication.

Reporting to the Manager, Systems Management, the Senior Analyst, Database Services will play a critical role supporting the University’s Database systems and Information Management processes and implement solutions to meet the needs of our University of Guelph communities and partners.

The successful candidate will be tasked with:

  • Installing, configuring, and maintaining SQL Server databases
  • Performing database backup and recovery, patching, and security administration
  • Monitoring and optimizing database performance, availability, and capacity
  • Developing and implementing data migration, replication, and integration strategies
  • Troubleshooting and resolving database issues and providing technical support
  • Developing and maintaining database documentation, policies, and procedures
  • Participating in change management processes and ensuring compliance with IT standards and best practices
  • Collaborating with other IT teams and stakeholders on database design, development, and testing
  • CCS projects including determining resource requirements, assigning project tasks, and reporting progress to management and/or partners and clients.

Requirements of the position include:

  • Bachelor’s degree in Computer Science/Information technology and a minimum of 5-6 years of related database administration experience, or an equivalent combination of education and experience
  • Experience and demonstrated technical knowledge and proficiency with:
    • Managing Microsoft SQL Server 2019 and above
    • Administering Microsoft Windows servers
    • Using Transact-SQL to write transactions and stored procedures
    • Automation of common Windows Server and SQL Server tasks using PowerShell
    • SQL Server performance tuning and optimization;
    • OS and database Monitoring and troubleshooting tools;
    • Backup, restoration, and recovery procedures;
    • Disaster Recovery (DR) options for SQL Server
  • Excellent interpersonal and communication skills with ability to work effectively with both business clients and technical team members
  • Strong technical writing skills and a demonstrated commitment to documentation
  • Experience working closely with developers and an understanding of their workflows and processes
  • Expert knowledge of current and emerging trends database systems, including experience with cloud technologies would be an asset
  • Experience with change management processes in an enterprise environment
  • Excellent analytical ability and thorough understanding of large-scale information technology applications and information management practices
  • Ability to carry out occasional maintenance outside of regular business hours, as required.
  • Certification in SQL server, with certifications in Cloud and/or Windows OS administration strongly preferred

This position currently involves elements that must be performed on-campus as well as elements that can be conducted remotely. More information regarding the flexible work policy can be found here: 520 Flexible Work Arrangements (Non-Academic Staff) | Human Resources (uoguelph.ca).

Why choose the University of Guelph

  • Comprehensive Extended Health Care Benefits: Immediate enrollment in extended health to cover yourself and your family.
  • Time off: Strong vacation allocation, floater days, and paid time off during the December closure to ensure that you are at your best.
  • Wellness: In addition to extensive wellness programming, the University offers a yearly flexible spending credit that can be allocated to any of the following: Health Spending, Wellness or Professional Development.
  • Learning & Development: Learning and development curriculum and other professional growth opportunities.
  • On-campus Activities: Discounts on food and apparel, fitness programming, access to networking events and team building opportunities.
  • Improve Life: Work that directly impacts a brighter future by turning knowledge into action.

Kindly ensure a comprehensive application by submitting both a cover letter and attaching your resume when applying for the position.

Position Number 686-011
Classification P05*
Professional/Managerial Salary Bands

*Tentative evaluation; subject to committee review.
At the University of Guelph, fostering a culture of inclusion is an institutional imperative. The University invites and encourages applications from all qualified individuals, including from groups that are traditionally underrepresented in employment, who may contribute to further diversification of our Institution.

Posting Date: 2024 06 19
Closing Date: 2024 07 03

Search form Search Human ResourcesSearchSearch Current Opportunities
  • Animal Housing
  • Pharmacy Technician
  • Registered Veterinary Technician (Large Animal Ward)
  • Client Services Clerk
  • Dispatcher
  • Food and Hospitality Services Assistant
  • Casual Campus Safety Attendant
  • Hospital Assistant
  • Radiation Therapist (RT)
  • Registered Veterinary Technician
  • Medical Device Reprocessing Technician
  • 3rd Cook
  • Academic Program Assistant
  • Administrative Assistant to the Chair
  • Assistant Vice-President, School of Continuing Studies
  • Associate Vice President, Advancement
  • Custodian
  • Decision Support Consultant
  • Delivery/Materials Handler
  • Education Abroad Advisor
  • Manager, Graduate Curriculum
  • Manager, Guelph Food Innovation Centre
  • Manager, Veterinary Clinical Skills Learning
  • Medical Lead
  • Portfolio Manager
  • Research Technician I, Centre for Biodiversity Genomics - Analytics Unit
  • Second Class Operating Engineer
  • Senior Analyst, Database Services (current page)
  • Senior Development Manager
  • Senior Human Resources Consultant (Staff Relations)
  • Writing Specialist (English Language Support)
Printer-friendly versionPDF version Share this page
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Print this page
#J-18808-Ljbffr

  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Senior Analyst, Database Services Senior Analyst, Database Services Forbes Ranks U of G Among Canada's Top Employers Professional and Managerial Group Senior Analyst, Database Services Computing and Communications Services (CCS) Hiring #: 2024-0313 Please read the Application Instructions before applying Computing...


  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Senior Development Manager Senior Development Manager Forbes includes U of G Among Canada’s Best Employers Professional and Managerial Group Senior Development Manager Alumni Affairs and Development, Ontario Veterinary College Hiring #: 2024-0321 Please read the Application Instructions before applying At the...


  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Senior Development Manager Senior Development Manager Forbes includes U of G Among Canada’s Best Employers Professional and Managerial Group Senior Development Manager Alumni Affairs and Development, Ontario Veterinary College Hiring #: 2024-0321 Please read the Application Instructions before applying At the...


  • Guelph, Ontario, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Budget Analyst Budget Analyst Forbes includes U of G Among Canada's Best Employers Professional and Managerial Group Budget Analyst Budget and Financial Planning Office Three (3) positions Hiring #: Please read the Application Instructions before applying This regular, full-time position is an exciting...

  • Analyst, Database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: Temporary - Work Language: English - Hours: 30 hours per week - Education: Bachelor's degree - Experience: 5 years or more - or equivalent experience **Work setting**: - Willing to relocate - Consulting firm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement...


  • Guelph, Canada Linamar Corp Full time

    Senior, Financial AnalystThe Senior Financial Analyst position, reporting to the Consolidations Manager, is responsible for conducting and documenting complex financial analysis. Additional responsibilities include providing functional advice and training to the Financial Analysts and Co-op students


  • Guelph, Ontario, Canada Linamar Corp Full time

    Senior, Financial AnalystThe Senior Financial Analyst position, reporting to the Consolidations Manager, is responsible for conducting and documenting complex financial analysis. Additional responsibilities include providing functional advice and training to the Financial Analysts and Co-op students

  • Database Assistant

    2 days ago


    Guelph, Canada United Way Guelph Wellington Dufferin Full time

    **Position Overview** Reporting to the Systems & Database Manager, your work will ensure effective donor data capture and quality. You will assistant with importing and inputting data, data maintenance and clean up, and support for the development of online donation pages. This behind the scenes role provides vital support in ensuring we have data we can...

  • Analyst, Database

    2 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: Temporaire - Langue de travail: Anglais - Heures de travail: 30 hours per week - Education: - Expérience: **Education**: - Bachelor's degree - or equivalent experience **Work setting**: - Willing to relocate - Consulting firm **Tasks**: - Data Science - Design and develop database - Collect and document user's requirements - Write,...

  • Analyst, Database

    1 week ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Work Term: Temporary Work Language: English Hours: 30 hours per week Education: Bachelor's degree Experience: 5 years or more- or equivalent experienceWork setting: Willing to relocate Consulting firmTasks: Collect and document user's requirements Data Science Design and develop database Design, construct, modify, implement and test data models and database...

  • Research Analyst

    4 weeks ago


    Guelph, Canada Agricorp Full time

    Agricorp is looking for a **Research Analyst **to join our Program Development division. **The Role**: The Research Analyst provides expertise in the interpretation and synthesis of agricultural business knowledge and complex data using analytical methods, turning complex data into a useful format to enable decision-making. The Research Analyst also manages...

  • Research Analyst

    21 hours ago


    Guelph, Canada Agricorp Full time

    Agricorp is looking for a **Research Analyst **to join our Program Development division. **The Role**: The Research Analyst provides expertise in the interpretation and synthesis of agricultural business knowledge and complex data using analytical methods, turning complex data into a useful format to enable decision-making. The Research Analyst also manages...

  • analyst, database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...

  • analyst, database

    1 week ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...

  • analyst, database

    3 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...


  • Guelph, Ontario, Canada Dean Group Full time

    Position: Senior Global Compensation Analyst / Total Rewards Type: Hybrid 2 X per month in the Guelph or Toronto downtown office Our client a Canadian owned firm in the manufacturing and engineering sector with offices worldwide is searching for an experienced Senior Compensation Analyst with global compensation experience due to a promotion. Must have...

  • analyst, database

    3 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: TemporaireLangue de travail: AnglaisHeures de travail: 30 hours per weekEducation: Expérience: EducationBachelor's degree or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate...

  • analyst, database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: TemporaireLangue de travail: AnglaisHeures de travail: 30 hours per weekEducation: Expérience: EducationBachelor's degree or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate...

  • Analyst, Database

    1 week ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: Temporaire Langue de travail: Anglais Heures de travail: 30 hours per week Education: Expérience:Education: Bachelor's degree- or equivalent experienceWork setting: Willing to relocate Consulting firmTasks: Data Science Design and develop database Collect and document user's requirements Write, modify, integrate and test software code...


  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities HR Services Assistant HR Services Assistant Forbes includes U of G Among Canada’s Best Employers Professional and Managerial Group HR Services Assistant Human Resources Temporary full-time from July 1, 2024 to July 1, 2025 Hiring #: 2024-0311 Please read the Application Instructions before applying The Human...