Database Administrator

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

Candidates must clearly explain in detailed in their answers to the screening questions how they meet each required education and experience criterion including the assets qualifications. The answers must include where and how you obtained the required education and experience, as well as the period(s) in which you performed those duties. Please note that stating the requirement has been met, and/or listing past or current responsibilities, does not represent adequate substantiation. Candidates must provide concrete examples that clearly illustrates how they meet each one of them. Each answer must be different from one another (NO COPY PASTE) and must address the specific question. Please note that your answers to the pre-screening questions will be used to evaluate the ability to communicate effectively in writing.
Only the information provided in the answers to the questions will be used for screening purposes. Candidates will not be solicited for incomplete or possible missing information. Resumes will only be used as a secondary source to validate the education and/or experience described in the answers to the screening questions. Failure to provide the information in the requested format will result in candidates’ applications being rejected.

Work environment

WORK LOCATIONS:

Please note that although IITB is a national organization, some of the positions staffed as a result of this process will require a location in the NCR.

Intent of the process

A pool of qualified candidates may be established in order to staff similar positions within the Innovation, Information and Technology Branch (IITB) In the capital national region, with various language requirements (Bilingual imperative BBB/BBB, English essential, French essential).

Positions to be filled: 15

Information you must provide

Your résumé.

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

ESSENTIAL QUALIFICATIONS

EDUCATION :

Successful completion of two years of an acceptable post-secondary educational program in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Notes :
1. Indeterminate period incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above, are deemed to meet the minimum education standards based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the CS group.

2. It is the recognized educational institution (e.g. community college, CÉGEP or university) that determines if the courses taken by a candidate correspond to two years of a post-secondary program at the institution.

3. At the manager's discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum post-secondary education stated above. Whenever the minimum education is met using this alternative, it is met for the specific position only and must be re-assessed for other positions for which the manager has specified this alternative.

Degree equivalency

EXPERIENCE :

Definition of experience: Experience is defined as experience gained through employment, studies, volunteer work or an acceptable combination for a minimum period of one (1) year in the IM/IT field.

*Recent is defined as experience normally acquired within the last three (3) years.

EX1 Recent* experience performing database administration type-activities such as: backup, recovery, tuning, troubleshooting OR monitoring of a database for MS SQL Server 2012 or higher OR Oracle 11g or higher.

EX2 Recent* experience in developing and maintaining PL/SQL or SQL database scripts.

EX3 Recent* experience in dealing with clients OR external stakeholders in support of IM/IT Systems.

EX4 Recent* experience in solving database problems and issues.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

ASSET QUALIFICATIONS :

AED Bachelor's degree in one of the following programs: computer engineering, computer science, information technology, information management.

Degree equivalency

EXPERIENCES :

AEX1 Experience in T-SQL.

AEX2 Recent* experience in managing database security.

AEX3 Experience in planning, implementing and troubleshooting a high availability database environment.

AEX4 Experience using diagnostic tools to monitor SQL Server databases and server resources.

AEX5. Occupational Certification: Microsoft Certified Solutions Associate: SQL Server 2012 or higher.

AEX6 Experience with Unix/Linux scripting.

AEX7 Recent* experience in performing database migration to new version.

AEX8 Experience with any of the following: TOAD, SQL Developer, SQL*Plus OR Team foundation Server (TFS).

The following will be applied / assessed at a later date (essential for the job)

Various language requirements
Bilingual imperative BBB/BBB
English essential,
French essential

Information on language requirements

KNOWLEDGE :

K1 Knowledge of the methods and practices that are used in the design and management of relational databases.

ABILITIES :

Ability to communicate effectively orally.
Ability to communicate effectively in writing.
Ability to analyze technical problems and make appropriate recommendations.
Ability to plan, prioritize and meet deadlines.

PERSONAL SUITABILITY :

Focus on quality and details
Teamwork
Judgement

The following may be applied / assessed at a later date (may be needed for the job)

ASSET KNOWLEDGE :

AK1 Knowledge of AIX and/or RedHat Linux OS.

OPERATIONAL REQUIREMENTS:

Willingness to work overtime, often on short notice.

Conditions of employment

CONDITIONS OF EMPLOYMENT:

Reliability Status
Secret security clearance

Other information

The Public Service of Canada is committed to building a skilled and diverse 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.

Information on employment equity

Preference

Preference will be given to veterans and to Canadian citizens, in that order, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.