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

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 prior to the closing date. You may also review jobs open to the public through INFOTEL at 1-800-645-5605. The INFOTEL number for persons using a TTY/TDD is 1-800-532-9397.

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.

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

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 a 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.
(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:
Experience* developing on the .NET platform
Experience* supporting SQL server
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:
Knowledge of quality assurance processes
Knowledge of Visual Basic for applications (VBA) and Microsoft word VBA templates
Knowledge of Microsoft Team Foundation server and/or Azure DevOps
Knowledge of the VB.NET framework and T-SQL

Abilities:
Ability to communicate effectively orally
Ability to communicate effectively in writing
Ability to plan and organize
Ability to trouble shoot and problem solve
Ability to work in a team
Ability to multitask in an environment of conflicting priorities

Personal Suitability:
Effective interpersonal relationships
Dependability
Judgement
Client service orientation

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

Experience:
Experience working in a scientific laboratory environment
Experience developing on the VB.NET platform
Experience designing Crystal Reports

Knowledge:
Knowledge of the RCMP National Forensic Laboratory Services
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.

CONDITIONS OF EMPLOYMENT
(Cannot change during the candidate’s term in section)
• 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

Candidates must meet all essential qualifications to be appointed to a position. This will be determined through the use of various evaluation tools.
Candidates may be required to meet the asset qualifications or the organizational needs, depending on the requirements of the specific position being staffed.

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: https://www.cicic.ca

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.

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


HOW TO APPLY:
You will be required to answer screening questions to demonstrate how you meet the Essential Qualifications (Education and all Essential Experiences).
When answering the screening questions, it is not sufficient to say that you have the required qualifications or to list your current or past responsibilities. Rather, you must provide concrete examples of tasks you have accomplished with significant details to explain the WHAT, WHEN, WHERE and HOW you acquired each qualification.

For each experience criteria, please provide the following information:

1- Name of the department or organization where the experience was acquired;
2- Title of the position occupied, group and level and the period(s) in which you performed the functions (M-Y to M-Y)
3- Specific details of tasks or projects demonstrating how the experience was acquired

Should your responses to the screening questions contain insufficient details to demonstrate that you meet the screening criteria, your application will not be given further consideration in this process. Candidates will not be solicited for incomplete or possible missing information.

Preference

Preference will be given to veterans first and then to Canadian citizens and permanent residents, 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.