Database Administrator (Team Leader and/or Technical Advisor)

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

ABOUT US

OPPORTUNITY TO WORK FOR ONE OF THE TOP EMPLOYERS IN CANADA

Employment and Social Development Canada (ESDC) is one of the largest departments in the Government of Canada, with over 27,000 people from coast to coast. You could work in a forward thinking, transformative service delivery Department that includes Service Canada, and the Labour Program, which continuously strives on innovation and supporting Canadians. ESDC has been recognized as one of Canada's Top 100 Employers (2021), Canada's Top Family-Friendly Employers (2021) and National Capital Region's Top Employers (2021).

Your new ideas and fresh perspective can make a difference in the services provided to Canadians. Being one of the largest departments in the Government of Canada, we offer many opportunities to be challenged, to develop and to make an impact! We value our employees by creating a healthy work environment, by encouraging work-life balance and by supporting ongoing development, training and promotional opportunities for our employees.

WORK LOCATIONS
Innovation, Information and Technology Branch (IITB) is a national organization, with a wide variety of work that can be performed regardless of geographic location. IITB's Hub locations outside of the 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. Part-time or full-time telework and virtual work arrangements are available but are subject to management approval. Furthermore, some positions may require working from an IITB office.

NOTE: As a result of the COVID-19 pandemic, most IITB employees are teleworking for the foreseeable future. These temporary work arrangements are determined on a case-by-case basis dependent on operational requirements of the position at the time of hiring. As the situation with the pandemic evolves, there might be changes to the available work arrangements.

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 linguistic requirements, various security requirements, various conditions of employment and for various locations.

Positions to be filled: 5

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
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
EX1: Significant experience** working collaboratively with multi-disciplinary teams, such as application development teams, storage specialists, and/or system administrators on IT projects and/or maintenance activities.

EX2: Recent experience* in database upgrade and/or migration activities.

EX3: Recent experience* providing technical advice and guidance to management***, clients or team members.

EX4: Significant experience** in performance tuning, troubleshooting and optimizing databases to improve efficiency and increase system reliability.

EX5: Significant experience** in the design, development or maintenance of database management systems for Oracle 12c or higher, or MS SQL Server 2012 or higher.

Definitions:
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 experience is defined as experience normally acquired within the last three (3) years.
** Significant experience is understood to mean the depth and breadth of experience normally associated with having performed a broad range of complex activities related to this task, which are normally acquired over a period of three (3) years.
*** Management is defined as manager level and above.

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

ASSET QUALIFICATIONS
TEAM LEADER AND TECHNICAL ADVISOR
EDUCATION
AED1: Bachelor degree from a recognized post-secondary institution in computer science, information technology, information management or other specialty relevant to the position to be staffed.
AED2: Any IT related occupational certification.

EXPERIENCE
AEX1: Experience in an IT operations production environment support role.
AEX2: Experience in supporting Cloud-based solutions.
AEX3: Experience in implementing database backup and disaster recovery procedures.

KNOWLEDGE
AK1: Knowledge of database high availability solutions.


TEAM LEADER ONLY
EXPERIENCE
AEX4: Experience in supervising staff, including the planning, coordination and assessment of the work performed by employees delivering IM/IT projects/services.
AEX5: Experience applying project management principles and best practices during the planning, implementation, monitoring and completion of projects.
AEX6: Experience in gathering and analyzing client business requirements in the context of information technology projects.

KNOWLEDGE
AK2: Knowledge of the principles and best practices of Project Management.

ABILITIES
AA1: Ability to supervise, plan, coordinate and assess the work performed by employees.


TECHNICAL ADVISOR ONLY
EXPERIENCE
AEX7: Significant experience** in providing technical direction to working groups and leading project teams composed of technical staff.
AEX8: Experience in collaborating and building effective working relationships with various stakeholders to facilitate implementation of a new IT solution, a service or activity.
AEX9: Recent* and significant** experience in coordinating the implementation and support of a database for a major/complex**** solution.

KNOWLEDGE
AK3: Knowledge of best practices associated with implementing Oracle or MS SQL Server database security.
AK4: Knowledge of Windows PowerShell.
AK5: Knowledge of data warehouse best practices.
AK6: Knowledge of cloud best practices.
AK7: Knowledge of NoSQL database technologies.
AK8: Knowledge of Unix-Linux scripting.
AK9: Knowledge of PL/SQL coding.
AK10: Knowledge of T-SQL coding.

Degree equivalency

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

Various language requirements
TEAM LEADER:
- Bilingual Imperative CBC/CBC

TECHNICAL ADVISOR:
- Bilingual Imperative BBB/BBB
- English essential
- French essential

Information on language requirements

KNOWLEDGE
K1: Knowledge of current database trends and best practices.
K2: Knowledge of Relational Database Management System (RDBMS ) diagnostic and performance analysis tools.
K3: Knowledge of database management standards and procedures.
K4: Knowledge of Information Technology (IT) industry trends.

ABILITIES
A1: Ability to manage multiple priorities in a rapidly evolving environment.
A2: Ability to administer large and complex**** databases.
A3: Ability to work collaboratively with multi-disciplinary teams, such as application development teams, storage specialists, and/or system administrators on IT projects and/or maintenance activities.
A4: Ability to provide technical advice and guidance to management*** or clients or team members.
A5: Ability to communicate effectively orally.
A6: Ability to communicate effectively in writing.

Definitions:
*** Management is defined as manager level and above.
**** Major/complex solution, product, service, or application is defined typically as having the following factors:
i. A production/development server environment consisting of not less than 5 servers in various tiers (front-end, application, database);
ii. A requirement for high availability and high reliability (production), or creating/maintaining multiple development environments;
iii. A distributed and large (500+) client base.

PERSONAL SUITABILITY
PS1: Client Focus
PS2: Dependability
PS3: Initiative
PS4: Judgement
PS5: Leadership

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

ORGANIZATIONAL NEEDS
At Employment and Social Development Canada, diversity is our strength. If you’re a woman, an Aboriginal person, a person with a disability or a visible minority and are interested in bringing in different perspectives and insights, let us know by completing the Employment Equity (EE) section in your application. Appointments of members of these EE groups could be made to ensure our workforce is inclusive and representative of the Canadian public we serve.

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

***************************
Application process
***************************
The hiring organization will accept applications on-line only. All job applications must therefore be submitted through the Public Service Resourcing System. To submit an application on-line, please select the button “Apply Online” below.

Persons requiring accommodation preventing them from applying on-line are asked to contact 1-800-645-5605.

By answering online screening questions, it is your responsibility, as a candidate, to provide CONCRETE AND DETAILED EXAMPLES to clearly demonstrate how you meet the education and experience requirements listed in the Other Qualifications sections, as well as the competencies (text questions).

Candidates must clearly explain in detail in their answers to the screening questions how they meet each required education and experience criterion including the asset 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. During the application or assessment process both cheating and plagiarism are considered forms of misconduct and are not permitted. Any person found cheating, including those who help others to cheat, may be subject to removal from the staffing process.

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 above information as instructed in the requested format will result in candidates’ applications being rejected.

You may save your application as a draft and return to it at a later date. Your application must be completed and submitted in order to be considered. Partially completed applications, or those in draft cannot be considered. You can make modifications to your submitted application at any time, but once your application has been selected for screening, you will no longer be able to make modifications and your submission will be considered final.

**************************
Assessment
**************************

A variety of assessment tools may be used in the assessment of candidates, such as: written test, practical test, situational exercise, oral interview, simulation, presentation, role play, work samples, performance appraisals, reference checks, and/or assessment board member personal/direct knowledge of candidates’ qualifications. Some assessment tools may be administered electronically, others, in-person.

Please note that asset qualifications, obtained results, top-down and/or random selection may be used to identify which applications will be given further consideration.

Candidates must meet the essential qualifications to be appointed to a position. The essential qualifications that are listed in the statement of merit criteria are mandatory. Applicants may be appointed to the position even though he/she does not meet any or all of the asset qualifications. However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed.

Pass marks will be established for each qualification. However, achieving the pass mark is not a guarantee of an appointment or that candidates will be put through the next stages of the assessment process. A cut-off score or a top-down approach may be used at any step if there is a sufficient number of candidates to meet immediate and anticipated staffing needs.

***************************
Travel status - Travel costs
***************************

Please note you will not be considered to be in travel status or on government business and that travel costs will not be reimbursed. Consequently, you will be responsible for travel costs.

***************************
Proof of education
***************************
Proof of your education credentials will be requested during the assessment phase of this process.

Candidates with foreign education credentials are required to provide proof of Canadian equivalency.

Foreign certificates and/or diplomas must be assessed against Canadian education standards. The federal public service will accept any Foreign Educational Credentials as long as they are deemed comparable to Canadian standards, determined by a recognized credential assessment service.

The Canadian Information Centre for International Credentials (CICIC) assists persons who wish to obtain an assessment of their educational, professional, and occupational credentials by referring them to the appropriate organizations.

You can access the CICIC website at: https://www.cicic.ca/. This website provides links to a number of Canadian organizations that provide equivalency assessments.

Original diplomas, degrees or certified transcripts may be required and must be presented upon request. Failure to produce required documents will result in your application not being considered.

***************************
Communication
***************************
Acknowledgment of receipt of applications will not be sent.

PLEASE NOTE: Our intention is to communicate with applicants by e-mail for screening/assessment purposes. It is imperative that you provide a current email address that accepts e-mail from unknown users (some email systems block these types of email). Candidates are strongly encouraged to check their email on a regular basis. It is entirely your responsibility to inform us at all times of any changes regarding your contact information.

***************************
Official languages- Bilingual positions
***************************
Persons are entitled to participate in the appointment process in the official language of their choice. Applicants will be asked to indicate in their on-line application their preferred official language for each of the following: a) correspondence, b) written exam, and c)interview.

To be considered for a Bilingual Imperative position, you must be willing to undergo Second Language Evaluation testing OR you must already have Second Language Evaluation results (proof will be required).

Candidates are asked to identify which they are interested in being assessed for on their application. Bilingual candidates will be asked to undergo the PSC Second Language Evaluation (SLE) exam or provide valid SLE results with their application. To obtain a copy of SLE results, candidates may make a request at the following web-site:
http://www.psc-cfp.gc.ca/ppc-cpp/test-examen-result/result-eng.htm

For more information on SLE, visit the following web-site: https://www.canada.ca/en/public-service-commission/corporate/about-us/contact-us.html#N1

***************************
Other informations
***************************

An assignment, secondment or an acting appointment is a temporary resourcing option. The approval of your substantive supervisor will be required before an offer can be made.

***************************
What do you need to know about diversity and accommodation?
***************************
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 selfdeclaring as being a member of one or more of the following EE groups: Aboriginal peoples, persons with disabilities, women and visible minorities.

If you are selected for further consideration, please advise the person who will contact you of any accommodations you may require during the selection process.

The Public Service of Canada is also committed to developing inclusive, barrier-free selection processes and work environments. If contacted in relation to a job opportunity or testing, you should advise the Public Service Commission or the departmental official in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.

If you studied abroad, you must have your certificates and / or diplomas assessed against Canadian education standards. This will allow you to provide proof that your foreign credentials are comparable to Canadian standards when applying for a job in the public service. This recognizes diplomas obtained abroad that are considered comparable to Canadian standards through a recognized credential assessment service.

The Canadian Information Centre for International Credentials (CICIC) assists persons who wish to obtain an assessment of their educational, professional, and occupational credentials by referring them to the appropriate organizations. You can access the CICIC website at https://www.cicic.ca/. This website provides links to a number of Canadian organizations that provide equivalency assessments.

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.