Database designer Jobs in Ottawa, ON

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 Database Administrator (SQL Server / Azure SQL) position. In this role, you will support the day‑to‑day operation and continuous improvement of enterprise infrastructure across on‑premises and hybrid environments. You will help ensure systems are secure, reliable, and resilient while supporting operational, lifecycle, and automation initiatives in partnership with the IT Infrastructure Lead.

What you’ll do:

• Provide day‑to‑day operational support for enterprise infrastructure, including server and virtualization platforms, networking and voice/video, storage and backup, and database systems.
• Monitor, troubleshoot, and resolve infrastructure issues, ensuring high availability and escalating complex problems when needed.
• Support upgrades, migrations, and modernization initiatives with minimal service disruption.
• Maintain security, backup, and disaster recovery readiness, supporting patching, remediation, and testing activities.
• Use automation, tooling, and documentation to improve operational efficiency, reliability, and consistency.
• Collaborate with cross‑functional teams to support integrated services and continuous improvement.

What you should have:

• A bachelor’s degree in Information Technology, Computer Science, Engineering or a related field. An equivalent combination of education and/or experience can be considered.
• A minimum of 5 years of managing enterprise SQL database experience.
• Hands‑on experience across core infrastructure domains (networking, virtualization, storage/backup, databases).
• Experience supporting on‑premises Microsoft SQL 2005 to 2025 and Azure SQL environments.
• Knowledge of ITSM processes (incident, problem, change).
• Strong troubleshooting, automation (e.g., PowerShell), and communication skills.

Technologies:

• Microsoft SQL 2005 to 2025, Azure SQL.
• Virtualization & Compute – VMware, Hyper‑V, Nutanix.
• Cloud & Hybrid Platforms – Microsoft Azure.
• Storage, Backup & Recovery – Enterprise storage and backup solutions.
• Automation & Monitoring – PowerShell and infrastructure monitoring tools.

It would be great if you also had:

• Exposure to enterprise infrastructure environments, with experience in one or more domains such as networking, virtualization, storage/backup, or databases.
• Familiarity with regulated or security‑sensitive environments, including audit, compliance, remediation activities, and basic hybrid cloud concepts.
• Progressing industry certifications (e.g., Microsoft, VMware, Azure, networking) and ITIL Foundation or equivalent service management training are considered 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!