Description
Professional Summary * 15 plus years of strong experience in Oracle (8i / 9i/10g/11g) with UNIX environment. Extensive knowledge in design and development of stored procedures / functions / Packages / database triggers. Tuning queries for higher performance (Using Hints, HWM concepts, explain Plan, Tkprof, row-chaining concepts etc). Expertise in different DDL / DML / TCL commands. * Involved in system study, analysis, design, coding, testing and debugging of software, implementation and training for users. * Extensive Experience in back end development including Database design, complex stored procedure, Database triggers, functions packages, views, materialized views( using Complete, fast and force refresh), Database links, Partitions, indexes, Synonyms, Dynamic SQL, Merge using ORACLE SQL and PL/SQL. * Used collections and bulk insert with records, PL/SQL Table, nested table, varrays and bulk collect and forall concepts. * Extensive use of In-line Views, scalar queries and analytical functions (like row_number, lead, lag, max, avg, sum etc). * Used Autonomous Transaction for force commit during skipping the oracle exceptions and continue the program. * Implementation of new 10g features like dense_rank, model, nested table (MULTISET UNION, intersect, SUBMULTISET), setting PLSQL_WARNINGS, utl_mail, recyclebin etc. * Data Warehouse with extensive experience in developing and testing applications using Oracle. * In-depth understanding of Oracle architecture, memory and process structures. * Experienced in writing unit tests for PL/SQL code. * Strong knowledge in advanced PL/SQL techniques like Cursor management, Exception Handling, Collections like REF Cursors, Sys_refcursor, PL/SQL Tables and extensively involved in performance tuning in oracle using Explain plan, Optimization Hints, TKPROF. * Good work experience in client server architecture * Analyzing the system performance periodically and work on the showstoppers to automate/streamline thereby reducing the downtime of the applications * Imparting knowledge to the team and setting up processes to create knowledge pools on the issues faced and methodology used to resolve - Known Error database * Implementing disaster recovery plans for applications to avoid downtime due to unforeseen issues * Incident Management, Problem Management and Release Management experience * Development experience in both Waterfall model and Agile methodology * Team lead/Tech lead experience with delivery responsibility for over 5 years
Accomplishments
Highlights:
Job Skills
Keywords
