Solve your spatial data conversion challenges with FME. Get the most extensive format support for data translation and integration, and unlimited flexibility in data model transformation.
GeoAnalytics specializes in the planning, design, and implementation of enterprise class, spatially enabled information systems that create true spatial intelligence. More than data and information, spatial intelligence combines system and data integration with business and predictive intelligence as well as spatial analytics to provide knowledge and understanding from all corners of the enterprise.
Providing high quality, leading edge consulting and applications development services to clients in both the public and private sectors, GeoAnalytics offers unique technical capabilities and expertise in business and predictive intelligence, asset and resource management, enterprise addressing, customer information systems, records management, site location, strategic database marketing, compliance, and transactional systems.
We are currently seeking to fill a Senior Database Developer position, based out of our corporate headquarters in Madison, Wisconsin. The position will require some travel and work at client sites across the U.S.
This position will provide leadership in the design, development, migration and deployment of spatially-enabled databases and related business databases. The majority of work will involve use of ESRI ArcGIS Desktop, Geodatabase, ArcSDE solutions as well as system design software, Oracle RDBMS (including Spatial), SQL Server DBMS and Microsoft Access technologies. Applied experience is required in the migration of ESRI coverage, shape file, and CAD data into Geodatabase and ArcSDE structures. In addition, knowledge of data migration methods in general is required for the integration of disparate databases. The position will be expected to help lead client GIS/IS staff and facilitate GeoAnalytics staff in the completion of various enterprise database and application development projects involving GIS.
As the Senior Database Developer you will focus on:
Leading design, development, migration and deployment of spatially-enabled databases and related business databases and related system components
Gathering customer business requirements and developing logical and physical database designs
Implementing database architecture designs, including memory and storage configuration and security strategies for database users and application roles
Developing and executing data conversion/creation procedures to support legacy data migration into RDBMS systems, Geodatabases and ArcSDE
Deploying GIS-enabled databases at customer sites, including installation of relational database technology and GIS middleware, and implementing database schemas and table structures required to store spatial and non-spatial attribute data
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
Actively participating in project team communication, coordination, interaction and management activities
Developing database structures for use in Analytical Applications, both tabular and spatial
Developing automated ETL (Extract, Transform, Load) systems, both tabular and spatial
GeoAnalytics offers a challenging and cordial team environment along with a competitive salary, benefits package, and future growth opportunities.
Qualifications
The following desired skills and experience will qualify you for this opportunity:
Five years experience implementing IS/GIS systems in production environments, with specific expertise utilizing ESRI ArcInfo and ArcGIS
Three years experience installing, designing, and deploying relational database technologies, specifically Oracle 8i/9i/10g (including Spatial), MS SQL Server 2005 and ESRI GIS database solutions including Geodatabases and ArcSDE 8/9
Familiar with data 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
Understanding of the different methods of transaction handling between spatial and tabular systems
Experience with data warehousing, automated ETL, data profiling and cleansing, integration of multiple source databases, OLAP structures, and how they integrate or feed into Business Intelligence interfaces
Application programming skills and production experience including PLSQL (Oracle) and T-SQL (Microsoft) for stored procedure development and VB, AML, Python, etc. for application development
Understanding of different approaches involving stored procedures vs client application processing
System design and modeling techniques, including experience with industry standard methodology and tools (UML notation in Visio, Rational Rose, RUP, Agile, Enterprise Architect, ERD notation in Visio, ERStudio, etc.)
Strong interpersonal and written communication skills and experience working closely with clients
Bachelor of Science degree (Computer Science, GIS, Engineering, Mathematics or similar technical field). Advanced degree preferred.
Secondary and/or Additional skills could include:
Work experience setting up and/or supporting ESRI ArcIMS applications
Work experience with other RDBMS such as SQL Server, DB2, or Sybase
Familiarity with other GIS software solutions such as AutoDesk AutoCad, Intergraph GeoMedia, and Bentley Microstation
ESRI ModelBuilder and related scripting languages such as Python for spatial data management and geoprocessing
Business requirements definition and use case development
How to Apply
For consideration please visit our website at www.geoanalytics.com and click on the Career Center link. GeoAnalytics is an affirmative action and equal opportunity employer.
See more threads and details about Glenn's AnyGeo Weblog HERE The Editor (Glenn) started the AnyGeo blog some time ago and the threads are now also mirrored here at GISuser.com - RSS feed is available to add to your favorite news reader.
Featured Events
The OReilly Where 2.0 conference brings together the people, projects, and issues inspiring change. Where 2.0 exposes the tools pushing the boundaries of the location frontier, tracks the emergence of new business models and services, and examines new sources of data and the platforms for collecting them.
GeoWeb 2008 - This exciting annual conference will take place in Vancouver, Canada from July 21-25th, 2008 at the Morris J. Wosk Centre for Dialogue. The GeoWeb 2008 conference welcomes both public and private organizations to meet, discuss and learn about todays most innovative geospatial technologies.
2008 ESRI International User Conference (ESRI UC) - Users from more than 120 countries come to learn new skills, share information, and discover best practices, tips, and tricks that they can use instantly. Be part of this extraordinary experience August 48, 2008, in San Diego, California.
2008 ESRI Survey & Engineering GIS Summit - August 2-5, San Diego, California. Join more than 400 surveyors and engineers in exploring the possibilities of GIS technology. See how GIS software integrates with surveying and engineering tools to provide more complete business solutions and field processes.
Jobs 
See more threads and details about 
Get GISuser news & updates via RSS
