Dba

Partner with third-party vendor to design and implement a new business intelligence platform for the company’s SaaS-based Project Portfolio Management application, modernizing reporting and analytics capabilities. Developed and implemented the Change Data Capture (CDC) in Oracle for reliable downstream replication. Consulted on the design and implementation of Azure Data Factory pipelines to extract and transform Oracle source data into partitioned Parquet datasets in Azure Data Lake Storage Gen2 for downstream Databricks ingestion. Oversaw the implementation of a Databricks Medallion architecture using PySpark and Delta Live Tables to process Oracle-sourced Parquet data — deduplicating Bronze-layer ingests, reconciling CDC changes in Silver, and modeling Gold-layer fact and dimension tables powering embedded Power BI analytics. Introduced row-level security (RLS) and Unity Catalog for governed analytics access. Implemented Databricks Delta sharing capabilities for real time Databricks to Databricks integrations. Assisted with the design and automation of a Terraform-based Infrastructure-as-Code (IaC) framework to deploy Azure Data Factory, Key Vault, Storage Account, SQL Database, Log Analytics Workspace, and Managed Identities across dev, test, and production environments. Integrated environment configuration via YAML templates and automated validation through Go-based Terratest to ensure consistent, repeatable deployments. Ensured full alignment to the Statement of Work, validating deliverables and maintaining accountability. Assisted with the creation of the Technical Design Document (TDD) to eliminate ambiguity and ensure maintainability. Structured and led Knowledge Transfer (KT) sessions to equip stakeholders for post-implementation support.