Geoscience Database Specialist

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

We will only accept on-line applications received via the GC Jobs site at: https://www.canada.ca/en/public-service-commission/jobs/services/gc-jobs.html. To submit an application on-line, please select the button "Apply Online" below. Persons with disabilities preventing them from applying on-line should contact 1-800-645-5605.

Screening questions have been built into the application process, when answering the screening questions you must provide concrete and detailed examples to clearly demonstrate how you meet the qualification. We can’t make any assumptions about your experience. Simply saying you have the required qualifications or listing your current duties is not enough. Instead, provide concrete and detailed examples that clearly explain where, when, and how you gained the experience. We’ll only use your résumé as a secondary source of information. The breadth and depth of experience may be considered during screening, assessment and/or selection of candidates.

The Government of Canada is committed to building a skilled workforce that is representative of Canada's diversity, which includes the recruitment of Canadian Veterans and releasing Canadian Armed Forces personnel: https://www.canada.ca/en/public-service-commission/jobs/services/public-service-jobs/canadian-armed-forces-members-veterans.html.

We encourage applicants to identify any abilities, competencies, and/or experiences acquired through employment with the Canadian Armed Forces where applicable.

Duties

The Geoscience Database Specialist (GDS) is responsible for designing, developing and maintaining computer software programs using Treasury Board of Canada Secretariat approved computer-coding languages to support Programs/Projects.

The GDS is responsible for providing subject matter expertise as it relates to database design, development and maintenance. These databases are required to follow all Government of Canada (GoC) directives by enforcing database policies, procedures and standards. Databases are to be developed in accordance with end-user requirements and follow all relevant geoscience data management principles.

The GDS is required to support seamless flow of geoscience data that considers both backend data structure and frontend accessibility for end-users, while achieving acceptable user defined performance.

The GDS will minimize downtime and manage parameters to provide efficient query responses while performing regular database evaluations to ensure data integrity and security.

The GDS is required to regularly update their existing skillsets and knowledge to match current advancements in computer programming languages while taking learned concepts and applying them to other problems.

Work environment

At Natural Resources Canada, a Federal government job means developing leadership skills, fostering teamwork, and supporting creativity and innovation. We know it takes people from diverse pools of talent to make this happen. That is why we are looking for people like you. As an employee at Natural Resources Canada, you can enjoy diverse employment opportunities, a range of career development programs, and a learning culture that supports you to learn on an ongoing basis. We support balancing your work and private life by offering the benefits of flexible work arrangements.

Intent of the process

The intent is to staff one PC-03 position on a term basis located at 3303-33rd Street NW, Calgary, Alberta.

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 - candidates MUST meet each essential qualification to be considered:

►A degree from a recognized post-secondary institution, with acceptable specialization* in physics, geology, chemistry or some other science relevant to the position (i.e. computer science, geographic information systems, etc.).

* The courses for the specialization must be acceptable and must have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization.

Degree equivalency

Experience:
► Significant* experience in designing, developing, and maintaining software applications using program language(s) (i.e. C#, Javascript, HTML, Pascal, Python, Visual Basic, Perl script, etc.).
► Significant* experience in using SQL and SQL procedural language.
► Significant* experience in developing one or more data models and designing one or more database management systems.
► Significant* work experience managing geoscience data.
► Experience using extract, transform, load (ETL) tool(s) to integrate data into a databases.

*Significant means: at least 3 years experience within the last 5 years.

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

Education:
► An additional degree or a diploma from a recognized post-secondary institution with acceptable specialization in geoinformatics, geographic information systems, computer science or other field of science related to the position.

Degree equivalency

Experience:
► Experience identifying, recommending and integrating emerging trends and technologies such as, Cloud, Machine Learning, Artificial Intelligence, etc.
► Experience in analysis and synthesis of spatially enabled geoscience data.
► Experience effectively communicating technical or scientific database concepts to non-subject matter experts.

OPERATIONAL REQUIREMENTS:
►Willing and able to work long periods of sustained attention to a computer screen.

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

English essential

Information on language requirements

Knowledge:
► Knowledge of geoscience data management, integration, and dissemination.
► Knowledge of programming language(s) and application development.
► Knowledge of building data flows and developing relational data models.

Abilities & Competencies:
► Ability to integrate scientific data from different sources to a common standard.
► Ability to effectively communicate orally and in writing.
► Ability to work collaboratively within a multi-disciplinary team.

Personal Suitability:
► Values and Ethics
► Initiative
► Results oriented
► Research and Problem solving
► Dependability

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

Knowledge:
► Knowledge of code libraries.
► Knowledge of Open Source databases such as PostgreSQL.
► Knowledge of enabling databases to work with web based applications.

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

Information on employment equity

ORGANIZATIONAL NEEDS:
►We are committed to making real change in our workplace. A change that is consistent with the social expectations to do better. To treat people fairly. To make a difference. To do more.

At Natural Resources Canada, we strive for better. Better natural resource sustainability. Better processes and systems. Better innovation. Better people. We can’t be better without you and the uniqueness you offer. We are looking for diverse perspectives, backgrounds, and experiences to strengthen our diversity. At Natural Resources Canada, we value these differences.

We encourage, as part of your application or resume, to voluntarily highlight what makes you unique, by identifying if you are a member of an under-represented group. If you are successful in this hiring process, this information could contribute to our hiring decisions.

Conditions of employment

Reliability Status security clearance - This factor is not used at the screening stage. The hiring department is responsible for the security clearance process.

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

All information obtained throughout the selection process, from the time of application to close of process, may be used to evaluate the candidates.

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.

Those selected for an interview should be prepared to provide the names of their references. Some or all of these individuals may be contacted. References must have an in-depth and direct knowledge of your work, and must be able to answer specific questions pertaining to your achievements and strengths.

You must provide proof of your education credentials and occupational certification. Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca/.

Random selection and/or top-down selection may be used at any time during the process to identify which applicants will be further assessed.

The breadth and depth of experience may be considered when making selections from the qualified pool.

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.