URGENT REQUIREMENT- H1B can also apply Role: Oracle DBA (Hybrid) Experience: 7-8 years + Location: 4 Irving Place, New York New York 10003 Pay rate: Decent Hourly Rate Must-Have: 3+ Years of Experience with:
- 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
- Performance monitoring and optimization of all ArcGIS / ArcFM Environments (REQUIRED SKILL)
ABOUT THE ROLE:
- Support Oracle OMS and eSRI-based GIS Environments & 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 compresses and rebuilds the index
- Maintaining growth, scalability, tasks and schedules
- Data synchronization and replication
- Maintenance of current editing workflows and version architecture
- Maintain ConEdison enterprise geospatial data models for Gas and Electric ( Versioned and non-versioned
- datasets)
- Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrations