Requirment Sr

Hello consultant,

Please find the below JD and let me know your interest with your updated profile ASAP

NOTE: Only W2

Title : Sr. Oracle DBA-GIS Systems

Location : NYC / Hybrid (3 days)

Duration : Contract

JD:

Must Have Skills
•   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
•   ArcGIS
•   ArcGIS Server, Portal
•   Oracle Utilities Full Job Description:
•   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 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
•   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.
•   Implemented Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-Database.
•   Scripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle database
•   Keep up with latest SDE releases by performing server upgrades, installing patches and service packs when necessary.
•   Set up SDE multi-user editing database, perform database compress, and re-orgs after editing. Scripted an upload process that refreshes the test SDE, and Oracle database environments to the production environment after versioning.
•   Installed, updated, and managed FlexLM single user and multi-user license files.
•   Update spatial metadata view with Dimensional Information about Geometrics
•   Created Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial Indexes.
•   Provide support for version activities, and perform database reorgs to improve database performance.
•   Installation and configuration of Oracle Application server, OC4J and mapview for Oracle Spatial.
•   Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning database performance issues for SQL Server and Oracle databases on Unix and Windows operating systems.
•   Performed of SDE database/repository for SQL Server and Oracle.
•   Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage, reclaim dead space, optim Urgent requirment Sr. Oracle DBA-GIS Systems Contract NYC / Hybrid (3 days)