drjobs Oracle Cloud Database Adminstrator (Oracle EBS)

Oracle Cloud Database Adminstrator (Oracle EBS)

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Toronto - Canada

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

If you are interested kindly send the following documents toemailprotectedat your earliest convenience.

Job Title: Oracle Cloud Database Adminstrator
Client: One of the Ministry in Ontario
Work Location: Toronto Ontario Hybrid
Hours per day or Week:7.25 hours per day
Security Level:
CRJMC
Must haves
  • Expert data/database administration experience e.g. Microsoft Azure SQL database and Synapse database Oracle IMS DB2 etc.
  • Expert experience with Microsoft Azure technologies including Azure pipeline DACPAC storage account disk file share Azure key vault Azure portal virtual machine Azure DevOps Data Lake Data Lakehouse Azure monitoring tools.
  • Experience with Cloud data platforms data management and data exchange tools and technologies.
  • Experience with Azure SQL Oracle IMS/DB2 data replication (knowledge of).
Description
Deliverables section:
Scope of Services and Deliverables The Services and Deliverables to be provided by the Vendor will include the following:
  • Participate in the review of project work request and maintenance release artefacts Use Case System Requirement Specification etc.
  • Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
  • Design develop and optimize data/database CI/CD pipelines.
  • Design logical and physical data models using Sybase Power Designer.
  • Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC.
  • Promote database changes through Development Integration Testing QA UAT Production environments.
  • Provision data in cloud environment according to requirements.
  • Design develop data loading data conversion data migration program.
  • Design develop and implement data conversation of VLD (Very large Data) of Online analytical processing (OLAP) and online transaction processing (OLTP) environments to Cloud Softwareasaservice (SaaS) Platformasaservice (PaaS) and Infrastructureasaservice (IaaS) environments.
  • Design develop and implement fact/dimension model data mapping data warehouse data lake and data lakehouse.
  • Plan configure maintain administrate tune performance of Oracle Microsoft Azure SQL database and Synapse database.
  • Support cloudbased heterogeneous data replication solution.
  • Develop complex Oracle PL/SQL program SQL server stored procedure to fulfill project work request maintenance requirements.
  • Optimize performance of PL/SQL program SQL server stored procedure.
  • Monitor and analyze incident provide timely resolution.
  • Perform reference data administration as required.
  • Build and test database backup/recovery scripts.
  • Build and test database automation scripts.
  • Perform database administration including patching/upgrade monitoring performance tuning partitioning capacity planning OEM upgrade/enhancement achieving etc
  • Document and resolve any database problems/issues.
  • Provide effective knowledge transfer to Ministry staff at all stages of this assignment
Experience and Skill Set Requirements
Cloud DataOPS40%
  • Expert experience with Microsoft Azure technologies including Azure pipeline DACPAC storage account disk file share Azure key vault Azure portal virtual machine Azure DevOps Data Lake Data Lakehouse Azure monitoring tools.
  • Experience with Cloud data platforms data management and data exchange tools and technologies.
  • Experience with Data pipeline and workflow development orchestration deployment and automation.
  • Experience in DataOPS principle best practice and implementation and Agile project development and deployment.
  • Experience in Continuous Integration/Continuous Development/Deployment (CI/CD) and Data provisioning Automation.
  • Experience with digital product data analysis data exchange data provisioning and data security.
  • Experience with structured semistructured unstructured data collection ingestion provisioning and exchange technological development.
  • Experience with DataOPS performance monitoring and tuning.
Database Management40%
  • Expert data/database administration experience e.g. Microsoft Azure SQL database and Synapse database Oracle IMS DB2 etc.
  • Extensive experience with SQL Server Stored Procedure Oracle PL/SQL PL/1 development and performance tuning.
Data Replication Pipelines 20%
  • Experience with Azure SQL Oracle IMS/DB2 data replication.
Note:
This position is currently listed as Hybrid; however the consultant will be remote due to COVID19 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.


Required Experience:

Senior IC

Employment Type

Contract

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.