Work Experience

• IGate Global Solutions

  02/2013--08/2014 India

  Oracle DBA

  - Configuring DGMGRL for the databases for DR Test activity like Switch over and Switch back using flashback, dgmgrl and normal method. - Capacity Planning and monitoring the database growth on the basis of periodic reports. - Allocating system storage & planning for future storage requirements of the database. - Performing day-to-day DBA activities including daily health checks, database backups, Trouble-shooting, analyzing CPU load and monitoring performance affected areas. - Upgrading the databases from 10g to 11g as well as Degrading from 11g to 10g. - Working in 24/7 environment in shifts. - Creation of tablespaces, Adding and resizing datafiles as per requirements. - Preparing Standard Operating Procedures (SOP) for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers. - Installing Oracle Binaries, OEM agent on all boxes, creating databases and refreshing the data. - Analyzing tables and indexes for better performance, Rebuilding Indexes/Monitoring Indexes. - Gathering statistics of database on weekly basis.- Resolving issues such as Deadlocks, connection problems, runaway processes and privileges. - Co-ordination with all primary DBA's to work upon the efforts of the team putting at the right track to gain the better performancern","tPerforming day-to-day DBA activities including daily backup reports, Trouble-shooting, analyzing CPU load and monitoring performance affected areas. - Installing, Creating and applying latest patches for the 11g and 12c databases - Upgrading the databases from 10g to 11g as well as from 11g to 12c. - Renaming and Cloning of databases based upon requests either CDB or PDB databases. - Configuring Third Party Tool for RMAN i.e., DDB tool. - Configured OEM 12c tool for monitoring the databases by installing the agents in the respective servers. - Involved in Tablespace and User managements tasks with granting standard roles/privs, on CDB and PDB database level. - Preparing Standard Operating Procedures (SOP) for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers. - Analyzing tables and indexes for better performance, Rebuilding Indexes/Monitoring Indexes. - Confguring Wallet on the database level (TDE /orapki) in 12c RAC databases. - Resolving issues such as Deadlocks, connection problems, runaway processes and privileges. - Working on Database, Schema, Table level refresh activities on all Boxes. - Monitoring, Troubleshooting and Administering the Oracle Golden Gate Setup and sync up. - Performing day-to-day DBA activities including daily backup reports, Trouble-shooting, analyzing CPU load and monitoring performance affected areas. - Installing, Creating and applying latest patches for the 11g and 12c databases - Upgrading the databases from 10g to 11g as well as from 11g to 12c. - Renaming and Cloning of databases based upon requests either CDB or PDB databases. - Configuring Third Party Tool for RMAN i.e., DDB tool. - Configured OEM 12c tool for monitoring the databases by installing the agents in the respective servers. - Involved in Tablespace and User managements tasks with granting standard roles/privs, on CDB and PDB database level. - Preparing Standard Operating Procedures (SOP) for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers. - Analyzing tables and indexes for better performance, Rebuilding Indexes/Monitoring Indexes. - Confguring Wallet on the database level (TDE /orapki) in 12c RAC databases. - Resolving issues such as Deadlocks, connection problems, runaway processes and privileges. - Working on Database, Schema, Table level refresh activities on all Boxes Monitoring, Troubleshooting and Administering the Oracle Golden Gate Setup and sync up.

• Cognizant Technology Solutions

  09/2014--Till Date India

  Sr. Oracle DBA