Having around 4 years of relevant experience as an Oracle PL/SQL. Performed development, production support, application support and enhancement of Business Applications. Experience in writing SQL queries, DDL, DML, DCL, Views, Materialized Views and Global Temporary Table. Involved in phases of the SDLC (Software Development Life Cycle) from development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Having knowledge in ITIL/ITSM. Excellent skill in Functions, Stored Procedures, Triggers, Index and Supplied Packages. Having knowledge in Analytical Functions. Import data with Oracle Tables using SQL Loader. Expertise in Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO) using Explain Plan, Hints provided by oracle. Handling the CR’s [Change request] and IR’s [incident request] and fixing the defects. Having knowledge on basic Unix commands. Ability & Willing to learn/work in new technologies. Working in 24/7 rotational shifts.
As a database developer was involved in the following:
• Understanding the client Project Change Requests requirements and prepared
• Detailed understanding document and Impact analysis document
• Managing Delivery Schedules, Handling the CR's [Change request] and IR's[incident report] and fixing the defects
• Creation of simple DB queries, running pre-defined scripts
Co-ordinates the PLSQL source code deployment with source control team for system and UAT testing teams
• Performing the root cause analysis and providing the solutions