Database Administrator

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.

What you need to succeed

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 Azure certifications. (an asset)
• MS SQL Server certifications. (an asset)
• Foreign Credential Validation against Canadian Standards

Experience

• 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)

Competencies

• 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.

Excellent benefits

In addition to the excellent benefits provided by the federal government, you will also enjoy benefits unique to NSERC/SSHRC, including an annual office closure between December 25 and January 1 to support rest and spending time with family and friends over the holiday season. 

Equity, diversity and inclusion

We are committed to inclusive and barrier-free recruitment to create a workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.

We welcome all candidates, and encourage applications from women, Indigenous Peoples (First Nations, Métis and Inuit), veterans, persons with disabilities, Black and other racialized persons, persons of ethnic origins, diverse religions, abilities, sexual orientations, gender identities and expressions, and members of the 2SLGBTQIA+ community.

Accommodation

Let our team know if you require accommodation or support during the recruitment process by contacting us at recruiting@nserc-crsng.gc.ca.

What you need to know

• The intention of this process is to establish a pool of partially and fully qualified candidates that may be used to staff indeterminate or term positions at NSERC and SSHRC.
• Priority will be given to Canadian citizens and permanent residents. 
• A written examination may be administered.
• 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 the Social Sciences and Humanities Research Council of Canada (SSHRC).

We wish to thank all applicants for their interest in applying for this position. Acknowledgment of receipt of applications will be sent to all applicants however, only candidates selected for exams or interviews will be contacted.

If you have technical difficulties when applying for this position, please contact the Njoyn Support Team by email at candidate.njoynhelp@cgi.com or by calling 1-877-427-7717.

If you require additional information on the position, please contact us at recruiting@nserc-crsng.gc.ca.