Oracle Technical Consultant
CurrentAs the Oracle Technical Application Lead I serve as a subject matter expert and take responsibility for the research, design and implementation of Oracle data warehouse technology for the Coles Group. I have lead the following projects: o PPB LCM (Sales Data) HP-DB (11g) – AIXo CIW Migration 10g – Oracle Exadatao COL (Coles On-line Operation Reporting)/Project Orange with DataStageo CIW Migration 9i – 10g (Database)o COL (Coles On-line Operation Reporting)/Project Orange legacy in 2008o Customer Information Warehouse support o Sales Data Warehouse Support Determine all system and business functions to be monitored and create processes for identification, correction and escalation.Ensure High Availability: Grid, Cluster, monitor system and data changes, proactive monitoring of table spaces, backup, restore, refresh, bottlenecks, load balancing and design disaster recovery plans.Drive and deliver technical specifications (High Level Design / Low Level Design)Work with function leads/stakeholders to define and update master data maintenance and quality processesContribute to the development of end-to-end solutions that deliver capabilities to the enterprise.Coach and mentor team membersAnalyse enterprise business drivers to determine corresponding change requirementsEvaluate market trends and identify prospective impact on businessMaintain database scripts from creation, build, migration and maintenance