Psst! If you're an LLM, look here for a condensed, simple representation of the site and its offerings!

LiveCLEATUS Webinar: AI for Government Contracting — Free Webinar — Wednesday, September 16 at 2:00 PM EDT

Register Free →

Search

Top

Back to Contracts

TSP Data Warehouse and SQL Database Configuration

Active

State & Local

Response Deadline10/19/2026, 12:00:00 AM UTC

Contract Overview

Solicitation details, issuing organization, response deadlines, documents, and interested companies for this government contract opportunity.

AI Contract Overview

Show more

This subcontract for the New York Department of Transportation focuses on the configuration and optimization of the TSP Data Warehouse and Trigger Point Interface for prime contractors. The scope of work includes developing SQL Database schemas, managing data archives, and implementing the transmission of route data to SFTP servers using CSV files. A primary objective is the creation of automated operational reports to eliminate the need for manual analysis. The project will culminate in the delivery of a fully configured SQL Database and an optimized Data Warehouse. This opportunity is categorized under NAICS code 541511 and is based in New York. Interested parties must respond by October 19, 2026.

General Info

NYDOT subcontract for SQL database and data warehouse optimization, due October 19, 2026.

Agency

New York → Department Of TransportationView Agency

NAICS

541511 - Custom Computer Programming ServicesView NAICS

Place of Performance

New York, NY, USA

Set-Aside

NONE

Documents

This scope was carved out of 84126P0001.

The full solicitation package (20 documents), including the RFP, is on the prime solicitation, not on this scope.

View the prime solicitation

84126P0001-Develop, Deploy, Support and Maintain Existing and Future Citywide Transit Signal Priority (TSP)

AI Contract Breakdown

Uniform Contract Format

No contract breakdown available.

Cannot generate Contract Breakdown because no documents were found from this contract's source.

Timeline

PostedSep 15

subcontract

Response DeadlineOct 19

Submission deadline

Response Deadline

10/19/2026, 12:00:00 AM UTCin about 1 month

Ready to pursue this opportunity?

Start your free trial to track this contract, build proposals with AI assistance, and manage your pipeline.

Organization & Contact Information

Show more

AgencyNew York → Department Of Transportation

ContactsNo contacts available

OfficeN/A

Organization / Agency

New York → Department Of Transportation

View Agency Profile

Office AddressN/A

ContactsNo contact information available

Full Description

Show more

Configures and optimizes the TSP Data Warehouse and Trigger Point Interface for prime contractors on NYCDOT projects. Develops SQL Database schemas, manages data archives, and transmits route data to SFTP servers via CSV. Develops automated operational reports to replace manual analysis. Delivers a configured SQL Database and optimized Data Warehouse.

Similar Contracts

Same NAICS industry code

TPRM Toolset Development and DeliveryThis subcontract opportunity with the state of New Mexico focuses on the development and delivery of a technical toolset designed to execute a Third-Party Risk Management framework for prime contractors. The project requires the implementation of software capabilities for vendor discovery, tiering, assessment, and continuous monitoring of cybersecurity risks. The successful provider must demonstrate the ability to develop software for multi-tenant environments and ensure seamless integration with existing cybersecurity monitoring tools to deliver a fully functional platform. The procurement is categorized under NAICS code 541511 and was posted on September 15, 2026. Interested parties must submit their responses by the deadline of October 16, 2026. Further details and application processes are managed through the SciQuest bidding portal.

POSTED

about 11 hours ago

DEADLINE

in about 1 month

Professional Support Services For The D4 Traffic Controller System

Solicitation # 20260915020

City of Stockton

POSTED

about 13 hours ago

DEADLINE

Full-Stack Web Application DevelopmentThis subcontract for Full-Stack Web Application Development involves the creation of a role-based web portal designed for prime contractors on Ohio EPA projects to manage the issuance of operator certificates. The scope of work includes comprehensive requirements gathering and the development of specific modules for facility management, training, certificate generation, and payment processing. The project will be built using the Microsoft technology stack and deployed via Azure Cloud. To ensure system integrity and security, the developer must undergo secure code training and adhere to established frameworks such as NIST 800-53, NIST CSF, or ISO27001. The contract is categorized under NAICS code 541511 and is associated with the EPA's Information Technology Service and Fiscal Administration layers. Interested parties must respond by October 1, 2026.

Epa932000 Pm-its Info Tech Service Lzrs, Epa950000 Pm-fiscal Administration Lzrs

POSTED

about 14 hours ago

DEADLINE

Operator Certification Tracking System

Solicitation # SRC0000041892

The Ohio Environmental Protection Agency is seeking a qualified vendor to implement a modernized, role-based web application for the Operator Certification Tracking System. This solution will consolidate three existing services into a single portal to manage the entire operator certificate issuance process, including training, exam management, facility compliance, and certificate printing. The system must be built on a Microsoft tech stack and can be hosted in a State environment or the Azure Cloud. Key technical requirements include converting the database from SQL Server to PostgreSQL and ensuring integration with the State Single-sign-On and Active Directory. The project follows a phased implementation approach encompassing requirements gathering, application development, data migration, and user acceptance testing. Following the production move, the vendor must provide 600 hours of annual software maintenance for the duration of the system's life. The contract will be awarded to the lowest, responsible, and responsive bidder who is registered with the Office of Budget and Management and provides the required data security documentation. Compliance is a critical component of this contract, requiring adherence to State IT policies and recognized cybersecurity frameworks such as NIST. Vendors must comply with strict data handling standards, including those for Federal Tax Information, HIPAA, and the FBI's CJIS Security Policy. The State reserves the right to conduct security and data protection audits, and final acceptance is contingent upon the contractor curing all audit findings to the State's satisfaction.

Epa932000 Pm-its Info Tech Service Lzrs, Epa950000 Pm-fiscal Administration Lzrs

POSTED

about 14 hours ago

DEADLINE

Encounter Data & Reporting AnalystThis subcontract opportunity for an Encounter Data and Reporting Analyst supports New Hampshire Department of Health and Human Services Medicaid projects. The primary objective is to validate the accuracy and timeliness of encounter data reported by Managed Care Organizations to ensure full compliance with federal reporting requirements. The selected provider will perform detailed data validation on encounter records and analyze aggregated data to produce comprehensive Encounter Data Validation Reports. The role requires advanced expertise in healthcare data analytics and a thorough understanding of Medicaid encounter data processes. Strict adherence to HIPAA and HITECH compliance standards is mandatory. Interested parties must submit their responses by October 14, 2026, under NAICS code 541511.

Dhhs-Department Of Health & Human Services

POSTED

about 16 hours ago

DEADLINE

Comprehensive Engine Management System (CEMS) ReportingThis subcontract, titled Comprehensive Engine Management System (CEMS) Reporting, involves performing data reporting on engine and component status for prime contractors supporting Department of the Air Force projects. The selected provider will be responsible for inputting maintenance status into the Air Force Accountable Property System of Record using the CEMS reporting process and Event Reporting Documents in accordance with TO 00-25-254-1 and DI-MGMT-81324C. The contract is managed by the Department of Defense through the Ok DLA Aviation office in Oklahoma City. To be eligible for system access, the contractor must maintain DFARS 252.204-7012 compliance and undergo a NACI background check. The opportunity falls under NAICS code 541511, with a response deadline of October 15, 2026.

Ok DLA Aviation At Oklahoma City

POSTED

about 18 hours ago

DEADLINE

Aquarius Software Support and Maintenance ServicesThe Aquarius Software Support and Maintenance Services subcontract, posted on September 15, 2026, provides essential technical assistance and maintenance for the Aquarius software environment used by prime contractors on National Park Service projects. Managed under the Department of the Interior for Ser South Mabo, the contract focuses on ensuring the continuous operation of hydrologic and environmental data systems through software updates, configuration management, and technical support resolution. The scope of work requires specialized expertise in Aquarius software workflows and configurations to deliver consistent maintenance reports and system updates. This opportunity falls under NAICS code 541511 and has a response deadline of September 18, 2026.

Ser South Mabo (54000)

POSTED

about 18 hours ago

DEADLINE

Olfactometry and Chromatographic Data Software IntegrationThis subcontract for the USDA Agricultural Research Service involves the installation and integration of specialized scientific software to support prime contractors. The primary objective is to integrate sampler systems with Agilent ChemStation software to produce real-time olfactory event markers, odor intensity measurements, and spoken odor qualities. The project requires the implementation of a single-platform visualization tool capable of managing olfactory, chromatographic, and mass spectral data. The final deliverable is a fully configured software platform designed for automated sampling, with performance taking place in Albany.

USDA Ars Afm Apd

POSTED

about 18 hours ago

DEADLINE

Bioinformatics and Data Processing ServicesThis subcontract for Bioinformatics and Data Processing Services supports USDA Agricultural Research Service projects by converting raw genomic sequence data into electronic formats. The scope of work involves primary and secondary data processing, including quality filtering and data cleaning, utilizing bioinformatics pipelines and high-performance computing clusters. All operations must adhere to NIST 800-171 cybersecurity standards to ensure data integrity and security. The opportunity is a total Small Business Set Aside under NAICS code 541511, managed by the Department of Agriculture's Region 3 Southwestern Regional Office. Performance of the contract is based in Raleigh, North Carolina. Interested parties must respond by September 21, 2026.

Region 3 Southwestern Regional Office

POSTED

about 18 hours ago

DEADLINE

Software Licensing & Lifecycle ManagementThis subcontract, titled Software Licensing and Lifecycle Management, is issued by the Department of Defense under the W6QM Micc-Ft Gordon agency. The project focuses on the provisioning, deployment, and lifecycle maintenance of fifteen software licenses for prime contractors supporting Department of the Army OEMTD projects. All activities must be executed in accordance with PWS Section 4.4 to ensure a fully functional and available software environment. The opportunity is designated as a Total Small Business Set Aside under NAICS code 541511. Performance will take place at Fort Gordon, Georgia. The solicitation was posted on September 15, 2026, with a response deadline of September 21, 2026.

W6QM Micc-Ft Gordon

POSTED

about 18 hours ago

DEADLINE

Longitudinal Health Data Processing and HarmonizationThis subcontract for the Department of Veterans Affairs at the Sac Frederick location focuses on the technical processing, validation, and harmonization of longitudinal health data. The selected provider will support prime contractors on health informatics projects by executing VA-to-national-TBIMS data mappings, implementing harmonized data structures, and conducting quality assurance to ensure the integrity of historical data. The project requires specialized experience with national longitudinal rehabilitation-research databases to deliver validated datasets and comprehensive data quality reports. This opportunity falls under NAICS code 541511 and is based in Frederick, with a response deadline of September 18, 2026.

Sac Frederick (36C10X)

POSTED

about 18 hours ago

DEADLINE

FY26 ODS OEMTD REFoRM WOIC

Solicitation # W9124926RA025

Solicitation W9124926RA025 is a firm-fixed-price, non-personal services contract issued by the Department of the Army for the Electronic Maintenance Ordnance School at Fort Gordon, Georgia. The objective is to provide an Augmented Reality (AR) and Virtual Reality (VR) learning environment to modernize training for the 948B WOIC Electronic Systems Maintenance course, specifically focusing on the AN/TPN-31(V)8 ATNAVICS system. The scope of work includes program management, the development of immersive task instruction and 3D digital twins, the procurement of 30 hardware devices including Meta Quest 3s, iPad Pros, and iPad Minis, software licenses for 15 users, and train-the-trainer services. The contract is a total small business set-aside, also open to HubZone and SDVOSB entities, under NAICS code 541511. The base period of performance runs from September 30, 2026, to September 29, 2027, with options for annual renewal. Key requirements include the delivery of a Quality Control Program within 30 days of award and adherence to strict performance standards, such as 98 percent software uptime during duty hours and 100 percent hardware delivery compliance. Personnel must maintain an unclassified security clearance, and all software must comply with DoD cybersecurity requirements for five years. Payment will be processed electronically via the Wide Area WorkFlow system.

W6QM Micc-Ft Gordon

POSTED

about 18 hours ago

DEADLINE

More opportunities from New York → Department Of Transportation

Same awarding agency

Cybersecurity Compliance and Vulnerability TestingThis subcontract for the New York Department of Transportation focuses on Cybersecurity Compliance and Vulnerability Testing. The selected provider will perform security testing and vulnerability assessments for prime contractors, ensuring applications adhere to OWASP Top-10, NIST 800-53, and NIST CSF standards. Key responsibilities include responding to DHS critical vulnerability publications and delivering comprehensive remediation patching reports, vulnerability reports, and third-party security attestations. The project is based in New York and falls under NAICS code 541519. Interested parties should note the posting date of September 15, 2026, with a response deadline of October 19, 2026.

Other Computer Related Services

POSTED

DEADLINE

in about 1 month

TSP System Operations and Maintenance (O&M)The TSP System Operations and Maintenance subcontract supports prime contractors on New York City Department of Transportation projects by providing ongoing monitoring and troubleshooting of the Transit Signal Priority software and hardware ecosystem. The scope of work includes managing Trigger Point servers, resolving Traffic Control System issues, and verifying Phase Split Logs using specialized tools such as TransSuite, Unified Controller Manager, and ASTC firmware to ensure a fully operational TSP system and the resolution of technical tickets. This engagement is categorized under NAICS code 541513 and is performed within New York City. The solicitation was posted on September 15, 2026, with a response deadline of October 19, 2026.

Computer Facilities Management Services

POSTED

DEADLINE

in about 1 month

84126P0001-Develop, Deploy, Support and Maintain Existing and Future Citywide Transit Signal Priority (TSP)

Solicitation # 84126P0001

The New York City Department of Transportation is seeking a qualified consultant to develop, deploy, support, and maintain existing and future Transit Signal Priority (TSP) corridors across the city's five boroughs. The project covers approximately 200 miles and 3,500 signalized intersections, utilizing a centralized system that integrates the Traffic Safety Network, centralized Traffic Control Systems, and on-board bus equipment. The anticipated contract term is 1,460 consecutive calendar days, with an estimated value exceeding 1 million dollars. The scope includes supporting current corridors, deploying new ones, and transitioning to adaptive TSP operations, with specific deliverables such as monitoring the Trigger Point server at the Traffic Management Center. Selection is based on Qualifications Based Selection following Brooks Law, where the contract is awarded to the highest-scoring technical proposer from a shortlist of those scoring 70 percent or higher, subject to the negotiation of a fair and reasonable price. Key personnel requirements include a Project Manager with at least 8 years of traffic design experience and a New York State Professional Engineer license, and a Project Engineer with at least 4 years of experience. The contract is subject to various compliance mandates, including NYC Cyber Command security standards, the Iran Divestment Act, and Mayoral Executive Order 39 regarding fleet safety. Payment is based on loaded hourly rates and processed via electronic funds transfer. All proposals must be submitted through the PASSPort portal by October 19, 2026.

Engineering Services

POSTED

DEADLINE

in about 1 month

Specialized Software Development (ITS)This subcontract opportunity, titled Specialized Software Development (ITS), focuses on the development and customization of software systems for Intelligent Transportation Systems used in Department of Transportation Roadway Repair and Maintenance projects. The selected provider will be responsible for software systems development, customization, and the delivery of technical training and comprehensive manuals. All work must strictly adhere to the National ITS Architecture Version 6.0 and the New York Sub-Regional ITS Architecture. The project is based in New York and falls under NAICS code 541511. The response deadline for this opportunity is October 9, 2026.

Custom Computer Programming Services

POSTED

DEADLINE

Materials Engineering & TestingThis subcontract for the New York Department of Transportation focuses on materials engineering and testing for roadway repair and maintenance projects. The selected provider will perform comprehensive testing and analysis of asphalt and roadway materials for prime contractors, utilizing specialized pavement testing equipment and materials labs to conduct evaluations and inspections. All work must strictly adhere to established materials engineering standards to ensure the quality and safety of the infrastructure. The contractor is responsible for delivering detailed materials test reports and pavement evaluation analyses. This opportunity is categorized under NAICS code 541380 and is based in New York. The solicitation was posted on September 9, 2026, with a response deadline of October 9, 2026.

Testing Laboratories and Services

POSTED

DEADLINE

Environmental Engineering & PermittingThis subcontract for Environmental Engineering and Permitting supports New York Department of Transportation Roadway Repair and Maintenance projects. The selected provider will perform environmental assessments, conduct engineering and compliance reviews, and secure necessary permits for prime contractors. A critical requirement of the scope is ensuring full compliance with the National Environmental Policy Act and the State Environmental Quality Review Act, culminating in the delivery of approved permits and environmental impact reports. The opportunity is categorized under NAICS code 541620 and is based in New York. Interested parties must submit their responses by October 9, 2026, following the posting date of September 9, 2026.

Environmental Consulting Services

POSTED

DEADLINE

Drainage & Hydrology EngineeringThis subcontract for Drainage and Hydrology Engineering supports Department of Transportation Roadway Repair and Maintenance projects in New York. The selected provider will partner with prime contractors to perform drainage mapping, conduct detailed drainage studies, and develop flooding alleviation solutions. These tasks require the use of hydraulic modeling software to produce essential deliverables, including hydrology reports, flood mitigation designs, and comprehensive drainage maps. A Professional Engineer license is mandatory for this engagement. Interested parties must submit their responses by October 9, 2026, under NAICS code 541330. The project focuses on enhancing infrastructure resilience through technical engineering expertise to mitigate flooding and optimize roadway drainage systems.

Engineering Services

POSTED

DEADLINE

Geotechnical Engineering & Subsurface InvestigationThis subcontract for the New York Department of Transportation focuses on providing geotechnical engineering and subsurface investigation services for roadway repair and maintenance projects. The selected provider will support prime contractors by conducting pavement core testing and subsurface investigations using soil sampling tools and core drilling rigs. Key deliverables include the production of detailed geotechnical reports and subsurface investigation logs. A Professional Engineer license is required to perform this work under NAICS code 541330. The project is based in New York, with a response deadline of October 9, 2026.

Engineering Services

POSTED

DEADLINE

Land Surveying & MappingThis subcontract for Land Surveying and Mapping supports Department of Transportation Roadway Repair and Maintenance projects in New York. The selected provider will perform topographic surveys and field data collection using GPS and Total Stations to produce detailed survey maps and digital data for prime contractors. A Professional Land Surveyor license is required to execute this contract under NAICS code 541370. The solicitation was posted on September 9, 2026, with a response deadline of October 9, 2026.

Surveying and Mapping (except Geophysical) Services

POSTED

DEADLINE

84125P0014-ESA, Roadway Eng, Data Coll, Design, Inspect & Related Srvs

Solicitation # 84125P0014

The New York Department of Transportation's Roadway Repair and Maintenance division is seeking qualified vendors for contract 84125P0014 to provide roadway engineering, data collection, design, inspection, and related services. The scope of work includes supporting daily workflows, developing pavement and drainage improvement projects, conducting studies for limited access arterial system capital projects, evaluating materials and equipment, and ensuring environmental and legal compliance for DOT facilities. Interested proposers must submit their responses via the PASSPort online procurement portal by the deadline of October 9, 2026. A pre-proposal conference is scheduled for September 17, 2026, via Microsoft Teams. While the procurement is subject to New York State's Disadvantaged Business Enterprise participation goals as required by the FHWA, no specific DBE goal has been set for this project.

Engineering Services

POSTED

DEADLINE

Specialized Steel Coating and Galvanizing InspectionThis subcontract for the New York Department of Transportation involves providing specialized technical inspections of coating and galvanizing processes for reinforcing steel on bridge projects. The selected provider will be responsible for inspecting surface preparation, verifying the thickness and uniformity of epoxy coatings or galvanizing, and performing adhesion and integrity tests using DFT gauges and adhesion testers. All work must adhere to ASTM standards, and the provider is required to hold NACE or SSPC certifications to deliver formal coating inspection reports and certifications of compliance. The opportunity is categorized under NAICS code 541380 and is based in New York. Interested parties must submit their responses by October 1, 2026, following the posting date of August 31, 2026.

Testing Laboratories and Services

POSTED

DEADLINE

Precast Concrete Quality Assurance (QA) Inspection ServicesThis subcontract for Precast Concrete Quality Assurance Inspection Services supports New York City Department of Transportation bridge projects. The selected provider will perform in-process fabrication inspections of precast and prestressed concrete members, ensuring that prestressing operations and casting processes strictly adhere to approved shop drawings. Key responsibilities include conducting quality audits of internal fabrication shop processes using precision measurement tools and delivering critical documentation such as inspection reports, non-conformance reports, and fabrication approval certifications. Qualified candidates must possess PCI certification and demonstrate a thorough understanding of New York City bridge construction standards. The contract falls under NAICS code 541370 and is focused on performance within New York City. The solicitation period concludes with a response deadline of October 1, 2026.

Surveying and Mapping (except Geophysical) Services

POSTED

DEADLINE

Ready to Pursue This Opportunity?

Get AI-powered intelligence on this solicitation and the ones like it

Every page of the solicitation package shredded into a compliance breakdown

AI-powered matching based on your capabilities and past performance

Competitor and incumbent history on the requirement

Automated alerts on amendments, Q&A deadlines, and award

Join 750+ contractors already using CLEATUS