Summary of Experience

Confidential Sr Oracle and GIS DBA. Reporting to IBM DBA Manager. Responsible for providing consulting and support services on Oracle database and GIS system migration for 27 state government agencies to a Data Center facilities in Texas. The work area includes but not limited to the following items.

• Oracle database administration support including installation, configuration, maintenance, backup, tuning on both UNIX/Linux Windows based operating system
  • Unix/Linix and Windows Shell scripting e.g NT shell, bash, tcsh, ksh
  • VBscripts
• Experience with following Oracle features
  • RMAN Backup Recovery Disaster Recovery using TSM and disk
  • Database upgrade and CPU Patching
  • Oracle Grid Control 10G/11G and Database Control
  • Oracle Data Guard
  • Oracle Real Application Cluster
  • Import/Export Datapump
  • Batch jobs setup and monitoring e.g Windows Scheduler/Unix Crontab
• Backup Scheduling Tools like NetBackup Scheduler, Windows NT Scheduler, Unix/Linux Crontab
• GIS user accounts maintenance, configuration, integration
• GIS infrastructure, system design and upgrade
• E.g. Setup/Install/Configure ArcGIS Server 9.3, ArcIMS 9.3, ArcSDE 9.3 for Texas Education Agency, Texas Parks and Wild Life, Texas Department of Transportation, Railroad Commision, Texas Commision on Environmental Quality etc.
• E.g Installation and configuration of Visual Studio, SQL Server 2005/2008 and Oracle 9i/10g/11g
• GIS Data Maintenance and loading/unloading, data massaging, spatial analysis etc.
• SQL Server database administration like backup, tuning

Confidential Senior IS Developer. Reporting to Houston Program Manager. Responsible for GIS system development with full project development life cycle like prototyping, acquiring user requirements, project scheduling and primary spatial and relational database administration work. Confidential

Involved in the design and implementation of water-resources-type engineering modeling. The system is basically designed to track every detail leading to illicit discharge to outfalls connecting to all kinds of water bodies. Mr. Chow participates in designing UML the data model and the ongoing setup, maintenance and data loading process with ESRI ArcSDE V9.1 database repository. He also serves as the ArcSDE administrator to setup and maintain the database in both Microsoft SQL Server and Oracle. He is also actively coding various GIS desktop applications like OTS Outfall Mapping Tools, geoprocessing Spatial Proximity Analysis components by ESRI ArcObjects V9.1 and Water Chemistry Field Data Collection tool with latest ESRI mobile technology Arcpad V7on tablet PC iXplore . After field data is collected by the tablet PC, they would be synchronized with ArcSDE database by a third party software GO Sync through the internet media. Therefore, contractors would be able to up-sync their data even without the need of accessing the internal network on server side. The whole system is short listed for presentation in the ESRI Annual Conference 2006 in San Diego, US.

Confidential

Involved in the design and implementation of attaching a GIS Spatial component SWAP utilizing ESRI ARCSDE technology to an existing generic Oracle database WUD . The major objective is to develop automated programmatic workflow for executing insertion, update and deletion of records to and from both databases. The process involved the development of ESRI UML diagram, development of automated database stored procedures, setting up and configuration of ARCSDE and Oracle databases, and development of various .NET and ArcObjects based applications to well fit into the physical business workflow process.

Confidential

Involved in implementation of an ArcHydro based Watershed Modeling system which aims at providing linkage mechanism between hydraulic modeling and hydrologic model through features, objects, relationships and topology in GIS. Other development functions include custom database design, data conversion utility with NHD datasets from USGS etc.

Confidential

Involved in the design and implementation of an GIS web pages to display various county wide spatial and aspatial data. A typical example is to show people whether a residential lot resides within a FEMA flood plain area and identifying the lot number from the county web site and query the annual tax chargeable to the lot. It is developed with ESRI ArcIMS V4.01 together with ESRI ArcMap Server V8.3 as the back end integration service.

Confidential

Involved in the enhancement and upgrade of geodatabase data modeling with ESRI ArcInfo V8.3 and Microsoft Visio .Net for UML Modeling. The objective is to incorporate the cultural resource report details with the cultural resource feature class with UML modelling approach.

Confidential

Involved in modification and upgrade of geodatabase data modeling with Microsoft Visio .Net UML Modeling package and ESRI Case Tools. With Visio, all newly created attributes would be generated under the ArcHydro based database schema.

Confidential System Analyst. Reporting to System Manager. Responsible for leading a group of 4 - 5 colleagues to design, implement and monitor an in-house GIS system for town planning applications in HK

Implemented a town planning oriented system Building Dilapidation and Rehabilitation Information System BDRIS for Planning Department of HK government

Responsible for overall system design and getting user requirements

Prepared documents like user material, program specification, SA D report, etc

Serve as Oracle DBA for supporting the development, setup, configuration and maintenance of database for long term development.

Involved in programming for system interfaces and data conversion with major tools such as ESRI ArcObject V8.3, ESRI ArcInfo Desktop V8.3, ESRI ArcIMS V4.0, ESRI ArcSDE V8.3, Oracle RDBMS V9

Summary of Technical Experience