GIS Database Developer/Analyst

“”

The position will lead GeoAnalytics’ customers in the design, development, and deployment of GIS databases and related business applications. The majority of GIS consulting services work will involve use of ESRI ArcGIS, Geodatabase, and ArcSDE solutions as well as Microsoft Access and SQL Server DBMS technologies. Applied experience is required in the migration of ESRI coverage, shape file, and CAD data into Geodatabase and ArcSDE structures. Initially, the work will be conducted at a local client site. During this time, the position will lead client GIS/IS staff and facilitate offsite GeoAnalytics staff in the completion of various enterprise GIS database and application design and development projects.

As the GIS Database Developer/Analyst you will focus on:

• Gathering customer business requirements and developing logical and physical GIS database designs using industry standard data modeling tools (e.g. Visio)
• Developing and executing data conversion/creation procedures to support legacy data migration into RDBMS systems, Geodatabases and ArcSDE
• Deploying GIS databases at customer sites, including installation of relational database technology and implementing database schemas and table structures required to store spatial and non-spatial attribute data
• Implementing database architecture designs, including memory and storage configuration and security strategies for database users and application roles
• Developing organizational and operational models for enterprise GIS data management
• Developing database stored procedures and triggers to supplement GIS-based business applications
• Creating technical and user documentation related to system development work

As a qualified candidate you will possess the following skills and experience:

• Minimum five years experience implementing IS/GIS systems in production environments, with specific expertise utilizing ESRI ArcInfo and ArcGIS
• Minimum three years experience installing, designing, and deploying relational database technologies, specifically MS Access, SQL Server 7.x/2000, and ESRI GIS database solutions including Geodatabases and ArcSDE
• Familiar with data cleansing and restructuring techniques based on relational principles including normalization and referential integrity. Familiarity with Geodatabase model development
• Knowledge of SQL and experience working with multiple operating systems and hardware platforms with special emphasis on UNIX and Windows OS versions
• Application programming skills including T-SQL (MS) or PLSQL (Oracle) for stored procedures development and VB, AML, etc. for applications development
• Applied experience with formal IS/GIS design and implementation methodologies and related tools (e.g., Visio, Rational, etc.)
• Project team coordination and management
• Ambitious, self-motivated, and results-oriented
• Minimum Bachelor of Science degree, Masters degree preferred

Additional valuable skills would include:

• Work experience setting up and/or supporting ESRI ArcIMS applications
• Work experience with other RDBMS such as Oracle, DB2, or Sybase
• Familiarity with other GIS software solutions such as AutoDesk AutoCad, Intergraph GeoMedia, and Bentley Microstation

” “