"Alerted.org

** Webcam interview; *** Long term project ***LinkedIn Must*** Hybrid (3days per week onsite ) at NYC *** Due to Security Reason USC/GC/GC EAD *** W2 Only *

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.