Senior Spatial Database Administrator Job at Riverside Technology, Remote

T2ladnU1Q011MWxMZ2xUNGdRNzFpdDRjTHc9PQ==
  • Riverside Technology
  • Remote

Job Description

Riverside is seeking to hire an experienced Senior Spatial Database Administrator to support Enterprise Data Management Services (including Geospatial) for the National Park Service (NPS), Information Resources Directorate, National Information Services Center (NISC) in Lakewood, Colorado. Overall, NPS needs data management services to document, plan, create, deploy, maintain, sustain, troubleshoot, and update new and legacy enterprise geospatial and data management systems. These services include database operations, geospatial enterprise database and geospatial web service support, data development, data migration, data pipeline development, data integration, geospatial web mapping, and reporting or business intelligence capabilities.

This position will assist the NPS in developing, documenting, implementing, securing, and maintaining geospatial and alphanumeric data models and databases in Relational Database Management Systems (RDBMS) in both on-premises and cloud environments. The Spatial Database Administrator will help manage and administer spatial data in geodatabases and associated editing workflows, including publishing and management of geospatial web service-based editing workflows using ArcGIS Enterprise, PostGRE/GIS, and Geoserver. They will also assist with database instance management, configuration, and disaster recovery for spatial and alphanumeric data.

Responsibilities:

  • Development, Maintenance, and Operations of Enterprise Geodatabases and associated SQL Server or Postgres Instances.
  • Create functional specifications and recommend solutions for alphanumeric and geospatial data systems.
  • Develop and maintain databases and data systems, reorganizing data in a readable format. Use automated tools to extract data from various sources, remove or repair corrupted data, and fix coding errors and related problems.
  • Define database physical structure and functional capabilities and current and future storage requirements.
  • Develop and document appropriate metadata records (business, technical, process, and operational) for the contents of developed data management systems and data standards.
  • Develop and maintain enterprise data d architecture to support business requirements.
  • Develop and implement physical data models for both tabular and geospatial data systems and reverse engineer physical databases as needed by various business units/program areas.
  • Monitor and optimize database(s) performance and user access, plan for backup and restoration/recovery of database information, manage and monitor data replication.
  • Publish geospatial web services to support feature service editing workflows and branch versioning. Configure Enterprise Geodatabases and web services to support various workflows in support of customer requirements.
  • Maintain database and instance performance by calculating optimum values for database parameters.
  • Implement new releases, completing maintenance requirements.
  • document and develop these processes to better align with security best practices and to support the development of our Authority to Operation (ATO), and
  • Possess familiarity with, and willingness to learn, unstructured and NoSQL data patterns such as graph databases, JSON document and key-value stores, and other emerging technologies that best fit with identified customer requirements.
  • Implement and monitor applicable security controls as defined by the most recent release of the applicable Security Technical Implementation Guide (STIG) under the direction and supervision of the IT Security Officer (ITSO).
  • Provide input to Plan of Action and Milestones (POAM) for any non-compliant Authority to Operate (ATO) boundary checks related to SQL databases.
  • Respond to and remediate security alerts concerning administered databases instances

Qualifications / Skill Requirements:

  • BA/BS and 4 years of experience least with Enterprise Geodatabases on MS SQL Server and PostGre/GIS, including SQL Instance management
  • At least 3-years of experience publishing geospatial web services using ArcGIS Enterprise, ArcGIS Online, and open-source GIS Content Management Platforms.
  • Experience with or willingness to learn how to leverage cloud data storage, processing, and analytics in Microsoft Azure or Amazon Web Services (AWS) since the technical stack is a hybrid cloud environment.
  • Experience in developing, documenting, implementing, securing, and maintaining geospatial and alphanumeric data models and databases in Relational Database Management Systems (RDBMS)
  • Skills in Structured Query Language (SQL) and database procedural code such as T-SQL.
  • Expertise in managing and administering spatial data in geodatabases and associated editing workflows, including publishing and management of geospatial web service-based editing workflows using ArcGIS Enterprise, PostGRE/GIS, and Geoserver.
  • Experience with database instance management, configuration, and disaster recovery for spatial and alphanumeric data.
  • Strong organizational skills
  • Detail oriented and effective verbal and written communication skills
  • Ability to be flexible in responding to changes in schedules and job priorities
  • Able to work in a team environment with partners from various disciplines
  • Able to work in the US without sponsorship

At Riverside, we are committed to fostering an inclusive and merit-based workplace. We provide equal employment opportunities to all individuals, ensuring that hiring and employment decisions are based on qualifications, skills, and performance. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Job Tags

Full time, Flexible hours,

Similar Jobs

University of Maryland Medical System

Medical Assistant (MA), Orthopedics, PRN Job at University of Maryland Medical System

 ...THE MEDICAL HEART OF MARYLAND Treating over 330,000 patients every year, the University of Maryland Medical Center is at the...  ...environment. We are seeking new an d experienced Medical Assistants to join our extraordinary team! As a Medical Assistant... 

Ryder System

Senior Software Engineer, Infrastructure - Data Platform Job at Ryder System

 ...Description** :**Responsibilities**+ **Design and Maintain Robust Data Architecture:**+ Design, maintain, and optimize our data...  ...opportunities.+ **Technical Expertise:**+ Solid foundation in data analytics and big data technologies, capable of leveraging these skills... 

Greenlife Healthcare Staffing

Medical Assistant - General Practice Job at Greenlife Healthcare Staffing

 ...advancement pathways Impactful Work: Serve diverse communities in public health settings Position Overview Greenlife Healthcare...  ..., and recordkeeping. This is an excellent opportunity for entry-level professionals or those seeking to expand their clinical experience... 

AmeriHealth Caritas

Pediatric Shift Care Utilization Management Review Nurse Job at AmeriHealth Caritas

 ...the unit Supervisor, the Clinical Care Reviewer- Shift Care is responsible for managing...  ...pediatric shift care services including skilled nursing and home health aide services, medical...  ...setting+ Minimum of 3 years of Utilization Management experience, preferably within... 

Carle Health

Radiologic Technologist Intern - Proctor Job at Carle Health

 ...variety of healthcare businesses. Carle BroMenn Medical Center, Carle Foundation Hospital, Carle Health Methodist Hospital, Carle Health Proctor Hospital, Carle Health Pekin Hospital, and Carle Hoopeston Regional Health Center hold Magnet designations, the nations highest...