2.1 Tasks for Database Modeller / Information Management Modeller

The Database Modeller / Information Management Modeller must perform the following tasks:

1. Maintain the following Information Management systems currently in use within the RCAF AWC. Maintenance includes the implementation of security patches for commercial products used within the system and resolution of user-identified problem reports.

• The ASIP Dashboard, a Microsoft SQL Server database with a custom web interface deployed to the Defence Wide Area Network (DWAN) and integrated with Microsoft Exchange and SharePoint.

• The DSSTNi Asset Management Tool, a Microsoft SQL Server database with a custom web interface deployed to the DSSTNi Research and Development Network (R&D Net).

• The Aircraft Protection Matrix, a Microsoft SQL Server database with a custom web interface deployed to the Defence Wide Area Network (DWAN).

• Continue development of the following Information Management systems currently in use within the RCAF AWC. Continued development includes the implementation of new releases for commercial products used within the system and resolution of user-identified feature requests, as well as updating all associated documentation.

• The ASIP Dashboard, a Microsoft SQL Server database with a custom web interface deployed to the Defence Wide Area Network (DWAN).

• The DSSTNi Asset Management Tool, a Microsoft SQL Server database with a custom web interface deployed to the DSSTNi Research and Development Network (R&D Net).

• The Aircraft Protection Matrix, a Microsoft SQL Server database with a custom web interface deployed to the Defence Wide Area Network (DWAN).
• Design, develop, implement, test and document the following new Information Management systems.

• A ticketing system and help desk using the DND-licensed HaloITSM framework.

• A terrain database* for the DSSTNi IS, including integration with the DND-licensed MaK VR-TheWorld terrain server, allowing configuration control and distribution of terrain models in support of simulation.
• An entity database solution for the DSSTNi IS allowing configuration control and distribution of entity models in support of simulation.
• Provide legacy databased migration support to other RCAF AWC organizations as required by the Technical Authority (TA).
• Analyze and evaluate alternative data architecture solutions to meet business problems or requirements to be incorporated into the corporate data architecture, including estimates of schedule and funding requirements.

* terrain databases are employed by multiple systems within E&S to provide the synthetic environment for simulators. This SOW requires multiple versions, compatible with multiple simulators and need an information management solution that can track this information, organize it and make it available upon demand to users of our DSSTNi IS. DND has licensed MaK VR-TheWorld as the technical solution for this requirement, in alignment with our other uses of the MaK simulation suite, but require the services of an IM Modeller to configure and populate this tool.

MTC1	The Bidder must demonstrate that the proposed resource has a minimum of ten (10) years of experience, within the last fifteen (15) years from the date of bid closing, designing, developing, implementing, testing and documenting new information management solutions in accordance with client requirements. This must be demonstrated by providing complete details of the experience including: - Name and Description of Client Organization; - Scope, timeframe (from-to dates (month/year); - Description of the Roles and Responsibilities, and - Contact name and information for the resource’s client(s). The proposed resource’s client(s) may be contacted to confirm the information provided.
MTC2	The Bidder must demonstrate that the proposed resource has a minimum of ten (10) years of experience, within the last fifteen (15) years from the date of bid closing, maintaining and continuing development of existing information management solutions in accordance with client problem reports and feature requests. This must be demonstrated by providing complete details of the experience including: - Name and Description of Client Organization; - Scope, timeframe (from-to dates (month/year); - Description of the Roles and Responsibilities, and - Contact name and information for the resource’s client(s). The proposed resource’s client(s) may be contacted to confirm the information provided.
MTC3	The Bidder must demonstrate that the proposed resource has completed a minimum of one (1) database migration within the last five (5) years. This must be demonstrated by providing complete details of the experience including: - Name and Description of Client Organization; - Scope, timeframe (from-to dates (month/year); - Description of the Roles and Responsibilities, and - Contact name and information for the resource’s client(s). The proposed resource’s client(s) may be contacted to confirm the information provided.