IdentityOver 7.4 years of IT experience i.e. 5.4 years rich experience as Oracle DBA and 2 years of work experience as Sql DBA with well-known service based organisation. Proficient in requirement analysis, Database maintenance and Cloning.
Planning and creating database and coordinating with infrastructure team for DNS setup.
Performing Database Patching activity, DB upgrade and conducting DR test.
Performing Database refresh/cloning using hot/cold backup and Database migration activity.
Performing Re-Org activity using various methods in both Offline and Online mode.
Performing various Schema/Table refresh using Data Pump as per business requirements.
Handling various Block Corruption issues and fix those issues.
Handling long running sessions, generating explain plan and analyze.Taking Gathering stats for database/schemas/tables.
Handling various Production Deployment activities over week end.
Handling Tablespace/Storage management and User/Session management DB activities.
Raising request with Server team and coordinating with them, if any database issues due
to server.
Taking various types of RMAN backups as per business requirements and
performing various recovery strategies using those backups.
Performing Database Duplication using RMAN backup.
Having good knowledge on RAC and Configuring physical and standby databases using Data Guard environment and handling switch over/fail over issues.
Having good knowledge 12C
