Questions-Answers- Update 30 MAY (003).pdf

Questions/Answers for RCTA Database

1. Regarding the Existing Online Database System: * The PWS mentions the new system should provide "similar capabilities as the existing online database system," which has been used for over 12 years and has "many different complex capabilities" (PWS 1.1.1, 1.2, 5.0). Could you provide more detailed specifications, documentation, or an overview of the key functionalities and complexities of the current system that need to be replicated or improved upon? * Is there an opportunity to view or receive a demonstration of the existing system?

Answer: No, due to the short suspense.

2. Specifics of "Customized" Elements: * PWS 5.0, items 2 and 8, refer to a "customized" online user and class registration process, and "Customized reports, forms, print documents, certificates, badges." Could you provide more detail on the expected number and types of these customized items, and any specific formatting, data fields, or logic requirements? For instance, how many unique report/form templates are anticipated?

Answer: We currently have 15 standard reports, options to print class certificates and rosters, student badges, and receipts. We currently have 34 email options to contact students. There is also an option to roll up survey results.

3. Interpretation of Subjective Requirements: * PWS 5.0, item 5, requires a "Web interface design that is aesthetically pleasing, and user-friendly, intuitive, and easy to navigate." Are there any existing RCTA branding guidelines, style guides, target user personas, or specific usability benchmarks that should be considered?

Answer: https://www.wrctc.org/

We prefer this layout.

4. Scope of "100% Customizable System": * PWS 5.0, item 11, states the system should be "Flexible and 100% customizable for updates." Could you elaborate on the anticipated nature and extent of these customizations? For example, is the expectation for RCTA staff to perform certain customizations via an admin interface, or does this primarily refer to the contractor's ability to efficiently modify and update the system?

Answer: Website interface yes, database manipulation no.

5. Data Migration: * Given the existing system has over 12 years of data (PWS 5.0), and PWS 1.4.15 mentions "transfer of data to the new server," could you provide more insight into the volume, structure, and format of the existing data to be migrated? Are there any known data quality issues or specific data transformation requirements?

Answer: No Known Data quality issues

6. Scope of "Development" and Timeline: * The contract start date is June 15, 2025, for services including "development" (PWS 1.1.1) and "HOST, SUPPORT, AND MAINTAIN CUSTOM DATABASE" (SAM.gov notice). Given the offer due date of June 2, 2025, could you clarify the expected scope of initial "development" work anticipated by the contract start date versus ongoing development and modification throughout the contract period?

Answer Unknown by the Government.

7. Role of www.rcta.org and Existing Registration: * PWS 1.2 mentions the "online database and web registration system is integrated with our website - www.rcta.org." We also note that www.rcta.org appears to have existing registration functionality. Could you clarify how the new system's registration and user interface will integrate with or replace the existing registration functionalities on www.rcta.org? Will the new system's interface be the sole platform for these functions, accessed via www.rcta.org?

Answer: Yes, we want them to be integrated.

8. System Availability and Downtime:

* Go-Live Downtime Allowance: For the initial cutover to the production environment, is a short, scheduled service interruption window (e.g., 2-3 hours, during off-peak times) acceptable, or is a zero-downtime go-live a strict requirement?

Answer: After 1500 during the week and anytime during the weekends.

* Ongoing Update Downtime: For post-go-live updates, such as feature rollouts or critical patch deployments, are short, scheduled maintenance windows (e.g., 5-30 minutes during off-peak hours) permissible, particularly if service restarts are necessary for schema changes or container updates? Understanding this will help in planning for methodologies like blue-green deployments if near-zero downtime is required for all updates.

Answer: To be expected.

9. Database Management and Production Strategy:

* While PWS 5.0, item 13, requires a "daily system backup", could you confirm if the following more specific practices are expected as part of the production data strategy?

* Advanced Backup Methods: Are specific backup methodologies required, such as logical exports in addition to full backups, and/or Write-Ahead Log (WAL) archiving to enable Point-In-Time Recovery (PITR)?

* Replication/Failover:Is replication of the database to a standby or failover node for high availability a requirement?

* DML Auditing: Is Data Manipulation Language (DML) auditing, such as row-level change tracking (e.g., via triggers or logical decoding), required for compliance, detailed auditing, or specific rollback purposes beyond standard backups?

Answer: A daily backup would be required for all data entry for the day. A monthly full system backup would be preferable if we needed a historical point.

10. What is the name of the last incumbent who performed this service

Answer: that will not be provided

11. What is the contract award number and award amount for the last incumbent contractor?

Answer: That will not be provided

12. How many contractors are supporting the existing RCTA course registration system?

Answer: One

14. Is the Customer open to having the Contractor host the online database solution in a secured Microsoft US Government Cloud?

Answer: Yes

17. Is a security clearance required for this contract? If so, what level (NACI/Public Trust, Secret, TS)?

Answer: No

18. Can work be performed remotely or must work be performed at facility in Meridian, MS?

Answer: Remotely

19. What is the estimated budget or not-to-exceed (NTE) amount for this contract?

Answer: This is a Request for Proposal; this information cannot be provided.

22. What date is this contract scheduled to start?

Answer: 15 June 2025- Within the scope of the PWS

23. PWS 1.1 uses the term “hosting.” Can the Government confirm how the Student and Course information database and website are hosted today? Would the contractor assume operation of that hosted environment in performance of these duties?

Answer: Data from database will be provided by the incumbent, and yes.

25. Regarding PWS 1.4.5 Will contract performance include onsite activities?

Answer: No

27. PWS 1.4.5.6.2 states to follow markings and outputs per classification level. Is there a classification level for this contract?

Answer: Unclassified

Answer: 28. 1.4.8 identifies a Contract Manager. Is the Government’s expectation that this Contract Manager equivalent to a Program Manager dedicated to this contract?

Answer: No.

29. 1.4.15 Phase In/Phase Out states “During the phase out period, the contractor shall provide support for the transfer of data to the new server.” Can the Government identify the server specifications? Is the server GFE or should the contractor bid the acquisition of a server? In what format is the data that is being transferred?

Answer: Should be in SQL format. Unknown how data is currently hosted or stored.

30. 2.1.2 Defective Service. Can the Government identify if there is a backlog of defects? Can the Government identify how many defects occur annually?

Answer: Less than 5 only a few annually.

31. PWS 2.1.4 identifies Key Personnel. Can the Government list the Key Personnel?

Answer: that would be the Offeror’s key personnel, however this is not applicable.

32. Section 3.0 is vague. Can the Government define what property, material, equipment and/or services would be required as GFP?

Answer: Not applicable, Government Furnished Property is NOT provided.

33. PWS 4.1 General references the scope of Paragraph 1.1 which states “The contractor shall provide all personnel, equipment, tools, materials, supervision, and quality control necessary, except as specified in Paragraph 3.0 as Government Furnished, to perform hosting, system maintenance, security, editing, and help desk support for the Student and Course Information Database System Services, as defined in this PWS.” Can the Government identify what personnel, equipment, tools, materials are utilized today?

Answer: Unknown, as the incumbent provides all personnel, equipment, tools, materials for the contract.

34. Does the scope include maintaining, enhancing and modifying www.rcta.org? Can the Government provide requirements documents, maintenance manuals, list of enhancements, and security logs or tickets?

Answer: Yes, but no document, manuals etc.

35. For PWS 5.0- what technology stack will be used for development? What is the existing database technology? Does the offeror have the option to propose its own database platform?

Answer: Currently use SQL. As long as the data can be transferred, any platform can be used.

36. Reference PWS 5.0 (1) How many users should the system support?

Answer: 20 admin users. At least 50,000 student profiles and agency representative accounts.

38. Reference PWS 5.0 (2) What customizations does the Government desire?

Answer: After initial setup and acceptance, minimum maintenance required. Typically only when there are issues.

Answer: 39. Reference PWS 5.0 (3) What technology provides messaging, alerting and email functions?

Answer: Email templates currently. Would like the ability to send text messages.

40. Reference PWS 5.0 (5) What technology is the current online web interface built in?

Answer: WordPress

41. Reference PWS 5.0 (7) Is there a current ticket management system?

Answer: No

42. Reference PWS 5.0 (8) Does the Government have a list of customized reports, forms, etc?

Answer: Yes. We currently have 15 standard reports, options to print class certificates and rosters, student badges, and receipts. We currently have 34 email options to contact students. There is also an option to roll up survey results.

Reference PWS 5.0 (9) How often are training sessions required?

Answer: Initial training only and we will train replacement personnel on site.

43. Reference PWS 5.0 (10) What is the current security posture that offerors need to ensure adherence to?

Answer: Unclassed

44. Reference PWS 5.0 (11) What customizations are anticipated?

Answer: Base customizations off this website https://www.wrctc.org/

45. Reference PWS 5.0 (13) What is the current system backup technology and process?

Answer: Unknown

46. Technical Exhibit 1, PRS Performance Objective 5.0-1 and 5.0-2 identifies create new documents and modules on an as needed basis. How often are new documents or modules required?

Answer: Rarely

47. There is no section L or M providing submission guidelines for the proposal. Will the Government be provided Section L and M to include proposal page count, volumes and additional guidance on submission?

Answer: Limit proposal to no more than 20 pages.

48. Does the government have an expected number of FTEs and desired SCA categories?

Answer: No

49. Are there any statistical data on the help desk requests such as number of request per day, week or month?

Answer: Only contacted current contractor 5 times in the last year for issues.

50. What is the validity period of the proposal?

Answer: 30 Days

51. Does the government have a designated timeframe of development for the new database and application?

Answer: The Government is scheduled to have contract in place by 15 June 2025

53. PWS 1.4.1 states provide services between 7:00AM – 7:00PM, CST, Monday through Friday.

Is the Government’s expectation that the Help Desk be manned during this time? Is there a standard Help Desk phone number and/or email inbox to receive tickets or requests?

Answer: No. As long as we have someone to contact and solve issues in a timely manner.

Example: 24 hours.

54. Can the Government define the hosting requirements?

Answer: No

55. Will the Government extend the proposal due date by 2 weeks after the questions are answered to allow offerors to account for the Q&A in their proposal?

Answer: Not at this time due the POP starting 15 June 2025

56. What is the complete technology stack (programming languages, frameworks, database, OS, etc.) of the current custom-built online registration database system?

Answer: SQL database and WordPress

57. Will bidders be provided with technical documentation (e.g., architecture diagrams, data models, API specifications) for the current system, or an opportunity for a demo/read-only access to understand its functionalities?

Answer: No

58. Regarding the requirement for the new system to provide "similar capabilities" (PWS 5.0):

Can RCTA provide a detailed feature list or use cases from the existing system that must be replicated?

Answer: We currently have 15 standard reports, options to print class certificates and rosters, student badges, and receipts. We currently have 34 email options to contact students. There is also an option to roll up survey results.

59. What are the specific pain points or limitations of the current system that RCTA wants the new system to explicitly address or improve upon?

Answer: Improve the current system with ability to send text messages regarding registration and easier access for students to register for classes.

60. Can you elaborate on the current method and technology of integration between the existing database system and the website www.rcta.org (PWS 1.2)?

Answer: Unknown.

61. PWS 5.0 #11 states "A Flexible and 100% customizable system for updates." Can you clarify the expectation for "100% customizable"? Does this refer to user-configurable elements, admin-level UI builders, or the ability for the contractor to make any requested code change?

Answer: Changes would be performed by contractor. Admin rights would be given to Government IT manger on site for minor corrections.

62. For PWS 5.0 #12 "Online database system shall be compatible with mobile phones": Is responsive web design sufficient?

Answer: Currently yes.

63.Regarding the scope of development, PWS 1.1.1 mentions developing an 'online registration database system' and several requirements under PWS 5.0 (such as #1 'Online Class, Student, Instructor...functionality', #2 'Online User and class registration process', and particularly #5 Answer: 'Web interface design') strongly imply the creation of a user- facing web portal. Could you please confirm that the contractor is responsible for developing the complete web portal/application through which students and administrators will interact with the database, in addition to the database system itself?"

Answer: Yes.