Job Description We would like to present to you a new job opportunity and I think you may find it interesting.
If you are interested kindly send the following documents by Monday, December 23, 1 : 30 PM EST if that interests you and matches your profile.
Without mandatory documents, we cannot submit a candidate.
- Updated Resume in word format (Mandatory)
- Candidate Resume Summary and References {The one attached on the website Apply Online link} (Mandatory)
- Expected hourly rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
Job Title : RQ07583 - Database Administrator - Application - Senior Work Location : Toronto, Ontario, Hybrid Estimated Start Date : 2024-12-23 Estimated End Date : 2025-03-31 #Business Days : 80.00 Extension : 250.00 Hours per day or Week : 7.25 hours per day Security Level : No Clearance Required
Must haves
10+ years' experience Oracle Database Administrator including Oracle RDBMS, Data Guard, Automatic Storage Management (ASM), Oracle Vault, Oracle Security / Encryption, and Oracle Enterprise Manager (OEM) on RedHat Linux Enterprise.2+ years of experience with Oracle Golden GateExperience with installing and testing new versions i.e., upgrading from Oracle 12c version of 19c.Hands-on Experience in Azure CloudDescription
Deliverable and Skillset
The Cúram case management software (v7.0.1.2) is integral to various program areas within the Ministry of Labour, Immigration, Training and Skills Development (MLITSD) Employment & Training Division’s Employment Ontario Information System (EOIS) platform providing frontline caseworkers with access to a contemporary case management system. Currently, the backend database for most EOIS applications is supported by Oracle 12c.To enhance the efficiency, security, and overall maintainability of the system, ministry is initiating the Cúram and Oracle upgrade projects and requires servicers of a seasoned Oracle Application DBA.This strategic endeavour must be to upgrade the existing Cúram platform and Oracle Database version, which is approaching the end of its support, to the latest versions. As part of this exercise, to support the latest middleware, WebSphere will also be upgraded.The key deliverable and skillsets required.
An experience Oracle Database Administrator including Oracle RDBMS, Data Guard, Golden Gate, Automatic Storage Management (ASM), Oracle Vault, Oracle Security / Encryption, and Oracle Enterprise Manager (OEM) on RedHat Linux Enterprise.Experience with installing and testing new versions i.e., upgrading from Oracle 12c version of 19c.Working knowledge of features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, RMAN backup / recovery, fail-over, data masking, security, and new data types.Experience with install, patch, and maintenance of all Oracle softwareExperience with performance tuning all Oracle instance components including SQL and PL / SQL for application databases.Hands-on Experience in Azure Cloud including VM, Storage, Network, Security, Key Vault, Backup / RecoveryExperience with troubleshooting, problem solving, performance tuning, infrastructure, application, and data related issues.Strong leadership and Ability to communicate regularly with project and operational teams.Excellent analytical, problem-solving, and decision-making skillsExperience and Skill Set Requirements
Criterion | Criterion Details | Criterion Maximum Rating
Technical Skills and Experience |
10+ years experience Oracle Database Administrator including Oracle RDBMS, Data Guard, Automatic Storage Management (ASM), Oracle Vault, Oracle Security / Encryption, and Oracle Enterprise Manager (OEM) on RedHat Linux Enterprise.2+ years of experience with Oracle Golden GateExperience with installing and testing new versions i.e., upgrading from Oracle 12c version of 19c.Working knowledge of features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, RMAN backup / recovery, fail-over, data masking, security, and new data types.Experience with install, patch, and maintenance of all Oracle softwareExperience with performance tuning all Oracle instance components including SQL and PL / SQL for application databases.Hands-on Experience in Azure Cloud including VM, Storage, Network, Security, Key Vault, Backup / Recovery, Scripting / Automation and maintaining data standards while adhering to the Data Protection Act | 35Problem-Solving Skills |
5+ years experience with troubleshooting, problem solving, performance tuning, infrastructure, application, and data related issues.Experience with Oracle database version upgrade and migration issuesProficient in troubleshooting, root cause analysis, and implementing solutions | 25Project Management Skills |
2+ years experience with project planning and execution | 20Soft Skills |
Ability to communicate regularly with project and operational teams.Excellent analytical, problem-solving, and decision-making skillsStrong leadership and collaboration skillsProven track record for building strong working relationships.A demonstrated team player with a track record for meeting deadlines | 15Public Sector Experience |
Previous experience working within the public sector would be an asset | 5Total | 100 Note : This position is currently listed as " Hybrid "; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.
Hybrid : 3 days onsite / 2 days remote.Qualification Bachelor Degree Job Related Sector(s) Database Administrator Experience
Greater Than 10 Year