• 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

Managed around 70+ database servers for business-critical applications. The Database environment includes Production, User Acceptance Test (UAT), Development and Testing. Responsibilities• Provide 12 x 7 operational L1/L2 offshore support for assigned apps and respective Oracle database systems • Mentoring developers in clarifying requirements and doubts regarding the tickets.• Resolve technical issues of the offshore team and escalate to onsite lead when needed• Guide the… Show more Managed around 70+ database servers for business-critical applications. The Database environment includes Production, User Acceptance Test (UAT), Development and Testing. Responsibilities• Provide 12 x 7 operational L1/L2 offshore support for assigned apps and respective Oracle database systems • Mentoring developers in clarifying requirements and doubts regarding the tickets.• Resolve technical issues of the offshore team and escalate to onsite lead when needed• Guide the team on technical approach and oversee technical progress on issue resolution of issues assigned to team.• Addressing the functional issues of the client across US • Coding / Performance tuning (writing scripts and DBA activities) • Application migrations / database migrations / applying Oracle security patching• Involved in resource planning, taking interviews and providing metrics to measure the performance• Working in close coordination with the team members & senior members to identify & implement process enhancement initiatives• Management of Schemas, Objects & Partitioning the tables & indexes • Extensive performance tuning experience, Database/Instance Tuning, Memory Tuning.• Experience in Developing PL/SQL Program Units like Procedures, Functions, Packages, Triggers etc.• 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 implementing Backup & Recovery methodologies using RMAN. Show less