Job title: Senior Analyst, Database Services
Company: University of Guelph
Job 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 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 in 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: .
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**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, ON
Job posting date : Fri, 21 Jun 2024 00:29:48 GMT
Apply for the job now!
#J-18808-Ljbffr