Designation: Senior Consultant
? L3 support for Production RAC DB
? Fixed MView log purging issue
? Troubleshooted performance issue in MView refresh from client server
? Health check report prepratation and PSU/patchset recommendation
? Performance tuning recommendation
? OEM setup and alert configuration for production env.
? Fix of AWR snapshot purging issue
? DB installation and build for SIEBELenv
? Required Patch set recommendation
? Identification of DB bottleneck and necessary tuning from Administration prospective.
? Successful Performance Tuning recommendation to application jobs causing high resource utilization or having poor performance
? DB backup policy
? Configuring RMAN hot backup jobs
? Automation of DB stats collection like DB Time, CPU, buffer cache ratio, redo generation etc
? Automation of AWR generation for successive snapid of online hours
? Automation of ADDM generation for successive snapid of online hours.
? Automation of OSWatcher stats collection for online hours
? Identification of attributes to benchmark performance and throughput of DB sever and application
? Daily basis DB support.
? Complete ownership and planning for Go Live from DB prospective
? Efficient DB rollback plan preparation based on customer requirement.
? Identified peak hours during testing window and suggested necessary changes/recommendation.
? Planning and successful implementation of Oracle DB migration and upgrade from 184.108.40.206 (RHEL5.8) to 220.127.116.11 (Solaris 11...
Read More »