Job Description
As part of establishing a new agency, there are a number of key priority projects that we will initiate and look to deliver including but, not limited to:

• Data Analytics Platform Enhancements
• Digital Procurement Systems
• Knowledge, Records & Information Management
• ERP
• Operational Support

Experience required:
Creates 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
General Skills:
Experience with one or more operating systems
Experience with one or more database technologies
Experience in one or more programming languages
Experience in the use of information retrieval packages and proficiency with query languages
Experience in monitoring and enforcing database rules
Experience in Incident, Change and Configuration Management procedures
Experience with one or more communications protocols
Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
A team player with a track record for meeting deadlines
Desirable Skills:
Experience with distributed data systems
Experience with middleware and gateways
Experience with researching and implementing cyber security vulnerability remediations
Awareness of emerging IT trends and directions
Experience with Computer Aided Software Engineering (CASE) tools
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience in Database Administration, Maintenance Optimization
Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
Subject matter expert in database design of the data warehouse or data marts.
Skills:
Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Additional Skills for Case Management and ERP
Experience in designing/developing an automated data distribution mechanism
Knowledge and understanding of object-oriented analysis and design techniques.
Experience in developing enterprise architecture deliverables (e.g. models) based
Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
Knowledge and understanding of Information Management principles, concepts,
policies and practices
Experience in impact analysis, implementation planning and implementation of technology or suite-specific patches, maintenance packs and releases, and technology stack patch sets and releases
Experience in technical design, planning and implementation of specific technology or suite
Experience with database administration and vendor support services