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

Work environment

At the Public Service Commission of Canada (PSC), we foster a healthy, modern, diverse, and inclusive workplace. We collaborate in a hybrid work environment. Apply to join our talented team!
Assessment accommodation

Our highly collaborative organization is an ideal place for an experienced and skilled Database Administrator looking to take their career to the next level. We're currently upgrading our legacy systems, transitioning towards the cloud, and are in the process of building an Enterprise Datawarehouse, offering an exciting opportunity to work with cutting-edge technologies and to drive real business transformation.

But we believe what sets us apart is our culture of collaboration and teamwork. We firmly believe that the best solutions come from bringing together diverse perspectives and expertise, and therefore, we're committed to creating an environment where everyone can feel valued, supported, and encouraged to share their ideas and insights.

As a member of our team, you'll have the chance to work with a talented and passionate group of I.T. professionals who are dedicated to delivering exceptional results for our partners, departments, and Canadians as a whole.

Furthermore, the PSC has started to work in a Hybrid Work environment. Employees are required to report to a PSC office according to TBS's (Treasury Board of Canada Secretariat) new directives to stabilize and have a universal approach, with the opportunity to telework the rest of the time, subject to operational requirements. This model offers interesting opportunities to combine the best of our traditions with new approaches to foster a diverse and healthy public service.

Intent of the process

The intent of this process is to staff two (2) Database Administrator positions indeterminately. A pool of qualified candidates will be created to fill future vacancies on an indeterminate or term basis with various linguistic profiles and/or various security requirements within the public service Commission. Other government departments may use the pool upon the PSC's approval. 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)

EDUCATION:
ED1. 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.

Degree equivalency

EXPERIENCE:
EX1: At least three (3) years in the past five (5) years’ experience as a Database Administrator.
EX2: Experience with providing advanced technical support in the development, integration, implementation, and maintenance of Database Management Systems (DBMS) in operational and project environments.
EX3: Experience in providing expert technical advice, recommendations, and guidance to fellow IT colleagues across various disciplines and levels (Junior, senior and intermediate)
EX4: Experience with writing and evaluating SQL scripts including writing and tuning SQL/ PL/SQL and Transact-SQL code for stored procedures, functions, triggers and complex data structures.
EX5: Experience with performing backups and recoveries on databases.

KNOWLEDGE:
K1: Knowledge of Data structures, concepts, and Database design principles (i.e., data normalization).
K2: Knowledge of current and emerging trends relating to new information technologies.

ABILITIES:
AB1: Ability to communicate effectively orally.
AB2: Ability to communicate effectively in writing.

PERSONAL SUITABILITIES:
PS1: Innovative thinking: you innovate through analysis and ideas
PS2: Teamwork: you collaborate effectively with your colleagues
PS3: Results-oriented: you are focused on achieving results
PS4: Decision-making: you take initiative and are able to work in an environment with little supervision.

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

Various language requirements

Information on language requirements

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

ASSET EDUCATION:
AED1: Graduation with a degree from a recognized post-secondary institution with specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed.
Degree equivalency

Degree equivalency

ASSET EXPERIENCE:
AEX1: Experience in installation/configuration, integration, implementation and/or maintenance of at least one of the following DBMSs: Oracle, Microsoft SQL Server, or MySQL.

AEX2: Experience with working in a Unix/Linux or Windows environment, including writing, designing, and automating scripts.

AEX3: Experience in the design, development, testing, monitoring, managing and optimization of Business Intelligence/Data Warehouse related hardware and software products.

AEX4: Experience with Flyway or other open-source database migration tools.

ASSET KNOWLEDGE:
AK1: Knowledge of capacity and storage management
AK2: Knowledge of SQL Server Reporting Services (SSRS) functionality
AK3: Knowledge of Microsoft Power B.I. Techniques and Patterns
AK4: Knowledge of database security principles and practices

Conditions of employment

Reliability Status 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

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.