Technical Advisor, Enterprise Data Management Services (EDMS) - ANTICIPATORY

Update: Amendment to Selection process number 20-RCM-EA-N-S-NCR-SPS/CIO-90177. If you have already submitted your application, there is no need to re-apply.

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

*** ONLY ONLINE APPLICATIONS WILL BE ACCEPTED ***

All job applications must therefore be submitted through the jobs.gc.ca site. To submit an application online, please select the button "Apply Online" below.

Persons who cannot apply online or persons with disabilities preventing them from applying online are asked to inform the contact persons responsible for this process and to contact 1-800-645-5605 prior to the closing date.

When answering the screening questions you must ensure that you provide complete and thorough details of your education and experience. Do not assume that the screening board has any previous knowledge of your background, qualifications, or work history. Please describe in detail using concrete examples, how you meet the education and experience required. It is not sufficient to only state that the requirement is met or to provide a listing of current responsibilities. Failure to provide sufficient and appropriate information may result in elimination from the process.

It is the responsibility of the candidate to clearly outline that they meet each of the screening criteria (i.e. Education, Experience Qualifications, both Essential and Assets if applicable) by responding to the screening questions in the online application. Please note that it is not sufficient to only state that the requirement is met or to provide a listing of current responsibilities, rather the candidate must provide concrete examples that clearly illustrate how they meet the requirement. Lack of examples and details may result in your application being rejected as the Assessment Board will have insufficient information to determine whether or not you meet the qualifications.

Résumés may be used as a secondary source to validate the qualifications described; comments such as "refer to my attached résumé" will not be accepted and may result in your application being rejected.

Work environment

***Please note that this position is located at 1200 Vanier Parkway, Ottawa, Ontario.***

The Systems Delivery and Project Portfolio Management (SDPPM) Branch is a directorate of the Information Management/Information Technology (IM/IT) Program, and part of the Specialized Policing Services (SPS) Business line.

A key priority of the SDPPM directorate is to implement innovative policing applications to facilitate collaboration, enhance connectivity, and digital policing systems while aligning to and leveraging existing Government of Canada Digital tools and services with National and International policing partners and clients.

Intent of the process

The intent of this anticipatory process is to establish a pool of qualified candidates which
may be used to staff similar positions in the Information Management/Information
Technology (IM/IT) Program within the RCMP in the National Capital Region on an
indeterminate or specified period (including term, acting, or assignment) basis, with
various linguistic profiles and various RCMP security clearances.

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:
Successful completion of two (2) 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 OR an acceptable combination of education, training and/or experience.

Degree equivalency

EXPERIENCE:
• *Recent and **significant experience in providing technical leadership in the support of database design, development, integration, administration or performance tuning.
• **Significant experience in engaging multiple stakeholders to resolve issues at the database layer.
• Experience in providing technical advice and guidance to work teams and clients.
• Experience in the development of standards, best practices, or policies.

Definitions:
* Recent is defined as experience gained with the last five (5) years.
** Significant is defined as the depth, breath and complexity of experience normally associated with full-time performance of various activities related to the duties.

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

English essential

Information on language requirements

KNOWLEDGE:
• Knowledge of Database Design and Management
• Knowledge of current IT trends in the Government of Canada

ABILITIES:
• Ability to communicate effectively in writing
• Ability to communicate effectively orally
• Ability to coach project teams or individuals
• Ability to provide analytical and technical advice
• Ability to negotiate methods or techniques

PERSONAL SUITABILITY:
• Showing Initiative and Being Action-Oriented
• Judgement
• Working effectively with others
• Flexibility
• Client Service Orientation

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

ASSET QUALIFICATIONS:

• Experience in the installation, configuration, or support of Oracle on Z/Linux or Linux x86, SQL Server on Windows, or Db2 on z/OS.
• Experience in the installation, configuration, or support of IDOL or IBM InfoSphere.
• Experience in the installation, configuration or support of a NoSQL implementation.
• Experience in the configuration or support of specialized hardware acceleration solutions such as SAP HANA or IBM IDAA.
• Experience in other database technologies or platforms such as: Postgres, Pervasive, MySQL.
• Experience with database solutions running on public or private clouds.

OPERATIONAL NEEDS:
• Willingness and ability to provide after-hours support via operational availability (on call).
• Willingness and ability to work overtime on short notice.

Conditions of employment

Top Secret security clearance - RCMP Top Secret security clearance

All applicants for positions within the Royal Canadian Mounted Police will be subject to a thorough security clearance process which includes an interview wherein questions may include (but not limited to), reference checks, previous employment, on-line activities, credit checks, alcohol and/or drug use.

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

A written exam may be administered.

An interview may be administered.

Reference checks may be sought.

A simulation/situational exercise or role play may be administered.

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.

Acknowledgement of receipt of applications will not be sent; we will contact candidates when the screening process is completed.

You must provide proof of education credentials. If you obtained your degree outside Canada, it is your responsibility to demonstrate its equivalence, please take a look at the following link for more information: http://www.cicic.ca/383/foreign-credential-recognition.canada.

Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

Please identify clearly your substantive group and level and your employment status on your resume and/or application form.

If a qualified candidate has been selected and appointed on an indeterminate basis from the established pool, they will be removed from the pool. If a candidate is selected for a specified period (including term, acting, or assignment/secondment) appointment, they will remain in the pool for future offers.

Our means of communication with applicants is via e-mail. Please ensure to include a functional e-mail address, which will accept messages from unknown users (some e-mail systems block these types of e-mails). It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required.

The Public Service of Canada is committed to building a skilled, diverse workforce reflective of Canadian society. As a result, it promotes employment equity and encourages candidates to indicate voluntarily on their application if they are a woman, an Aboriginal person, a person with a disability or a member of a visible minority group.

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.

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.