Proficient in Software Development and Implementation of
Oracle 10G/11G/12c with hands-on expertise in database
programming using Oracle PL/SQL.
Experienced in writing complex SQL queries and PL/SQL Stored
Procedures, Functions, Cursors, Triggers, and Packages. Adept at
performance tuning, adhering to Work Request and Change
Request protocols.
Skilled in automating SQL*LOADER for seamless data loading
from flat files.
Profound knowledge in advanced Oracle SQL programming,
encompassing Analytical Functions, Subqueries, Indexes, and Set
Operators.
Proficient in creating, modifying, and effectively utilizing
database objects such as Tables, Constraints, Sequences,
Indexes, and Group Functions. Excellent exposure to query tuning
using Materialized Views.