Bhaskar Reddy

Experience

• 

  Logic Information Systems

  Dec 2009 - Oct 2011

  Oracle Database Adminstrator

  Client: Gander - USA• 24 X 7 support to Production database which includes off hours support also.• User management, Security management, Database Auditing.• Created the Development, Test and Production databases• Data Guard setup and implementation.• Worked on RMAN backups.• Installation, Upgrade, Migrate of Oracle 10g, 9i and 11g Configuration and patches.. Worked on Oracle Retail Application installation and Support.. RMS,RISA,RIB Application Installations.. Good exposure on Oracle SOA Suite• Extensively worked Oracle Data Pump.• Also responsible for maintaining Application schema, Schema changes.• Database security - this activity includes creating/revoking users. Creating roles, grant/revoke roles from users/roles.• Used RMAN for Hot and cold Backup and for online - offline backups.• Implement 10G OEM Grid control on production, QA, Development databases.• Installation of Oracle agent and configuring the targets in OEM.• Works closely with application developers, vendors. Show less

• 

  LTI - Larsen & Toubro Infotech

  Oct 2011 - Sept 2014

  Systems Engineer

  Client: HD Supply and Veolia Water solutions24x7 Oracle Database Administrator for Production, Development and Standby databases and provided on call support• Providing complete technical support and solutions to ensure that the Oracle DB server systems perform• Maintaining and providing complete support to company's business Critical production as well test/dev/training 210 databases (24*7*365 running), including largest database size is 2.7 TB. Managing standby databases on disaster recovery site and keep synchronize with DC databases. • Migrating code from DEV/QA to production environment, reviewing the code• Creation and maintenance of Oracle physical data guard/standbys.• Managing backup of cluster ware files by using ocrconfig utility.• Worked on RAC databases.• Monitoring, Scheduling, planning backup & recovery strategy using hot, cold and RMAN.• Patched and upgraded (10.2.0.1 database to 10.2.0.4).• Applied CPU, PSU and one off patches in RAC Environment (Rolling Method).• Performed the database upgradation from version to version (10g to 11g).• Worked on 11g database active cloning.• Administered the cluster databases using crsctl and srvctl utilities.• Administered asm instance by using the asmcmd command line• Performed database cloning by using hot and rman backups.• Performed the active database cloning.• Performed BRTOOLS activities in SAP databases.• Implemented rman backup strategy for the rac database.• Monitoring free space in file system, asm disks and table spaces.• Configured physical standby by database (DATAGUARD) and tested for switchover and failover. • Installed the new QA and DEV databases.• Applied Application level patches using ADPATCH utility. Show less

• 

  Hewlett Packard Enterprise

  Sept 2014 - Oct 2017

  Sr Oracle and ExadataDBA - ITO SERV CONS DELIVERY III-B

  • Experience in administering Oracle databases with GRID Control.• Handling the database alerts through Grid control.• Blackout the Targets using Grid control.• Created useful reports in Grid control for database Monitoring.• Performed backup using conventional, Data Pump, HOT backup, cold backup and RMAN (Recovery manager).• Performed the database up gradation from version to version (11.2.0.3 to 11.2.0.4).• Experienced in database cloning by using COLD, HOT, Active clone and RMAN backups.• Monitoring various database activities like number of users, memory usage, Alert log file, Trace files and Archive log files.• Experience in applying the Interim and CPU patches on databases.• Develop, document, publish and implement oracle related SOPs.• Implemented and experienced on Dataguard on the production environment.• Experienced on syncing the standby database with production database.• Planning the effective Backup and Recovery databases and monitoring the existing backup and recovery procedures periodically.• Experience in administering Oracle 10g RAC databases.• Extensive understanding of both standalone and RAC database architecture.• Upgraded 10g RAC database from https://www.linkedin.com/redir/invalid-link-page?url=10%2e2%2e0%2e1 to https://www.linkedin.com/redir/invalid-link-page?url=10%2e2%2e0%2e4• Tested Transparent Application Failover (TAF).• Administered the cluster databases using crsctl and srvctl utilities.• Configured physical standby by database (DATAGUARD) and tested for switchover and failover. • Experienced in BRTOOLS for SAP databases.• Experienced on Ebusiness suite tiers. Show less

• 

  Oracle

  Oct 2017 - now

  Principal Advanced Support Engineer