Description

You will manage and maintain Esri and Schneider-based GIS environments and databases.

Responsibilities

• Maintain Esri ArcGIS Enterprise (10.6.1) environments and manage planned migrations.
• Monitor and optimize performance for all ArcGIS and ArcFM environments.
• Manage data synchronization, replication, and sync job failures.
• Perform SDE compress, rebuild indexes, and database re-orgs after editing.
• Support build deployments, maintain configuration stores, and manage Linux/Windows server requests.
• Maintain enterprise geospatial data models for Gas and Electric using versioned and non-versioned datasets.

Required Skills

• 5+ years of experience in database administration and backend database management.
• Expertise in optimal Oracle database design and advanced SQL development using Oracle SQL Developer.
• 3+ years of experience creating stored procedures in SQL.
• Proficiency in installing, configuring, and upgrading GIS applications (ArcSDE, ArcFM, ArcIMS) on Windows and Unix.
• Experience managing ArcGIS user accounts, instances, services, and permissions.
• Hands-on experience with Oracle Spatial, MySQL, DB2, and SQL Server.
• Ability to design and manage SDE-Oracle database storage following vendor best practices.
• Skill in scripting and scheduling shell and batch scripts for SDE monitoring.
• Familiarity with Oracle Transparent Application Failover (TAF) for SDE-Database load balancing.
• Experience with FlexLM single-user and multi-user license file installation and updates.
• Ability to create spatial, parallel spatial, and partitioned spatial indexes.
• Proficiency in database security, session management, and auditing strategies.

Preferred Skills

• Experience with ArcGIS Server and Portal.
• Familiarity with Oracle Utilities.

Key Skills

Education

Any Graduate