John Squire Email and Phone Number

An Oracle Technical Architect/ Data Architect; comprehensive experience of designing, developing and implementing transactional, data warehouse & Business Intelligence solutions from small to large scale projects utilising Oracle database technology often in complex and challenging environments. Specialising in the implementation and tuning of high-performance multi-terabyte systems. A hands-on technologist who understands the big picture but still gets their hands dirty.Expert in conceptual, logical and physical data modelling using relational (3NF) and dimensional data modelling techniques (Kimball) utilising Oracle Case Tools, Toad data Modeller and MS Visio.Expert in the design and developing of multi-terabyte database applications for reliable and robust systems, including table partitioning strategies, indexing strategies, pl/SQL, SQL development and performance tuning.Project management expertise in scoping, estimation, planning, resource optimisation and team leadership.Have proven judgement, necessary to evaluate and select the best solutions to complex problems.A driver of change; always looking for opportunities to utilise new features and technology that will reduce operational / maintenance costs, increase performance or productivitySpecialities: Oracle 12c, Oracle 11gR2,Oracle 10g,Oracle 9i, Analysis and Design, Database Design (Warehousing, ODS and Transactional ), SQL & PL/SQL, Performance tuning, Case Tools, Capacity Planning, Project Management, Application Express - Apex, ETL