3+ years of experience with creating stored procedures in SQL
advanced SQL development in Oracle SQL Developer
Backend Database
optimal oracle database design
Senior Database Administrator
MUST HAVE:
ArcGIS
ArcGIS Server, Portal
Oracle Utilities
JOB DESCRIPTION
Support eSRI and Schneider based GIS Environment & Databases
o 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.
Designed and deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups.
Employment type
Contract
Referrals increase your chances of interviewing at GTECH LLC by 2x