Skills
OraclePL/SQLSQLXMLAgile
Job Description
Job Title: Oracle PL/SQL Developer
Location: Smithfield, RI (Onsite)
Travel/Relocation/Remote: Relocation
Responsibilities
- Design and develop efficient database code SQL PLSQL for REST Service based application
- Should be able to redesign or rearchitect Stored PROCs
- Actively participate in all aspects of the software engineering process
- Should be able to perform verification and validation of developed SQL code
- Should be able to adapt to new technologies
Mandatory Skills
- Minimum 2-5 Years of strong Oracle database development experience Packages Triggers procedures functions etc
- Strong understanding of design and architecture of Oracle database preferably latest version
- Excellent knowledge of RDBMS and hands on experience in Oracle SQL and PL SQL
- Excellent knowledge and hands on experience of SQL performance tuning and database performance tuning
- Excellent knowledge and hands on experience of Oracle XML DB Store
- Process and Retrieve XML data within Oracle
- Practical knowledge of ORACLE DB Stored procedures normalization
- Experience in developing pattern-based solutions and effectiveness with the abstraction building libraries interceptors sdk etc
- Advanced knowledge on data structure concepts like Binary Tree Binary Search Tree Graphs
- Hands on experience on Tree operations traversals using Order Tree Pre Post Order Tree
Good to Have
- Experience with Agile Methodologies
- Well versed with other Oracle tools like SQL Developer or Toad
- Knowledge of REST Services and Microservices would be an added advantage.