8-Attachment D1 - Tech and Security Requirements Innovation Challenge.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Tech Innovation Challenge - Fire Department
Solicitation number
542905
Issued by
Wayne County, Detroit City, Michigan

About this file

Summary

This is a Technical and Security Requirements Matrix prepared by the City of Detroit Office of Contracting and Procurement for a Technology Innovation Challenge focused on equipping Detroit firefighters and medics with modern safety and response technologies. The requirements document establishes baseline security and cloud infrastructure standards that prospective vendors must meet or address through their proposed solutions. The matrix comprises 70 total requirements and questions organized across two functional areas: General Security (44 requirements) and Cloud Checklist Questionnaire (26 requirements). Vendors are required to respond using a standardized coding system indicating whether requirements are met as proposed (C), met with alternatives (A), or not met (N), with space for explanatory comments.

The General Security section addresses single sign-on and Active Directory integration, multi-factor authentication, SAML authentication through Azure Active Directory, encryption protocols for data at rest and in transit, role-based security controls at multiple organizational levels, user group management, and compliance certifications including HIPAA, CJIS, and IRS Publication 1075. Additional security requirements cover audit trail capabilities with second-level precision timestamps, administrative configuration of log retention periods, customizable audit reporting, session timeout functionality, security activity logging, and file scanning for cyber threats. The Cloud Checklist section requires vendors to describe uptime responsibilities, governance and notification processes, legal and regulatory compliance strategies, adherence to security frameworks such as NIST, ISO/IEC, COBIT, or ITIL, and provision of SOC 2 Type 2 reports at no additional cost. Vendors must also address account management, security monitoring, data inventory procedures, subcontractor security inheritance, public key infrastructure, data separation in multitenant environments, network segmentation, firewall protection with intrusion detection, dedicated virtual resources, media sanitization procedures, and system environment availability.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Table of Contents

Table of Contents
Tab No.Functional AreaNumber of Requirements / Questions
1General Security44
2Cloud Checklist Questionnaire26
Total Requirements + Questions:70

1. Security

ATTACHMENT F - REQUIREMENTS MATRIX
RFP Name & RFP # _________Enter vendor name here
Available Responses
CRequirement Met and Proposed (Standard features available in the product)0
AIntent of Requirement Met and Proposed with Alternative0
NRequirement Not Met with Proposal0

TOTAL 0

Req #FunctionGeneral Security RequirementVendor Response
(C, A, N)Comments
1SSOThe system has the ability to utilize the City's Active Directory user validation to achieve single-sign-on, regardless of deployment method.
2AD integrationThe system has the ability to inherit groups from Active Directory for application authentication.
Multi Factor AuthenticationThe system has the ability to support Multi Factor Authentication (MFA)
3SAMLThe system has the ability to utilize the City's SAML Authentication (Azure Active Directory) for user validation to achieve single-sign-on, regardless of deployment method.
4SAMLThe system has the ability to map SAML groups or App roles from Azure Active Directory for application permissions .
5Password EncryptionThe system has the ability to store passwords in encrypted form, if applicable.
6EncryptionThe system has the ability to encrypt data stored in the database.
7EncryptionThe system has the ability to encrypt data stored in the application.
8EncryptionThe system has the ability to encrypt data in transit.
9EncryptionPlease provide information as to what level of encryption/encryption methods are used in transit and at rest.
10Role based securityThe system has the ability to provide read, write, update, and delete access using role based security.
11Role based securityThe system has the ability to provide security at the following levels:
12Role based securityDepartment or Agency;
13Role based securityDivision;
14Role based securityRole or group;
15Role based securityUser ID;
16Role based securityScreen;
17Role based securityMenu;
18Role based securityReport;
19Role based securityField;
20Role based securityThe system allows for departmental administrative self-service (e.g. ability to make changes to roles and workflows) with audit trail capability.
21Role based securityThe system has the ability to update all user profiles automatically (user discretion) when a change in their role (s) is/are made.
22Role based securityThe system has the ability to allow a City system administrator to add and change permissions for system access.
23User GroupsThe system has the ability to establish, deactivate, and archive user groups.
24User GroupsThe system has the ability to delete user groups that do not have historical data, with an audit trail.
25City AdministrationThe system allows for departmental administrative self-service (e.g. ability to make changes to roles and workflows) with audit trail capability.
26ComplianceThe system is HIPAA compliant and vendor will enter into a BAA with the City.
27ComplianceThe system is CJIS compliant
ComplianceThe system is IRS Publication 1075 compliant
28ComplianceThe system meets compliance rules / regulations in order to ensure the sensitive digital assets are guarded against loss, theft and misuse
29ComplianceThe system is compliant with applicable compliance regulations.
30Security CertificationsPlease list any industry standard security certifications the solution / vendor has. (Ex: ISO 27001).

Please note annual SOC 2 type reports will be required via the City’s contract.

31Audit CapabilitiesThe system has the ability to track and audit changes throughout the system that creates a log of all records maintained and includes:
32Audit CapabilitiesDate;
33Audit CapabilitiesTime;
34Audit CapabilitiesUser;
35Audit CapabilitiesInformation prior to change;
36Audit CapabilitiesChanged information
37Audit CapabilitiesThe system has the ability to allow the audit trail to have a date/time stamp to the nearest second.
38Audit CapabilitiesThe system has the ability to allow a City system administrator to configure the duration that time audit logs are retained (e.g. 90 days). Proposer to describe how this feature works.
39Audit CapabilitiesThe system has the ability to provide customizable audit reports.
40Access Time OutThe system has the ability to log users off the system after an administrator-defined period of inactivity, based on user-defined roles.
41Access Time OutThe system has the ability to allow a system administrator to log out users.
42SecurityThe system has the ability to allow authorized users to have access to a log of security activity to determine users that have signed on and off the system, as well as unsuccessful attempts to sign on to the system.
43SecurityThe system has the ability to scan attached files for viruses, malware, or other cybersecurity threats (vendor to specify capability for using City preferred anti-virus solutions).
44APIThe system has the ability to support API's (Application Programming Interface) for third-party system integration, imports, and exports of data.

2. Cloud Checklist

ATTACHMENT F - REQUIREMENTS MATRIX

RFP Name & RFP # _________

Cloud Service Provider Security Checklist
Please provide an answer or statement to all issues listed
Enter vendor name here
Prompt #TopicVendor Response
1Describe who is responsible uptime, maintenance, patching and administration of the server.
2The provider must show diagram (and possible past examples) of their governance and notification processes for their services.
3Describe how the provider will guarantee legal and regulatory compliance with government and sectorial (industry specific) laws and regulations.
4Does the solution follow one of the following sets of security and privacy control best practices? Indicate which.
4aNIST Series
4bISO/IEC Series
4cCOBIT
4dITIL
5The vendor will provide to the City, at no additional cost, the most recent SOC 2 Type 2 report from its cloud hosting provider covering the environments used by the City.
6Describe process for Account Management
7Define who is responsible for security monitoring. If the City will be responsible for securing the environment, describe how the City will obtain logs to ingest into its SIEM.
8Describe how a data inventory of City of Detroit Data Assets will be kept.
9Will subcontractors be used? If yes, will all security controls be inherited by subcontractors?
10Describe Public Key Infrastructure
11Process for separation of data belonging to different consumers in a multi‐tenant environment.
12Does the solution use a private, shared or hybrid cloud?
13Process used to separation of network traffic in a shared multi‐tenant provider environment
14Statement guaranteeing adherence to all privacy laws governing the physical areas of data storage.
15Willing to participate in a Risk Assessment and Privacy Impact Assessment covering the storage of PII.
16Network traffic must be screened and firewall protected network must have intrusion detection & prevention in place.
17Network must have detailed logging and documented alerting capabilities.
18Dedicate VLANs with dedicated virtual firewall.
19Describe how the City of Detroit network access separated from provider network access.
20Are the City of Detroit VMs are on a dedicated hypervisor?
21Will provider's servers only communicate with the City of Detroit logical disk units?
22Will online storage and backup media be scrubbed when retired or replaced?
23Identify system environments that will be available to the City (e.g. production, development, test)
24Identify shared components of the system (e.g., network segments, backup tapes, etc.)
25Identify Data storage and transfer limits
26Identify normal and peak bandwidth requirements

File details come from the government source that posted it. Updated .