Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS_SQL.
Experience in tuning SQL statements using EXPLAIN PLAN.
Expertise in loading data from flat files to the Database Tables using SQL * LOADER and EXTERNAL TABLE.
Knowledge of UNIX SHELL Scripting and scheduling CRON jobs.
Experience in using Oracle concepts Like Table Partitioning, Optimizer hints and Materialized Views (Snapshots).
Expertise in using latest features to Optimize Performance (Bulk Collects, Collections, Ref Cursors, Materialized views and Global Temporary Tables.
Extensive experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
Expertise in Creating User Schemas and giving them set off permissions.
Proficient in writing and tuning Multi-Complex SQL statements, complex joins co-related sub-queries and SQL statements with Analytical functions (Rank, Lead, Lag etc).
Experience in Implement high quality and maintainable code.
Translate business requirements into development strategies.
Work with business users to clarify the requirement.
Provide accurate and timely estimates (work breakdown schedules).
Document and executes unit and integration tests.
Supports the needs and requirements of other applications team.
Working knowledge on using new partitioning techniqueslike Interval, reference and extended composite (List-List, List-Range) partitioning.
Strong analytical problem solving and communication skills.
Strong in developing efficient logical code for a given specific task.