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

Similar Jobs