Database Administrator

Information and Innovation Solutions (IIS) Number of Positions Being Staffed: 1 Classification: GR-08 Security Clearance Required: Secret $92,635 to $114,362 Language

Requirements:
English or French Essential Open To: All employees of the Federal Public Service residing in the National Capital Region Work Arrangement: Closing Date: November 20, 2026 Special posting considerations: The intent of the process is to staff one (1) position through a term, an assignment, a secondment agreement, or the Build Canada Exchange program and, to create a pool of partially qualified candidate that may be used to staff similar term or indeterminate positions within NSERC and SSHRC. Preference will be given to Canadian citizens and permanent residents.

Who we are

This position falls within a directorate that provides common services to two funding agencies: the Natural Sciences and Engineering Research Council of Canada (NSERC) and Social Sciences and Humanities Research Council of Canada (SSHRC). The Natural Sciences and Engineering Research Council of Canada (NSERC) is Canada’s largest funder of science and engineering. A career at NSERC means supporting the visionaries, explorers and innovators who are searching for the scientific and technical breakthroughs that will advance knowledge, improve the lives of Canadians and transform the world for the better. At the Social Sciences and Humanities Research Council of Canada (SSHRC), we bring together the research community, as well as the public, private and not-for-profit sectors, in contributing knowledge, talent and expertise to build a better future for Canada and the world. SSHRC is seeking talented professionals passionate about Canadian research and the value it brings to society. Visit our career page at NSERC or SSHRC to learn more about why you should join our agency. What you will do

We are seeking an experienced and highly motivated Database Administrator (DBA) to join our Information Technology team. The successful candidate will be responsible for the administration, maintenance, security, performance, and availability of enterprise database environments. This role supports critical business applications, Business Intelligence (BI) initiatives, legacy systems, and time-sensitive award competition processes. The ideal candidate thrives in a fast-paced environment, demonstrates strong problem-solving skills, and can effectively manage competing priorities while meeting strict deadlines. Education

Graduation from a recognized post-secondary institution in computer science, information technology, or another field relevant to the position being staffed, or an acceptable combination of education, training, and/or experience. MS SQL Server certifications. (an asset) Experience administering, monitoring, maintaining, and optimizing MS SQL Server or Sybase database environments, including capacity planning, performance tuning, and troubleshooting. Experience designing, developing, and maintaining database structures and code, including tables, views, stored procedures, functions, triggers, indexes, and DDL/DML scripts. Experience implementing and maintaining database security and lifecycle management practices, including access controls, encryption, auditing, vulnerability management, patching, upgrades, and security updates. (an asset) Experience managing database availability and recoverability through backup, recovery, disaster recovery, and business continuity procedures. (an asset) Knowledge

Knowledge of Azure cloud database services and cloud-based database environments. Knowledge of data migration, data conversion, ETL processes, and system integrations, including practices to ensure data integrity, accuracy, and consistency throughout data transition activities. Knowledge of data warehousing, reporting, and analytics solutions, including query optimization, reporting performance, and operational documentation Knowledge of Sybase and legacy database environments, including the support and maintenance of legacy database systems and applications. (an asset) Knowledge of DevOps, CI/CD pipelines, and infrastructure automation. (an asset) Knowledge of enterprise database architecture and operations, including high availability, reliability, performance, security, and Azure SQL database modernization initiatives. (an asset) Communicate effectively (verbal and written) Planning and Organizing Analysis and Problem Solving Adaptability & Priority Management Initiative & Action Oriented Team oriented Client Services oriented

What we offer
Hybrid Work

Our hybrid work model facilitates flexibility, collaboration and work-life balance. We currently require employees to work from our offices 3 days a week (may be subject to change based on operational requirements), while ensuring that the needs of people who may require accommodations, are met in accordance with the Accommodation Policy. In addition to the excellent bene