Senior Database Administrator / Technical Specialist

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

In order to have your application considered, all screening questions must be answered. Candidates must provide CONCRETE EXAMPLES WHICH DEMONSTRATE, how they meet the education requirement and the experience factors listed in the essential qualifications and asset qualifications. Please note that it is not sufficient to only state that the requirement is met or to provide a listing of current responsibilities.

FOR EACH EXPERIENCE CRITERIA, please provide the following MANDATORY information:
1 - Name of the department or organization where the experience was acquired;
2 - Title of the position occupied and duration for which you exercised the functions; and
3 - Specific details of tasks or projects demonstrating how the experience was acquired and concrete examples.

Résumés will be used as a secondary source to validate the education and/or experience described in the screening questions.

You must meet all essential qualifications in order to be appointed to the position. Other qualifications may be a deciding factor in choosing the person to be appointed. Some essential and other qualifications will be assessed through your application. It is your responsibility to provide appropriate examples that illustrate how you meet each qualification. Failing to do so could result in your application being rejected.

Intent of the process

This process may be used to establish a pool of candidates that may be used to staff similar positions at an identical or equivalent group and level with various official language proficiencies (English or French Essential, English Essential, Bilingual Imperative BBB/BBB, Bilingual Imperative CBC/CBC), various security profiles (Reliability Status, Secret ), various tenures (Indeterminate, Temporary) using various staffing mechanisms (Indeterminate appointment, Term appointment, Acting appointment, Deployment, Assignment, Secondment) at Immigration, Refugees and Citizenship Canada.

Positions to be filled: 1

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 a 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 via 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 and **significant experience in developing or supporting IM/IT systems.
EX2 *Recent and **significant experience providing advice to IT staff or clients.
EX3 *Recent and **significant experience in coordinating tasks or deliverables in an IM/IT environment.

*Recent experience is defined as a depth and breadth of experience normally gained within the last five (5) years.

**Significant experience is defined as combined experience of at least two (2) years.

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

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

Information on language requirements

KNOWLEDGE
K1 Knowledge of techniques and practices associated with the design, development, testing and administration of databases.
K2 Knowledge of database administration tools.
K3 Knowledge of relational database management system architecture.

COMPETENCIES
• Effective Interactive Communication
• Written Communication Skills
• Client Service Orientation
• Initiative
• Cooperation and Collaboration
• Values and Ethics
• Adaptability/Flexibility
• Judgment/Analytical Thinking

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

ASSET QUALIFICATIONS

AEDU1 Project Management Certification
AEDU2 Information Technology Infrastructure Library (ITIL) Certification.
AEDU3 Oracle Certification :
-Oracle Database Administrator Certified Associate Certification (OCA)
-Oracle Database Administrator Certified Professional Certification (OCP)
-Oracle Database Administrator Certified Master Certification (OCM)
AEDU4 Microsoft Certification:
-Microsoft Certified Solutions Associate (MCSA) in Database Administration
-Microsoft Certified Systems Engineer (MCSE) in Data Management and Analytics

Degree equivalency

AEX1 Experience supervising teams, including planning, coordination and assessment of the work performed by employees and/or contractors in an IT environment.
AEX2 Experience in collecting and analyzing client requirements, making recommendations, and implementing solutions using information technology tools.
AEX3 Experience communicating technical information to clients or service partners.
AEX4 *Recent and **significant experience in developing written material such as charter, briefing notes, business process model, communication products or presentations.
AEX5 Recent* and significant** experience in providing operational support for an Oracle, MS SQL Server or Sybase ASE Relational Data Base Management System (RDBMS) including troubleshooting problems, optimizing database performance, and providing backup and restore activities.

*Recent experience is defined as a depth and breadth of experience normally gained within the last five (5) years.

**Significant experience is defined as combined experience of at least two (2) years.

OPERATIONAL REQUIREMENTS
Full-time schedule requiring work outside normal office hours week-ends and overtime.
• Ability and willingness to carry a government-owned mobile device during and outside working hours.
• Be willing and able to travel occasionally or when required.
• Be willing and able to work overtime 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

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.

A valid e-mail address must be provided. The Selection Board will communicate with candidates by e-mail to provide/request information and to invite candidates to attend any portion of the assessment

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


Candidates whose applications are retained for further consideration may be required to travel to attend an interview or for the administration of a test. If you are asked to travel in relation to this appointment process, you should direct any questions you have about travel entitlements to the hiring organization, when contacted, and they will provide you with the necessary information.

Candidates from outside the federal public service may be required to pay for their own travel and relocation expenses.

Candidates will need to provide proof of their education credentials at a later time in the process. Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca/indexe.stm

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

Applicants with disabilities: If you require a technical aid or an alternative method of assessment to ensure an equitable assessment of your qualifications, please indicate so in your application.

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.