Developer, 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 special accommodation. All information received in relation to accommodation will be kept confidential.

Information on accommodation for persons with disabilities

Duties

TBS is positioning itself to be on the leading edge of digital transformation in government. If you are interested in helping to incubate the future of IM/IT in government then this is an exciting opportunity. Whether it is trailblazing the use of Protected B cloud, Machine learning and Artificial Intelligence and agile delivery software, you will have the opportunity to contribute and be seen as a leader in digitizing the Government of Canada.

Work environment

The Treasury Board of Canada Secretariat (TBS) is a central agency located in the National Capital Region. Working at TBS offers a unique opportunity to contribute to the work of a central federal agency, and to be part of cultivating the federal public service as a model workplace. With high-performing teams and innovative practices, TBS professionals in various fields serve Canadians by collaborating on government-wide initiatives, driving excellence in people management and taking initiative while effectively managing risks.

TBS’s new flagship facility at 90 Elgin Street, in the heart of downtown Ottawa, is the hub of its activities. The new building meets the government’s Workplace 2.0 concept, has Wi-Fi throughout, and has many fully equipped videoconference areas to support collaboration and innovation. Employees have access to amenities such as showers, change rooms and secure bicycle storage, allowing them to commute using Ottawa’s bike path system.

If you are a leader, a motivator and a strategic thinker who wants to work for one of Canada’s Top Employers, consider joining the TBS team.

Intent of the process

A pool of qualified persons resulting from this process MAY be created and MAY be used to fill similar positions with linguistic profiles (English essential, bilingual imperative BBB/BBB, bilingual imperative CBC/CBC) as well as tenures (indeterminate, deployment, acting, assignment, secondment, specified period) which may vary according to the position being staffed.

This pool may be used to staff similar positions in other organizations within the core public administration (http://www.psc-cfp.gc.ca/plcy-pltq/rfli-lirf/index-eng.htm).

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:
Successful completion of two 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.

1. Indeterminate period incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above are deemed to meet the minimum education standards based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the CS group.

2. At the manager's discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum post-secondary education stated above. Whenever the minimum education is met via this alternative, it is met for the specific position only and must be re-assessed for other positions for which this alternative has been specified by the manager.

Experience:
- Experience in analyzing user requirements and providing development estimates.
- Experience in designing, developing, testing, maintaining and implementing IM/IT solutions or services
- Experience working with multi-disciplinary or cross-functional business IT teams;
- Experience in troubleshooting technical issues

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

Various language requirements
Bilingual Imperative BBB/BBB
English Essential

Information on language requirements

Knowledge:
- Knowledge of the Software Development Life Cycle (SDLC)
- Knowledge of Agile methodology

Competencies:
- Analytical Thinking
- Initiative
- Teamwork
- Results orientation
- Application development and support maintenance

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

- Experience in the development, testing, implementation, maintenance and support of web-based applications and static Web sites using CSS, HTML, XML, ASP, ASP.NET, VB.NET, C#.Net, JavaScript
- Experience in programming within the .NET Framework 3.0 and above using Visual Studio
- Experience with MS-SQL Relational Database Management Systems (RDBMS);
- Experience implementing Web Content Accessibility Guidelines (WCAG) when developing or modifying web applications.
- Significant experience building and maintaining Desktop and Server Operating Systems
- Significant and recent experience with monitoring and supporting Infrastructure systems
- Experience writing technical procedures and support documentation
- Recent experience automating processes through PowerShell or other scripting languages.
- Experience configuring and supporting Microsoft CRM Dynamics software
- Experience configuring and supporting CA Clarity Project Portfolio Management software
- Experience in crystal report development
- Experience in SSIS packages and ETL development
- Experience in SQL 2012 and higher
- Experience in Python
- Experience in R
- Experience in relational databases, creating SQL queries, views and stored procedures
- Experience in data modelling

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 targeted groups when you apply.

Information on employment equity

We will communicate with you about this process by email. As a result, you must update your Public Service Resourcing System profile if it changes. Applicants should use an email address that accepts messages from unknown senders (some email systems block such messages).

If you do not respond to our communications, we will interpret this as your withdrawal from the process.

Candidates may be required to meet the asset qualifications or the organizational needs, depending on the requirements of the specific position being staffed.

Reference checks may be sought.
An interview may be administered.
A test may be administered.
An assignment, secondment, or acting appointment requires approval of your supervisor.
Please identify clearly for which position(s) you are submitting an application.
You must provide proof of your education credentials.
Persons are entitled to participate in the appointment process in the official language of their choice.
You must indicate on your application if you require a technical aid for testing or an alternative method of assessment.
A random and/or top down selection of candidates may be used in the determination of those to be given further consideration in the assessment process.

Preference

Preference will be given to veterans and to Canadian citizens, in that order.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.