Overview
Skills
Job Details
ArcGIS and Geospatial Skills
Deep ArcGIS Pro Knowledge: Proficiency in ArcGIS Pro's core functionalities, including data editing, spatial analysis, and advanced cartography, is essential to guide users effectively in their workflows. Ability to describe and guide users about best practices for using ArcGIS Pro interactions with ArcGIS Enterprise Portal applications and services.
Enterprise Geodatabase (SQL Server): Expertise in managing enterprise geodatabases within SQL Server is crucial.
SQL Server Standard: Understanding how to create, manage, and secure a geodatabase, including user creation, permissions, and database maintenance tasks like compression and index rebuilding.
SQL Server Administration Skills
Database Maintenance: Performing regular maintenance on the SQL Server databases, such as updating statistics and rebuilding indexes, is crucial to prevent performance degradation. For SQL Server Standard, leveraging the built-in SQL Server Agent for automated tasks is beneficial.
SQL Server Express Limitations: Proficiency in managing the constraints of SQL Express is important. This includes monitoring database size to prevent reaching the 10 GB limit and understanding that features like the SQL Server Agent are unavailable for automated maintenance.
Security Management: Knowledge of the correct methods to manage SQL Server security is needed to work with the MaineIT team that manages the profile information of authenticated database users and roles, ensuring appropriate permissions are granted to GIS users.
Consulting and Troubleshooting Skills
Business Workflow Analysis: You must listen to users' needs and design appropriate workflows that account for the different capabilities and limitations of SQL Server Express vs. Standard. This involves advising users on whether their project data should reside in one database or the other.
Virtual Desktop Administration Skills
Virtual Desktops and Apps: ESRI recommends a Virtual Desktop Infrastructure (VDI) approach for ArcGIS Pro for optimal performance, managing and optimizing both dedicated desktop and virtualized application deployments is essential.
GPU Virtualization: As ArcGIS Pro is graphics-intensive and performs poorly without a dedicated GPU, expertise in configuring graphics delivery using technologies like NVIDIA vGPU within the virtual servers is required to ensure a responsive user experience.