Database Analyst (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

At the Public Service Commission of Canada, we foster a healthy, modern, diverse and inclusive workplace. Our efforts to create and maintain an outstanding workplace have been recognized. According to Forbes magazine, we are one of Canada’s Best Employers in 2021. Apply for a job today to join a great team.

Intent of the process

The intent of this process is to staff two positions at the Public Service Commission (PSC). A pool of qualified candidates may be created to staff vacant positions in the future. Other government departments may use the pool upon approval from the PSC.

By applying to this process, you consent to your personal application-related information being shared with other government departments interested in staffing similar positions.

Positions to be filled: 2

Information you must provide

Your résumé.

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

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.

Degree equivalency

-Approximately 2 years of experience as Database Administrator or Programmer Analyst;
-Experience in the troubleshooting of database issues;
-Experience with at least one of the following platforms: Oracle RDBMS or Microsoft SQL Server or MySQL;
-Experience with Unix/Linux and Windows operating systems.

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

Various language requirements
English or French essential
Bilingual - imperative BBB/BBB

Information on language requirements

Second Language Writing Skills Self-Assessment
In order to help you decide if you should apply to a bilingual position, an optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.

For more information, please consult:
Unsupervised Internet Test of Second Language Writing Skills

-Knowledge of data structures and concepts (data normalization);
-Knowledge of SQL, data manipulation language (DML) and data definition language (DDL);
-Knowledge of procedural languages programming (i.e. C/C#, T-SQL, PL/SQL, PL/pgSQL).

-Analytical Ability
-Communication
-Detail oriented
-Problem-solving

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

-Experience in data conversion and migration

-Experience with installation, upgrade or patching of at least one of the following softwares: Oracle RDBMS or Microsoft SQL Server or MySQL

-Experience with Flyway (an open-source database-migration tool)

-Experience in enterprise-wide data modeling and database design

-Experience in logical and physical data modeling, mapping logical to physical.

-Experience in design, development, testing, monitoring, managing, and validating DataWarehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes

-Experience in coordinating with other DataWarehouse IT stakeholders to ensure overall health and performance of the DataWarehouse environment

-Experience working with end users to translate business questions and requirements into applications that employ the appropriate reporting tools

-Experience in monitoring system performance, reliability, availability, and recoverability of the DataWarehouse environment.

-Experience in the evaluation, selection, testing, and optimization of Business Intelligence/DataWarehouse related hardware and software products

-Experience using ETL (Extract, Transform Load) tools

-Knowledge of networking concepts;
-Knowledge of Unix/Linux operating system scripting;
-Knowledge of query plan and SQL optimization principals;
-Knowledge of database backup and recovery methodology;
-Knowledge of capacity and storage management;
-Knowledge of Oracle RDBMS 11g/12c/19c or Microsoft SQL Server 2008/2016 or MySQL 5.6/10.2.

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

Candidates have the right to be assessed in the official language of their choice.

Candidates must clearly demonstrate in the screening questionnaire how they meet the education and experience criteria listed as essential and asset qualifications on the statement of merit criteria. In order to do so, the candidate must provide the information as part of their answer to the pertinent screening question, using concrete examples, in the textbox provided. The assessment board cannot and will not make any assumptions about your experience. Note that it is not sufficient to only state that the qualifications are met or to provide a listing of current or past responsibilities. Resumes may be used as a secondary source to validate the experience described in the experience questionnaire. Failure to clearly demonstrate in the questionnaire how you meet the education and experience, both essential and asset, where applicable, may result in the rejection of your application. Candidates will not be solicited for incomplete or missing information.

Communication for this process will be sent via email. It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required. Candidates who apply to this selection process should include an email address that accepts email from unknown users (some email systems block these types of email).

All the information collected during the selection process, from the time of application until the end of the process, will be used to assess the candidates.

Volume management mechanisms may be used.

Asset qualification(s) may be applied in this selection process.

Written communication will be assessed via the candidate's job application.

You will be asked to provide a minimum of two (2) references.

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.