IT Database Analyst, Database and Data Administration

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

As one of Canada’s Best Diversity Employers, AAFC is proud to celebrate our achievement in creating a diverse, respectful, and positive workplace where all employees are valued and recognized for their unique qualities, ideas, voices and perspectives.

We are looking for skilled and experienced individuals in IT Database and Data Administration. To apply:
►It may take you 45 to 60 minutes to complete your application. Check out our video above for tips and advice!
►You don’t need to provide a cover letter (just your résumé). Your résumé is required and will be reviewed and used to validate the qualifications described.
►When submitting your application, you will be asked for information about your education and experience. The system will prompt you with specific questions for each qualification. This requires that you provide additional details in a written text response thoroughly explaining where, when and how you obtained this education or experience. Ensure you answer the questions if applicable.

Duties

As part of AAFC’s Information Systems Branch, you will be a part of an organization that prioritizes innovation and both departmental and inter-departmental collaboration. The organization is supported by a Chief Information Officer who has implemented a personalized approach to Employee Wellness and Talent Management programs for all employees.

As a Database Analyst, you would provide database administration functions including:
✔ supporting database applications (custom and commercial off the shelf) using Oracle or other major relational database systems
✔ working with various software applications in order to provide technical support and assistance to clients
✔ maintaining service availability and monitor database performance
✔ participating in multi-disciplinary IT project teams focusing on database development and administration

Intent of the process

Immediate need: To staff 1 Database Analyst position on a full-time permanent basis (in either Ottawa or Winnipeg).

Qualified candidates will also be placed in a talent pool to be used for staffing similar permanent or temporary positions.

In addition to permanent staffing, we may also use this selection process when needing to hire experienced public servants who are interested in temporary opportunities such as acting appointments, assignments, or secondments.

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)

Successful completion of two (2) 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.

If you were educated outside of Canada, you must have your certificates and/or diplomas assessed against Canadian education standards. Click on the link below to contact the Canadian Information Centre for International Credentials (CICIC).

Degree equivalency

Note: When answering the application screening questions (for experience qualifications below), you must be specific and provide concrete examples and details for each experience element, as applications will be screened on the information provided. Do not presume that the hiring board has any previous knowledge of your background, qualifications, or work history.

► Significant and recent experience working in an Information Management and Information Technology (IM/IT) environment analyzing requirements, delivering solutions and/or providing support. Significant experience is defined in that it is a major aspect of your daily work activities. Recent experience is defined as being within the last two (2) years.
► Experience in identifying and assessing IM/IT requirements, and providing IM/IT technical advice, assistance, and coaching to colleagues or clients.
► Experience in preparing technical documentation, such as procedures, user guides and IM/IT requirements.
► Considerable and recent experience in database management with Oracle 11gR2 or greater on HP-UX or Linux platform. Considerable experience is defined as an important aspect of your daily business activities. Recent experience refers to experience gained in the last two years.

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

English essential

Information on language requirements

The following QUALIFICATIONS are also required for these positions and you will be assessed for them at a later date:
► Knowledge of IM/IT standards, policies and guidelines.
► Knowledge of IM/IT principles, processes, tools and techniques.
► Knowledge of current and emerging trends in IM/IT.
► Analytical Thinking
► Client Focus
► Communication
► Continuous Learning
► Results Orientation
► Teamwork

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

► A diploma/degree from a 3 or 4 year program offered by a recognized college or university with specialization in Computer Sciences, Computer Engineering or any other field related to the position.

Degree equivalency

► Professional certification in areas such as:
o HP-UX
o Linux
o Windows
o Oracle RDBMS
o Microsoft SQL server (SQL Server 2008 or greater)

► Recent experience in analyzing, designing, programming and maintaining computer applications using programming languages, technologies and/or architectures such as:
o Oracle RDBMS 11g or higher
o Microsoft SQL server (SQL Server 2008 or greater)
o PL/SQL programming
o n-tier application architecture
o Incident management using tools such as Vantive, Assyst or Automatic Call Distributions (ACD)
o Erwin (Data modeling)
o Identifying and resolving operational, performance and connectivity problems for Corporate Applications
o Database administration with emphasis in the implementation, installation and maintenance of Oracle RDBMS database software and associated tools.
o Public or private cloud (Azure, AWS, etc.)
o Kubernetes, Docker, and/or other similar technologies
o Other popular relational and non-relational data storage technologies such as Hadoop/Cloudera, MySQL, PostgreSQL, NoSQL, etc.

► Recent experience in an operations infrastructure support role such as:
o Operating system support of Oracle databases

► Knowledge of data modeling and/or database development and management concepts and techniques.
► Knowledge of IT Operations service delivery and service support concepts including approaches for their implementation.
► Knowledge of Microsoft Windows, Linux or UNIX operating systems.
► Knowledge of data integration practices for Extract/Transform/Load (ETL), Enterprise Information (EII) and Enterprise Application Integration (EAI).

► In support of achieving a diversified workforce, consideration may be given to candidates self-declaring as belonging to one of the following Employment Equity groups: Aboriginal peoples, Persons with a Disability; Visible Minorities, Women.

Conditions of employment

► In order to be appointed to a position, a Secret Security clearance will be required. You will be expected to maintain this clearance throughout the duration of your employment.

Other conditions of employment:
► Ability and willingness to work overtime.
► Ability and willingness to varied hours.

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

APPLICATION & CORRESPONDENCE INFORMATION

⇨ Persons with disabilities preventing them from applying on-line are asked to contact the email referenced below under “Contact Information”.

⇨ We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you require special accommodation at any stage in the selection process, including technical aid or an alternative method of assessment to ensure an equitable assessment of your qualifications, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

⇨ Applications submitted by email will not be accepted. You must apply through the "Apply online" link below. Persons are entitled to participate in the appointment process in the official language(s) of their choice. Applicants are asked to indicate their preferred official language(s) in their application.

⇨ Once you click "Apply Now," the first step of the process will involve completing what we call ‘screening questions’ and attaching your resume. The responses you provide to these screening question, alongside your resume, will help us determine whether you meet the education and experience requirements.

⇨ We will contact you by e-mail and/or via your GC Jobs account. Please ensure that your e-mail address is valid and accepts messages from unknown users. It is your responsibility to regularly check your e-mail and jobs account for communications regarding this selection process. Should we contact you and you fail to reply within the designated time frames, your application may not be considered further.

⇨ 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.


WHAT WILL HAPPEN NEXT? ASSESSMENT INFORMATION

⇨ You must meet all essential qualifications in order to be appointed to the position. Other qualifications may be a deciding factor in choosing the person to be appointed. Depending on the number of applicants, volume management strategies such as random selection, top-down approach and/or establishing cut-off scores to determine who will continue in the staffing process, may be used for the purpose of managing applications. Please note that although you may attain the established pass mark on any of the assessments used in this staffing process, management may decide to use a higher cut off score.

⇨ A written examination and/or an interview will be administered.

⇨ Reference checks will be conducted and you will be asked to provide contact information for references, including at least one current or former supervisor and a client. Reference checks will be sought near the end of the selection process. The Assessment Committee reserves the right to contact references other than the ones submitted by the candidates if found necessary, in order to make a suitable assessment of the candidates.

⇨ Proof of your education credentials will be required at a later date.

Preference

Preference will be given to veterans and to Canadian citizens, in that order, 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.