In this challenging role I am a member of a very small team responsible for the maintenance, administration and accessibility of geospatial server-side software and corporate spatial data held for the clients of ServiceFirst, a multi-tenanted corporate services provider. My responsibilities include:• Installation, configuration, testing and maintenance of ArcGIS Server and ArcSDE server-side software components, and the associated upgrade of ArcSDE schema objects held in the Oracle Spatial enterprise database.• Preparation of project/work plans and timing estimates concerning the implementation of geospatial server side software upgrades.• Management of corporate spatial data held in the Oracle ORDBMS, with respect to data loading and validation, implementation of appropriate security and maintenance practices.• Design and creation of Oracle schema objects to meet client needs and maximise performance, such as feature classes/datasets, views, triggers, indexes, procedures and functions.• Provision of application support services for the spatial components of corporate business applications. • Analysis and resolution of complex problems in the interface between our Oracle, application server and desktop software components.• Liaison with clients on a daily basis from multiple agencies who are sharing these geospatial resources, and whose differing needs must be accommodated during software upgrade preparation.• Assessment of new software components to help meet client needs, staying abreast of changes in the geospatial industry.• Developing, publishing and maintaining ArcGIS Server web services.

I was a member of a small team of staff working on the establishment of the DNR corporate Enterprise Database (EDB), and related software architecture. The EDB is a central repository for key spatial and textual corporate datasets, and was being accessed by ArcIMS applications, corporate business applications and regional ArcGIS users. The environment being used was Oracle Spatial 9i, ArcSDE 9, and ArcGIS 9. My responsibilities included:• developing and running procedures to load data from a variety of sources to the Oracle Spatial/ArcSDE/ArcGIS environment, utilising a variety of dataload methods depending on the source and nature of the data (Oracle import, sqlloader, FME, SDEimport, ArcCatalog, SQL, PL/SQL).• providing support services for the spatial components of business applications • providing application development services, in particular with ArcIMS• creating and modifying data models with Visio and Erwin.• liaising directly with technical staff at Oracle Corp in America and ESRI in Australia to resolve procedural and technical issues with the data environment.• liasing with inhouse DBAs on the requirements for spatial data in the Oracle RDBMS in terms of data structures, capacity planning and third party software

I worked as a Computer Mapping Officer on the establishment of the Crown Land Information Database (CLID). The CLID Project was established to convert the administration of Crown land (which comprises approximately 50% of NSW) from paper based manual procedures to computerised workflow procedures. This was successfully achieved. CLID consisted of a an intranet based Oracle Forms application, and the Spatial Administration System (SAS) which was a GeniusII/Genamap 7.2 interface. All textual data was held centrally in an Oracle RDBMS, with spatial data decentralised and synchronised via nightly updates. The SAS interface integrated the local spatial data and remote textual data.During CLID development, a 4 year spatial data capture program operated at DITM (now LPI Bathurst) to capture the extent of the Crown Estate in a series of thematic layers. My duties included the following:• ongoing development work on the SAS interface according to user requirements and Project priorities, utilising Genamap scripting, Unix shell scripting, Genius II. • liaison with Genasys regarding bugs found in the Genamap GIS software during both SAS development work and spatial data delivery from the DITM (now LPI Bathurst). Application of software patches or development of work-around code.• development of data management batch processes, and data extraction routines.• development, testing and operation of a process to derive a breakdown of areas of Crown land under selected administrative types by local government area, from spatial/textual data, for the first Statewide valuation of Crown land.• technical support and training for the 400+ SAS users both locally in Bridge Street and remotely in 22 District Office locations. • development of data capture protocols and procedures for the spatial capture of over 40,000 Crown licenses. This included procedures for the data compilation by Lands Officers in District Offices, and protocols for data capture at DITM.