Database Administrator (12-month Term)

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**
• *Position Responsibilities**

Maintain secure, high-performing database environments through proactive monitoring, tuning, and lifecycle management (upgrades, patches).

Manage and optimize database schemas and structures across multiple environments, including consolidation, cleanup and maintenance on transactional and data warehouse databases.

Collaborate with development and DevOps teams to integrate database changes into CI/CD pipelines and perform data modeling.

Support and oversee backup, recovery, and disaster recovery processes

Support reporting and analytics by enabling access and integrating data sources using SSRS, Power BI, SSIS, and Azure Data Factory.

Govern database security by managing roles, permissions, and scheduled jobs in alignment with organizational standards.

Maintain accurate documentation of database structures, processes, and operational procedures.

Configure and maintain monitoring and alerting systems to proactively identify and resolve issues.

Maintain an understanding of ETL workflows and reporting best practices.

• *Competencies**
• *Problem Solving**: Ability to notice small details where others may miss for the purpose of analysis; quickly consider solutions and alternatives to determine a course of action.
• *Results Orientated**: Focuses on desired outcomes, sets high expectations and pushes towards attaining milestones; looks for opportunities, and consistently moves to action.
• *Quality Orientation**: Sets high expectations for self; ensures accurate delivery of work across the team; conducts extensive discussions with peers, business units and external business partners to ensure assumptions are complete.
• *Information Seeking**: Driven by an underlining curiosity to know more about things, people, or issues; asks questions to get at the root cause of a situation or problem and understand environmental context.
• *EducationExperience**

Bachelor's degree, certificate or diploma in Computer Science, Information Technology, or related field.

Minimum 5 years of experience in database administration and management.

Strong knowledge of relational database systems on Microsoft SQL (On-premise and Azure)

Basic experience or familiarity with SSRS, Power BI, SSIS, Azure Data Factory for reporting and data integration tasks.

Experience with schema management, performance tuning, and security best practices including relational and dimensional data modeling.

Familiarity with DevOps principles and CI/CD pipelines.

Preferred certifications: Microsoft Certified: Azure Database Administrator Associate.

• *When you become a GMSer, you can expect**:

Competitive salary and bonus opportunities.

Personal and professional development initiatives.

Social events, volunteer opportunities, and a whole lot of fun.

Free coffee - yes, really! And if tea is more of your vibe, we've got that covered too!

• *Are we a fit?