Database Administrator

S M Software Solutions Inc. - Toronto, ON (13 months ago)

Apply Now

Database Administrator, Toronto, ON - Job Details |

Cluster: Labour and Transportation Cluster

Ministry: Ministry of Transportation

Assignment Name: Road User Safety Program

Anticipated Assignment Start Date: Tuesday, September 17, 2019

Anticipated Assignment End Date: Tuesday, March 31, 2020

Est. # of Days: 128

Work Location – 125 Sir William Hearst Ave. Toronto, ON M3M 0B4


Road User Safety Program

The mandate of MTO’s Road User Safety Program is to develop and support Ministry strategies for improvement of road safety and vehicle mobility through:

  • Education, enforcement and regulation of safe driving behaviour; and
  • Promotion of vehicle and motor carrier safety while striving to provide excellent customer service

The program also manages the driver licensing service, which issues permits to drive, in the form of a Drivers’ Licence Card, to qualified Ontario residents. Key Priority Areas currently include:

  • Road Safety: Continue to improve road safety for all road users;
  • Business Integrity and Modernization: Uphold public trust and pursue a change to meet clients’ needs;
  • Service Delivery Partnerships: Develop relationships and oversight of delivery partners;
  • Enhanced Public Service and Customer Satisfaction: Provide quality products and services
  • Horizontal Integration and Collaboration:
  • Support development of integrated and efficient products and services
  • Improved system integration (i.e. alleviating stress from primary databases)

MTO has overall accountability to maintain the provincial driver, vehicle and carrier I&IT systems consisting of more than 65 applications, in partnership with the Labour and Transportation I&IT Cluster. These systems touch most Ontarians in one way or another. They collect and manage data for Ontario’s 8.9 million drivers, 10.6 million vehicles, and 85,000 registered truck and bus carriers. The systems process over 30 million business transactions each year. More than 40 key stakeholders, including delivery agents, partner ministries, and external customers rely on the ministry’s computerized systems to provide and process data and information.

These consultant resources will be used to augment our current complement of full-time staff, to extend the cluster's capacity in a flexible and timely manner, to ensure we have the ability to meet defined timelines in order to ensure delivery for the business-critical requirements.


Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:

  • Participate in the review of and contribute to solution artefacts – User Story, System Functional Requirement, Threat Risk Assessment, Privacy Impact Assessment, Solution Design,
  • Design and document dimensional and OLTP data model according to OPS standard
  • Setup RHEL/Windows guest OS on Cloud. Perform Linux and Windows administration
  • Design and seek project and management approval of Cloud Data Warehouse infrastructure, including database software/service selection, database design, capacity planning, performance tuning, high availability, disaster recovery, backup/restore,
  • Design and implement Cloud Infrastructure as Code to build the Cloud Data Warehouse using Cloud build automation tools, i.e., Ansible, Terraform, Packer and VSTS
  • Implement risk mitigation recommendations based on Threat Risk Assessment
  • Design and implement initial data load, and ongoing data replication from source databases, including on-premise IBM Mainframe IMS and DB2, Oracle on Solaris and AIX, Microsoft SQL Server OLTP databases, minimizing the impact to the 7x24 missional critical operational source databases while satisfying Cloud Data Warehouse
  • Design and implement code-drop automation to promote changes in Cloud Data Warehouse development, test, QA, UAT and production environments
  • Prepare Cloud Data Warehouse maintenance and support documentation
  • Analyze business requirements and develop SQL and/or other programs to support ad-hoc reporting
  • Support the development of advanced analytics and business intelligence capabilities utilizing Cloud Data Warehouse
  • Support the development of an online citizen/user self-service portal for sending information requests related to driver, vehicle, collision, and carrier reports/abstracts to the Ministry for processing utilizing Cloud Data Warehouse
  • Maintain and support Cloud Data Warehouse database in development, test, QA, UAT and production environments
  • Develop Linux housekeeping shell scripts and Windows powershell scripts
  • Support QA testing and User Acceptance Testing
  • Perform database monitoring and performance tuning on database objects and at database instance levels
  • Assist IT project management in the preparation of project plan as required
  • Document and resolve any database problems/issues
  • Provide effective knowledge transfer to Ministry staff at all stages of this assignment

Skill Set Requirements:

  • Experience with planning, installation, maintenance, administration of Oracle 12c/18c database on AIX 7.1 and/or Solaris 10, RHEL in Cloud
  • Experience with planning, installation, maintenance, administration of Microsoft SQL Server database on Windows server and Cloud environment
  • Experience with Cloud database products/services
  • Experience with Cloud IaaS, PaaS and SaaS
  • Experience with Azure technologies and tools for database infrastructure, high availability, backup/restore, disaster recovery, security, networking, storage account, file share, Azure key vault, Azure portal, Azure monitoring
  • Expert experience with Infrastructure as Code build automation using Ansible, Terraform, Packer and VSTS
  • Experience with configuring and administrating Red Hat Enterprise Linux guest OS in Cloud environment.
  • Experience with configuring and administrating Windows server guest OS in Cloud environment.
  • Extensive experience with Linux shell scripting and Windows powershell to develop housekeeping.
  • Experience with data replication technology and tools in Cloud environment, such as Oracle GoldenGate, Informatica PowerCenter, Microsoft SQL Server Integration Services (SSIS)
  • Proven experience in very large 7x24 data warehouse database design, administration and support in Cloud environment.
  • Proven experience in OLTP and dimensional data model design using Sybase PowerDesigner

Job Type: Contract