* Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
* Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Responsible for developing, maintaining and supporting PL-SQL applications and supporting Java and .NET developers.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Wrote Shell Scripts for Data loading and DDL Scripts.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Optimized existing queries for better performance and less impact on database.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
Involved in data replication and high availability design scenarios with Oracle Streams.
Environment: Oracle Database 11g, Windows XP, SQL Developer, TOAD, XML, SQL, Putty, PLSQL, GitHub, Crucible, VB.net, JIRA, Postman.
Companies Worked For:
Job Titles Held: