Futran Tech Solutions Pvt. Ltd.
Oracle PL/SQL Developer with Java
Futran Tech Solutions Pvt. Ltd., Edison, New Jersey, us, 08818
Role: Oracle PL/SQL Developer with Java
Location: Edison, NJ
Fulltime role
JD is as below:
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 packagesUnderstanding 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 loaderStrong working experience with Advanced SQL and PLSQL knowledgeExperience 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 databaseCalling created db objects from JavaTransaction handlingException handlingJava script
Location: Edison, NJ
Fulltime role
JD is as below:
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 packagesUnderstanding 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 loaderStrong working experience with Advanced SQL and PLSQL knowledgeExperience 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 databaseCalling created db objects from JavaTransaction handlingException handlingJava script