NOTICE OF PROPOSED PROCUREMENT (NPP)
For
TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS)
GSIN: D302A ADP SYSTEM DEVELOPMENT SERVICES
Reference Number: 87055-15-0202 Solicitation Number: 87055-15-0202
Organization Name: Canadian Nuclear Safety Commission
Solicitation Date: 2015-09-08 Closing Date: 2015-09-23 02:00 PM Eastern Daylight Saving Time (EDT)
Anticipated Start Date: 1 to 2 months from closing date
Estimated Delivery Date: Estimate Level of Effort: 180 days (including Option Periods)
Contract Duration: The contract period will be for 60 days from the date of contract with an irrevocable option to extend it for up to 2 additional 60-day periods.
Solicitation Method: Competitive Applicable Trade Agreements: WTO-AGP, NAFTA, AIT
Comprehensive Land Claim Agreement Applies: No Number of Contracts: 1
Requirement Details
Tendering Procedure: Selective Tendering
This requirement is open only to those TBIPS Supply Arrangement Holders who qualified under Tier 1 for services in the National Capital Region for the following category:
One (1) I.4 Database Modeller/IM Modeller, Level 3
The following SA Holders have been invited to submit a proposal:
6233902 Canada Ltd.
Aerotek ULC
Cache Computer Consulting Corp.
Calian Ltd.
CISTEL TECHNOLOGY INC, TECSIS CORPORATION IN JOINT VENTURE
DLS Technology Corporation
DWP Solutions Inc.
Greenline Systems Canada, ULC
Holonics Inc.
Nortak Software Ltd.
PRECISIONERP INCORPORATED
Prolity Corporation
The VCAN Group Inc., Titus International Inc. in Joint Venture
TPG Technology Consulting Ltd.
Veritaaq Technology House Inc.
However, should an uninvited SA Holder wish to be invited, it may contact the Contracting Authority in writing to request an invitation at any time prior to five days before the published bid closing date, and an invitation will be made to that SA Holder. To ensure efficient operation of the procurement system, the Contracting Authority will invite no more than the first 10 SA Holders that request an invitation. In no circumstance will such an invitation require Canada to extend a bid closing date.
Description of Work:
Objective and Scope
The CNSC requires the full-time professional services of one (1) Level 3 Database Modeller to provide database design and development, database modelling, and database conversion activities in support of upcoming IMTD projects.
Technical Environment
The current technological environment at CNSC is as follows:
- Microsoft SQL Server 2005, 2008, 2012, and a Clustered SQL 2008 environment;
- Visual Basic .NET (VB.NET) and C# applications;
- PowerBuilder 8 to 12.6 applications;
- ColdFusion 6 to 11 applications;
- Microsoft Windows Server 2008 R2
- Microsoft Team Foundation Server 2008 and 2012
- Microsoft Dynamics CRM 2013
- Microsoft Windows 7
- Microsoft Office 2010
Tasks
The Database Modeller’s tasks include, but are not limited to, the following:
- Provide database design and development.
- Perform database modelling.
- Perform database conversions.
- Review corporate architecture strategies and directions, data requirements, and business information needs and devise data structures to support them.
- Improve modeling efficiency through recommendations on how to better utilize current metadata repositories
- Participate in the development of data modelling and metadata policies and procedures.
- Build, convert, test, repair, configure and document 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, 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.
- Design, develop and maintain web-based database applications.
- Analyze and tune databases for optimal efficiency.
- Provide database support and advice to the application developers.
- Produce, modify and maintain database design requirement documents
- Perform and/or coordinate updates to the database design.
- Develop and implement security procedures for the database, including access and user account management.
- Provide hands-on, expert technical assistance to developers
- Transfer knowledge to CNSC staff throughout the process
- Working beyond normal working hours, including evenings and weekends as and when required on approval from Technical Authority.
Deliverables
The Database Modeller will be responsible for the following deliverables:
- New Database applications
- Data models
- Database conversions
- Database modifications according to business, functional and design requirements
- Tables, indexes, views, triggers and stored procedures
- Database security procedures
- Database design requirement documents
- Detailed deployment instructions documents
- Other resource or client identified architecture-related documentation/artefacts
Incumbent:
The work has been performed by a contracted resource in the last 12 months.
Security Requirement: Common PS SRCL #19 applies
Minimum Corporate Security Required: Facility Security Clearance (FSC)
Minimum Resource Security Required: Secret Clearance
Contract Authority
Name: Dan Simard
Phone Number: 613-996-6784
Email Address: d••••••••@••••••••.••.ca
Inquiries
Inquiries regarding this RFP requirement must be submitted to the Contracting Authority named above. Request for Proposal (RFP) documents will be e-mailed directly from the Contracting Authority to the Qualified Supply Arrangement Holders who are being invited to bid on this requirement. BIDDERS ARE ADVISED THAT “BUYANDSELL.GC.CA” IS NOT RESPONSIBLE FOR THE DISTRIBUTION OF SOLICITATION DOCUMENTS. The Crown retains the right to negotiate with any supplier on any procurement. Documents may be submitted in either official language.
NOTE: Task-Based Informatics Professional Services (TBIPS) Method of Supply is refreshed three (3) times per year. If you wish to find out how you can be a “Qualified SA Holder”, please contact R••••••••@•••••.••.ca.
