Senior Oracle Database Administrator / GIS Support Engineer
Location: New York, Onsite
Experience: 10+ Years
Job Description:
We are seeking an experienced Senior Oracle DBA with strong GIS (ESRI) experience to support and manage a complex Oracle OMS and ESRI-based GIS environment. This role involves database administration, performance tuning, ArcGIS Enterprise support, and large-scale enterprise data management in a mission-critical environment.
Key Responsibilities
Support Oracle OMS and ESRI GIS environments and databases
Manage ArcGIS / ArcFM environments, including performance monitoring and optimization
Maintain sync jobs, deployments, configuration stores, and report failures to application teams
Perform database maintenance, upgrades, optimization, and capacity planning
Execute SDE compress, index rebuilds, and database reorgs
Manage data synchronization, replication, versioned and non-versioned datasets
Support and maintain ESRI ArcGIS Enterprise (v10.6.1) and future migrations
Design and manage SDE Oracle database storage following best practices
Implement and maintain disaster recovery, backup, and recovery strategies (RMAN, Data Pump)
Monitor OS performance (CPU, memory, I/O, swap, filesystem) on Linux and Windows servers
Provide database security management, auditing, and SOX compliance
Support application teams with testing, deployments, and production support
Required Technical Skills (Must Have)
3+ years of experience creating stored procedures in SQL
Advanced SQL development using Oracle SQL Developer
Strong experience as a Senior Oracle Database Administrator
Expertise in Oracle database design, performance tuning, and optimization
Hands-on experience with SDE, ArcGIS, ArcFM, ArcIMS
Experience managing Oracle, SQL Server, and enterprise databases
Strong knowledge of backup, recovery, Data Guard, and DR strategies
Additional Technical Experience
ESRI technologies: ArcGIS Server, Portal, ArcSDE
GIS platforms: ArcGIS, MapInfo, Oracle Spatial
Enterprise environments: SAP, Oracle Applications, Oracle Fusion Middleware
Scripting: PL/SQL, shell scripts, batch scripts
Database security, auditing, and compliance (SOX)
Nice to Have
Experience with Enterprise GIS and database projects
Exposure to Oracle Utilities
Experience supporting large-scale infrastructure migrations