Database Administrator

Update: The closing date of this process has been extended to March 31, 2023.

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

The Federal Public Service is stronger and most effective when we reflect the diversity of the Canadian population we serve. Employment and Social Development Canada (ESDC) is dedicated to building and promoting a diverse, equitable and inclusive workforce, representative of Canadian society. All candidates who believe they are qualified are encouraged to apply, including Black, other racialized and Indigenous peoples, women, persons with disabilities and persons of the LGBTQ2+ community.

Applicants MUST submit their application online. No other mediums will be accepted. Failing to do so will result in your application being rejected. Candidates in situations preventing them from applying online and needing special accommodations must advise the selection board prior to the closing date (see Contact information section below).

You must include your résumé with your application; however, DO NOT refer us to your résumé as it may only be used as a secondary source of information.

You must clearly demonstrate in your application how you respond to the factors of Education and Experience that are included in the essential qualifications listed below. It is your responsibility to provide concrete examples (including dates) illustrating how you respond to each qualification. Failing to do so, your application may be rejected as applicants will NOT be solicited for incomplete or missing information.

You must clearly demonstrate in your application how you meet the Education requirements listed in the Essential Qualifications section below. Please indicate:

• Institution name, city, province / state, country
• Program name and duration
• Period of time spent at the institution (Month/Year to Month/Year)
• Successful completion of program (degree, diploma, certificate received).

You must clearly demonstrate in your application how you meet the Experience factors listed in the Essential Qualifications section below. Provide concrete examples of the tasks you completed which show how the experience was acquired. For each experience factor, please indicate:

• Name of the employer where the experience was acquired.
• Period of time in which you have gained the experience (Month/Year to Month/Year).
• Title of the position held.

This is a crucial step of the process. We can’t make any assumptions about your experience. Simply saying you have the required qualifications or listing your current duties is not enough; your answers must be specific, detailed and self-contained as your résumé will not be reviewed. The depth and breadth of the experience of an applicant may be considered as part of screening or selection of a candidate, which is why it is recommended you quantify your experience.

For Government of Canada employees: Please clearly identify your substantive group and level, and your employment status. Indeterminate employees at the same group and level or equivalent will be considered for deployment.

The application may be used to evaluate the ability to communicate effectively in writing.

Work environment

IITB is a national organization within Employment and Social Development Canada (ESDC), with a wide variety of IT work that can be performed regardless of geographic location.

IITB's hub locations outside of the Gatineau/Ottawa National Capital Region are located in: St. John's, Dartmouth, Charlottetown, Bathurst, Fredericton, Miramichi, Moncton, Boucherville, Jonquière, Laval, Montréal, Shawinigan, Belleville, Chatham, Cornwall, London, Toronto, Mississauga, Windsor, Vaughan, Winnipeg, Regina, Edmonton, Calgary and Vancouver.

The federal public service is transitioning to a common hybrid work model that supports sharing in-person experiences that are essential to cohesive, collaborative and high-performing organization while continuing to provide flexibility to support offsite work. At an individual level, this is captured in annually reviewed work arrangements with the on-going objective to balance operational requirements with employee individual circumstances and work preference.

In the context of Employment and Social Development Canada’s mandate, most positions are identified as either onsite or hybrid (combination of onsite and offsite work). At ESDC, employees who fall within the hybrid work category report onsite a minimum of two days per week (40% of their regular work schedule), as determined by operational requirements. On an exceptional basis, a predominately offsite work arrangement may be possible. Prior to appointment, the hiring manager will discuss with the successful candidate(s) the options and/or specifics as it pertains to the work arrangement.

Where operationally feasible, ESDC also supports flexibility related to the work schedule including, a compressed work week, varying start and end times, and leave with income averaging.

Intent of the process

A pool of partially or fully qualified candidates may be established through this process to staff identical or similar positions at Employment and Social Development Canada with various tenures, various language requirements, various security requirements, various conditions of employment and for various locations.

Positions to be filled: Number to be determined

Information you must provide

Your résumé.

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

EDUCATION:
Graduation from a two-year program of study from a recognized post-secondary institution with acceptable specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Note:
1. Indeterminate incumbents in the IT group on December 9, 2021 who do not possess the education prescribed above, are deemed to meet the minimum education standard 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 IT group.
2. Indeterminate 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 standard 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 IT group.
3. At the manager’s discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum 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 this alternative has been specified by the manager.

Degree equivalency

EXPERIENCE:
EX1: Recent* experience performing database administration type-activities such as: backup, recovery, tuning, troubleshooting or monitoring in one or more of the following: MS SQL Server 2012 or higher, 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.

DEFINITION:
* Recent experience is defined as depth and breadth of experience normally associated with the performance of those duties on a regular basis for a period of approximately twelve (12) months or more, acquired within the last five (5) years. However, a shorter duration may be considered based on demonstrated complexity and diversity of work handled, scope of work, and/or level of direct responsibility for a wide variety of complex files and/or projects.

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
English or French

Information on language requirements

Second Language Writing Skills Self-Assessment
In order to help you decide if you should apply to a bilingual position, an optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.

For more information, please consult:
Unsupervised Internet Test of Second Language Writing Skills

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

ABILITIES:
A1: Ability to communicate effectively orally.
A2: Ability to communicate effectively in writing.
A3: Ability to analyze technical problems and make appropriate recommendations.
A4: Ability to manage multiple priorities under tight deadlines.

PERSONAL SUITABILITY:
PS1: Focus on quality and details
PS2: Initiative
PS3: Judgement
PS4: Dependability
PS5: Client Service

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

ASSET CERTIFICATIONS AND EDUCATION:
AC1: Certification: Microsoft Certified Solutions Associate: SQL Server 2012 or higher.
AED: Bachelor's degree in one of the following programs: computer engineering, computer science, information technology, information management.

Degree equivalency

ASSET EXPERIENCE:
AEX1: Recent* 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: Experience with Unix/Linux scripting.
AEX6: Recent* experience in performing database migration to new version.
AEX7: Experience with any of the following: TOAD, SQL Developer, SQL Plus OR Team foundation Server (TFS).
AEX8: Experience with AIX and/or RedHat Linux OS.

DEFINITION:
*Recent experience is defined as depth and breadth of experience normally associated with the performance of those duties on a regular basis for a period of approximately twelve (12) months or more, acquired within the last five (5) years. However, a shorter duration may be considered based on demonstrated complexity and diversity of work handled, scope of work, and/or level of direct responsibility for a wide variety of complex files and/or projects.

Selection may be limited to members of the following Employment Equity groups: Aboriginal persons, persons with disabilities, visible minorities, women

Information on employment equity

Employment and Social Development Canada is committed to Employment Equity (EE). In order to achieve a representative workforce, selection may be based on qualified candidates self-declaring as belonging to one or more of the following EE designated groups: Indigenous peoples, persons with disabilities, women and visible minorities. We encourage you to indicate if you belong to one or more of the designated groups by completing the EE section in your application.

OPERATIONAL REQUIREMENTS:
Willingness to work overtime, often on short notice.

Conditions of employment

Reliability Status security clearance

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

Reference checks may be sought.

An interview may be administered.

A test may be administered.

A situational exercise may be administered.

No informal discussions will be held.

You must provide proof of your education credentials.

Candidates with foreign education credentials are required to provide proof of Canadian equivalency. Any applicable fees are the responsibility of the candidate.

A random and/or top down selection of candidates may be used in the determination of those to be given further consideration in the assessment process.

Candidates must meet the essential qualifications to be appointed to a position.

Candidates may be required to meet the asset qualifications or the organizational needs, depending on the requirements of the specific position being staffed.

Candidates will be contacted and invited to assessments via email. It is imperative that you provide a valid email address that accepts email from unknown users (some messaging systems block these types of correspondence). Candidates are responsible for checking their emails, as well as their junk emails, regularly. In addition, you need to inform us of any changes to your contact information. If you fail to follow these recommendations, you may be eliminated from the selection process.

Preference

Preference will be given to veterans first and then to Canadian citizens and permanent residents, 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.