Experience in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance.
Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes, and exception handling. Create database objects like tables, views, sequences.
Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file format.
Extensive experience in trouble shooting, Query Optimization and performance tuning use of explain plans.
Experience in using the features Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic SQL and Oracle RAC.
Experience to write scheduler jobs and Troubleshoot issue if any failures.
Analyze application requirements and provide recommended design. Support code migration from development to staging environment.
Write complex SQL queries and PL/SQL procedures to extract data from various source tables.
Ability to work independently and as part of a team, deliver under pressure and tight deadlines.
