Over 7+ years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 11g/10g/9i/8ion Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i,9i to 10g and 10g to 11g applied oracle patches.
Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD.
Experience in fulfilling DBA daily activities, schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
Worked on space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, ASH, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
Involved in performance tuning and database reorganizations. Performed SAN analysis and provided recommendations .Worked on Disaster Recovery and Implementation
Setup and installed Oracle 11g,10g RAC software with ASM & OCFS2 File systems.
Database security include authentication, access controls, secure configuration and auditing.
Maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM, CRS Cluster.
Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
Experience in designing, implementing and supporting highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN