Oracle DBA

ROLE: Oracle DBA

LOCATION: Hybrid in NYC

Responsibilities

• Support Oracle OMS and eSRI based GIS Environment & Databases
• OMS and GIS related Linux /Windows server requests built to ConEd standards
• Performance monitoring and optimization of all ArcGIS / ArcFM Environments
• Maintaining sync jobs and reporting failures to the Application PoCs
• Support Build deployments
• Maintain configuration stores
• Provide ongoing database maintenance, including optimizing databases for specific applications.
• Update database software as required.
• SDE compress and rebuild index 
• Maintaining growth, scalability, tasks and schedules
• Data synchronization and replication
• Maintenance of  current editing workflows and version architecture
• Maintain enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets)
• Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrations
• Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.

 Technical Skills

• 3+ years of experience with creating stored procedures in SQL
• advanced SQL development in Oracle SQL Developer
• a seasoned Oracle Database Administrator
• Backend Database
• optimal oracle database design
• Senior Database Administrator

 administration and testing of Enterprise GIS and Database Projects

ArcGIS

ArcGIS Server, Portal

Oracle Utilities