Oracle Dba

**Essential Skills**:

- Oracle Golden Gate set up for real time replication with DataBricks (Must Have)
- Performance tuningKnowledge and experience building data ingestion, history, change data capture using Oracle Golden Gate is an asset.
- Experience building data ingestion and change data capture using Golden Gate
- Azure Data Factory (good knowledge required) to maintain pipeline from Oracle to Azure Data Lake
- Azure Databricks/PySpark (good Python/PySpark knowledge required) to build transformations of raw data into curated zone in the data lakeAzure Databricks/PySpark/SQL (good SQL knowledge required) to develop and/or troubleshoot transformations of curated data into datamart model
- Development of documentation and materials as part of a review and knowledge transfer to other members
- Experience using ETL tools such as Microsoft SSIS, stored procedures, T-SQL (Nice to Have)Azure Data Lake and Databricks, and building Azure Data Factory and Azure Databricks pipelines (Nice to Have)
- Python and PySpark (Nice to Have)
- Ability to present technical requirements to the business

**Job Types**: Full-time, Fixed term contract

Schedule:

- 8 hour shift
- Monday to Friday

Ability to commute/relocate:

- Brampton, ON: reliably commute or plan to relocate before starting work (preferred)

Work Location: Hybrid remote in Brampton, ON