IT Specialist, CS-03, Data Services & Technology Management (DSTM), Data and Business Intelligence Directorate (DBID), Information Technology Branch (ITB), Canada - Jobs in Quebec City, QC

Job Description

For a description of key terms used on CRA job notices, go to Definitions for job seekers.About the jobOn October 6, 2021, the Government of Canada announced details of its plans to require vaccination across the federal public service. As a separate and large federal employer, the Canada Revenue Agency (CRA) supports and will follow this new policy direction.As of November 8, 2021, all employees of the CRA, including new hires, are required to be fully vaccinated against COVID-19 unless accommodated based on a medical contraindication, religion, or another prohibited ground for discrimination as defined under the Canadian Human Rights Act and attest to their vaccination status.The requirement to be fully vaccinated applies to all employees and new hires, whether they are teleworking, working remotely or working on-site. This condition of employment applies to indeterminate (permanent), determinate (term), and student hiring. Should you reach the point in the staffing process where it is necessary to verify conditions of employment, there will be a requirement to complete an attestation of vaccination status.CRA prioritizes diversity and inclusion and is firmly committed to providing a diverse workforce that reflects the population we serve. CRA’s National Employment Equity (EE) Staffing Strategy strives to eliminate EE gaps for the four EE designated groups: Indigenous peoples, persons with disabilities, members of visible minorities, and women. Where an EE gap exists at the time of appointment, EE may be used as an appointment criterion for permanent and temporary appointments/staffing actions over six months made through this process.Job dutiesIT Specialist CS0079The Data Services and Technology Management Division (DSTM) of the Information Technology Branch (ITB) is responsible for the provision of modern, sustainable and scalable data services. The division collaborates with the Canada Revenue Agency (CRA) branches and ITB stakeholders in order to provide appropriate Database Management and Business Intelligence (BI) solutions.Key responsibilities:

• Providing technical support for Database Management on mainframe, cloud and distributed platforms.
• Offering technical support for the Database Management Systems (DBMS) on the mainframe (z/OS), electronic Business Computing Infrastructure (eBCI) platform (Linux), Cloud and Windows environments.
• Database Infrastructure Development research and implementation projects.
• Database security.

To view the complete work description click here: CS0079 Job Description. If you cannot access the link, you may contact the email listed at the bottom of the notice to obtain a copy of the work description.Language Requirements

• English Essential
• Bilingual Imperative BBB/BBB

The pool established from this staffing process may be used to staff similar positions.Come work for the CRA, one of the Top 100 Employers in Canada!Due to the COVID-19 pandemic, public health recommendations and restrictions are in place across Canada and may change as circumstances evolve. You may be required to temporarily work remotely (e.g. from home). Further information will be provided if you are selected for the position.To applyWho can applyPersons residing in Canada and Canadian citizens residing abroad.AND eligible veterans and Canadian Forces membersPreference for appointment will be given to veterans, Canadian citizens and permanent residents, in that order.If you are a candidate from the general public, you will have to pay for any expenses related to your participation in this staffing process, as well as any relocation costs if you receive an offer of employment from this process.Virtual reporting may be possible, if operational requirements permit.Qualified members and former members of the Canadian Forces who receive an offer of employment are not entitled to relocation costs from the CRA. They may, however, be entitled to a final relocation from the Department of National Defence.Essential staffing requirementsTo be eligible, you must meet the following requirements.EducationMeet CRA’s CS Education Standard:

• A degree or a diploma from a recognized postsecondary institution, in computer science, information technology (IT), information management, or other specializations relevant to the position;

or

• Any degree from a recognized postsecondary institution; and three years of IT experience. (The experience must be validated by the Information Technology Branch CS Education Committee).

Note: You MUST upload your education credentials in the education section of your Candidate Profile and attach it to your application in order to demonstrate that you meet the essential education requirements by the closing date and time of this poster. In addition, for foreign education credentials, you MUST provide a scanned copy of your International Educational Credential Assessment, if applicable. Failure to do so can result in your application not being considered furtherExperienceThere are three (3) streams for this Notice of Job Opportunity. Candidates must indicate which stream or streams they wish to apply. The candidate must show how they meet the required experience for each stream for which they apply.Please demonstrate how you meet all the experience requirements that you wish to be considered for, since these may be used later on for placements.Stream 1 (Distributed & Database Services):Candidates must have experience* as a database administrator utilizing at least one (1) of the following Relational Database Management Systems (RDBMS):

• Oracle;
• DB2 for Linux/UNIX/Windows;
• PostgreSQL;
• Microsoft SQL Server.

• Experience is normally associated with the performance of these functions as part of the major job duties accomplished for a period of not less than four (4) cumulative years within the last seven (7) years.

Stream 2 (Host Database Services):Candidates must have experience* in the following:

• DB2 for z/OS (mainframe); and
• Messaging Queue (MQ) on z/OS and distributed platforms.

• Experience is normally associated with the performance of these functions as part of the major job duties accomplished for a period of not less than five (5) cumulative years within the last seven (7) years.

Stream 3 (Cloud database):Candidates must have experience* in at least one (1) of the following Database Management Systems (DBMS) in the Amazon or Azure Cloud:

• Implementing RDBMS (Relational Database Management Systems) in Cloud models IaaS (Infrastructure as a Service) and/or PaaS (Platform as a Service) and/or SaaS (Software as a Service);
• Implementing NoSQL databases in Cloud models.

• Experience is normally associated with the performance of these functions as part of the major job duties accomplished for a period of not less than three (3) cumulative year within the last five (5) years.

Note: You MUST include all relevant experience in the questionnaire portion of your application. Resumes will not be considered or reviewed as part of your application. Failure to do so can result in your application not being considered further.AssessmentThe essential staffing requirements indicated below will be assessed during the process and may be used to identify candidates for positions. Asset staffing requirements (indicated below or additional ones) may also be assessed during the staffing process and may be used to identify candidates for positions. You will be notified in advance of any asset requirements to be evaluated.EssentialQualifications:The following qualification will be assessed by stream using an interview.

• Database administrator technical knowledge
• Ability to analyze and resolve IT problems
• Ability to share knowledge
• Ability to communicate effectively orally

The following qualifications will be assessed using a reference check.

• Dependability
• Ability to work effectively with other team members
• Ability to mentor others
• Values and Ethics

Results from locally developed assessment tools are not portable to other staffing processes.Additional considerations

• Budgetary considerations
• Duration of appointment
• Start date
• Minimize business disruption
• Employment Equity

Conditions of employment

• Security Clearance: Reliability Status*

• Certain positions may require Secret clearance

• Willingness to work overtime
• Willingness to be on-call on a rotational basis

Want to know moreWe encourage you to read Important information on staffing at the CRA to find out more about staffing processes and how to apply.The CRA is committed to building a skilled, diverse workforce reflective of Canadian society. To find out more, consult Employment equity, diversity and inclusion at the CRA. We encourage you to complete the Employment Equity (EE) Staffing questionnaire as part of your application if you wish to be considered for staffing actions using the EE staffing requirement in this process. Your questionnaire response will be retained on file for the duration of the staffing process. If you do not complete the questionnaire, you will not be considered for any staffing actions using the EE staffing requirement in this process. If you decide to modify your response or fill out this questionnaire at a later date, please notify the contact listed at the bottom of this notice of job opportunity.CRA employees support the economic and social well-being of Canadians, and build public trust. We have high expectations, and our employees are held to the standards of conduct outlined in our Code of integrity and professional conduct and Directive on conflict of interest, gifts and hospitality, and post-employment.Information regarding the status of your application will be communicated via the candidate profile on the CRA Careers site. We strongly encourage you to verify the email address attached to your profile and to check your messages regularly for any updates.ContactName: HR Staffing Processes ITB (CRA)Email address: CS03DSTMG@cra-arc.gc.caYou must complete your candidate profile before you can apply.Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected