IT Technical Advisor / IT Team Leader, Database Management

Update: Poster closing date extended from November 21, 2022 to December 2nd, 2022.

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. However, certain positions may require a physical presence at a specific 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. However, in these changing times, there is a requirement to be able to work from home. This may remain a component of the evolving workplace.

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.

Notes:
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 (For both positions)

EX1: Experience in developing data models with specific experience in conceptual, logical and physical data modeling.

EX2: Experience in providing recommendations to management (manager and above) in one or more of the following areas: data modelling, data management, data architecture, data warehousing, or data analytics.

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

Various language requirements
English Essential
French Essential
English or French Essential
Bilingual Imperative BBB/BBB
Bilingual Imperative CBC/CBC

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 (for both positions)

K1: Knowledge of current relational database management systems Oracle and MS SQL Server
K2: Knowledge of data modeling techniques and practices
K3: Knowledge of data warehousing techniques and best practices

________________________________________________________________________________

COMPETENCIES (for both positions)

C1: Demonstrating integrity and respect
C2: Thinking things through
C3: Working effectively with others
C4: Showing initiative and being action-oriented

________________________________________________________________________________

ABILITIES (for both positions)

A1: Ability to communicate effectively orally
A2: Ability to communicate effectively in writing
A3: Ability to analyse and work with large and complex data sets.
A4: Ability to work collaboratively with multi-disciplinary teams, such as application development teams, storage specialists, or system administrators on IT projects/maintenance activities

ABILITY - IT TEAM LEADER

A5: Ability to supervise, plan, coordinate and assess the work performed by employees

________________________________________________________________________________

PERSONAL SUITABILITY (for both positions)

PS1: Leadership
PS2: Client Service Orientation

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

ASSET EXPERIENCE (For both positions)

AEX1: Experience working in the processing of complex data models in one or more of the following areas: operational applications (transactional processing), Data Warehouse and Data Mart applications (On-Line Analytical Processing)

AEX2: Experience in participating in information gathering sessions, documenting client data requirements and providing impact analyses for database solutions.

AEX3: Experience in developing technical specifications for data extract, transformation and load (ETL) routines as required to support requirements

ASSET EXPERIENCE - IT TEAM LEADER

AEX4: Experience in supervising staff, including the planning, coordination and assessment of the work performed by employees delivering IM/IT projects/services.

________________________________________________________________________________

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 - Some positions may require a 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.