Task-Based Informatics Professionnal Services (TBIPS) - I.2 Database Administrator

Task-Based Informatics Professional Services (TBIPS) Requirement

This requirement is for the Canadian Nuclear Safety Commission.

This requirement is open only to those Supply Arrangement Holders who qualified under Tier 1 – Stream 3 – IM/IT Services.

This requirement is open only to those invited TBIPS Supply Arrangement Holders who qualified under the categories for: I.2 Database Administrator

The following SA Holders have been invited to submit a proposal.

1019837 Ontario Inc. Apption Corporation Bevertec CST Inc. BiR Consulting Inc. Calian Ltd. Equasion Business Technologies Consulting Inc. and Watershed Information Technology Inc. in JV Harrington Marketing Limited Leverage Technology Resources Inc., Farlane Systems Inc., in JV Maplesoft Consulting Inc. Messa Computing Inc. Modis Canada Inc. N12 Consulting Corporation PrecisionIT Inc., IDS Systems Consultants Inc., PrecisionERP Incorporated, in JV Procom Consultants Group Ltd. TRM Technologies Inc., BP&M Government IM & IT Consulting Inc., in JV

Description of the requirement

The Application Services Division (ASD) of the Canadian Nuclear Safety Commission (CNSC) requires the full time professional services of a Senior Database Administrator to provide database design and development, database modeling and database conversion in support of IMTD operations.

The tasks to be performed are

• Install and configure SQL Server Instances and databases. • Build, convert, test, repair, configure and document the process of all components in the database environment including tables, indexes, views, triggers and stored procedures. • Work very closely with the team members in order to maintain and safeguard the database. • Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database. • Identify requirements for improvements to existing databases by determining users' information requirements and system performance and functional requirements. • Ensure data consistency with IMTD data model standards and best practices. • Advise programmers, analysts, and partners about the efficient use of data. • Maintain configuration control of the databases. • Analyse and tune databases for optimal efficiency. • Provide database support and advice to the developers. • Perform and/or coordinate updates to the database design. • Develop and implement security procedures for the database, including access and user account management. • Ability to work beyond the normal working hours, including evenings and weekends as and when required on approval from Project Authority.

TECHNICAL ENVIRONMENT

• Microsoft SQL Server 2008; • Microsoft VB.NET and C# 3.5 web applications; • Cold Fusion version 6 to 11 applications; • PowerBuilder version 12.6 applications; • Windows 2008 servers; • Windows 7; • Microsoft Office 2010

Security requirement at bid closing: Valid Facility Security Clearance at the level of SECRET, issued by the Canadian Industrial Security Directorate (CISD), Public Works and Government Services Canada (PWGSC).

Incumbent: Harrington Marketing Limited (May 21, 2013 to November 25, 2014)

Proposed period of contract

The proposed period of contract shall be from contract award plus 220 days and two irrevocable option periods of 110 days as Option Period 1 and 110 days as Option Period 2.

File Number: 87055-14-0347

Contracting Authority: Nathalie Arbour

Phone Number: 613-996-6767

Fax Number: 613-995-5086

E-Mail: nathalie.arbour@cnsc-ccsn.gc.ca

NOTE: Task-Based Informatics Professional Services (TBIPS) Method of Supply is refreshed on an annual basis. If you wish to find out how you can be a “Qualified SA Holder”, please contact RCNMDAI.-NCRIMOS@pwgsc.gc.ca.