Database Administrator

Layermark - Fairfax, VA

Full-time

Fairfax, VA

About the position

The Spatial Data/Database Administrator role focuses on designing and implementing spatial data models for systems that integrate spatial components into their data architecture. The position involves developing ETL tools for data migration, ensuring data quality, and documenting metadata for spatial data models.

Responsibilities

• Design and implement spatial data models for systems incorporating spatial data.
• Develop ETL tools to migrate data from non-spatial to spatial models.
• Create data quality control processes and tools to ensure data integrity.
• Determine spatial database model requirements and implement them.
• Develop functional requirements and design documents for proposed data models.
• Document metadata for spatial data in compliance with FGDC standards.

Requirements

• Experience with Microsoft SQL Server and the latest versions of ArcGIS.
• Familiarity with Esri's Data Interoperability and Data Reviewer extensions or similar ETL tools.
• Ability to develop functional requirements and design documents for data models.
• Familiarity with spatial data and FGDC metadata.

Nice-to-haves

• Experience with various workflows in Branch Versioning.