Database analyst Jobs in Ottawa, ON

Tenure:

Term

Duration: 1 year

Language Requirements: English

Work arrangements:Due to the nature of the work and operational requirements, this position may be eligible for a limited hybrid work arrangement (combination of working onsite and telework).

At the NRC, we recognize that Indigenous candidates may have important connections to their communities and you may be eligible for an exception to this work arrangement. Alternative work arrangements may also be considered to accommodate candidates as required. To learn more about these options, please contact the NRC Hiring team using the contact information below.

Assignments will be considered according to NRC's policies.

Discover the possible

Anything is possible at the NRC, named in 2025 one of Canada’s Top Employers for Young People, Top Employer in the National Capital Region and Forbes Canada’s Best Employers!

As Canada’s largest research and innovation organization, our world-renowned research pushes the boundaries of science and engineering to make the impossible, possible. Every day we explore new ideas through innovative research and help companies discover possibilities that impact Canada’s future and the world.

At the NRC, you’ll also discover new possibilities. Our supportive workplace fosters a culture of creativity, welcoming fresh perspectives and innovation at all levels. We value teamwork. You’ll collaborate across multiple fields and with the brightest minds to find creative solutions. Most importantly, you’ll discover what’s possible within you as you grow, make valuable contributions and progress in your professional journey. From ground-breaking discoveries to a life-changing career, discover your possible at the NRC.

The role

We are looking for a Technical Advisor, Application Development / Database and Data Administrator to support our Chief Information Officer Branch (CIOB). The Technical Advisor, Application Development / Database and Data Administrator would be someone who shares our core values of Integrity, Excellence, Respect and Creativity.

Under the direction of the Manager, Web Applications Development, the Technical Advisor is responsible for the design, development, testing, implementation and maintenance of ChemIn-InChim, a custom-built Symfony-based Web application that is used as the NRC-wide online Chemical Inventory tool.

The Technical Advisor writes new and modifies existing application code while following industry standards and best practices, performs database administration tasks, participates in project activities and discussions, advises on approaches for new functionalities, creates technical specifications and produces technical documentation.

The Technical Advisor works closely with the Health, Safety and Environment (HSE) Branch as well as technical specialists, colleagues, senior advisors and staff from the NRC Research Centres, Branches and IRAP to clarify requirements for services and to resolve technical issues.

Screening criteria

Applicants must demonstrate within the content of their application that they meet the following screening criteria in order to be given further consideration as candidates:

Education

University degree or 3-year college diploma in Computer Science, Computer Engineering, System Engineering, or other related field.

An equivalent combination of relevant training and experience may also be considered.

For information on certificates and diplomas issued abroad, please see Degree equivalency

Experience

• Recent* and significant** experience working in a high-pace collaborative development environment based on the LAMP stack technologies;
• Recent* and significant** experience developing and maintaining large dynamic Web applications using Symfony framework and Doctrine. Experience with other comparable PHP frameworks may also be considered;
• Recent* and significant** experience developing with Object Oriented PHP;
• Significant** experience designing and maintaining MariaDB or MySQL databases;
• Significant** experience developing with technologies such as HTML, CSS, JavaScript, jQuery, , ;
• Significant** experience using GitLab for code versioning and issue tracking;
• Experience using command line tools in the UNIX/Linux and Windows environments.

** Significant is defined as at least 2 to 6 years of experience.

* Recent is defined as within the last five years.

Condition of employment

Reliability Status

For a Reliability Status, verification of background information over a period of 5 years is required.

Language requirements

English

Information on language requirements and self-assessment tests

Assessment criteria

Candidates will be assessed on the basis of the following criteria:

Technical competencies

• Advanced knowledge of the Symfony framework including dependency management with Composer and WebPack, Flex structure, custom guards, complex Doctrine elements, components, libraries and bundles;
• Advanced knowledge of the Object Oriented PHP programming language;
• Solid Knowledge of MariaDB or MySQL relational databases and the SQL/DQL query language;
• Solid knowledge of HTML, CSS, JavaScript, jQuery, and ;
• Solid knowledge of Git (GitLab) for version control and issue tracking;
• Knowledge of the UNIX/Linux Operating System and command line tools;
• Ability to create new and modify existing application code based on business requirements;
• Ability to code to industry standards and write technical documentation in English in a fluent and consistent manner.

Assets
1. Understanding SAML authentication and MS Graph API.
2. Familiarity with the Web Content Accessibility Guidelines (WCAG).

Behavioural competencies

• Technology support - Client focus (Level 2)
• Technology support - Communication (Level 2)
• Technology support - Conceptual and analytical ability (Level 3)
• Technology support - Results orientation (Level 3)
• Technology support - Teamwork (Level 2)

Competency Profile(s)

For this position, the NRC will evaluate candidates using the following competency profile(s): Technology Support

View all competency profiles

Compensation

From $103,911 to $130,061 per annum.

NRC employees enjoy a wide-range of competitive benefits including a robust pension plan, comprehensive health and dental coverage, disability and life insurance, office closure at the end of December, and additional supports to enhance your well-being throughout your career and beyond.