RQ09963 Database Administrator Intermediate

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 7-10years

Posted on: 4 hours ago

Vacancies: 1 Vacancy

Job Summary

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.

Requirements

Experience and Skill Set Requirements:

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.

Skill Set Requirements:

Database Skills:

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:

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:

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

Required Skills:

Experience and Skill Set Requirements: 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. Skill Set Requirements: Database Skills: 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: 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: Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.

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