Esri ArcSDE Geodatabase Administrator

Georgia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Our client is seeking an Esri ArcSDE Geodatabase Administrator with solid experience and knowledge in designing, implementing, and supporting multi-user versioned geodatabases.

Our client's Enterprise GIS Team is composed of 4 developers, a team leader, and user support specialist. The team supports over 300 ArcGIS Desktop (Citrix VM) users and over 60,000 annual geospatial web application (ArcGIS Server) visits. The team develops Esri ArcGIS services, applications, and geodatabases (Oracle 11g/12c SDO/ST Geometry). The team supports GIS functions in transportation permitting, road inventory, emergency operations, crash location, project planning, and asset management. The team coordinates with client, server, network, and database/data warehouse personnel to support IT Project implementation and user support.

Esri Roads and Highways is implemented to support road centerline and event feature editing workflows. Our client's geoportal has been enhanced to provide public access to data, metadata, and services (ArcGIS, KML, WMS, etc.). Additional extract, transform, and loading (ETL) functions have been developed with ActiveBatch, Esri Model Builder, Esri Workflow Manager, and SafeSoftware FME to support business needs.

The Geodatabase Administrator position end date is set for one year.

Responsibilities:
Performs geospatial data processing/ETL and publishing of data into enterprise geodatabases
Acquires, maintains, and disseminates GIS data in support of one business unit
Maintains currency and completeness of enterprise geodatabase data, metadata, and geoportal
Ensures completion of data updates and facilitates resolution of data governance/quality issues
Controls GIS data security, access, distribution, and retention
Replicates, synchronizes, and restores geodatabases
Creates data caches
Troubleshoots and supports end user data compression, versioning, and multi-user editing workflows within geodatabases
Implements data security and access controls
Implements geodatabase design standards
Creates and supports Active Batch, Model Builder, Workflow Manager, and FME jobs
Migrates raster holdings to Image Server
Performs geodatabase administration, configuration, tuning, and performance monitoring in hand with Oracle DBA's
Develops spatial views and data views in hand with Enterprise Data Warehouse Team
Geodatabase design documents, metadata, data models, and schemas
Facilitates GIS data interoperability with Bentley Microstation transportation design plans

Required Skills:
Bachelor's in Geography, GIS, Computer Science, or a related field
5+ years experience - ArcGIS with geodatabase development, editing, analysis, and QA/QC

Experience with ArcGIS 10.x. Geodatabases
3+ years experience - ArcSDE replication, versioning, synchronization
3yrs Experience - Geodatabase development and analysis using GIS
5yrs Experience - Microsoft Office
1 year experience - Python Scripting and Esri Model Builder
Batch data loading and Scripting experience
SDO geometry/Oracle Spatial & Graph experience
PL/SQL, SQLPlus query skills
Knowledge of Oracle RDBMS (Relational database management system)
Ability to multi-task, detail oriented, and have strong organizational skills
Accountable and results oriented
Data analysis, problem solving, and troubleshooting skills
Strong teamwork and communication skills
Comfortable in a fast paced environment

Desired Skills:
GISP or Esri Technical Certification
Oracle database experience
Knowledge of linear Referencing or transportation experience
Esri Image Server implementation experience
Database ETL or FME Experience
Microstation Experience
Trimble GPS, GPS Analyst, and Arc Pad experience

Start date
n.a
Duration
12 month
From
ESG Consulting
Published at
17.07.2018
Project ID:
1599522
Contract type
Freelance
To apply to this project you must log in.
Register