Description

You will own the administration and support of Oracle OMS and eSRI based GIS environments and their underlying databases.

Responsibilities

• Support and maintain Oracle OMS and GIS related Linux/Windows server requests adhering to ConEd standards.
• Monitor and optimize performance across all ArcGIS/ArcFM Environments.
• Maintain data synchronization jobs and report failures to Application Points of Contact.
• Perform ongoing database maintenance, including database compression, index rebuilding, and schema updates.
• Manage growth, scalability tasks, and data replication processes for geospatial data models.

Required Skills

• 5+ years of experience as a Database Administrator, specializing in Oracle.
• Expertise in advanced SQL development and creating stored procedures using Oracle SQL Developer.
• Experience managing Geographic Information Systems (ArcGIS, Oracle Spatial).
• Proficiency with database backup and recovery methods (RMAN, Data Pump, Export/Import).
• Familiarity with Linux and Windows server environments.
• Experience with spatial indexing (e.g., Parallel, Partitioned Spatial Indexes).
• Ability to script automation tasks using Shell Scripts and batch scripts.
• Knowledge of core database technologies including MySQL, DB2, and SQL Server.
• Experience with Oracle Enterprise GIS (ArcGIS Enterprise 10.6.1) and related migrations.

Key Skills

Education

Any Graduate