Current membership doesn't allow to view contact information of candidates

 

Age, Birthday:
33  years, May 26, 1988
Citizenship:
India
Permission to work:
Yes



About Me

Having  7  years of Experience as Oracle Database Administrator on various versions of oracle from  9i till 12c  and in all the phases of Database Management System on UNIX flavored environments like Exadata Machines, RedHat Linux, Sun Solaris, AIX, HP and Windows Servers.

  1. Experienced in designing the database’s architecture and to ensure that the database is secure, scalable and performs reliably for Oracle Standalone and RAC Databases.
  2. Involvement in planned maintenance activities like Upgradations from 10g, 11g and 12c, applying Quarterly/Bug Patches in Standalone and RAC Environments.
  3. Experienced in Database Backup & Recovery scenarios using RMAN and configuring Third party tool like (DDB), Used Exp/Imp, Datapump to take logical backups at Database level, Schema level and Table level.
  4. Experienced in Active/Backup based Duplication, Cloning of databases, PITR of 12c CDB & PDB databases using RMAN and  creating  SOP Documentations.
  5. Experienced in implementing and managing DataGuard configuration, using both DGMGRL and command line on Standalone and RAC environment (11g&12c).
  6. Involved in the DR Drill activities on both RAC & Standalone environments using different methods based (viz., Flashback method, DGMGRL method and Normal Command line, Snapshot conversions) on the client requirement.
  7. Experienced in deploying Oracle Advanced Security, including using TDE Wallets, SSL Keystores to encrypt entire tablespaces and protecting.
  8. Gained strong knowledge overview on Oracle Exadata machine which helps to involve in activities.
  9. Involved in configuring and administrating the Oracle GoldenGate Setup between databases.
  10. Experienced in Install & Upgrade of OMS/OEM and Agents from 11g (11.1.0.1) to 12c (12.1.0.4).
  11. Performance Tuning using tools/utilities by Automated Workload Repository (AWR), ADDM, explain plan, TKPROF and Statspack as well as rebuilding Indexes, checking Blocking sessions, SQL Query Tuning, finding Chained-rows and taking the appropriate action on time.
  12. Worked in multiple Domains like Banking, Healthcare, Pharma and Financing with strict adherence to the predefined SLA’s with application team to define the data model and work on tuning and optimizing database related operation.
  13. Experienced in working on Remedy (Incident management / Change management) BMC Patrol.
  14. Willingness to learn new technologies such as Cassandra,  MongoDB,  Postgres, MySQL,etc., openness to new ideas and ability to learn quickly as well as competence to work on own initiative as part of a team.

Oracle Database Administrator

Resume Infomation

Experience:
5 - 10 years
Category:
Technical Support
Type:
Full Time, Part Time, Contract, Remote, Freelance
Language:
English
Job Country:
United Kingdom
Job City:
London

Education

  • Osmania University
    2008--2011 MCA
    Master of Computer Applications

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

Professional Skills

  • Oracle DBA
    100%
  • Unix
    100%
  • Aix
    100%