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?
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.