Database Analysts and Programmer Analysts - Inventory

Update: Please note: Information added under "Work Environment".

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

When you apply to this selection process, you are not applying for a specific job, but to an inventory for future vacancies. As positions become available, applicants who meet the qualifications may be contacted for further assessment.

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

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.

♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦

What makes inventories different from other job advertisements? You only need to apply once to be considered for multiple job opportunities at the CS-02/CP-02 group and level within the RCMP!

Don't worry, even if your application is not selected for one job, your application remains in the inventory and can be selected again for the entire duration that the inventory remains open. Additionally, you can go back and update your résumé or responses to the screening questions at any time.

Our inventory process is open-ended: based on your interest and experience, we will guide you to the team that matches your qualifications and skills.

Random selection may be used at any time during the process to identify which applicants from the inventory will be assessed.

* Multiple batches of applications will be retrieved throughout the duration of this inventory.

Re-evaluation period: If candidates are eliminated during the screening stage based on education and experience, there will be a 6 month waiting period. After this period, candidates may resubmit their application with more recent and/or additional detailed information in order to be reconsidered.

♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦

Work environment

***Please note: All positions are located at 1200 Vanier Parkway, Ottawa, Ontario.***

The Systems Delivery and Project Portfolio Management (SDPPM) is directorate of the RCMP Information Management/Information Technology (IM/IT) Program, and part of Specialized Policing Services Business line of the Royal Canadian Mounted Police (RCMP) organization.

A key priority of the SDDPM 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, National and International policing partners and clients.

The SDPPM Branch is composed of four (4) Portfolios:

• Integration and Product Specialization: Responsible for new corporate systems/applications, including custom-built and COTS systems across Canada and internationally. Responsible for overseeing the provision of project management and administrative support services for programs and projects within the IM/IT Program.

• Common Solutions Development: Responsible for custom-built and commercial off-the-shelf (COTS) systems for clients of the assigned Common Solutions Portfolio. The business and technology solutions are used by clients across the RCMP to enhance their police, corporate management and administrative services delivery and performance.

• Application Development and Maintenance: Project Portfolio Management: Responsible for numerous portfolios of IM/IT solutions and business transformation projects In support of their delivery mandate, they work with key strategic partners, including RCMP business lines and policy centres.

• Project Portfolio Management (PPM): Responsible for their portfolio of IM/IT solutions and business transformation projects. In support of their delivery mandate, they work with key strategic partners, including RCMP business lines and policy centres, SSC and other federal departments and have access to the Project Delivery Office (PDO) for support services.

Intent of the process

This inventory will be used to establish a partially or fully qualified pool of candidates which may be used to staff similar positions within the RCMP in the National Capital Region, on an indeterminate or specified period (including term, acting, assignment/secondment or casual) basis, with various linguistic profiles and various security profiles.

(SEE OTHER INFORMATION)

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 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 in Application Development or Database Support.
· *Experience working in an Information Management/Information Technology (IM/IT) field.

Definition: * Experience may have been gained through employment, studies, volunteer work, or an acceptable combination.

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

ASSET CRITERIA:
· Experience with Business Intelligence (BI) Tools
· Experience in MS Dynamics
· Experience in Geospatial Information System (GIS)
· Experience within a Cyber Security Environment
· Experience in writing Structured Query Language (SQL)
· Experience in the use of database performance tools
· Experience in developing conceptual, logical, physical and dimensional data models
· Experience in deploying database changes in a web-based application environment
· Experience in mobile application development
· Experience in application development using Java or J2EE Web application server such as Weblogic or Java Web Framework such as Struts, SPRING, MVC, JSF, Hibernate, ExclipseLink, or MyBatis
· Experience in application development using C++ or C# within a development framework such as .Net.
· Experience using SPUFI, JCL, CICS, or ISPF
· Experience in PeopleSoft (PeopleCode, PeopleTools or SQR) applications development including testing and debugging.
· Experience in SAP ABAP applications development including testing and debugging.
· Experience in development using PowerBuilder
· Experience using XML and XML related APIs
· Experience in development using COBOL

OPERATIONAL REQUIREMENTS:
· Willingness and ability to support a 24/7 system including being on call
· Willingness and ability to travel occasionally if required
· Willingness and ability to work overtime

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

Various language requirements
Various linguistic profiles: English Essential and Bilingual Imperative (BBB/BBB and CBC/CBC)

Information on language requirements

KNOWLEDGE:
· Knowledge of Application Development or Database Support
· Knowledge of Standards and Methodologies for testing software

ABILITIES:
· Ability to communicate effectively in writing.
· Ability to communicate effectively orally.

PERSONAL SUITABILITIES:
· Adaptability and Flexibility
· Collaboration and Cooperation

Conditions of employment

Reliability Status security clearance - Various Security levels: RCMP Enhanced Reliability Clearance, RCMP Secret Clearance, RCMP Top Secret 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

AKNOWLEDGEMENT OF RECEIPT OF APPLICATIONS WILL NOT BE SENT. WE WILL ONLY CONTACT THOSE CANDIDATES SCREENED INTO THE PROCESS.

Testing/interviews will be conducted at locations of the employer's choice and may require candidates to travel to the test/interview location.

Please note that within the context of this selection process, travel costs/expenses will not be reimbursed. Consequently, candidates will be responsible for travel costs.

Travel related to the selection process: Please note that candidates (including employees of the Public Service) will not be considered to be in travel status or on government business.

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