SUMMARY

• Around 9 years of experience in Oracle Apps DBA and Oracle RAC DBA.
• 2 Years of experience on Apache Cassandra.
• In depth knowledge of Apache Cassandra (how it works) and experience in installations, configurations and monitoring DataStax Enterprise cluster and open source Cassandra cluster.
• Experience in data backup, recovery and scheduling repair service in Cassandra clusters.
• Experience in managing multi - tenant Cassandra clusters on public cloud environment like AWS and Open stack (Rackspace).
• 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.
• Excellent working skills with installation, Cloning, Patching, Upgrade, migration Language installation.
• Excellent knowledge of Oracle 11i Application Administration, R12 and Oracle 12c Database Administration.
• Strong experience in Patching and Cloning Oracle Applications.
• Performed Application admin tasks using AD Utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink).
• Maintaining system configuration using autoconfig.
• 24 * 7 Production Database Support and maintenance.
• 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 Data Guard.
• Experience in Backup and Recovery.
• Experience in Shared APPL TOP.
• User management and security.
• Applying Database patches using OPatch utility.
• Database Space Management, which includes creation of Tablespaces.
• Creating and adding data files to primary database storage structures.
• Experience in Hot, Cold, Logical (Export/Import) and RMAN backups.
• A very good knowledge on shell scripting
• Having Good knowledge of Linux.

TECHNICAL SKILLS

Big Data Ecosystems: Apache Cassandra

ERP: Oracle Applications (Release 11i&R12) EBS

Operating Systems: Solaris, Linux - Red Hat

RDBMS: Oracle 9i,Oracle 10g,Oracle 11g and Oracle 12c.

Languages: SQL.

Tools: / Utilities: TOAD, Putty

PROFESSIONAL EXPERIENCE

Confidential, San Jose

Responsibilities:

• Extensively worked on DSE installations and upgrades (major and minor) whenever necessary Tables, index rebuilding, moving objects etc.
• Expertise in Cassandra administration in a production environment
• Working experience on setting up Opscenters for multiple clusters and their maintenance. Done upgradations on Opscenter (Major and minor).
• Cassandra backup and recovery mechanism.
• Worked on setting up more than 20 DSE six node clusters and maintaining them via Opscenter.
• Expertise in enabling SSL, security and JMX options in the clusters.
• Expertise in using CQLSH and quering the database.
• Experience in migrating keyspace data between clusters and from other sources as well.
• Worked on scheduling repair, backup services and monitoring other performance parameters through Opscenter.
• Good hands-on on setting up DSE-Spark and DSE-Solr clusters.
• Provide 24/7 support for the database based upon the SLAs of the different environments.
• Experience in using datastax java driver from load testing the data into Cassandra.
• Monitoring tools like nodetool, Opscenter and JConsole.

Confidential

Responsibilities:

• Extensively worked on DSE installations and upgrades (major and minor) whenever necessary Tables, index rebuilding, moving objects etc.
• Expertise in Cassandra administration in a production environment.
• Worked on scheduling repair, backup services and monitoring other performance parameters through Opscenter.
• Good hands-on on setting up DSE-Spark and DSE-Solr clusters.
• Provide 24/7 support for the database based upon the SLAs of the different environments.
• Worked on scheduling repair, backup services and monitoring other performance parameters through Opscenter.
• Good hands-on on setting up DSE-Spark and DSE-Solr clusters.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

Responsibilities:

• As a Team member Handled one production instance and Three test instances
• As part of R12 upgrade, upgraded the Upgrade 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.
• 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.

Confidential

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.

Confidential

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.