Prinicipal Consultant
• Roles played includes Programmer, Senior Systems Engineer , Database Administrator and Tech lead• Involved in Development, Production support and implementation of projects • Good strengths in Analysis, Coding, Testing and Documentation.• Management of Schemas, Objects & Partitioning the tables & indexes • Experience in Developing PL/SQL Program Units like Procedures, Functions, Packages, Triggers etc.• Experience in using Data Pump Technologies and External… Show more • Roles played includes Programmer, Senior Systems Engineer , Database Administrator and Tech lead• Involved in Development, Production support and implementation of projects • Good strengths in Analysis, Coding, Testing and Documentation.• Management of Schemas, Objects & Partitioning the tables & indexes • Experience in Developing PL/SQL Program Units like Procedures, Functions, Packages, Triggers etc.• Experience in using Data Pump Technologies and External Tables.• Experience in Data Extraction and Loading data to Oracle from different sources using Sql *Loader, Export/Import, Data Pump.• Managed physical and logical structures, Implement and maintain security, Backup and recovery, Performance Tuning, Planning data flows for a new or revised database, Troubleshooting Database.• Provided solutions to the escalations from developers, Remote and onsite support to customers.• Experience in Oracle Database Creation, Patch application, Upgradation.• Possesses excellent communication and interpersonal skills and ability to work in a team as well as individually.• Looking ahead for great career in a fair working environment with opportunities to grow.• Monitoring and optimizing the performance of the database and performing tuning using EXPLAIN_PLAN,AWR and ADDM • Exposure of working on Toad/OEM/Putty, SSH,SQL Loader, FTP Client, ERWIN• Involved in Data guard setup , Drill activities and performance tuning• Knowledge of Oracle ASM and RAC environment• Knowledge of Oracle Streams• Worked on setting up Oracle dataguard, re-building of standby database• Identifying Synch issues in Standby site and re-synching with primary database• Worked on Active RMAN Duplicate method and Active Standby setup as part of mew feature in Oracle 11g R2 Show less