Suhas K P Email & Phone Number

Creation and Maintenance of Database with DBCA and Manual methods.Refreshing Tables and Schemas using data pump utility.User Management: Creating Users, Roles, Profiles.Maintenance of Tablespaces, Datafiles, Control files, Redolog files.Converting the hash table to partitioned tables using Online Redefinition utility.Partition maintenance activities (Involves adding or dropping partitions automatically through scheduler jobs and monitoring the partitions).De fragmenting the tables and rebuilding indexes.Gathering statistics of table, indexes whenever needed.Handling Major Application Deployments release and Bridge calls.OEM: Handling OEM 12c Configurations and Agents, adding databases, scheduling reports, resolving Metric collection errors and Disabled by upload manager errors on grid.Creating Customized report in OEM as per the Client requests.Troubleshooting and Fixing the OEM issues, Configured warning alerts, critical alert notifications via email in OEM 12c,11g grid controlExposure in shell scripts and Stored procedures to automate the processes.Scheduling various jobs to be fired through corn jobs.Addressing issues related to replication using Streams.Applied PSU, bug patching activities, agent bug patch on exadata. Applied Patches to production database on quarterly basisConfiguring Oracle ODBC connectivity for the clients.Backup and recovery strategy for RAC, standalone databases using RMAN.Database level Performance Tuning like generating reports to analyze the Database performance. (Explain Plan, Execution Plan, AWR and ADDM Reports).Installing and Configuring OSWatcher for performance analysis for standalone and RAC databases.Performed OCR and voting disk files backup and Administrated RAC database using SRVCTLAdding and deleting the node from existing cluster instance.Implemented data guard set up in TEST Environment.Providing support for Oracle RAC, Standalone databases and Exadata database environments.