GIS Database Administrator
Posted on Feb 7, 2020 by ESG Consulting
Our client is seeking a GIS Database Administrator to designs & secure Esri ArcSDE Geodatabases to store, track, & maintain geospatial data & metadata. Develop and update database models, administers geodatabases, and maintain multi-user versioned geodatabases.
Data Manager will upgrade and implement changes to vector and raster geodatabases including Esri Roads and Highways. Provides ETL functions for processing data into Esri geodatabases through Esri Model Builder, Workflow Manager,and SafeSoftware FME. Will be responsible for implementing Esri Parcel Fabric for storage and maintenance of Right of Way and surplus parcels.
Performs geospatial data processing/ETL and publishing of data into enterprise geodatabases
Acquires, maintains, and disseminates GIS data in support of client 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 and tiles
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
Supports raster data in Image Server
Performs geodatabase administration, configuration, tuning, and performance monitoring in hand with Oracle DBA's
Develops and updates spatial views and data views in hand with Enterprise Data Warehouse Team
Develops geodatabase design documents, metadata, data models, and schemas
Facilitates GIS data interoperability with Bentley Microstation transportation design plans
Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units.
The candidate will follow internal standards and accepted best practices for developed solutions.
Consultant must have cell phone which can be used as a contact for business calls.
Bachelor's in Geography, GIS, Computer Science, or a related field
5 years Esri ArcGIS geodatabase development, editing, analysis, and QA/QC
3 years Esri ArcSDE replication, versioning, synchronization
5 Years Microsoft Office
3 years Python Scripting and Esri Model Builder
Batch data loading and Scripting experience
2 years Safe Software FME Desktop/Server
1 year Experience in working with or supporting Esri Parcel Fabric data model
3 years Experience PL/SQL, SQLPlus query skills
1 year Experience working with or supporting Esri Roads and Highways data model
Knowledge of Oracle RDBMS (Relational database management system)
SDO geometry/Oracle Spatial & Graph experience desired
Ability to multi-task, detail oriented, and have strong organizational skills
Accountable and results oriented
Data analysis, problem solving, and troubleshooting
Strong teamwork and communication skills
Comfortable in a fast-paced environment
Esri Geoevent Processor experience Highly desired
Health, Dental, Vision, 401K
ABOUT ESG CONSULTING:
ESG Consulting is an award-winning national provider of diversified information technology consulting services to Fortune 1000, public sector entities, and emerging growth firms nationwide.
Founded in 1986, ESG offers more than 32 years of experience in the IT staffing, Engineering and consulting industry. While local to Atlanta we are headquartered in Santa Clara.
ESG is an equal opportunity company. Our flexible management culture believes in creating a business environment that fosters personal and professional growth and achievement. We make ESG a place where people are treated not as employees but as "partners".