Go to content Go to navigation Go to search

My Services :: 1039 days ago

I offer the following services to customers:

  1. Independent Solutions Advice and Sanity Checking
    Solutions not Software ;
    Does what you have been offered really stack up?
    Open Source vs Commercial off the shelf (COTS)?
    Unpacking buzzwords like SOA, BPEL, J2EE, .NET, WebServices…     ;
  2. Database Benchmarking:
    How well are you getting a return on investment for your Oracle Spatial/SQL Server 2008 Spatial/PostGIS database?
    How good is your databases documentation/metadata?
    Is the integrity and quality of the data stored in your databases as good as you think?
    Is your use of Oracle (Spatial), SQL Server (2008 Spatial) consistent with industry best-practice?
    Get advice on some simple “rules” to follow to improve your database!
  3. Database Consulting through build and configuration services
    Ensuring your databases reflect your needs? via:
    1. Data Quality Rules Documentation, Conformance Testing, Correction and Certification using Radius Studio
    2. Data Conversion, Migration, Loading;
    3. Database Design;
    4. PL/SQL – Oracle, PL/pgSQL – PostgreSQL, T-SQL – SQL Server – Script Design and Coding;
    5. Database Performance Tuning;
    6. Spatially enabling Data Warehouses and Processes;
    7. ArcSDE Configuration and Tuning.
  4. SpatialDB Training Courses and Staff Mentoring
    Spatial SQL Training on your datasets;
    After Training support     ;
  5. Improving ROI on your current GIS software infrastructure
    Matching business problems to existing software investment;
  6. Free Software

I have over 20 years experience with database technologies from mainframes through to personal computers. I have 18 years Oracle use, and am recognised by the Oracle Spatial development team as one of the early adopters of Oracle’s Sdo_Geometry data type. I use PostgreSQL/PostGIS regularly and was on the original beta program for SQL Server 2008 Spatial (aka “Katmai”). While most of my solutions work centres on Oracle, I also have the necessary SQL Server, PostgreSQL/PostGIS and MySQL experience to help you implement the best solution possible.

I also have one of the longest experience of using ArcSDE in the industry and can help you get the best out of this piece of ESRI software. Also, with the new ESRI Spatial Type for Oracle, PostgreSQL and SQL Server, I am in a unique position to help you plan your migrations from SDEBINARY to either the ESRI Spatial Type, SQL Server 2008 Spatial or Oracle’s Sdo_Geometry.

Finally, as a geospatial professional with IT and Oracle (Certified Professional SQL 10gR2; Certified Associate DBA 10gR2) qualifications and experience, I can help guide the uptake of geospatial technologies into business’s IT infrastructures.

Let me help you cost-effectively spatially-enable your enterprise.