GDOT - Esri Data Manager(Database Administrator 3)--626903
Compensation: $89,010.00 - $128,720.00 /year *
Employment Type: Full-Time
Industry: Information Technology
Loading some great jobs for you...
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.The Dept of Transportation seeks a Data Manager who will upgrade and implement changes to vector and faster 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 GDOT 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 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 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 plansCandidate will be working in the GDOT 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 GDOT standards and accepted best practices for developed solutions.Position is on-site at Georgia DOT offices at One GA Center at 600 West Peachtree Street NW, Atlanta, GA 30308.The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful consultants have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted. Candidates must have valid United States Social Security Number (SSN).The Department has 12 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval. Consultant must have cell phone which can be used as a contact for business calls.GDOT does not provide free parking. All routine commuting expenses are the responsibility of the candidate.Travel is not expected in this position. However if required, Georgia DOT will reimburse authorized travel expense lodging and meals. Georgia DOT will reimburse authorized travel use of a personal vehicle use. All travel expense reimbursement shall be in accordance with State Accounting Office Travel Policy: | Skill | Required / Desired | Amount of Experience needed | Candidate Experience | 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 Micro station ETL experience | Highly desired | |
Associated topics: data administrator, data analytic, data architect, data center, data management, data quality, data scientist, etl, mongo database administrator, sql
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.
Loading some great jobs for you...