Database Administrator

This requirement is open only to those TBIPS Supply Arrangement Holders who qualified under Tier 1 for services in the Quebec Region for the following category:

One (1) Database Administrator (I.2) – Level 3 (Senior)

The Information and Technological Solutions Branch and the Chief Information Officer are seeking an Oracle and SQL Specialist on site and on Cloud (databases and application servers). The need associated with this mandate is essentially for a bank of hours to support our internal resource in specific and highly specialized tasks.

The resource will report to the Information and Technological Solutions Branch and will perform development and support functions.

The project involves the following objectives:

• Mandatory experience with Windows server 2008 and +
• Oracle database version 11g and +
• Oracle Application Server version 10g and +
• Grid control 12.1.0.5.0
• ORDS (Oracle REST Data Services) 3.0.1.177.18.02
• Apex 5.1.4.00.08
• PL / SQL server 10.50.6000 and SQL v 12.0 on Cloud
• Create the databases and seed the data on physical media
• Track database object access performance to ensure tuning
• Manage release migrations
• Update programs and fix potential bugs (install patches) and provide approval before production releases
• Ensure that backups are properly executed and ensure data recovery and the restoration of databases to operational condition (disaster recover) following a serious incident (Oracle and SQL)
• Maintenance: environment updates, capacity monitoring, account access and security, etc.

Security Requirement: Common PS SRCL #19 applies