TBIPS - Level 3, I.4 Database Modeller / IM Modeller (NPP)

NOTICE OF PROPOSED PROCUREMENT (NPP) For TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS) GSIN: D302A ADP SYSTEM DEVELOPMENT SERVICES

Reference Number: 87055-16-0406 Solicitation Number: 87055-16-0406 Organization Name: Canadian Nuclear Safety Commission Solicitation Date: 2017-03-09 Closing Date: 2017-03-23 02:00 PM (EDT) Anticipated Start Date: 1 to 2 months from closing date Estimated Delivery Date: Estimate Level of Effort:  440 days (including Option Periods) Contract Duration: The contract period will be for 110 days from the date of contract with an irrevocable option to extend it for up to 3 additional 110-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) Level 3, I.4 Database Modeller / IM Modeller The following SA Holders have been invited to submit a proposal: 2Keys Corporation Apption Corporation Coradix technology Consulting Ltd. Emerion Flex Tech Services Inc. Lightning Tree Consulting, Burbek, and P.G. Rodier Consulting in Joint Venture LIKE 10 INC., SoftMosis Inc. IN JOINT VENTURE MGIS Inc., B D M K Consultants Inc IN JOINT VENTURE Nisha Technologies Inc. Real Decoy Inc. Symbiotic Group Inc. Systematix IT Solutions Inc./Systematix Technologies de L'Information Inc./Les Services Conseils Systematix Inc. in Joint Venture. Teambuilder Consulting Inc. TeraMach Technologies Inc. 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: 1.0 Objective CNSC requires the professional services a Level 3 Database Modeller to provide database design and development, database modelling and database conversion in support of upcoming IMTD projects). 2.0 Technical Environment

Microsoft SQL Server 2005, 2008, 2012 and Clustered SQL 2008 environment; Sybase ASE 15.5 Microsoft VB.NET applications C# ASPX applications PowerBuilder 10.5 applications Cold Fusion 6, 7 and 10 applications Windows Server 2008 Microsoft SQL Server 2008, 2012 and Clustered SQL 2008 environment Microsoft Team Foundation Server 2008 and 2012 Microsoft Windows 7 Microsoft Office 2010

3.0 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. Working beyond normal working hours, including evenings and weekends as and when required on approval from Project Authority.

4.0 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

Incumbent: The work was 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: dan.simard@canada.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 RCNMDAI.-NCRIMOS@pwgsc.gc.ca