ORACLE DBA

Role description Administration of oracle 19c Developement, UAT, SIT and Production database. OEM monitoring and administrating OEM s. Database refresh and RMAN cloning. Database upgradation from 12c to 19c. Database migration from onpremise to GCVE. Handling Oracle Jira tickets (DBA, REQUEST, PERF,CHANGE). Administration of Oracle RAC and Standalone infrastructure. Applying PSU and OJVM patch on RAC and Standalone DB using rolling upgrade method. Resolving Patching/Database related issues and coordinating with Oracle global support team to fix the issue on time. New database creation , RAC data guard configuration and administration. Restricting database access request using roles and profiles. configuration and monitoring of RMAN/EXPDP backup and validation. conducting Audit on several aspects of Database both on resource and performance. Analyzing AHF reports and diagnostic reports for troubleshooting. Role description Administration of oracle 19c Developement, UAT, SIT and Production database. OEM monitoring and administrating OEM s. Database refresh and RMAN cloning. Database upgradation from 12c to 19c. Database migration from onpremise to GCVE. Handling Oracle Jira tickets (DBA, REQUEST, PERF,CHANGE). Administration of Oracle RAC and Standalone infrastructure. Applying PSU and OJVM patch on RAC and Standalone DB using rolling upgrade method. Resolving Patching/Database related issues and coordinating with Oracle global support team to fix the issue on time. New database creation , RAC data guard configuration and administration. Restricting database access request using roles and profiles. configuration and monitoring of RMAN/EXPDP backup and validation. conducting Audit on several aspects of Database both on resource and performance. Analyzing AHF reports and diagnostic reports for troubleshooting.