Forensic Laboratory Application/Database Administration

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.

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 résumé" will not be accepted and may result in your application being rejected.

Duties

Performs full-cycle software development (business analysis, conceptual design, physical application design, development, testing and debugging, deployment, documentation, source control, versioning and upgrades) for custom specialized software applications and databases to provide scientific workflow enhancement tools or companion applications to the Laboratory Information Management System (LIMS), in a nationally distributed, accredited laboratory environment.

Consults with scientific staff to perform workflow and business analysis, as well as design and development of database objects to support the application (tables, views, triggers, stored procedures, indexes, etc.)

Works with other members of the Scientific Services team to provide expertise in database administration (backup and restore, data consistency, database/server monitoring and tuning, data replication setup and maintenance, disaster recovery).

Provides end-user technical support to scientific staff across Canada for applications developed by FS&IS and other laboratory databases as required.

Develops and provides technical support for various Cognos reports, Crystal reports, and Microsoft Word VBA templates as required to ensure their availability and functionality.

Performs data modeling for Business Intelligence purposes.

Provides consultative expertise to management in regards to strategies, technologies, timelines and best practices for enhancing program/service delivery using innovative custom laboratory software solutions.

Manages projects dealing with the planning of software implementations, and/or conversion of systems or data as required.

Work environment

As Canada’s national police force, the Royal Canadian Mounted Police (RCMP) is a critical element of the Government of Canada’s commitment to providing for the safety and security of Canadians. By tackling crime at the municipal, provincial/territorial, federal and international levels, the RCMP provides integrated approaches to safety and security, and a consistent federal role and presence from coast to coast to coast.
The RCMP offers exceptional careers, with opportunities for continued learning and growth to its employees. Join our team today!

As an employer of choice for over 28,000 men and women, the Royal Canadian Mounted Police (RCMP) promises a career like no other. With over 140 years of tradition and service, the RCMP is Canada’s national police service. Proud of our traditions and confident in meeting future challenges, we commit to preserve the peace, uphold the law and provide quality service in partnership with our communities.

The work is performed in an environment with intermittent distractions such as office or server noise and interruptions from telephone and visitors. The work involves daily exposure to glare from the computer screen and the requirement to sit for extended. As part of the criminal investigation process, there is lack of control over the pace of work and there is no tolerance for error.

Work Location: 1200 Vanier Parkway, Ottawa ON K1A 0R2

Intent of the process

The immediate need is to staff one position on an indeterminate basis, with a linguistic profile of English essential and an RCMP Secret security clearance

A pool of candidates may be established 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: 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 OR an acceptable combination of education, training and/or experience

Degree equivalency

Experience:
EX1. Experience* developing on the .NET platform

EX2. Experience* supporting SQL server

EX3. Experience* managing and writing queries, triggers, stored procedures and designing table structures for SQL server

*Experience is defined as a minimum of one (1) year

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

English essential

Information on language requirements

Knowledge:
K1. Knowledge of quality assurance processes
K2. Knowledge of Visual Basic for applications (VBA) and Microsoft word VBA templates
K3. Knowledge of Microsoft Team Foundation server
K4. Knowledge of the VB.NET framework and T-SQL

Abilities:
A1.Ability to communicate effectively orally
A2.Ability to communicate effectively in writing
A3.Ability to plan and organize
A4. Ability to trouble shoot and problem solve
A5. Ability to work in a team
A6. Ability to multitask in an environment of conflicting priorities

Personal Suitability:
PS1. Effective interpersonal relationships
PS2. Dependability
PS3. Judgement
PS4. Client service orientation

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

Experience:
AEX1. Experience working in a scientific laboratory environment

AEX2. Experience developing on the VB.NET platform

AEX3. Experience designing Crystal Reports

Knowledge:
AK1. Knowledge of the RCMP National Forensic Laboratory Services
AK2. Knowledge of Laboratory Information Management System (LIMS)

OPERATIONAL REQUIREMENTS
(may change during the candidate’s term in section)
• Willingness and ability to work overtime
• Willingness and ability to travel for work related assignments
• Willingness and ability to work in a police environment, including exposure to unsettling and/or graphic material

Conditions of employment

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.

• Work with and be exposed to hazardous chemicals, biological samples, and laboratory equipment
• Wear appropriate protective clothing and/or equipment
• Maintain standing and/or sitting positions for extended periods of time
• Move and/or lift items (up to 20kg)
• Adhere to laboratory safety standards and procedures
• Must have a valid driver’s license and be able to drive a fleet vehicle

NOTE: Candidates must meet the applicable Conditions of Employments at the time of appointment and must continue to meet these during the period of appointment.

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

Candidate must clearly demonstrate in their resume that they meet the education and experience requirements. Failure to provide sufficient information will result in the candidate being screened-out.

Candidates must obtain the required pass mark for each qualification in order to be given further consideration in the selection 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/

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

Random selection may be used to identify which applicants will be assessed in this appointment process.

PLEASE NOTE: For this selection process, our intention is to communicate with applicants by e-mail address for screening/assessment purposes (including issuing screening results, and sending invitations for written tests and interviews).

Applicants who apply to this selection process must include in their application a valid e-mail address and make sure this address is functional at all times and accepts messages from unknown users.

Candidates invited to an interview will be required to bring proof of their education credentials, in the form of a diploma or official transcript (original documents only).

Written test(s) may be administered.

Interview may be conducted.

Reference checks may be conducted.

Candidates must meet all of the essential qualifications noted in the Statement of Merit Criteria to be appointed to a position. A candidate may be appointed to a position even though she/he does not meet any or all of the asset qualifications or operational requirements. However, meeting these criteria is desirable and may be a deciding factor in choosing the person appointed.

Your resume must clearly demonstrate how you meet the requirements.

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

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.