GIS Business SME in Azure Environment with SQL Server - $85 CTC - REMOTE
Job Description: • **Crop to Crop resumes are accepted Work Location: 100% Remote. This will be an ad-hoc / part-time position. Hours will vary but all work will be done during normal State of Maine business hours (Monday - Friday 8:00am - 5:00pm) 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 Express: Awareness of the significant limitations of this edition, including the 10 GB maximum database size and hardware limits on CPU and RAM. Advising users on when to use it (for small-scale projects or testing) and when to upgrade to a licensed version is critical to avoid performance problems or service outages. Connection Management: Creating and managing secure .sde database connection files for users connecting to the SQL Server databases or SQL managed instances from their virtual desktop projects and/or the Enterprise Data Store is necessary. ArcPy Scripting: Proficiency with Python and the ArcPy library is necessary to automate geoprocessing tasks, particularly for data loading and management operations involving the SQL Server geodatabases. 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. Required Skills: • ArcGIS Pro knowledge • Virtual Desktop in Azure environment • Business Workflow Analysis - ability to communicate with end users on their needs Apply tot his job