Database Programmer

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

- Provide database development and maintenance for a variety of projects and products in support of four Courts; serving the Federal Court of Appeal, the Federal Court, the Court Martial Appeal Court, the Tax Court of Canada and Court Administration Services;
- Work with programmers, system administrators and quality assurance analyst to develop quality products;
- Work with enterprise relational database management systems to support all systems.

Intent of the process

A pool of pre-qualified or fully qualified candidates may be created to staff similar or identical positions with various tenure, various linguistic profiles and security requirements within the Courts Administration Service.

Candidates may be evaluated further, for specific opportunities, on qualifications that are deemed necessary, whether or not these qualifications have been listed on the job advertisement.

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)

Graduation with a degree from a recognized post-secondary institution from a program in computer systems technology, computer systems technician, computer science, information technology, information management, or other relevant specialty program.

Degree equivalency

Recent** Experience analyzing requirements and providing technical advice, guidance and recommendations on issues of various complexity to management and clients.

Recent** Experience working in a cross functional and multidisciplinary team providing database services in support of application development.

Recent** Experience in the development and support of Oracle database programmable objects.

Recent** Experience database modelling in support of enterprise systems.

Recent** Experience in the development and support of PL/SQL scripts.

(**) Recent experience is defined as experience acquired 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)

Experience working in a judicial or quasi-judicial environment.

Experience in the use of Microsoft Team Foundation Server (TFS) for source control of Oracle database programmable objects.

Knowledge of the modern development methodology Kanban as it applies to an IM/IT projects.

Willing and able to work overtime on short notice.
Willing and able to travel on occasion.

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

Various language requirements
Bilingual imperative BBB/BBB
English or French Essential

Information on language requirements

Dealing with difficult situations
Ability to work with minimal supervision
Ability to work under pressure to meet deadlines
Oral Communication
Written Communication

Initiative
Judgement
Teamwork
Flexibility
Client focus
Analytical thinking

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

On October 6, 2021, the Government of Canada announced details of its plans to require vaccination across the federal public service.

As per the new Policy on COVID-19 Vaccination for the Core Public Administration Including the Royal Canadian Mounted Police (https://www.tbs-sct.gc.ca/pol/doc- eng.aspx?id=32694), federal public servants in the Core Public Administration andmembers of the RCMP must attest to their vaccination status. The requirement foremployees to be fully vaccinated applies whether they are teleworking, working remotely or working on-site. This is a condition of employment and it applies to
indeterminate (permanent), determinate (term), casual, and student hiring. Should you reach the point in the selection process where it is necessary to verify terms and conditions of employment then the hiring manager or a human resources representative will contact you in order to complete an attestation.

In response to the COVID-19 pandemic and further to public health guidelines, preventative measures are being taken to ensure health and safety during the recruitment process.

Due to current circumstances, all assessment may be done virtually.

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.

Candidates must meet the essential qualifications to be appointed to a position.

Candidates must clearly demonstrate in the screening questionnaire how they meet the education and experience factors listed as essential and/or 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 provided area. 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/or asset, where applicable, may result in the rejection of your application.

A variety of tools and assessment methods may be used, which may include, but is not limited to written tests, interviews and reference checks. Other sources of information (such as performance agreements, work samples, board member knowledge, etc.) may be used to inform the assessment of the criteria identified on the Statement of Merit Criteria. Any information that you provide throughout this process, including email correspondence, may also form part of the assessment.

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

Written communication may be assessed via the job application.

Candidates will be required to provide proof of their education credentials in the form of a diploma or official transcript.

If a qualified candidate has been selected and appointed on an indeterminate basis from the established pool, they will be removed from the pool. If a candidate is selected for a specified period (including term, acting, or assignment/secondment) appointment, they will remain in the pool for future offers.

We will communicate with applicants by e-mail. It is your responsibility to verify your e- mails regularly. Applicants shall ensure that the e-mail address provided is valid and make sure this address is functional at all times and accepts messages from unknown users.

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.