Profile
Having 3 years of experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies under Unix Environments.
Ability to write DDL, DML and complex queries in Oracle SQL.
Strong skills include Oracle 10g/11g, UNIX Shell Scripting.
Extensively created and worked with PL/SQL Collections, Ref Cursor, Bulk collect and Indexes.
Experience in Stored Procedures, Packages.
Experience and knowledge on SQL Query Tuning and SQL loader, Trigger.
Knowledge on Performance tuning (Explain Plan, AWR, TKPROF utility).
Experience in UNIX Shell Scripting.
Knowledge on Oracle Architecture.
Experience in loading/unloading data to/from the Database.
Ability to work in shifts, preparing root cause analysis and ensuring the action points.
Scheduled Jobs using crontab.
Experience in working 24/7 Production Support.
Experienced in requirement analysis, coding, debugging and unit testing various modules in a software development life cycle (SDLC).
Remarkable ability to develop expertise in new technologies.
Sound programming skills ,analytical skills and good problem solving skills.