IT Analyst, Database Management

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 submitting your application to this selection process, you will be prompted to answer screening questions concerning the education and experiences requirements listed in the essential qualifications and asset qualifications section. It is your responsibility to provide clear and concrete examples in your responses to each question. It is recommended that you describe the experience examples in specific terms, providing sufficient details so that the Assessment Board can clearly understand. Describe the situation/task, how, when and where you acquired these experiences by giving examples. Content of your response must be supported by your CV/resume as your responses to these questions will be used as a primary source of information and your CV/resume will only be used to validate this information. Should you indicate in your response "please refer to CV/resume" your application will be rejected. Lack of examples and details will result in your application being rejected as the Assessment Board will have insufficient information to determine if the requirement is met.

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

Duties

The Canadian Space Agency is looking for an Oracle Database Administrator to join our Software and Database Solutions team.

Its main responsibilities are to:

1. Support Oracle databases in a Linux environment :

• Configuration, update and troubleshooting of Oracle DBMS software on Linux servers (including patches).
• Planning and monitoring the physical requirements of the database system, such as memory, disk space
• Creating, configuring and troubleshooting Oracle databases.
• Migration or upgrade of databases and related applications.
• Management and monitoring of storage space in databases
• Monitor and tune databases to ensure optimal performance.
• Ensure the security of databases.
• Control access permissions and privileges
• Configuration and update of Oracle's RMAN backup tool.
• Management, development and testing of backup and recovery procedures with RMAN
• Performing database recovery procedures in the event of problems.

2. Support the development and implementation of software solutions :

• Installation, configuration and update of the Oracle client on Web servers.
• Creation and maintenance of database structures.
• Provide recommendations for application design guidelines for database access.
• Work closely with IT project managers and database programmers.

Interesting, isn't it?
If the answer is yes, we encourage you to submit your application.

Work environment

The Canadian Space Agency, a stimulating environment, is committed to leading the development and application of space knowledge for the benefit of Canadians and humanity.

The Information Management Team at the Canadian Space Agency is a united, competent, multidisciplinary team at the heart of the organization.

We are located at Longueuil, Quebec. Telework and variable (compressed) working hours are possible.

We look forward to welcoming you to the team!

Intent of the process

The immediate need is to staff one (1) IT-02 level position on an indeterminate basis.

A pool of qualified candidates could be established to staff similar positions with various tenures (indeterminate, specified period, acting, secondment or assignment).

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)

ESSENTIAL QUALIFICATIONS - EDUCATION

Completion of two years of an acceptable post-secondary program of study in computer science, information technology, information management or other field related to the position to be filled.

Note : at the manager’s discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum education stated above. Whenever the minimum education is met using this alternative, it is met for the specific position only and must be re-assessed for other positions for which this alternative has been specified by the manager

Degree equivalency

ESSENTIAL QUALIFICATIONS - EXPERIENCE

E1. Significant* and recent** experience in Oracle database administration
E2. Significant* and recent** experience administering and updating Oracle's RMAN backup tool
E3. Significant* and recent** experience installing and configuring Oracle on Linux Red Hat
E4. Significant* and recent** experience in writing SQL queries

*Significant experience means the depth and breadth of experience normally associated with having performed a broad range of related activities for a period of approximately two (2) years.

** Recent experience is defined as experience that has been obtained within approximately the last five (5) years.

***IMPORTANT: If you have *Significant experience, that has not been acquired in the last 5 years, we invite you to submit your application to this selection process and provide us with all the information related how you meet this experience . Your application may be considered as part of this selection process.

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

ASSET QUALIFICATIONS - EXPERIENCE

EA1. Significant* and recent** experience in installing, administering and updating the Oracle Enterprise Manager tool
EA2. Significant* and recent** experience installing and configuring Oracle Data Guard

*Significant experience means the depth and breadth of experience normally associated with having performed a broad range of related activities for a period of approximately two (2) years.
** Recent experience is defined as experience that has been obtained within approximately the last five (5) years.

***IMPORTANT: If you have **Significant experience, that has not been acquired in the last 5 years, we invite you to submit your application to this selection process and provide us with all the information related how you meet this experience . Your application may be considered as part of this selection process.

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

Bilingual - Imperative (BBB/BBB)

Information on language requirements

ESSENTIAL QUALIFICATIONS - KNOWLEDGE

CO1. Knowledge of database administration.

ESSENTIAL QUALIFICATIONS - COMPETIENCIES

C1. Thinking Things Through
C2. Priority Management
C3. Team work
C4. Client service orientation
C5. Ability to communicate effectively

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

Selection may be limited to members of the following Employment Equity groups: Aboriginal persons, persons with disabilities, visible minorities, women

Information on employment equity

OPERATIONAL REQUIREMENTS

• Willingness and availability to travel occasionally
• Willingness and ability to work overtime

Conditions of employment

Secret security clearance

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

By applying to this process, you consent to your personal application-related information being shared with other government departments in the event that they would ask for it, in order to consider your application.

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.