Working as IT Principal Consultant in Cloud Services.

Managing Large Warehouse Databases.Supporting Change Management,Working with Oracle SR Support

Activities carried out are:-Configured High Availability with Dataguard and RAC, 6 node primary and 6 node DR. Database upgradations from 10.1.x.x to 10.2.0.4/11.0.1.7Switchover / Failover test performed every quarter depends on the criticality and the down time we get on the DB.Creating and designing the Databases as per the requirements and specifics tailored to the projects needs.Database Upgradation and database clone using RMAN / DatapumpRecommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.Implement effective database security practices and procedures.Applying all advocated patches and CPU patches.Maintain OFS database on Windows.In worst case , rebuilding DR using RMAN or using SRDF depends on size of DataBase.Co-ordinating with application team to solve technical issues.Perform maintenance activities in strict downtime. Oracle database files are managed thru ASM.Performing detailed database performance checks and analysis using AWR, GRID and other scripts and optimizing performance if necessary.Formulating Backup strategies using RMAN thru GRID.Taking Logical Backup using Oracle Utility expdp/impdp.Performing SQL query performance tuning and advising the development team accordingly.Maintaining appropriate change control procedures using Remedy.

Installation and Upgradation of oracle softwareApplying PatchesDatabase Upgradation and database clone. Coordinating with customers and users to solve technical issues.Perform maintenance activities in strict downtime. Database Space ManagementPerforming detailed database performance checks and analysis using STATSPACK and other scripts and optimizing performance if necessary.Formulating Backup and Recovery strategies using RMAN.Taking Logical Backup using Oracle Utility EXP/IMP.Troubleshooting backup and recovery and other database issues.Performing SQL query performance tuning and advising the development team accordingly.Maintaining appropriate change control procedures using Remedy.

Responsibilities as an Oracle Database Administrator:Installation and configuration of Oracle DatabaseWorked with FINACLE Core implementation.Creating Database and Database ObjectsStorage and space management includes Tablespace growth and Extent growthMonitoring Database FragmentationCreating and maintaining Rollback Segments.OFA ImplementationCreation of users and granting necessary privileges to maintain securityStrategic planning for Backup and Recovery including online and offline backupsTaking Logical Backup using Oracle Utility EXP/IMPPerforming Hot Backup using Automated and tested shell scriptsRecovering the Database without or Minimal Loss of DataSchedule the Database Re-Organization in order to keep the Database running smoothlyTuning of Database which includes SGA, IO, ContentionMonitoring V$Views, Alert logs and Trace Files.Using UTLBSTAT/ UTLESTAT for identifying performance Issues and recommend accordingly.

Technical Engineer.