National Programs Database Administrator

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

Duties

Canada’s National Forest Information System (NFIS) provides information about Canada’s forests and on sustainable forest management. As a member of the NFIS project office you will be responsible for the administration and management of databases (relational and non-relational) as well as a member of the software development team working in an agile environment.

Work environment

Have you ever wanted to be a part of a world-renowned science institution or work in an innovative forward-thinking research and development team? Here’s your opportunity to develop your skills and showcase your talents at the Pacific Forestry Centre, Natural Resources Canada (Government of Canada).

Intent of the process

The intent of this selection process is to staff one (1) permanent position.

A pool of candidates may be established to staff similar positions within Natural Resources Canada, for various locations across Canada, with various tenures (e.g., indeterminate, term, secondment, assignment), various language requirements, and various conditions of employment.

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:
Graduation from a two-year program of study from a recognized post-secondary institution with acceptable specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Note:
1. Indeterminate incumbents in the IT group on December 9, 2021 who do not possess the education prescribed above, are deemed to meet the minimum education standard based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the IT group.
2. Indeterminate incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above, are deemed to meet the minimum education standard based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the IT group.
3. 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

Experience:
• *Recent and significant experience in database maintenance
• Experience installing and maintaining PostgreSQL in a Linux/Unix environment
• Experience constructing and optimizing SQL statements
• Experience in systems design and documentation
*Recent and Significant is defined as approximately three (3) years of experience within the last five (5) years.

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

Asset Education:
A degree from a recognized post-secondary institution with acceptable specialization in Computer Science, Information Technology, Information Management, or Software Engineering or some other specialty relevant to the position.

Degree equivalency

Asset experience:
• Experience with Distributed and Redundant Database architectures
• Experience managing Geospatial Databases

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

English essential

Information on language requirements

Knowledge:
• Knowledge of Database Management Systems (including relational DBMS)
• Knowledge of PostgreSQL server installation and maintenance/administration
• Knowledge of Linux / Unix operating system

Abilities:
• Ability to write SQL statements.
• Ability to program in Java.
• Ability to problem solve IT related issues.
• Ability to conceptualize, design and document database designs.
• Ability to communicate orally and in writing

Personal Suitability:
• Team Player
• Judgement
• Adaptability
• Initiative

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

Asset knowledge:
• Knowledge of Oracle server installation and maintenance/administration
• Knowledge of NOSQL databases like MongoDB
• Knowledge of automation tools like Ansible

Asset ability:
• Ability to develop, implement and maintain database backup and recovery strategies.

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

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.

ONLY APPLICATIONS SUBMITTED ON-LINE USING THE ‘APPLY ON-LINE’ BUTTON ABOVE WILL BE CONSIDERED.

Tips for Applicants: It is your responsibility as a candidate to demonstrate clearly how you meet each of the essential and asset criteria for Education and Experience. Please note that it is not sufficient to simply state that the qualification is met or to provide a listing of current or past responsibilities. Rather you must provide concrete examples with dates and duration as to when these experiences were gained for each experience criterion. The information provided during the application process must enable the Selection Board Members to understand HOW (clear explanation of duties), WHEN and for HOW LONG (date and length of time in months or years), and WHERE (employer and geographic location) the experience was acquired. Your answer should clearly identify your role and explain relevant responsibilities and/or actions that you took. ''Please refer to C.V.'' or similar statements will not be accepted as a valid response. Your resume may be used to confirm the information provided. Candidates will not be solicited for incomplete or possible missing information.

Asset qualifications could be used at the screening stage. Please ensure that your application and resume clearly indicate how you meet these qualifications. Candidates will not be solicited for incomplete or missing information. A lack of information may result in your application not being considered any further.

In order to manage the number of applications in the selection process, management may use top-down consideration of scores at various steps in the process, to determine the number of candidates who will be further considered in the process.

Persons are entitled to participate in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

In the event that an employee of the public service is qualified through this process, and there is a temporary need, he/she may be considered for acting, deployment, assignment or secondment opportunities.

A written examination may be administered.
An interview may be administered.
References checks may be conducted.

We intend to communicate with the candidates by email. Candidates who apply to this selection process should include an email address that accepts emails from unknown users (some email systems block these types of email). If you do not wish to receive results by email or if you change your email address during the process, it is your responsibility to inform us.

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.