Activities performed as Oracle 9i DBA on Unix environment

====================================================

• Installing and Configuration of oracle software on unix environment.
• Creating databases and creating tablespaces providing storage for the tables.
• Monitoring the services availability.
• Checking for space availability and adding space whenever required.
• Managed users security by giving proper grants and privilages.
• Refreshing tables on demand from production database.
• Cloning databases.
• Re-created controlfiles to increase the maxdatafiles count
• Monitored database sessions.
• Helped users to clear locks.
• Appling RDBMS patches.
• Creating the required tablespaces, users and roles for the application.
• Involved in backup and recovery of database information and maintaining Hot Backups and Cold Backups.
• Troubleshooting database internal errors with oracle support.
• Used Oracle Enterprise Manger for monitoring events such as tablespace full and database up and down.