Home | Jobs | Search

Position Detail

Organization: Professional Technology Integration, Inc.
Title: ArcSDE Geodatabase Administrator (Ref: 2342)
Location: Atlanta, GA 30308
Application Deadline:
Posted: 2017-03-09

Position Description:

New Candidates must register, log in and apply here: http://www.professionaltechintegration.com/PTICloud9/?option=com_mycareer&job=view&jpid=2342&Itemid=508

Position: ArcSDE Geodatabase Administrator (Ref: 2342)
Location: Atlanta, GA 30308
Salary: $50.00/hr
Duration: 1 Years 3 Months 22 Days - Contract
Openings: 1
Submission Deadline: 03/17/2017

We are seeking an Esri ArcSDE Geodatabase Administrator with solid experience and knowledge in designing, implementing, and supporting multi-user versioned geodatabases. The Enterprise GIS Team is composed of 2 developers, a team leader, and system administrator. 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 coordinates with client, server, network, and database/data warehouse personnel to support IT Project implementation and user support.

The team is migrating from ArcGIS 10 to ArcGIS 10.4.1. Geodatabases will need to be upgraded. Esri Roads and Highways will be integrated with asset management and traffic operation systems. The geoportal will be enhanced to provide public access to data, metadata, and services (ArcGIS, KML, WMS, etc.). Additional extract, transform, and loading (ETL) functions will be developed with ActiveBatch, Esri Model Builder, Esri Workflow Manager, and SafeSoftware FME to support business needs.

• Manages the (SDE) data and operation of the Esri Roads and Highways and all other Esri enterprise geodatabases
• Performs geospatial data processing/ETL and publishing of data into enterprise geodatabases
• Acquires, maintains, and disseminates GIS data in support of GDOT activities
• 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

• Bachelor’s in Geography, GIS, Computer Science, or a related field
• 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
• Knowledge of linear Referencing or transportation experience

Required / Desired Skills
• ArcGIS with geodatabase development, editing, analysis, and QA/QC Required - 5 Years
• ArcSDE replication, versioning, synchronization Required - 3 Years
• Geodatabase development and analysis using GIS Required - 3 Years
• Python scripting Required - 3 Years
• Esri Model Builder Required - 3 Years
• Batch data loading and scripting experience Required - 3 Years
• SDE/Geodatabase administration Required - 3 Years
• Esri Roads and Highways and Workflow Manager Required - 3 Years
• SDO geometry/Oracle Spatial & Graph experience Required - 3 Years
• PL/SQL, SQLPlus query skills Required - 3 Years
• GISP or Esri Technical Certification Required - 1 Years
• Oracle database experience Required - 3 Years
• Esri Image Server implementation experience Required - 3 Years
• Database ETL or FME Experience Required - 1 Years
• Microstation Experience Required - 1 Years
• Trimble GPS, GPS Analyst, and Arc Pad experience Required - 1 Years