NOTICE OF PROPOSED PROCUREMENT (NPP) - Database Administrators - Level 3
Solicitation number 1000029713
Publication date
Closing date and time 2021/09/21 14:00 EDT
Last amendment date
Description
NOTICE OF PROPOSED PROCUREMENT (NPP) FOR TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS)
GSIN: D302A INFORMATICS PROFESSIONAL SERVICES
Reference Number: 1000029713
Solicitation Number: 1000029713
Organization Name: Department of Justice Canada
Solicitation Date: 2021-08-12
Closing Date: 2021-09-21 02:00 PM Eastern Daylight Saving Time EDT
Anticipated Start Date: 2021-11-01
Estimate Level of Effort: Unknown – Task Authorization Contract for services as and when required, award value: $3,703,000.00 including taxes
Contract Duration: The contract period will be from the date of contract to March 31, 2026, with two (2) additional one (1) year option periods
Solicitation Method: Competitive
Applicable 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: No
Number of Contracts: One (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:
- Two (2) Level 3 Database Administrators
The 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 VENTURE
- Cistel Technology Inc.
- Cofomo Ottawa
- CompuStaff Corp.
- Donna Cona Inc.
- Knowledge Providers Inc.
- Koroc Consulting Inc., Isheva Inc. in JOINT VENTURE
- MAKWA Resourcing Inc.
- Maplesoft Consulting Inc.
- Pricewaterhouse Coopers LLP
- Promaxis Systems Inc. and Holonics Inc. IN JOINT VENTURE
- S.I. SYSTEMS ULC
- TEKSYSTEMS CANADA CORP./SOCIÉTÉ TEKSYSTEMS CANADA
- Thales 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 applies
Minimum Corporate Security Required: Facility security clearance at the level of secret
Minimum Resource Security Required: Secret
Contract Authority
Name: Kayla Pordonick
Phone Number: 613-301-9709
Email Address: Kayla.Pordonick@justice.gc.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
Contract duration
Refer to the description above for full details.
Trade agreements
-
World Trade Organization Agreement on Government Procurement (WTO GPA)
-
Canada-Panama Free Trade Agreement
-
Canada-Korea Free Trade Agreement (CKFTA)
-
Canada-Honduras Free Trade Agreement
-
Canadian Free Trade Agreement (CFTA)
-
Canada-European Union Comprehensive Economic and Trade Agreement (CETA)
-
Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP)
-
Canada-Ukraine Free Trade Agreement (CUFTA)
-
Canada-UK Trade Continuity Agreement (Canada-UK TCA)
-
Canada-Chile Free Trade Agreement (CCFTA)
-
Canada-Colombia Free Trade Agreement
-
Canada-Peru Free Trade Agreement (CPFTA)
Contact information
Contracting organization
- Organization
-
Department of Justice Canada
- Address
-
284 Wellington StreetOttawa, Ontario, K1A0H8Canada
- Contracting authority
- Pordonick, Kayla
- Phone
- 613-301-9709
- Email
- Kayla.Pordonick@justice.gc.ca
- Address
-
284 Wellington StreetOttawa, ON, K1A 0H8CA
Buying organization(s)
- Organization
-
Department of Justice Canada
- Address
-
284 Wellington StreetOttawa, Ontario, K1A0H8Canada
Bidding details
Details for this tender opportunity are provided in the Description tab.
Please contact the contracting officer to get the full solicitation documentation, access information on how to bid, or if you have any questions regarding this tender opportunity.
Note that there may be fees to access the documents or bid. These should be outlined in the Description tab.
We recommend that you contact the contracting officer as soon as possible, as there may be deadlines for receiving questions.