Mandatory Skills:
· 3+ years of experience with creating stored procedures in SQL.
· Advanced SQL development in Oracle SQL Developer.
· A Seasoned Oracle Database Administrator.
· Backend Database.
· optimal oracle database design.
· Senior Database Administrator.
Oracle GIS / ArcGIS / SDE Database Administrator – Responsibilities & Experience
GIS & ArcGIS Enterprise Administration
· Supported Oracle OMS and eSRI-based GIS environments across Linux and Windows servers built to client standards.
· Administered ESRI ArcGIS Enterprise 10.6.1, including planning and execution of upgrades and migrations.
· Installed, configured, upgraded, and managed ArcSDE, ArcFM, ArcIMS, ArcGIS Server on Windows and UNIX platforms.
· Managed ArcGIS users, roles, services, instances, permissions, and configuration stores.
· Maintained enterprise geospatial data models for Gas and Electric utilities, supporting both versioned and non-versioned datasets.
· Supported multi-user editing workflows, version architecture, and reconciliation/posting processes.
· Maintained editing workflows, sync jobs, replication, and reported failures to application Points of Contact.
· Installed and managed FlexLM single-user and multi-user license servers.
Oracle Spatial & SDE Database Administration
· Designed and managed SDE-Oracle database storage per ESRI and Oracle best practices.
· Configured DBTUNE parameters for ArcSDE performance optimization.
· Performed SDE compress, index rebuilds, re-orgs, and spatial metadata updates.
· Created and maintained spatial indexes (standard, parallel, and partitioned).
· Supported data synchronization, replication, and environment refreshes (DEV/TEST/PROD).
· Loaded spatial (points, lines, polygons) and non-spatial data using SQL Loader, Data Pump, Import/Export, Transportable Tablespaces.
· Cloned and refreshed SDE databases across environments.
Performance Monitoring & Optimization
· Performed performance monitoring and tuning for ArcGIS, ArcFM, Oracle, SQL Server, and OMS environments.
· Tuned OLTP and OLAP workloads across Oracle and Microsoft SQL Server.
· Conducted database capacity planning, growth management, scalability planning, and job scheduling.
· Monitored OS-level metrics: CPU, memory, swap, I/O, filesystem, and network utilization on UNIX and Windows systems.
Backup, Recovery & High Availability
· Designed and implemented disaster recovery strategies using RMAN, Data Pump, export/import, hot/cold backups.
· Implemented Oracle Data Guard, Hot Standby databases, and Transparent Application Failover (TAF) with load balancing.
· Managed backup and recovery using RMAN, shell scripts, Tivoli, and third-party tools.
· Supported rapid environment refreshes and recovery from user/system data loss.
Automation & Scripting
· Developed and scheduled Shell, Batch, and PL/SQL scripts for:
o Database maintenance
o Monitoring SDE and Oracle environments
o Index rebuilds, compress jobs, and re-orgs
· Automated database refresh and maintenance processes.
Security, Compliance & Governance
· Managed database security, including users, roles, privileges, profiles, and session management.
· Implemented object-level, session, system, and logon auditing to meet SOX compliance.
· Designed and enforced database security and audit procedures aligned with corporate standards.
Application & Middleware Support
· Supported Oracle Applications, SAP, Oracle Fusion Middleware, and Oracle Application Server (OC4J, MapViewer).
· Assisted developers with functional, unit, and integration testing.
· Provided production and application support for GIS and database platforms.
Cross-Platform Database Experience
· Hands-on experience with:
o Oracle (Spatial, RAC, Data Guard)
o Microsoft SQL Server
o MySQL, DB2
o MapInfo
· Performed server consolidation (e.g., 5TB+ from Solaris 10 to Linux).
Nice to Have: -
· Administration and testing of Enterprise GIS and Database Projects.
· ArcGIS.
· ArcGIS Server, Portal.
· Oracle Utilities.
Never miss an opportunity! Create an alert based on the job you applied for.
