Job Description :
Experience in ER diagrams, normalization techniques, data architecting/modelling – using any Oracle tools
Extensive knowledge in Oracle SQL - tables, indexes, partitions, DB links, and experience in Oracle Advanced Pl/SQL– Procedures, Packages, Triggers
Experience in Unix/Linux Shell scripting and job scheduling using tools like UC4 or Oracle packages or any other job schedulers
Experience in Oracle database 11g and above
Experience in tuning SQL queries & PL/SQL code for optimum performance
Experience in Oracle data purge process in large volume database online.
Knowledge of Oracle RMAN backup and other maintenance.
Experience SQL * Loader tool of Oracle