1. Research on Oracle Database Migration between different versions.
My job was to do research on all entities in database which will be affected by migration to higher versions of oracle.
Study impact on present National Stock Exchange (NSE) systems.
Suggest many alternative methods of implementing a PL/SQL block which was easy to implement in higher versions.
2. Research on Oracle Forms and Reports For Migration to Oracle 10g IAS web server.
This was important project since oracle 6i was 2 tier architecture system and oracle 10g is 3 tier architecture system.
My worked involved extensive study of deploying oracle webserver. Tuning the webserver.
A vast difference was there in implementing a web based system and a standalone system. Many work arounds were discovered in the process of migration.
3. Research on Oracle Dataguard.
Oracle Dataguard is tool for replicating database efficiently between NSE primary site and NSE backup sites.
Extensive research was done in studying network latencies and its impact on the system.
4. Database Backup and Recovery.
These needed mastering Oracle backup and recovery concepts to maintain the database systems.
5. Oracle Streams Implementation.
Oracle Streams is tool which reads redo log buffer of oracle and extract the relevant information to the target databases. It is an effective feature which replicated data in real time from one database to another.
Research work was needed in identifying the best possible method to implement oracle streams.
6. Shell scripts for writing monitoring scripts.
I have written some shell scripts which can run concurrently and perform monitoring by coordinating with each other.
