IT professional with 11+ years of experience in Oracle DBA, PL/SQL, DB Architect and 3+ years of experience in DB2 in Mainframe environment.
Worked on Banking domain for clients CITI-NAIT, Bank of America and Santander Banco.
Worked on fully secured production and standby database by implementing Data Guard.
Worked extensively on database upgrade and patch update.
Extensively worked on SQL*Loader for large data load using direct path and parallel loading.
Worked on Database Performance tuning and Oracle Enterprise Manager.
Experience in designing, implementing backup and recovery strategies using RMAN and conventional methods
Experience in writing SQL and PLSQL scripts like Stored Procedures, Functions, Packages, and Handling Exceptions, creating database triggers in Oracle 10/11G.
Efficient in SQL query optimization using explain plan, TKPROF, reports, gathering statistics, pinning the objects, running scripts.