Saturday , February 4 2023

CSIS Jobs – Database Administrator

Website CSIS

Job Description:

The Canadian Security Intelligence Service (CSIS) is looking for a Database Administrator to join our talented database team in support of our mandate to ensure the safety of all Canadians. This position is responsible for the availability, integrity, accessibility and performance of all the database systems at CSIS by supporting, enhancing, administering and maintaining our corporate databases.

Job Responsibilities:

  • Perform database reorgs, statistic updates and other applicable utilities to ensure proper database function and performance.
  • Perform problem investigation, resolution and provide support for applications and developers
  • Hands-on experience of managing SQL server
  • Execute Database recovery procedures in case of either Hardware or Software problems.
  • Create and maintain database structures
  • Provide and maintain jobs/scripts in support of maintaining the physical aspects for the databases and the database management systems
  • Migration of new and/or changed database objects into the various environments.
  • Significant experience migrating/updating databases and their associated applications.
  • Implement requirements for backup and recovery and ensure successful nightly recoverable backups of all databases
  • Provide recommendations on application design guidelines for database access
  • Maintain and implement database security
  • Perform ETL design, generation and implementation for the management of application data
  • Perform database space management and monitoring
  • SQL product installation, maintenance and configuration
  • Monitor and tune databases to ensure optimal performance based on database and operating statistics

Job Requirements:

  • Experience with data modeling such as designing, creating or modifying physical database models.
  • Three (3) years of recent experience using database principles (design, security, types of objects and when to use them)
  • Experience with implementing data encryption
  • Experience with Cloud data infrastructure
  • Experience in the development and communication of policies, procedures and/or standards related to IT and technical concepts to non-technical clients.
  • Three (3) years of recent experience working with Microsoft SQL Server 2008 (or later)
  • Experience in researching and/or applying current trends, methodologies, standards, practices and/or products in an IT environment.
  • Experience working with and manipulating database system using SQL query language, including the creation/modification of stored procedures and views.
  • Experience in problem solving, troubleshooting and analyzing database issues and/or problems and to take appropriate corrective action.

Qualification & Experience:

  • Secondary school diploma and seven (7) years experience*or
  • Undergraduate degree or Master’s degree* and three (3) years experience*; or
  • Technologist diploma and four (4) years experience*; or
  • College diploma six (6) years experience*; or
  • Professional technologist equivalency designation and four (4) years experience*;

Job Details:

Company: CSIS

Vacancy Type: Full Time

Job Location: Ottawa, Ontario, Canada

Application Deadline: N/A

Apply Here