Job Description
Developing, documenting, implementing, securing, and maintaining geospatial and alphanumeric data models and databases in RDBMS in both on-premises and cloud environments. Supporting the Development, Maintenance, and Operations of Enterprise Geodatabases and associated SQL Server or Postgres Instances. Creating functional specifications and recommending solutions for alphanumeric and geospatial data systems. Developing and maintaining databases and data systems, reorganizing data in a readable format; using automated tools for data extraction, repair, and coding error fixes. Defining database physical structure, functional capabilities, and current/future storage requirements. Developing and documenting appropriate metadata records (business, technical, process, operational). Developing and maintaining enterprise data architecture to support business requirements. Developing and implementing physical data models for both tabular and geospatial data systems and reverse engineering physical databases. Monitoring and optimizing database(s) performance and user access, planning for backup and restoration/recovery of database information, and managing/monitoring data replication. Publishing geospatial web services to support feature service editing workflows and branch versioning. Configuring Enterprise Geodatabases and web services to support various workflows. Maintaining database and instance performance by calculating optimum values for database parameters. Implementing new releases and completing maintenance requirements. Documenting and developing processes to better align with security best practices and support Authority to Operate (ATO) development. Possessing familiarity with, and willingness to learn, unstructured and NoSQL data patterns (e.g., graph databases, JSON document and key-value stores). Implementing and monitoring applicable security controls as defined by the applicable Security Technical Implementation Guide (STIG) under IT Security Officer direction. Providing input to Plan of Action and Milestones (POAM) for non-compliant ATO boundary checks related to SQL databases. Responding to and remediating security alerts concerning administered databases instances. Providing examples of designing and implementing scalable GIS solutions that integrate with enterprise systems. Demonstrating a proven ability to innovate and enhance GIS functionalities.
About Flatwater, Inc.
Flatwater, Inc. serves as a technical leader responsible for designing, implementing, securing, and maintaining complex geospatial and alphanumeric data systems.