Experience

PostgreSQL Global Development Group

• IT Services and IT Consulting
• 1 - 100 Employee

• Volunteer Contributor, Committer (since 2016)

  • Jul 2009 - Present

  Feature development, bug fixing and patch review. My major contributions include: • Deferrable unique constraints • INSTEAD OF triggers • Automatically updatable views • WITH CHECK OPTION • Updatable security barrier views • Various improvements to arbitrary precision numeric arithmetic • Trigonometric functions that work in degrees • Improvements to extended statistics and statistical aggregates • Co-author of row-level security Feature development, bug fixing and patch review. My major contributions include: • Deferrable unique constraints • INSTEAD OF triggers • Automatically updatable views • WITH CHECK OPTION • Updatable security barrier views • Various improvements to arbitrary precision numeric arithmetic • Trigonometric functions that work in degrees • Improvements to extended statistics and statistical aggregates • Co-author of row-level security



University of Cambridge

• United Kingdom
• Research Services
• 700 & Above Employee

• Principal Software Developer & Database Expert

  • Oct 2007 - Present

  Designing and building core University systems, data-driven websites and databases for the University's central IT department, with a focus on identity and access management systems, and services for the wide variety of institutions that make up the University of Cambridge. Major developments include: • The University's directory of all staff and students, providing federated control to the Departments and Colleges of the University, group management for authorisation decisions and APIs for integration with other IT systems throughout the University. • The University's Password Management system for administering all user passwords, with rigorous strength checking, federated recovery options, and central account locking. • The central University training booking system, supporting multiple training providers throughout the University and providing users with a unified training record for personal and professional development. • Software purchasing site, offering a range of software at favourable rates to the University, central licence management and safe and secure software downloads. • Streaming Media Service for audio and video content produced by the University for research and teaching purposes, providing a central curated media archive, flexible transcoding options, together with streaming, downloading and embedding support. Show less



1Spatial

• Australia
• IT Services and IT Consulting
• 100 - 200 Employee

• Principal Software Engineer

  • Jan 1998 - Jul 2007

  Worked in all areas from the lowest level database code to building desktop and web user interfaces. • Designed and implemented improved spatial indexing and versioned B-tree algorithms, and a new query API for the company's proprietary geospatial database. • Lead developer for the C-to-Java initiative using JNI to expose legacy C code to Java. • Design authority for core low-level database modules. • Team lead for the AIDU project to deliver high quality aeronautical data for the production of air charts for the RAF. • Architect of the rules engine based product line (now branded as 1Integrate). Show less



University of Cambridge

• United Kingdom
• Research Services
• 700 & Above Employee

• Undergraduate supervisor (tutor)

  • Oct 1994 - Dec 1997

  Teaching 2nd year undergraduates introductory Quantum Mechanics and Special Relativity, and (for more advanced students) General Relativity. Teaching 2nd year undergraduates introductory Quantum Mechanics and Special Relativity, and (for more advanced students) General Relativity.