Sr. Oracle GIS Database Administrator - Hybrid Brooklyn NY

Codetech•Brooklyn, NY

2d•Hybrid

About The Position

Support Oracle OMS and Esri-based GIS environments and databases. The role handles OMS- and GIS-related Linux and Windows server requests built to Con Edison standards; monitors and optimizes ArcGIS and ArcFM environments; maintains synchronization jobs, configuration stores, and enterprise geospatial data models; supports build deployments; and performs ongoing database maintenance and software updates. Responsibilities also include SDE compression and index rebuilding, managing database growth and scalability, data synchronization and replication, maintaining editing workflows and version architecture, and supporting the ArcGIS Enterprise 10.6.1 environment and planned migrations. The position requires extensive Oracle and GIS database administration, including installation, configuration, upgrades, backup and recovery, security, auditing, performance tuning, capacity planning, and environment refreshes. The administrator supports developers and application users, assists with application testing, resolves complex database and application issues, and manages database designs, objects, and operating-system resource monitoring across Unix/Linux and Windows environments.

Requirements

At least 3 years of experience creating stored procedures.
Advanced SQL development experience using Oracle SQL Developer.
Experience as an Oracle Database Administrator.
Experience with backend database design and optimization.
Experience administering and testing enterprise GIS and database projects is listed as a nice-to-have in the posting.
Experience with Oracle, ArcGIS, ArcGIS Server, and Portal is listed as a nice-to-have in the posting.

Nice To Haves

Administration and testing of enterprise GIS and database projects.
Experience with ArcGIS, ArcGIS Server, and Portal.
Experience with Oracle Utilities.
Experience managing GIS platforms and related technologies including ArcGIS, MapInfo, Oracle Spatial, ArcSDE, ArcFM, and ArcIMS.
Experience with SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2, SQL Server, Linux/Unix, and Windows.
Experience with Oracle Data Guard, RMAN, Tivoli, SQL Loader, and FlexLM.

Responsibilities

Support Oracle OMS and Esri-based GIS environments and databases.
Handle OMS- and GIS-related Linux and Windows server requests in accordance with Con Edison standards.
Monitor and optimize performance across ArcGIS and ArcFM environments.
Maintain synchronization jobs and report failures to application points of contact.
Support build deployments and maintain configuration stores.
Perform ongoing database maintenance and optimize databases for specific applications.
Update database software as required.
Perform SDE compression and rebuild indexes.
Maintain database growth, scalability, tasks, and schedules.
Manage data synchronization and replication.
Maintain current editing workflows and version architecture.
Maintain Con Edison enterprise geospatial data models for gas and electric datasets, including versioned and non-versioned datasets.
Maintain the Esri ArcGIS Enterprise 10.6.1 environment and support planned migrations.
Install, configure, upgrade, and manage GIS applications and databases on Windows and Unix servers.
Create and manage ArcGIS user accounts, instances, services, and permissions.
Design and manage SDE-Oracle database storage according to vendor-recommended practices, including configuring ArcSDE dbtune files.
Design and deploy disaster-recovery plans for SDE servers and Oracle databases using RMAN, export/import, Data Pump, and online and cold backups.
Implement Oracle Transparent Application Failover (TAF) with failover and load-balancing capabilities for SDE databases.
Script and schedule shell and batch scripts to monitor SDE on SQL Server and Oracle databases.
Perform server upgrades and install patches and service packs for SDE releases.
Set up multi-user editing databases and perform database compression and reorganizations after editing.
Refresh test SDE and Oracle database environments from production after versioning.
Manage FlexLM single-user and multi-user license files.
Update spatial metadata views with dimensional information about geometries; create spatial, parallel spatial, and partitioned spatial indexes.
Support version activities and reorganize databases to improve performance.
Install and configure Oracle Application Server, OC4J, and MapViewer for Oracle Spatial.
Troubleshoot, research, and resolve complex database and application problems; monitor and tune SQL Server and Oracle database performance on Unix and Windows.
Monitor operating-system file systems, I/O, CPU, swap, memory, and network utilization; manage disk storage and prevent out-of-space conditions.
Implement and maintain Oracle partitioning to distribute file-system I/O, support data archiving, and improve performance.
Perform server consolidation, including migration of more than 5 TB from Solaris 10 to Linux.
Write, test, and deploy PL/SQL programs to automate database maintenance.
Review physical database models and verify that database designs and structures comply with applicable standards and procedures.
Assist developers with functional, unit, and integration testing of applications.
Configure, deploy, and manage backup and recovery strategies using RMAN, shell scripts, and Tivoli.
Manage database security and sessions; establish auditing strategies; administer users, roles, privileges, and profiles in compliance with corporate controls and SOX requirements.
Perform database reorganizations and index rebuilds to reclaim space and improve performance.
Document, track, analyze, develop, and validate functional requirements and database designs.
Refresh Oracle databases and applications between environments and perform SDE database cloning and refreshes.
Gather and document business rules, change-management information, and integration issues.
Load spatial and non-spatial data using inserts, SQL Loader, Import/Export, Data Pump, and Transportable Tablespaces.
Configure Oracle Names Server and SQLNET for client connections.
Create and configure hot standby databases and Data Guard across multiple servers.
Develop and maintain database backup and recovery environments using cold and hot backups, RMAN, scripts, and third-party tools.
Respond to data-refresh requests, verify backup strategies, develop recovery procedures, and support recovery from data loss caused by user or system errors.
Provide application refreshes and current data environments to development staff on request.
Provide database support to application developers, application support teams, and production users.
Perform capacity planning and design requirements for databases on new and existing systems.
Design and manage database security and audit procedures, including object-level, session, logon, and system-wide audits.
Create and administer stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes, synonyms, and database links.
Manage small, medium-sized, and large-scale projects in a fast-paced environment.
Administer Microsoft SQL Server and monitor and tune OLTP/OLAP database servers and databases.