Database Development Services

The vendor is required to provide database development services for information regarding potential solutions for managing radiological testing equipment and related data.
- Provide enhanced functionality, customization options, and ease of use compared to our current system.
- The new solution should:
• Support complex calculations and data processing.
• Enable robust inventory management and reporting capabilities.
• Be scalable and adaptable to future technological advancements.
• Ensure data security and integrity.
• Provide remote access capabilities.
- This system tracks inventory assets for approximately five types of dosimeters, radiological calibrators, and meters.
- The database including:
• Municipality details
• Contact information
• Facility data
• Inventory numbers
• Calculated exchange dates
• KI quantities
• Expiration dates
• TLD and kit specifics.
- The state seeks comprehensive areas:
• Solution options: describe the types of commercially available tools or systems that could meet our needs as outlined above; these may include, but are not limited to, database systems, asset management software, or specialized radiological equipment management solutions; highlight the benefits and limitations of each option, considering both on-premises and cloud-based solutions.
• Functionality and features: provide details on how your proposed solution can handle built-in calculations, such as date determinations and half-life calibrations; include examples of similar implementations if available.
• Inventory tracking and reporting: explain how your solution supports inventory management and report generation; discuss any customizable features that allow for tailored reporting, particularly for calibration history, repair history, and inventory status.
• Integration capabilities: discuss the ability of your solution to integrate with existing systems or software used by the department of safety.
• Security measures: outline the security features included in your solution to protect sensitive data, particularly concerning radiological testing equipment.
• Administrative rights: describe how your solution manages administrative rights, allowing staff to make changes, generate new reports, and support multiple concurrent users (5-10) accessing the system simultaneously.
• Remote access: detail how your solution provides remote access for field data entry, eliminating the need for paper forms and manual data entry upon return to the office.
• Implementation process:
1. Provide an overview of the implementation process for your proposed solution, including any required resources or support from the state during deployment.
2. Explain whether the current data from the Microsoft access database can be rolled over to the new system and what this process entails, including potential challenges and solutions.
• User training: detail the training programs available to ensure that staff can efficiently use the new system; include information on training formats (e.g., in-person, online) and ongoing support options.
• Cost estimates: provide a rough estimate of costs associated with implementing your proposed solution, including licensing, setup, training, and ongoing maintenance.
• Implementation timeline: suggest a feasible timeline for deployment, including key milestones from initiation to full operational status.
• Vendor experience: share information about your organization’s experience in developing similar database solutions, including case studies or references if available.
• Risk management: identify potential risks associated with your proposed solution and strategies to mitigate them.
• Redundancy: the new database will be backed up in case of failure; include information on:
• Backup frequency and methods
• Data recovery processes
• Redundancy measures
• Off-site backup storage (if applicable)
• Additional recommendations: offer any additional insights or recommendations that could benefit the state in selecting an optimal database solution.