Develop and provide support to all system interfaces
Basic SQL queries, such as create, insert, update, and delete a table.
Select statement with all type of joins between tables.(full join, left join, right join)
Experience of creating PL/SQL stored Procedures, Functions, Triggers, Views and Exception handling for retrieving.
manipulating, checking and migrating complex data sets in Oracle.
Help write and optimize in-application SQL statements
Analyze and ensure efficient transition of technical design documents and develop various SQL packages to provide support to application developers
Monitor and recommend changes if required to PL/ SQL packages and provide stored procedures and design and develop various relational database
Evaluate architecture for Oracle applications and prepare layouts for logical models and maintain database objects for various application components
Design and implement various structures for physical objects and recommend changes on applications through efficient statistical structures
Monitor and identify specific programming languages and recommend enhancement to programs and evaluate the software resolution
Design and analyze computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics
Collaborate with various departments and perform research on data processing functions