Job Requisition ID: 11967

Position Status: Permanent Full Time

Position Type: Hybrid

Office Location: Montreal (QC); Ottawa (ON)

Travel Requirement: Limited

Language Designation: English Essential

Language Skill Levels (Read/Write/Speak): ZZZ

Security Requirement: Secret

Salary: Our salaries generally range from $ 104,180.28 to $ 130,225.36 and are based on qualifications and experience.

About CMHC

The work you do and the work we do together matters. We come to work every day with a common purpose: to contribute to a well-functioning housing system.

At CMHC, we hold ourselves accountable for our results and support our colleagues in their achievements. We thrive on collaboration, connecting across CMHC and involving the right people to get our work done. Our leadership style is guided by trust, where our leaders favour an adaptive approach based on the needs of their teams.

Join us and be part of a team that's committed to making a real difference and be part of something meaningful.

What’s in it for you

We’ve got the purpose, the people and the perks you need for a fulfilling career. Here’s the comprehensive and generous benefits you get when you’re a permanent employee:

• Annual Paid vacation.
• Annual individual performance incentive.
• Defined benefit pension plan.
• Comprehensive group insurance plan to support your well-being from day one.
• Support towards your personal and professional growth with training, mentorship and more.
• An inclusive workplace culture and environment.
• While positions at CMHC require some in-office presence, alternative work arrangements may be considered for Indigenous candidates.

About the role

Join the Infrastructure and Operations team in the Senior Specialist, Database Administrator (SQL Server / Azure SQL) position. You will be responsible for supporting the stability, security, and continuous improvement of enterprise infrastructure services across on‑premises and hybrid environments. You will act as a senior technical authority providing hands‑on expertise, leading complex operational support and modernization initiatives, and ensuring infrastructure services remain reliable, recoverable, and aligned with enterprise architecture, cybersecurity, and ITSM standards.

What you will do:

• Operate, administer, and support MS SQL and Azure SQL database platforms.
• Proactively monitor, analyze, and optimize infrastructure health, performance, capacity, and availability to prevent service disruptions.
• Lead and resolve complex infrastructure incidents and problems, acting as a senior technical escalation point and performing root cause analysis in accordance with ITSM practices.
• Plan and execute infrastructure lifecycle and modernization initiatives, including platform upgrades, workload migrations, and data center or cloud‑adjacent transformations.
• Provide expert technical input into the design and implementation of new infrastructure capabilities, ensuring solutions are secure, scalable, and operationally viable.
• Implement and maintain security controls, backup, recovery, and disaster recovery capabilities, including testing, validation, and vulnerability remediation.
• Develop and maintain automation, tooling, and technical documentation to improve operational efficiency, consistency, and resilience.
• Collaborate across IT teams, provide mentorship and knowledge transfer, and act as a trusted technical advisor contributing to continuous improvement and service excellence.

What you should have:

• A bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field. An equivalent of education and/or experience can be considered.
• A minimum 7 years of experience in enterprise IT database administration roles.
• A senior‑level, hands‑on expertise , databases administration, optimization and support.
• Experience supporting on‑premises and hybrid cloud environments.
• Strong knowledge of ITSM processes (incident, problem, change).
• Advanced troubleshooting and scripting/automation skills (e.g., PowerShell) with strong communication ability.

Technologies:

• Compute & Virtualization: VMware, Hyper‑V, hyperconverged platforms (e.g., Nutanix)
• Storage, Backup & Databases: Enterprise storage and backup solutions; MS SQL Server, DB2, Azure SQL

It would be great if you had:

• Experience supporting regulated or security‑sensitive environments, with ITIL or equivalent service management exposure.
• Exposure to cloud platform operations and integration with on‑premises infrastructure.
• Familiarity with enterprise architecture principles and infrastructure standardization initiatives.
• Industry certifications in infrastructure technologies (e.g., Microsoft, VMware, Azure, networking, backup, or database platforms) are considered as assets.

Posting closing date: Note, the competition will remain active until filled.

Standby and Call Back duties are a requirement of this position and will be subject to CMHC policies, including the Standby and Call Back Pay Procedure.

Our commitment to diversity, equity, and inclusion

We’re committed to employment equity and encourage women, Indigenous Peoples, persons with disabilities, veterans and persons of all races, ethnicities, religions, abilities, sexual orientations, and gender identities and expressions to apply. We also welcome applications from non-Canadians who are eligible to work in Canada.

CMHC is an inclusive workplace where diversity of thought – and of people – are recognized, valued, and considered essential to achieving our mission.

Learn more about our commitment to diversity and inclusion

What happens after you apply

We know that applying for a new job can be both exciting and daunting, and we appreciate your effort. Learn more about our hiring process. If you are selected for an interview or testing, please advise us if you require an accommodation.

If you applied before and you were not successful don’t worry – we're always posting new positions, so don’t hesitate to give it another shot. We’re excited to see what you bring to the table this time around!