Oracle PLSQL Lead

Roles and Responsibilities:

• Should have hands on experience and be able to guide the team of developers
• Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Extensively worked on creating database objects including tables, indexes, views, sequences, packages.
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.
• Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.
• Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .
• Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements. For discussion purposes only | Page 1 of 2 Job Description – PLSQL Lead
• Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.
• Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.
• Handled a project where it involved building a process for BEx Team.

• Worked on Various OBIEE Reports as part of OBIEE Implementation.
• Executed queries and reports during Everest Transition Tests and its follow-up with data migration team regarding data discrepancies.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
• Strong understanding of architecture discipline, processes, concepts, and best practices. Must have hands on experience in coding and be able to guide the team of developers.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.
• Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.
• Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform.