Viknesh Kumar Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

• Having IT Experience in Oracle SQL & PLSQL as L1, L2, L3 Production support, Development.• Strong knowledge on Oracle SQL queries in dynamic using Single row functions, Window function, Group Function, Set operates, Joins, Subquery and pseudo columns.• Proficient in developing & Implementation of Cursors, Stored Procedure, Function, Package, Triggers and Exception handling mechanism.• Knowledge on Sql loader, Utl file package, DBMS_schedular, External table, Table partition.• Effectively made use of Table, View, Constraints, Sequence, Synonyms, Materialized view, GTT and indexes.• Having experience in Dynamic Sql, Collection, object types and Ref cursor.• Effectively made use of PL/SQL adv features such as (bulk collect, bulk bind(for all), limit, bulk exception ).• Performance Tuning [ SQL Tuning , PLSQL Block Tuning, Application Tuning ].• Involved in Unit Testing and System Testing.• Involved in Production support for fixing bugs & worked for Incident & Problem Management.