Oracle Management
Resume:
DAKSHINA MURTHY TANANKI
Mobile:+1-408-***-****
Mail Id:ac0cqw@r.postjobfree.com
Summary:
** ***** ** ********** ** Oracle RAC DBA and Oracle Apps DBA. Currently working at CISCO.
* ***** *f experience on Cassandra DBA.
Implemented Oracle 12c Database on Redhat Linux 6.4.
Hands on experience with Standby databases and Data Guard management.
Experienced in performing database health checks, monitoring and troubleshooting performance related issues.
Excellent working skills with installation, Cloning, Patching, Upgrade, migration Language installation.
Experience in Hot, Cold, Logical (Export/Import) and RMAN backups.
Applying Database patches using OPatch utility.
Excellent skills in database administration, backup and recovery activities.
Experience in Oracle 11i Application Administration and R12.
Strong experience in Patching and Cloning Oracle Applications.
Performed Application admin tasks using AD Utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink).
24 * 7 Production Database Support and maintenance.
Applying Database patches using OPatch utility.
Creating and adding data files to primary database storage structures.
In depth knowledge of Apache Cassandra (how it works) and experience in installations, configurations and monitoring DataStax Enterprise cluster and open source Cassandra cluster.
Cassandra installation on Openstack VM.
Node addition and removal in Cassandra.
Expertise in Cassandra administration in a production environment and using Opscenter.
Maintained more than 20 Cassandra clusters with six nodes each hosted on the cloud in pre-prod and production environments.
Good hands-on on setting up DSE-Spark and DSE-Solr clusters.
Cassandra Opscenter configuration and Migration
Cassandra utilities like Nodetool,cqlsh
Troubleshoot read/write latency and timeout issues
Configure backup, alerts, repairs and monitoring of Cassandra clusters
Experience in SOA, WebLogic and Agile.
Maintenance of concurrent processing requests and concurrent managers.
Interacted with the functional team, defined responsibilities, menus, request groups, users.
Handling multi tier architecture: Desktop tier, Application tier (Web server, Form server, Concurrent processing server and Administration server) and Database tier.
Experience in Shared APPL_TOP.
User management and security.
Database Space Management, which includes creation of Tablespaces.
A very good knowledge on shell scripting
Having Good knowledge of Linux.
Professional Experience:
Currently working in CISCO through TCS, San Jose as Assistant Consultant since Jan-15 to till date.
Worked in CISCO through TCS, Bangalore as I.T.Analyst since Oct-12 to Dec-14.
Worked in ORACLE, Bangalore as Consultant since July-10 to Sept-12.
Worked as Oracle Applications Database Administrator from Aug-07 to June-10 for CMCLimited.
Technical Skills:
RDBMS : Oracle 9i,Oracle 10g,Oracle 11g and Oracle 12c.
Big Data Ecosystems : Apache Cassandra,DSE
ERP : Oracle Applications (Release 11i&R12) EBS
Operating Systems : Solaris, Linux - Red Hat
Languages : SQL.
Tools/ Utilities : TOAD, Putty
Educational Qualifications:
Master of Computer Applications (M.C.A) from Andhra University in 2005.
Experience Summary:
CISCO SYSTEMS INC, San Jose, CA Jan-2015 to Present.
Sr.Oracle DBA /Oracle Apps DBA / Cassandra DBA
Responsibilities
Cloning/Refreshing Development and Test instances from Production instance.
Upgraded Database from 11g to 12C.
Planning, scheduling and executing database related ",Change Management" activities.
Provide DBA support to programmers/developers to support their daily activity.
Planning and supporting various database related upgrade and migration projects.
Planning and implementing backup strategies and testing recovery scenarios.
Applied Application patches like One-Off and Mini-Packs using adpatch.
Applying Database patches using OPatch utility.
Managed system configuration using autoconfig.
Performed Application admin tasks using ADADMIN utility.
Cloning single-node to single-node, single-node to multi-node using Rapid clone.
Compiling invalid objects.
Securing Oracle Applications by periodically changing Apps and schema passwords.
Bouncing the Apache-Servers and other servers, as necessary.
Monitoring concurrent jobs for Oracle E-Business suite.
Tracing and Debugging the applications and Concurrent Programs.
Managing database security by creating users and granting specific roles and privileges to users.
Database Space Management, which includes creation of Table spaces.
Executing the sql commands based on client request.
Performed the Migration tool as per client request.
Creating and removing the users as per client request.
Project: Managed Services, Offshore, Team Size 15
Organization: CISCO SYSTEMS INC.
Duration: June-2014 to Dec-2014.
Sr.Oracle DBA/Oracle Apps DBA
Responsibilities
As a Team member Handled one production instance and Three test instances
As part of R12 upgrade, upgraded the database from 9i (9.2.0.8) to 10.2.0.3
Upgraded Oracle Application 11.5.9 to 12.0.4. Production Instance has 2-Node APPS Tier with Concurrent Managers, Database node.
Provide DBA support to programmers/developers to support their daily activity.
Compiling invalid objects.
Tracing and Debugging the applications and Concurrent Programs.
Executing the sql commands based on client request.
Performing sysadmin role and did Validation Testing
Performed the backup activity weekly and monthly.
Database Space Management, which includes creation of Table spaces.
Creating and adding data files to primary database storage structures.
Recompilation of forms and JSP files, as required.
Applying Database patches using OPatch utility based on client request.
To participate actively in the support activities of Production Oracle eBusiness Suite.
Project: Managed Services, Offshore, Team Size 15
Organization: CISCO SYSTEMS INC.
Duration: Oct-2012 to May-2014.
Sr. Oracle DBA/Oracle Apps DBA
Responsibilities
Cloning single-node to single-node, single-node to multi-node.
Logical Exports and Imports.
Tables, index rebuilding, moving objects etc.
Compiling invalid objects.
Scheduled cloning and backup monitoring.
Applying Database patches using OPatch utility
Handling of different issues daily using ticketing system like connection issues, space issues, downtime issues, Apache issues, concurrent manager issues
Concurrent Programs issues, DB link issues, cron jobs maintenance, Printer setup.
To participate actively in the support activities of Production Oracle eBusiness Suite.
Project Name: SOEM
Organization: ORACLE.
Location: Bangalore.
Duration: Mar-2011 to Sept-2012.
Oracle DBA/Oracle Apps DBA
Key Responsibilities:
Cloning/Refreshing Development and Test instances from Production instance.
Applied Application patches like One-Off and Mini-Packs using adpatch.
Applying Database patches using OPatch utility.
Managed system configuration using autoconfig.
Performed Application admin tasks using ADADMIN utility.
Cloning single-node to single-node, single-node to multi-node using Rapid clone.
Compiling invalid objects.
Securing Oracle Applications by periodically changing Apps and schema passwords.
Bouncing the Apache-Servers and other servers, as necessary.
Monitoring concurrent jobs for Oracle E-Business suite.
Tracing and Debugging the applications and Concurrent Programs.
Managing database security by creating users and granting specific roles and privileges to users.
Database Space Management, which includes creation of Table spaces.
Executing the sql commands based on client request.
Performed the Migration tool as per client request.
Creating and removing the users as per client request.
Performed the backup activity weekly and monthly.
Project Name: i-Semicon (SONY Data Center Migration).
Organization: ORACLE.
Location: Bangalore.
Duration: June-2010 to Feb-2011
Oracle DBA/Oracle Apps DBA
Key Responsibilities:
As a Team member Handled one production instance and one test instance
As part of Data Center Migration, upgraded the 9.2.0.6 database to 9.2.0.8 and Configured CM and AP nodes
Created synonyms, DB Links as per the client requirement.
Applied Critical update patch (Oct 2009 patch).
CM node failover configuration
Performed GSS after Migration
Performed Advance supply chain planning (ASCP) patches.
Performed clone from production to test instance
Performed HTTP and Servlet configuration.
Applied Windows7 and Developer 6i patches.
Creating and adding data files to primary database storage structures.
Compiling invalid objects.
Applying Database patches using OPatch utility.
Performed the Shared APPL_TOP configuration.
Project Name: UNIFY
Organization: CMC Limited.
Oracle DBA/Oracle Apps DBA
Location: Hyderabad.
Duration: Oct-2009 to May-2010.
Key Responsibilities:
As a Team member Handled one production instance and Three test instances
Performing sysadmin role and did Validation Testing
Performed the backup activity weekly and monthly.
Database Space Management, which includes creation of Table spaces.
Creating and adding data files to primary database storage structures.
Recompilation of forms and JSP files, as required.
Applying Database patches using OPatch utility based on client request.
Project Name: Partenernet (Sales&Marketing).
Organization: CMC Limited.
Location: Hyderabad.
Duration: Nov-2008 to Sept-2009
Oracle DBA/Oracle Apps DBA
Key Responsibilities:
Cloning single-node to single-node, single-node to multi-node using Rapid clone.
Running AD utilities like adadmin and adrelink etc.
Bouncing the Apache-Servers and other servers, as necessary.
Enrolling Users, Assigning roles and profiles, maintaining system security through monitoring use access to database.
Compiling invalid objects.
Applying Database patches using OPatch utility.
Database backup and recovery.
Managing database security by creating users and granting specific roles and privileges to users.
Database Space Management, which includes creation of Table spaces.
Creating and adding data files to primary database storage structures.
Project Name: dba Direct.
Organization: CMC Limited.
Location: Hyderabad.
Duration: Aug-2007 to Oct-2008
Oracle DBA/Oracle Apps DBA
Key Responsibilities:
Cloning single-node to single-node, single-node to multi-node using Rapid clone.
Running AD utilities like adadmin and adrelink etc.
Bouncing the Apache-Servers and other servers, as necessary.
Enrolling Users, Assigning roles and profiles, maintaining system security through monitoring use access to database.
Compiling invalid objects.
Database backup and recovery.
Applying Database patches using OPatch utility.
Managing database security by creating users and granting specific roles and privileges to users.
Database Space Management, which includes creation of Table spaces.
Creating and adding data files to primary database storage structures.
Assisting the users in resolving the issues.
Contact this candidate