RQ09963 - Database Administrator - Intermediate

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:

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.