- Java script
- Exception handling
- Performance tuning
Strong experience in Oracle PL-SQL with 6 – 8 years of relevant experience.
Experience in Create, test and implement PLSQL triggers, stored procedures, functions, and packages
Understanding the different index types available in oracle database and analyze and provide recommendation on index resources usages.
Develop stored procedures PL SQL packages functions and other commonly used Oracle objects Advanced understanding of Oracle SQL PL SQL skills and Performance tuning.
Performance tuning tools: Oracle Database Console, PL/SQL Profiler, PL/SQL Collections, Partitioning, Advisors (Memory advisor - SGA/PGA, Undo Management, SQL Tuning Advisor, SQL Segment Advisor).
Deep knowledge of Oracle partitioning Indexing and Compression.
Strong knowledge in Data Import export data loading and data extraction.
Experienced in tuning of PL SQL Packages time CPU consuming SQL Queries.
Proficiency in Oracle SQL loader
Strong working experience with Advanced SQL and PLSQL knowledge
Experience working in a Unix/Linux environment and developing shell scripts.
Complete understanding of full software development lifecycle SDLC.
Should be able to work independently and deliver according to the expectation.
Should have good logical and analytical thinking.
For Java - making connection with database
Calling created db objects from Java