Database Administrator Intermediate

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

Assignment: RQ09963 - Database Administrator - Intermediate

Job Title: Database Administrator - Intermediate

Requisition (SS): RQ09963

Start Date:

Client: Community Services Cluster

End Date:

Office Location: 315 Front St Toronto

Organization: Community Services Cluster

Ministry: Ministry of Public and Business Service Delivery and Procurement

# Business Days: 250.00

Assignment Type - Note: The FFS resource is working 5 days onsite at the identified OPS location or hybrid arrangements at Managers Discretion

MUST HAVES:

Experience with one or more database technologies
Proficiency with SQL and experience writing SQL scripts
Experience designing data architecture for new databases
Experience in developing documentation on data standardization and requirements
Subject matter expert in database design of data warehouse or data marts.

Description

Responsibilities:

Create physical database designs and operates and administers the database management system (DBMS) including database optimization capacity planning installation and migration database design performance tuning backup and recovery.
Monitor and enforce database rules.
Use information retrieval packages and be proficient in query languages.
Research and implement cyber security vulnerability remediations.
Be aware of emerging IT trends and directions.
The resource will also support CSC release and infrastructure solutions support sustainment activities urgent priorities changing needs or time-sensitive infrastructure upgrades or other sustainment activities supporting any CSC platforms overseen by the Cluster where annual work is required.

Experience and Skill Set Requirements

Database Skills 70%

Experience with one or more database technologies
Proficiency with SQL and experience writing SQL scripts
Experience designing data architecture for new databases
Experience in monitoring and enforcing database rules
Experience cleaning transforming and joining data
Experience creating and applying data standards
Experience with dimensional data models
Subject matter expert in database design of data warehouse or data marts.

Communication Skills 25%

Experience in developing documentation on data standardization and requirements
Demonstrated consulting and relationship management skills with proven ability to elicit requirements develop/consult on options and solutions and provide effective guidance
Strong verbal and written communication skills; with both technical and non-technical audiences
A demonstrated team player with a track record for meeting deadlines

OPS Experience 5%

Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.

Assignment: RQ09963 - Database Administrator - Intermediate Job Title: Database Administrator - Intermediate Requisition (SS): RQ09963 Start Date: Client: Community Services Cluster End Date: Office Location: 315 Front St Toronto Organization: Community Services Cluster Ministry: Ministry of Public ...