NOTICE OF PROPOSED PROCUREMENT (NPP) - Database Administrators - Level 3

NOTICE OF PROPOSED PROCUREMENT (NPP) FOR TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS)GSIN: D302A INFORMATICS PROFESSIONAL SERVICESReference Number: 1000029713Solicitation Number: 1000029713Organization Name: Department of Justice CanadaSolicitation Date: 2021-08-12Closing Date: 2021-09-21 02:00 PM Eastern Daylight Saving Time EDTAnticipated Start Date: 2021-11-01Estimate Level of Effort: Unknown – Task Authorization Contract for services as and when required, award value: $3,703,000.00 including taxesContract Duration: The contract period will be from the date of contract to March 31, 2026, with two (2) additional one (1) year option periodsSolicitation Method: CompetitiveApplicable Trade Agreements: Canada Free Trade Agreement (CFTA), World Trade Organization Agreement on Government Procurement (WTO-AGP), Canada-Chile Free Trade Agreement, Canada-Columbia Free Trade Agreement, Canada-Panama Free Trade Agreement, Comprehensive Economic and Trade Agreement (European Union), Canada-Honduras Free Trade Agreement, Canada-Korea Free Trade Agreement, Canada-Peru Free Trade Agreement, Canada-Ukraine Free Trade Agreement, Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP)Comprehensive Land Claim Agreement Applies: NoNumber of Contracts: One (1)Requirement DetailsTendering Procedure: Selective TenderingThis 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:Two (2) Level 3 Database AdministratorsThe following SA Holders have been invited to submit a proposal:Adirondack Information Management Inc., Amita Corporation, Artemp Personnel Services Inc., The AIM Group Inc.,in JOINT VENTURECistel Technology Inc.Cofomo OttawaCompuStaff Corp.Donna Cona Inc.Knowledge Providers Inc. Koroc Consulting Inc., Isheva Inc. in JOINT VENTUREMAKWA Resourcing Inc.Maplesoft Consulting Inc.Pricewaterhouse Coopers LLPPromaxis Systems Inc. and Holonics Inc. IN JOINT VENTURES.I. SYSTEMS ULCTEKSYSTEMS CANADA CORP./SOCIÉTÉ TEKSYSTEMS CANADAThales Canada Inc.The AIM Group Inc.Description of Work:The Work is to be performed on JUS current and future managed and administered servers, applications/systems and supported software. Ongoing uninterrupted access to data without performance degradation is of the utmost concern. The Contractor’s DBAs will need to work at times in conjunction with SSC when SQL Server related matters must be escalated. They will be asked to perform work outside of core working hours(7:00AM and 6:00PM ET) including weekends.The Server Operating Systems used are Microsoft Windows Server versions 2008 and up. The SQL databases are Microsoft SQL 2012 or higher. The reporting tools used at JUS are Microsoft SSRS and PowerBI although SSAS and SSIS are also analytical and ETL tools used. VMware is used to manage the virtual machines.The responsibilities of the Contractor’s DBAs can include but are not limited to:Provisioning of SQL server software including creating clusters and/or high availability groups;Building and maintaining databases for applications and information tools in development and production environments;Developing and implementing security procedures such as for authentication purposes (e.g., Kerberos) including access and user account management;Identifying requirements for improvements to existing databases for system performance and functional requirements;Troubleshooting and resolving database related technical problems in non-production and production environments as well as data issues such as data integrity issues;Advising programmers, analysts, and users about the efficient use of data;Assisting in the design of data exchange interface between systems and related frameworks;Participating in the ongoing technical and application support in a production environment, including high availability (HA) technology and data extract scripts;Optimizing and fine tuning activities;Writing highly complex scripts to Extract, Transform, Load (ETL) data from one or multiple sources including complex data conversions/manipulations;Completing peer code reviews and providing recommendations to optimize performance;Producing documentation for corporate memory purposes;Performing knowledge transfer to JUS employees.Security Requirement: Common PS SRCL #34 appliesMinimum Corporate Security Required: Facility security clearance at the level of secretMinimum Resource Security Required: SecretContract AuthorityName: Kayla PordonickPhone Number: 613-301-9709Email Address: Kayla.Pordonick@justice.gc.ca InquiriesInquiries 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