• Green Card

• Corp-Corp

• W2-Contract

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 8th Nov 2021

Exp in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Experience in Oracle supplied packages and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Ability to write complex sql queries for reporting purpose.

Support the users of application by using multiple SQL and PL SQL techniques.

Experience is troubleshooting existing application issues quickly.

Create complex functions, scripts, stored procedures and triggers to support application development.

Strong technical, analytical and problem solving skills

Experience with C++ Programming or Java or informatica power center is a plus.

Experience with auto finance industry especially with accounting application is good to have.