Sql dba Jobs in Regina, SK

At GMS, we've been helping Canadians for more than 75 years to get the health and travel insurance they want and need. The same pioneering spirit that started our story is what drives us to do things differently today. Insurance, honestly, is our promise, and it's what we do at GMS. We care about our customers, our community and each other. As a non-profit organization, we're proud to reinvest our profits into the health of the communities we serve and that have supported us since 1949.

We want our employees to feel good about coming to work and being in a workplace that promotes flexibility, growth and a healthy work-life balance. If you'd like to be part of a team that truly takes care of our customers, our communities, and each other, this could be your chance.

Here's the role

GMS is excited to offer a 12-month term opportunity to join our Information Technology team. The IT Cloud Administrator will play a key role in supporting and maintaining legacy IT systems while contributing to the development of cutting-edge cloud technologies and modern data services on Microsoft Azure. As an IT Cloud Administrator, you will be pivotal in supporting GMS's hybrid network infrastructure and addressing data-related issues and business-as-usual (BAU) reports. This role offers the opportunity to collaborate closely with Data Engineers, Application Developers, Network and System Administrators, and other key stakeholders, driving impactful solutions across the organization.

Position Responsibilities

• Maintain and support GMS's on-premises network and firewall infrastructure.
• Maintain, troubleshoot, repair and administer local area networks (LANs), wide area networks (WANs), computer workstations, connections to the Internet and peripheral equipment.
• Implement network traffic and security monitoring software and optimize server performance.
• Provide troubleshooting and problem-solving support for network users.
• Assist in maintaining and supporting GMS's cloud network solutions and services.
• Contribute to safeguarding cloud-based applications from data breaches and cybersecurity threats.
• Resolve data-related issues and produce ad-hoc reports to meet business requirements.
• Assist in maintaining and updating data pipelines to accommodate business growth and evolving operational needs.
• Support the development and optimization of SQL scripts, including stored procedures and triggers, within GMS's databases.
• Assist in creating data flows, pipelines, and SQL scripts within GMS's cloud environment.
• Assist in maintaining and supporting the Data Warehouse and SSRS reports.
• Document data standards, rules, and quality checks to improve ETL processes.
• Perform Active Directory tasks such as password reset, and account unlock.
• Manage hardware inventory for end-user devices and maintain configurations for internal staff.
• Troubleshoot and resolve issues related to end-user systems and cloud services.
• Collaborate with IT team members to improve system reliability, scalability, and performance.

Competencies

Education & Experience

Are we a fit?

If you think so, please apply by February 6, 2025 . We'd love to reach out to everyone who applies, but we just don't have enough hands! If you're selected for an interview, we'll be in touch. If not, please consider us again in the future.