Senior Analyst, Database Services University of Guelph

Job title: Senior Analyst, Database ServicesCompany: University of GuelphJob description: 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 databasesPerforming database backup and recovery, patching, and security administrationMonitoring and optimizing database performance, availability, and capacityDeveloping and implementing data migration, replication, and integration strategiesTroubleshooting and resolving database issues and providing technical supportDeveloping and maintaining database documentation, policies, and proceduresParticipating in change management processes and ensuring compliance with IT standards and best practicesCollaborating with other IT teams and stakeholders on database design, development, and testingCCS 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 experienceExperience and demonstrated technical knowledge and proficiency with:Managing Microsoft SQL Server 2019 and aboveAdministering Microsoft Windows serversUsing Transact-SQL to write transactions and stored proceduresAutomation of common Windows Server and SQL Server tasks using PowerShellSQL Server performance tuning and optimizationOS and database Monitoring and troubleshooting toolsBackup, restoration, and recovery proceduresDisaster Recovery (DR) options for SQL ServerExcellent interpersonal and communication skills with ability to work effectively with both business clients and technical team membersStrong technical writing skills and a demonstrated commitment to documentationExperience working closely with developers and an understanding of their workflows and processesExpert knowledge of current and emerging trends in database systems, including experience with cloud technologies would be an assetExperience with change management processes in an enterprise environmentExcellent analytical ability and thorough understanding of large-scale information technology applications and information management practicesAbility to carry out occasional maintenance outside of regular business hours, as requiredCertification in SQL Server, with certifications in Cloud and/or Windows OS administration strongly preferredThis 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: .Why choose the University of GuelphComprehensive 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-011Classification P05**Tentative evaluation; subject to committee review.At the University of Guelph, fostering a diverse and inclusive environment 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.Expected salary:Location: Guelph, ONJob posting date: Fri, 21 Jun 2024 00:29:48 GMTApply for the job now! #J-18808-Ljbffr