Senior IM Modeller

Turtle Island Staffing; Canada; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading staffing agency is seeking a Database Modeller to maintain and develop information management systems for the RCAF AWC. Candidates must have a minimum of ten years of experience in database design and user support, with a proven track record in maintaining database solutions. The role requires expertise in Microsoft SQL Server and preparing documentation for new systems. This is an on-site position located in Canada.

Qualifications

• Minimum of ten years of experience designing and implementing information management solutions.
• Strong background in maintaining and developing existing information management systems.
• Experience with database migration within the last five years.

Responsibilities

• Maintain current information management systems used within the RCAF AWC.
• Continue development on existing information management systems.
• Design, develop and implement new information management solutions.

Skills

Database Design

Problem Solving

User Support

System Integration

Documentation

Data Architecture

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft SQL Server

HaloITSM

MaK VR-TheWorld

Job description

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).

The following new Information Management systems must be designed, developed, implemented, tested and documented.

• 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, but require the services of an IM Modeller to configure and populate this tool.

Note: The following bidder evaluation criteria are included for context.

1. 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.
2. 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.
3. 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.