Database Analysis, Design and Implementation Skills/Experience - 50%
· 10+ years hands on experience
· Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
· Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
· Experience with deployed databases security i.e. ensuring appropriate security and auditing controls are in place to meet security and privacy requirements
Technical Planning, Coordination and Monitoring Skills/Experience - 30%
· Experience coordinating implementation of technically advanced complex systems resources to lower non production environment
· Experience in providing complex/specialized systems analysis and design for success
· Communicates effectively to drive technical outcomes with technical staff/teammates
· 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 with distributed data systems
· Experience with middleware and gateways
· Awareness of emerging IT trends and directions
Communications and Teamwork Skills - 20%
· Experience documenting technical work that facilitates knowledge transfer
· Communicates technical issues in plain language effectively
· Excellent verbal and written communication skills
· Demonstrated strength building strong relationships and being a strong team player
Desirable Skills
· Experience with distributed data systems
· Experience with middleware and gateways
· Experience with researching and implementing cyber security vulnerability remediation's
· 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.
· 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)
· 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
Job Type: Fixed term contract
Contract length: 12 months
Salary: $80.00 per hour
Flexible Language Requirement:
• French not required
Schedule:
• Monday to Friday
Experience:
• Oracle and Microsoft SQL Database administration: 10 years (required)
• Microsoft Azure SQL database and Synapse database: 5 years (required)
• developing complex Oracle PL/SQL programs: 5 years (required)
• Azure build automation using Ansible, Terraform: 5 years (required)
Work Location: Hybrid remote in Toronto, ON M4V 1M2
Application deadline: 2024-02-16
Expected start date: 2024-04-02
