Senior IM Modeller

Turtle Island Staffing; Ontario; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading staffing company is seeking a Database Modeller / Information Management Modeller to maintain and develop critical information management systems for the RCAF AWC. The role requires extensive experience in database management, system design, and documentation, with a focus on security and user support. Candidates must demonstrate a strong background in maintaining existing systems and completing database migrations, ensuring effective data architecture solutions.

Qualifications

• At least 10 years of experience in designing and implementing information management solutions.
• Experience in maintaining existing information management solutions.
• Completion of at least one database migration in the last five years.

Responsibilities

• Maintain and develop Information Management systems within the RCAF AWC.
• Implement security patches and resolve user-identified problem reports.
• Design, develop, implement, test, and document new systems.

Skills

Database Management

Information Management

SQL Server

Documentation

Data Migration

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

The tasks include continuing development of these systems, which involves implementing new releases and resolving feature requests, as well as updating documentation.

• The ASIP Dashboard, a Microsoft SQL Server database with a custom web interface deployed to DWAN.

• The DSSTNi Asset Management Tool, a Microsoft SQL Server database with a custom web interface deployed to R&D Net.

• The Aircraft Protection Matrix, a Microsoft SQL Server database with a custom web interface deployed to DWAN.

The role also involves designing, developing, implementing, testing, and documenting new systems, such as:

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

• A terrain database for the DSSTNi IS, including integration with MaK VR-TheWorld terrain server for simulation support.

• An entity database solution for DSSTNi IS to support simulation.

Additional responsibilities include providing legacy database migration support, analyzing data architecture solutions, and configuring terrain databases with MaK VR-TheWorld.

*Terrain databases are used across systems within E&S for simulators, requiring version control and configuration management, which the IM Modeller will configure and populate using the licensed MaK VR-TheWorld tool.

MTC1

The Bidder must demonstrate that the proposed resource has at least ten (10) years of experience within the last fifteen (15) years in designing, developing, implementing, testing, and documenting new information management solutions, with details including:

• Name and description of client organization
• Scope and timeframe (month/year to month/year)
• Roles and responsibilities
• Contact information for the client(s)

MTC2

The Bidder must demonstrate that the resource has at least ten (10) years of experience within the last fifteen (15) years in maintaining and developing existing information management solutions, with similar details as above.

MTC3

The Bidder must demonstrate that the resource has completed at least one (1) database migration in the last five (5) years, with details including the client, scope, timeframe, responsibilities, and contact information.