12/28/2023 updated
RK
100 % available
Oracle DBA, Oracle DBA, Oracle DBA
Hyderabad, Portugal
Only remote
UnixDatabasesData DictionaryRelational DatabasesFile SystemsNode.jsOracle DatabasesOracle ApplicationsRecovery Manager (RMAN)SQL DatabasesToad (Software)Operational SystemsUser Administration
Data Dictionary, Database, databases, filesystem, Information Technology, Windows, Node, Operating System, oracle, Oracle database, Oracle databases, 12c, Oracle8i, Oracle10g, Oracle11g, Oracle 8i, 9i, Oracle 11g, Oracle DBA, Oracle 10g, RMAN, Rdbms, sql, Toad, UNIX, UNIX environment, UNIX platforms, User Management
Languages
EnglishGood
Project history
Environment : Oracle 11g, 12c on UNIX platforms.
Team size : 20
Role : Oracle DBA
Duration : FEB 2016 - Feb, 2020
Domain : Banking, Insurance, Hospitals
Responsibilities:
* Oracle PSU Patching using opatch & some other internal tools for oracle 11g & 12c
* Grid and Rdbms home maintenance.
* Worked on Golden gate
* Production Support
* Issues like Node Eviction.
* Create partitions for tables
* Change request Implementations in coordination with application and other teams.
* Coordinate with oracle support for issues until they are resolved.
Team size : 20
Role : Oracle DBA
Duration : FEB 2016 - Feb, 2020
Domain : Banking, Insurance, Hospitals
Responsibilities:
* Oracle PSU Patching using opatch & some other internal tools for oracle 11g & 12c
* Grid and Rdbms home maintenance.
* Worked on Golden gate
* Production Support
* Issues like Node Eviction.
* Create partitions for tables
* Change request Implementations in coordination with application and other teams.
* Coordinate with oracle support for issues until they are resolved.
Environment : Oracle 8i, Oracle 10g, Oracle 11g on UNIX platforms.
Team size : 35
Role : Oracle DBA
Duration : JUL 2012 - JAN 2016
Domain : Telecom Billing
Responsibilities:
* Refresh test databases with production for testing teams.
* Restoring Prod DB for Test environment using RMAN.
* 11g R2 RAC installation and setup for testing.
* Migrating databases from 10g to 11g for application upgrade testing.
* Apply database changes using Tiger tool and maintain the repository database of Tiger tool.
* Support during Production Release.
* Taking export backups of Full/Schemas/Tables/Tablespace level using EXP/EXPDP tools.
* Applied CPU, PSU & Grid Patches on 10g/11g Standalone/RAC.
* Implemented RMAN HOT/COLD backups.
* Implemented DR solutions for critical production for business reporting.
* Implemented BCV from production to auxiliary.
* Monthly Purging of tables according to the policy.
* Interpreting explain plan to understand the sql execution path.
* Providing technical assistance to developer's/end users in all ORA errors etc...
* Supporting release and post production environments
* Raise SR to Oracle Support for the critical issues & implement the steps suggested by support on test
environments, if successful, implement them on the production boxes
Team size : 35
Role : Oracle DBA
Duration : JUL 2012 - JAN 2016
Domain : Telecom Billing
Responsibilities:
* Refresh test databases with production for testing teams.
* Restoring Prod DB for Test environment using RMAN.
* 11g R2 RAC installation and setup for testing.
* Migrating databases from 10g to 11g for application upgrade testing.
* Apply database changes using Tiger tool and maintain the repository database of Tiger tool.
* Support during Production Release.
* Taking export backups of Full/Schemas/Tables/Tablespace level using EXP/EXPDP tools.
* Applied CPU, PSU & Grid Patches on 10g/11g Standalone/RAC.
* Implemented RMAN HOT/COLD backups.
* Implemented DR solutions for critical production for business reporting.
* Implemented BCV from production to auxiliary.
* Monthly Purging of tables according to the policy.
* Interpreting explain plan to understand the sql execution path.
* Providing technical assistance to developer's/end users in all ORA errors etc...
* Supporting release and post production environments
* Raise SR to Oracle Support for the critical issues & implement the steps suggested by support on test
environments, if successful, implement them on the production boxes
Client : IDEA Cellular, Pune
Environment : Oracle 8i, Oracle 10g, Oracle 11g on windows and unix platforms.
Team size : 25
Role : Oracle DBA
Duration : OCT 2010 - JUL 2012
Domain : Telecom
Responsibilities:
* Taking detailed Handover from the previous shift
* Check the critical alerts before taking the handover and know the status of the work done on them.
* Working on backup failure issues.
* Taking export backups of Full/Schemas/Tables/Tablespace level using EXP/EXPDP tools.
* Using Data Dictionary Views of DBA/USER/ALL/V$/GV$ for troubleshooting and other BAU activities.
* Applied CPU & PSU Patches on 10g/11g Standalone/RAC.
* Using Data Dictionary Views of DBA/USER/ALL/V$/GV$ for troubleshooting and other BAU activities.
* Monitoring of databases for alerts of tablespace's and archival errors.
* Creating db links, synonyms and other db objects for the application teams as per the request.
* Creating schemas, allocating quotas on tablespaces.
* Managing Profiles, User's & password Policies.
* Granting roles, privilege's according to the policy.
* Adding datafiles to the tablespaces in asm/filesystem.
* Checking the constraints, enabling or disabling them as per the requirement
* Raise SR for issues & Coordinate with oracle support to resolve the issues.
Environment : Oracle 8i, Oracle 10g, Oracle 11g on windows and unix platforms.
Team size : 25
Role : Oracle DBA
Duration : OCT 2010 - JUL 2012
Domain : Telecom
Responsibilities:
* Taking detailed Handover from the previous shift
* Check the critical alerts before taking the handover and know the status of the work done on them.
* Working on backup failure issues.
* Taking export backups of Full/Schemas/Tables/Tablespace level using EXP/EXPDP tools.
* Using Data Dictionary Views of DBA/USER/ALL/V$/GV$ for troubleshooting and other BAU activities.
* Applied CPU & PSU Patches on 10g/11g Standalone/RAC.
* Using Data Dictionary Views of DBA/USER/ALL/V$/GV$ for troubleshooting and other BAU activities.
* Monitoring of databases for alerts of tablespace's and archival errors.
* Creating db links, synonyms and other db objects for the application teams as per the request.
* Creating schemas, allocating quotas on tablespaces.
* Managing Profiles, User's & password Policies.
* Granting roles, privilege's according to the policy.
* Adding datafiles to the tablespaces in asm/filesystem.
* Checking the constraints, enabling or disabling them as per the requirement
* Raise SR for issues & Coordinate with oracle support to resolve the issues.