5+ Years of Total Experience as Oracle Developer Involving Analysis, Design, Implementation, And Support on Database Development. Expertise In Oracle 10g/11g/12c Database Development In Availability Production Environment. Provide effective investigation and root cause analysis for Incidents. Assisted with the maintenance of an existing Technology Services Organization client-server application. Provided technical support to end-users and other developers. Supported members of the testing team through user acceptance testing and pre-production and load testing. Successfully developed Oracle SQL, PL/SQL and Oracle forms and reports based projects. Expertise in Cursor, Procedure, Function, Package, Exception, Trigger and Collection Types and Bulk Collect etc. Expertise In Working With End-Users For Support, Troubleshooting to give Efficient Resolutions For Functional And Technical Issues. Basic Knowledge of Unix/Linux shell scripting. Working experience with Agile tools like JIRA, BitBucket, GitLab. Well versed with Basic Database concepts of SQL, PL/SQL, Query Tuning, Query optimization, Views, Explain Plan, Materialized Views etc. Expertise in Installation Of Oracle 10g/11g/12c Forms Reports Application And Configuration On Various Operating Systems on-premises as well as on cloud servers. Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms As Per Business Requirements. Creation and Enhancement of existing Procedures, Packages, functions as per client requirements. Implemented Oracle Auditing And Created Triggers For Tracking Database DML/DDL Changes And Improve Database Security. Importing External files To Oracle Database Table Using SQL*Loader. Deploying the application on Production Server & configuration for end-user. Creation of ACL for automail. Applying Patches for bugs and issues with the 12c forms and reports application. Gathering Requirements from the client and providing the best solution. Importing and Export Data Using Data Pump Utility EXPDP, IMPDP and Scheduling on Linux/Windows. Client-Server interaction for various requirements using Webuitil. Scheduling and monitoring of application server and backup. Scheduling shell scripts or dbms_jobs using crontab or Dbms_Scheduler (Monitoring Script, Listener Check, Backup Script) Etc.
©