Oracle PL-SQL Developer with Java

$110,000 - $120,000

Full Time

    Skills

    • PL-SQL
    • Java
    • Java script
    • Exception handling
    • Performance tuning

    Job Description

    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
    Transaction handling
    Exception handling
    Java script