Database Analyst

Update: Please note the amendment to the closing date. If you have previously applied, you do not need to re-apply.

Important messages

*** Please note that these positions are located at 1200 Vanier Parkway, Ottawa, Ontario.***

*** ONLY ON LINE APPLICATIONS WILL BE ACCEPTED ***

All job applications must therefore be submitted through the jobs.gc.ca site.
To submit an application on-line, 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.

Candidates must clearly demonstrate in the screening questionnaire how they meet the education and experience criteria listed in the Essential Qualifications and Asset Qualifications if applicable. Please note that stating that the requirement has been met, and/or listing past or current responsibilities, does not represent adequate substantiation. Rather, you must provide concrete examples that clearly illustrate how you meet the requirement. Résumés may be used as a secondary source to validate the qualifications described; comments such as "refer to my attached resume" will not be accepted and may result in your application being rejected.

Duties

- Participates in the design, development, implementation, integration and maintenance of Database schema changes.
- Assists in the provision of application support services.
- Participates in analyzing, defining and documenting client requirements as they relate to database principles.
- Under direction, documents database enhancements, schema changes and design documents to facilitate future deployments
- Provisioning of data through the use of ETL/CDC tools.

Intent of the process

The immediate need is to staff five (5) positions on an indeterminate basis: four (4) of the positions with a linguistic profile of English Essential and one (1) position with a linguistic profile of Bilingual Imperative BBB/BBB and for all positions an RCMP Top Secret security clearance.

A pool of candidates may be established inclusive of Public Service (PS) employees and Civilian Members (CM); and may be used to staff similar positions 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.

Should a Civilian Member (CM) be found qualified and selected for appointment, the appointment will not result in a change of status to the Public Service (PS) category for the CM. Notification regarding the CM appointment will be sent to all applicable candidates who are within the area of selection and participated in the advertised process.

Should a Public Service (PS) employee be found qualified and selected for appointment, notification regarding the PS appointment will be posted accordingly on www.jobs.gc.ca.

(SEE OTHER INFORMATION)

Positions to be filled: 5

Information you must provide

Your résumé.

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.

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 :
*Significant and **recent experience writing Structured Query Language (SQL).
*Significant experience in the use of database performance tools.
*Significant experience in the installation, configuration and support of proprietary software used in support of database systems.
*Significant experience conducting business requirements and functional analysis in support of database design.
*Significant and **recent experience in conceptual, logical, physical and dimensional data model.
*Significant experience in deploying Database changes in a web-based application environment.

Definitions:
*Significant is defined as the depth and breadth of experience that would normally have been gained performing the duties for a period of at least two (2) years.
**Recent is defined as experience gained within the last five (5) years.

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

ASSET QUALIFICATIONS

EXPERIENCE :
Experience writing SQL for RCMP hosted databases on DB2 (z/OS), Oracle or SQL Server.
Experience in IBM Infosphere suite of tools.
Experience in the use of Erwin.

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

Various language requirements
English Essential, Bilingual-imperative (BBB/BBB)

Information on language requirements

KNOWLEDGE :
Knowledge of database design.
Knowledge of database performance and tuning techniques.

ABILITIES AND SKILLS :
Ability to communicate effectively in writing.
Ability to communicate effectively orally.
Ability to analyze and solve problems.
Ability to establish priorities and plan own work.

PERSONAL SUITABILITY :
Teamwork
Initiative
Reliability
Continuous Learning
Client Focus

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

OPERATIONAL REQUIREMENTS
Willingness and ability to work overtime
Willingness to carry pager on rotational basis

Conditions of employment

Top Secret security clearance - RCMP Top Secret security clearance

Other information

A written exam may be administered.

An interview may be administered.

Reference checks may be sought.

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

Indeterminate employees at the same group and level, or equivalent may be considered for deployment, assignment/secondment prior to the assessment of other applicants.

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 and valid 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.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.