Having 5 years of experience as Oracle DBA (with RAC) in a team environment.
Provided 24x7 supports for critical databases (10g, 11g) in heterogeneous platforms
Good knowledge on Oracle Architecture and maintenance of single instance
Monitoring the table spaces usage, increasing the size of table spaces by adding data
files to the table spaces
Creating Users and Providing Quotas, Roles, Privileges and Profiles to users.
Resolving listener and network issues
Taking the schema level backups based on user requirements and schema refreshes
from prod to non-prod databases
Data transferring with export/import utilities and Data pump
Having good working knowledge on Cloning Database.
Good knowledge in the area of database backups and recovery strategies, scheduling
backup scripts and procedures with RMAN
Monitoring alert log, listener log and share with the Application team
Working knowledge on ASM databases (checking free space on disk groups,
communication of database instances with disk groups etc.)
Working knowledge on Data guard issues and also knowledge on configurations
Rebuilding the indexes and gathering the statistics for better performance
Experience on installing RAC(10g, 11g) and knowledge on RAC architecture
Converting a non RAC database to 10g RAC database using rconfig tool