Description
Our client is seeking a Data Manager who will upgrade and implement changes to vector and faster geodatabases including Esri Roads and Highways. Under broad supervision designs & secures Esri ArcSDE Geodatabases to store, track, & maintain geospatial data & metadata. Develops and updates database models, administers geodatabases, and maintains multi-user versioned geodatabases.
* Must be in GA to perform job, will work remote until 4/3 with the off need to be in the office due to Covid-19 and stay at home orders..*
Complete Description:
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 CLIENTS Right of Way and surplus parcels.
Responsibilities:
Performs geospatial data processing/ETL and publishing of data into enterprise geodatabases
Acquires, maintains, and disseminates GIS data in support of CLIENTS 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
Work Terms and Conditions:
Candidate will be working in the CLIENTS Office of IT Applications.
Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units.
The candidate will follow internal CLIENTS standards, and accepted best practices for developed solutions. CLIENT will reimburse authorized travel expense lodging and meals.
CLIENT will reimburse authorized travel use of a personal vehicle use.
All travel expense reimbursement shall be in accordance with Travel Policy
Bachelor's in Geography, GIS, Computer Science, or a related field
Required
4 Years
Esri ArcGIS geodatabase development, editing, analysis, and QA/QC
Required
5 Years
Esri ArcSDE replication, versioning, synchronization
Required
3 Years
Microsoft Office
Required
5 Years
Python Scripting and Esri Model Builder
Required
3 Years
Batch data loading and Scripting experience
Required
Safe Software FME Desktop/Server
Required
2 Years
Experience in working with or supporting Esri Parcel Fabric data model
Required
1 Years
Experience PL/SQL, SQLPlus query skills
Required
3 Years
Experience working with or supporting Esri Roads and Highways data model
Required
1 Years
Knowledge of Oracle RDBMS (Relational database management system)
Required
SDO geometry/Oracle Spatial & Graph experience
Desired
Ability to multi-task, detail oriented, and have strong organizational skills
Required
Accountable and results oriented
Required
Data analysis, problem solving, and troubleshooting skills
Required
Strong teamwork and communication skills
Required
Comfortable in a fast-paced environment
Required
Esri Geoevent Processor experience
Highly desired
Workflow Manager Extension (WMX) experience
Highly desired
ArcGIS Portal/Online Administration experience
Highly desired
GISP or Esri Technical Certification
Highly desired
Bentley Microstation ETL experience
Highly desired
Benefits:
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".