Senior Oracle Database Administrator at Auralis India Pvt Ltd

• Job Location New York, United States
• Seniority Executive
• Type Contract

Description

Job Title: Sr.

Oracle GIS Database Administrator Location: New York Duration: 12 Months contract Job Description Must Have 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 Nice To Have administration and testing of Enterprise GIS and Database Projects ArcGIS ArcGIS Server, Portal Oracle Utilities JOB DESCRIPTION Support Oracle OMS and eSRI based GIS Environment & Databases o OMS and GIS related Linux /Windows server requests built to ConEd standards o Performance monitoring and optimization of all ArcGIS / ArcFM Environments o Maintaining sync jobs and reporting failures to the Application PoCs o Support Build deployments o Maintain configuration stores o Provide ongoing database maintenance, including optimizing databases for specific applications.

o Update database software as required.

o SDE compress and rebuild index o Maintaining growth, scalability, tasks and schedules o Data synchronization and replication o Maintenance of current editing workflows and version architecture o Maintain ConEdison enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets) o 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.

Installation, configuration, upgrade and management of GIS (ESRI’s AcrSDE, ArcFM, ArcIMS applications on Windows and Unix servers.

Created and managed ArcGIS user accounts, instances, services and permissions.

Designed and Managed SDE-Oracle database storage according to vendors recommended best practices.

Configured dbtune file for Arcsde.