Oracle sql & pl/sql developer and database administrator
basic chemical industries group
Total years of experience :17 years, 8 Months
• Oracle SQL and PL/SQL Developer.
• Good hands on Report Builder 6i and Form Builder.
• Developing Reports and Forms.
• Maintaining Oracle Database and Application issues.
• Fixing bugs by applying patches.
• Cloning through Rapidwiz.
• Backup through Rman, import/export, cold and hot backup.
• Very well familiar with Symantec Backup and Recovery System in autoloader.
• Very well familiar with modules like PPM, GLM, SOM, POM, BOM, MRP, ADMIN,
ARM, APM, CMM, ICM, QCM etc.
• Worked as a team member in implementing RAC installing and configuring Cluster ware Software
• Defining Constraints and joining multiple tables to create Oracle Reports and Forms.
• Converting single instance Database to multiple instance in high performance availability.
• Cloning multi to single instance for test and development.
• AD Utilities - AD Patch, Auto Upgrade, AD Admin, AD Ctrl etc.
• Register a Form, Report etc.
• Maintenance of Concurrent Manager.
• System Administration.
• Performance tuning
• Good knowledge of SAN Storage.
• Installed and Configured Oracle RDBMS software on various platforms.
• Managing Table spaces, Data files, Control files, Redo Log files.
• Creating Databases Creation and space Estimation, Creating table spaces with storage parameters.
• Creating Database objects, Users, Roles, Profiles for the databases.
• Releasing locks as per the user request.
• Controlling and monitoring user access to the database for new and existing databases.
• Troubleshooting general issues like DB connectivity issues, Users login issues, And database corruptions.
• Upgraded Oracle 9i release 2 to oracle 10g release 2 on Linux platform
• Worked on user managed backup strategies
• Refreshing Oracle Databases Test and Development weekly.
• Check for invalid objects after applying patches.
• Configuring Recovery catalog for RMAN for backup.
• Maintaining regular logical EXPORT backups.
• Database Refresh activities, Database movement from one machine to another.
• Supporting to the development team.
• Performing Regular DBA activities.
• Master of Computer Application from Alagappa University (2007 to 2010).
• Bachelor of Commerce from Osmania University (2004 to 2007) INDIA.