Database and Application Support Analyst

Salaire: 
$72,725 - $81,850 plus $1,421.49 bilingual bonus for bilingual applicants (Expired Salary)
Type d'emploi: 
Durée Indéterminée
Lieu de travail: 
Ottawa
Date limite: 
16 Novembre 2017 - 15h30 EST
Niveau de recrutement: 
Employé-e-s de l'AFPC, des Éléments et de PSAC Placements ltée
Membres indiquant leur numéro de membre de l'AFPC
Membres du grand public
Numéro de concours: 
3600-0013B-017

Direction/Section

Direction des Ressources humaines et du développement organisationnel

Groupe

Unifor 2025
Classification: 
Niveau 9
Fonctions: 

Under the direction of the IT/IM Network Operations Supervisor, and as a member of the Information Technology and Information Management Section, the Database and Application Support Analyst is responsible for designing, developing, adapting/customizing, maintaining and ensuring the quality and integrity of databases, applications, data management tools and reporting.

Qualités requises: 

Education/Experience:

  • Bachelor degree in Computer Science or a relevant discipline or a combination of education and experience in the computer field;
  • A minimum of 6 years’ demonstrated working experience in an IT environment, with 4 years in designing, customizing and maintaining databases, software applications, programming and networks;
  • Web development experience with (HTML5/HTML/XHTML CSS3/CSS, PHP, MYSQL, Javascript) and Content Management Systems (Drupal, Joomla, WordPress...) a definite asset;
  • Experience optimizing and performance tuning MS SQL Server;
  • Experience with performance analysis using MS SQL Server tools like: Activity Monitor and SQL Profiler;
  • Experience with MS SQL Server Analysis Services;
  • Experience with MS SQL Server Integration Services including but not limited to implementing ETL solutions;
  • Experience with Dynamics GP;
  • Assets include: Experience coding in C# and Visual Basic using the ASP.Net framework; Azure SQL Database; Powershell; Microsoft R; Data Analysis/Analytics and Python.

Knowledge:

  • Advanced knowledge of server and desktop operating systems (e.g. Microsoft) and experience with PC hardware, software technology, networks and the TCP/IP protocol;
  • Advanced knowledge of Transact-SQL including implementing Stored Procedures, Triggers and Functions;
  • Advanced knowledge of Excel data connections, pivot tables and formulas;
  • Knowledge of Nintex workflow automated software, an asset.

Abilities:

  • Ability to install, verify, evaluate and implement various databases, systems and networks;
  • Demonstrated ability to provide comprehensive and technically sound advice and recommendations to managers and to other technical staff;
  • Proven track record of taking responsibility and ownership of work activities, and ability to demonstrate good time management;
  • Ability to demonstrate good client service through commitment and customer service;
  • Ability to adapt to and learn quickly new trending and emerging technologies, techniques, programming and reporting tools;
  • Ability to remain current on trends in emerging IT systems, networks and database design by participating in seminars, courses and industry presentations;
  • Ability to communicate effectively in English or French in writing and orally is essential.

Personal Suitabilities:

  • Commitment to continuous quality/ process improvement and change management processes and techniques;
  • The position requires excellent judgement and demonstrated problem solving skills, to provide advice on a variety of complex database and other technical issues, to all users and technical staff.

L'AFPC souscrit au principe de l'équité en matière d'emploi et s'efforce activement de mettre en place des effectifs représentatifs. On encourage la candidature des membres des groupes d'équité.