I am GIS B.Tech Graduate. In the aiming of becoming GIS Developer .I temporairly changed my profession from GIS Analyst to Software Engineer. But what I got in this software company is oracle (not .net or Python). I want know with gaining oracle experience how Can I comeback To GIS Domain any suggestions?
closed as primarily opinion-based by PolyGeo♦ Jun 26 '15 at 1:37
Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.
Oracle DBMS is is capable of storing spatial data either through custom formats (like Esri) or native (Oracle Spatial). This means it is worth learning for GIS Analyst because you will be able to interact with the DBMS either by using SQL/PLSQL/spatial SQL functions (for analysis and data retrieval, and you can do a lot with those spatial functions without using any desktop GIS interface).
As a GIS Database Administrator/GIS DBA, you will be able to administer the database (both database per se but also geospatial bits which involves spatial indices, multiuser editing, and geodata replication workflows). Oracle is used widely within multiple organizations who use Esri software together with ArcSDE to enable storing ArcGIS native enterprise geodatabase within Oracle database.
Natually, by learning Oracle you master SQL which can be used for any other SQL RDBMS. I find it especially useful to master spatial functions to be able to answer geographical questions with SQL, worth learning, too. A lot of those spatial functions are similar to PostGIS functions (and PostGIS is used very widely in GIS industry), so it will be a less steep learning curve to master PostGIS after getting savvy with Oracle.
I would say that there are two ways. The most obvious is that Oracle has an Oracle Spatial module with lot's of GIS functionnalities. The second is that Oracle, as a RDBMS, is also used as a third party software for the table storage and analysis.
The experience you get by managing an RDBMS like Oracle should thus be easy to valorize for a GIS job.
To follow up the top answer, a lot of online company's use Oracle real time scheduling systems (formerly Sidewinder) to organise and route their deliveries, (which uses the oracle spatial routing functionality). They are usually looking for GIS analysts to keep the underlying maps up to date.