Specialized It Consultant (Intermediate) 10421

Toronto, ON
Permanent
Full-time

1 month ago

Job Description:The goal of the project is for Ontario to transform its employment services to help more people find and keep quality jobs and help more businesses find the right workers with the right skills. The purpose of the Integrated Employment Services Transformation (IES) project is to ensure ministry readiness to initiate employment services transformation and transfer of responsibility for employment services programming for social assistance recipients.The resource will be involved in upgrading non-production databases, performance optimization, and the integrity and security of all application databases. The successful candidate will work with various technology teams to coordinate deliverables, including planning, execution, troubleshooting, deployments, and support. The resource will also provide services under the direction of the technical lead, project manager, and IT manager.The services and deliverables will include the following:

Providing Oracle database support to project teams
Build Oracle database Infrastructure in Azure Cloud
Provide ongoing support to all non-production and production database environments
Refreshing the non-production databases from production data
Tune all Oracle instance components including SQL and PL/SQL
Provide data migration and data extract support
Realtime data replication using Oracle Golden Gate technology
Provide high availability using Active Data Guard technology
Control access permissions and privileges
Maintain data standards, including adherence to the Data Protection Act
Test and enable new database features and customize them as per requirements
Install, configure, and test Oracle Enterprise Manager (OEM) grid agent
Provide performance tuning and optimization of Oracle databases
Provide database documentation, including standards, procedures, and definitions
Monitor and ensure CPU, memory, I/O, and storage are functioning as expected
Collaborate with the project manager, IT leads, database administrators, project teams, and vendors
Support deployment and release activities

Experience and Skill Set RequirementsTechnical Skills and Experience

10+ years experience with Azure Cloud and Oracle Database 19c and technologies including, Data Guard, Automatic Storage Management (ASM), Oracle Wallet, and Oracle Enterprise Manager (OEM) on RedHat Linux platform
2+ years of experience with Oracle Golden Gate
Working knowledge of new features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, information lifecycle management enhancements, and new data types
Experience with Oracle database upgrade and migration
Experience with install, patch, and maintenance of all Oracle software
Experience with tuning all Oracle instance components including SQL and PL/SQL
Experience with installing and testing new versions of the RBMS and maintaining data standards while adhering to the Data Protection Act

Problem-Solving Skills· 5+ years experience with troubleshooting, problem solving, performance tuning, and hardware and system software infrastructure architecture design· Proficient in troubleshooting, root cause analysis, and implementing solutionsProject Management Skills· 2+ years experience with project planning and executionSoft Skills· Ability to communicate regularly with technical, application, and operational teams· Excellent analytical, problem-solving, and decision-making skills· Strong leadership and collaboration skills· Proven track record for building strong working relationships· A demonstrated team player with a track record for meeting deadlinesPublic Sector Experience· Previous experience working within the public sector would be an assetMust Have:· 10+ years experience with Azure Cloud and Oracle Database 19c and technologies including, Data Guard, Automatic Storage Management (ASM), Oracle Wallet, and Oracle Enterprise Manager (OEM) on RedHat Linux platform· Working knowledge of new features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, information lifecycle management enhancements, and new data types· Experience with tuning all Oracle instance components including SQL and PL/SQL

Foilcon

Apply Now