*We have a contract opportunity for a ArcGIS Pro Subject Matter Expert for state government. The project is for 520 hours per year plus extensions. 100% Remote*.*
*Client: State Government - MaineMinimum 7 years experience. Length: 12 months+ assignment with possible extensions. Work Location: 100% RemoteInterview: MS Teams Meeting * Sr. Business SME2 Skills Required for ArcGIS Pro Users in an Azure Environment with SQL Server 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 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 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. Performance Monitoring: Monitoring and troubleshooting performance issues within the Enterprise environment, particularly those that impact ArcGIS Pro workflows, is necessary. Issues can arise from resource contention on AVD servers, especially if graphics or CPU resources are not properly allocated. User Profile Management: Managing user profiles (e.g., using virtual Profile Management tools) is important for ensuring users' settings and customized tools are persistent across sessions on their virtual desktops. 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. Connectivity and Drivers: Knowledge of installing and configuring the correct SQL Server ODBC drivers on the virtual desktops is essential for establishing stable database connections. 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. End-to-End Troubleshooting: Diagnosing and resolving issues that span the entire stack, from the virtual desktop application to the underlying SQL Server geodatabase, is essential. Training and Documentation: Providing training and creating documentation outlining best practices and limitations, particularly for users of SQL Server Express, is crucial for successful user adoption and preventing data loss or performance issues. -- *Thanks,* *Vardhan * *Email: [email protected] <[email protected]>* -- You received this message because you are subscribed to the Google Groups "SureIT" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/sureITlife/CAMLRyQgBKxxPxCsc2PihWEqftVsh1sA-tiqKDhyNhMm0vfi%2BOg%40mail.gmail.com.
