Description

You will manage Oracle OMS and eSRI-based GIS environments, ensuring database stability and performance across Linux and Windows servers.

This role is on-site.

Responsibilities

• Maintain ArcGIS and ArcFM environments through performance monitoring, optimization, and SDE compress/rebuild operations.
• Manage geospatial data models for Gas and Electric sectors, handling both versioned and non-versioned datasets.
• Execute database maintenance including software updates, indexing, partitioning, and data synchronization/replication.
• Design and deploy disaster recovery plans using RMAN, Data Pump, and export/import methods.
• Automate maintenance and monitoring tasks using PL/SQL, shell scripts, and batch scripts.

Required Skills

• 5+ years of experience in database administration and management.
• Hands-on experience with Oracle Spatial, ArcGIS (ArcSDE, ArcFM, ArcIMS), and ArcGIS Enterprise (10.6.1).
• Proficiency in managing Oracle, SQL Server, MySQL, DB2, and SAP.
• Strong knowledge of SQL and PL/SQL programming.
• Experience with Oracle Fusion Middleware and Oracle Application Server.
• Proven ability to manage data modeling, physical design, and data structures.
• Expertise with backup and recovery strategies using RMAN and Tivoli.
• Experience managing GIS user accounts, instances, services, and permissions.
• Competency in monitoring OS resources (I/O, CPU, memory, network) on Unix and Windows.

Preferred Skills

• Experience administering database security, including user roles, privileges, profiles, and auditing strategies.

Key Skills

Education

Any Graduate