– Having 4+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System.
– Expertise in using Exception handling extensively for the ease of debugging and displaying the error messages in the application.
– Expertise in Oracle 10g and 11g, PL/ SQL programming
– Having good knowledge on UNIX.
– Having very good knowledge on Performance tuning and Bug fixing.
– Involved in analyzing the data mapping documents and data flow diagrams.
– Created database objects needed such as, tables, views, indexes, procedure, functions and packages.
– Worked on setting up the change tables, change views and packages for oracle native.
– Created/modified oracle procedures, packages and functions to move the change data across multiple environments using DB links.
– Responsible for improving the performance of oracle CDC load process.
– Worked on analyzing, fixing and testing the CDC conflicts issues in production. Worked on creating test cases and data validation scripts.
– Developed automated scripts to create audit triggers for the main tables.
– Created sql loader scripts to load the data from files to temporary tables.
– Involved in working on creating reports and sending the data using oracle database, Excel, Text and CSV files.
– Responsible for creating data migration scripts.
myfreelance.ma
