VAMSI VIJAYA KRISHNA

ORACLE APPLICATIONS DBA /Cassandra

Contact # +1-408-***-****

Location: San Jose, CA Email : ac7vwf@r.postjobfree.com

Objective:

Seeking a position of Oracle Applications DBA where I will be able to continuously upgrade my personal and professional skills and meaningfully contribute to the development of the organization I serve.

Education Qualification:

Master of Computer Application from Vivekananda PG College (OU)–2006.

Bachelor of Computer Application, with First Division in August 2002.

Summary:

Oracle Applications DBA with 10.9 years of experience in Software industry and oracle applications administration in Production, development and test environments. Good experience in Oracle E-Business patching, upgrading and Load balancing.

Experienced in R12 Application upgrades from 11.5.9 to 12.1.3 and 12.0.4 to 12.1.3 and 12.2

Applied Patches in 12.2 ADOP(online patching) and in EBS lower versions using ADPATCH and Administering Concurrent Managers.

Experience in Oracle Database Administration, Oracle Applications, Analysis, Production environment and Applications support

Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning / Refreshing Database and Oracle Applications.

Expertise in Implementing and supporting Oracle High availability solutions like ASM, RAC, Active Data Guard etc

Experience in Database Upgrades from various versions (9.2.0.8 to 10.2.0.1) (10.2.0.1 to 10.2.0.4) (10.2.0.3 to 11.2.0.1) (11.2.0.3 to 12.1.0.2)

Expertise in Converting standalone DB to RAC DB

Expertise in planning, analyzing, implementing and coordinating multiple projects

Expertise in managing SLAs and meet deadlines under pressure in 24/7

Critical environments

Worked on Fresh Installation,Setup of Oracle OEM Grid Control 11.1.0.1 & 12c

Worked on numerous Backups and Restores using RMAN technology for replication of very large data volumes as part of Data Center Migration

Worked on deployment in SOA suite, creation of Data sources, JMS destinations, securing web services

Worked in setting of High Availability and clustering for Oracle SOA suite

WebLogic installation 3 modes - GUI, Console and Silent mode.Configuration template’s for various environment based installations Having Good knowledge of linux (as required for DataBase Administration).

Having Cassandra DBA Experience in installing, configuring and monitoring DataStax Cluster (Enterprise Edition).

Implemented multi - data center and multi-rack Cassandra cluster.

Knowledge in Cassandra read and write paths and internal architecture

Experience in migrating several data bases from on premise data center to Cassandra.

Experience with Disk Management and User Management and permissions.

Technical skills:

APPLICATIONS/Engine : Oracle Applications 11.5.9, 11.5.10.2, 12.0.4, 12.1.3, 12.2.5

Databases : Oracle 12C, 11g, 10g, Cassandra

RDBMS TOOLS : Oracle Enterprise Manager (OEM)

LANGUAGES : SQL, PL/SQL

OPERATING SYSTEMS : Red Hat Linux, Solaris, AIX

ORACLE UTILITIES : Export, Import, Adadmin, Adpatch, Rapid Install,

Rapid Clone, Autoconfig.

Experience:

Working in TATA CONSULTANCY SERVICES as Assistant Consultant from January 2012 to till date.

Worked in ORACLE SSI (Oracle Solution Services India), Bangalore as Assistant Consultant on Contract Since January 2008 to January 2012.

Projects:

1. Client

Cisco (Build Team), India/USA

Role

Oracle Apps DBA /Cassandra

Environment

Oracle E-Business Suite 11i (11.5.10.2), R12

Duration

February 2013 – Till Date

Organization

Tata Consultancy Services

Environment

Oracle 10g, Oracle 11g & Oracle E-Business Suite 11.5.10.2, R12

Project Details: Cisco (Build Team) USA

As part of IRM project, databases will be migrating the CISCO’S non production databases which are present in physical hosts to VM hosts

Roles and Responsibilities:

Cloning the database from PRODUCTION to Stage/test/dev environments and post migration activities.

Database migration from RCDN datacenter to RTP datacenter and GRID Installations

Multiple Database upgrade to 12C.

As part of migrations, will be migrating through RCDN database using RMAN backup and restore to RTP datacenter

Worked on Installation of Cassandra with multiple clusters.

Configure Cassandra to use internal authentication and authorization

User accounts setups with only the necessary privileges in Cassandra

Configuring firewall to block connections.

2. Client

Cisco (Build Team) / RTP project, India

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i (11.5.10.2), R12

Duration

January 2013 – January 2014

Organization

Tata Consultancy Services

Environment

Oracle 10g, Oracle 11g & Oracle E-Business Suite 11.5.10.2, R12

Project Details: Cisco (Build Team), India.

RTP is a CISCO’s new datacenter . CISCO’s non production databases which are present in RCDN datacenter are moved from RCDN datacenter to RTP datacenter.

Roles and Responsibilities:

Created number of non-prod databases and delivered them to the client.

Databases migration from RCDN datacenter to RTP datacenter

Database creations and migrations

Installing GRID and Creating DBAAS databases using EM

Converting standalone DB to RAC DB

Upgrading and platform migrating for both RAC and Non RAC instances

Schema export/imports/Migrations

Oracle database clone & upgradations.

3. Client

Cisco (Support Project), India

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i (11.5.10.2), R12

Duration

January 2012 – December 2012

Organization

Tata Consultancy Services

Environment

Linux, Oracle 9.x, Oracle 10g, Oracle 11g & Oracle E-Business Suite 11.5.10.2, R12

Project Details: Cisco (Support Project), India.

Roles and Responsibilities:

As a team member supported project releases and production releases.

Roles and responsibilities includes implementing production changes in the CR window.

Experienced in Oracle applications patch application and DB patch application.

User account management - creating users, disabling users, responsibility management.

Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long runners.

Worked on DBA Escalated tickets.

Troubleshooting all Oracle Apps Issues.

Administration by using AD Utilities.

Performed sysadmin tasks as per the requirement.

Resolved the configuration issues raised by development & testing teams.

4. Client

Ahold Project, Netherlands

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i (11.5.10.2)

Duration

October 2011 – January 2012

As a Team member Handled one production instance and Two test instances

Upgraded the Upgrade database from 10g (10.2.0.3) to 11.2.0.1

Upgraded Oracle Application 12.0.4 to 12.1.3.

Performed Oracle Application server upgradation from 10.1.3.0 to 10.1.3.5.

Performed Oracle Application server upgradation from 10.1.2.0 to 10.1.2.3.

Performing sysadmin role and did Validation Testing

5. Client

SONY (EAS Data Center Migration Project ), JAPAN

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i (11.5.10.2), HP-UX (32-bit)

Duration

July 2011 – September 2011

Project Details: Sony EAS project is changing the Data Center to Global Data Center (Singapore GDC). DB size: 400+ GB

As a Team member Handled one production instance and one test instance

As part of Data Center Migration, Performed clone from production to test instance.

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).

Performed GSS after Migration.

6. Client

Nokian Tires, Finland (Oracle SSI R12 Upgrade Project)

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite R12 (12.0.4), IBM-AIX 6.1

Duration

February 2011 – June 2011

Project Details: R12 upgrade from 12.0.4 to 12.1.3 for IBM-AIX platform.

DB size: 600+ GB

As a Team member Handled one production instance and Three test instances

As part of R12 upgrade, upgraded the Upgrade database from 10g (10.2.0.3) to 11.2.0.1

Upgraded Oracle Application 12.0.4 to 12.1.3. Production Instance has 2-Node APPS Tier with Concurrent Managers, Database node.

Performed Oracle Application server upgradation from 10.1.3.0 to 10.1.3.5.

Performed Oracle Application server upgradation from 10.1.2.0 to 10.1.2.3.

Performing sysadmin role and did Validation Testing.

7. Client

SONY (Oracle OD Data Center Migration Project), JAPAN

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i (11.5.10.2), HP-UX (32-bit)

Duration

February 2010 – January 2011

Project Details: Sony Migration project, as it is changing the Data Center to Global Data Center (Singapore GDC). DB size: 500+ GB

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.

8. Client

LANDMARK, DUBAI

Role

Oracle Retail DBA

Environment

Oracle Retail Applications on IBM-AIX 5.3

Duration

April 2009 – December 2009

As a Technical Consultant Retail DBA, planned for the upgradation of all Oracle Retail Applications on IBM-AIX 5.3 from versions 12.0.5 to 12.0.10.

Keeping the requirement of customer in mind and making changes in code if required and Database upgrades from 9.2.0.7 to 9.2.0.8 and 10.2.0.3 to 10.2.0.4.

Performed Oracle Application server upgradation from 10.1.3.0 to 10.1.3.3.

Performed Oracle Application server upgradation from 10.1.2.0 to 10.1.2.2.

9. Client

LOWES EXPORTS & IMPORTS (CANADA)

Role

Oracle Apps DBA

Environment

Oracle E-Business Suite 11i(11.5.10.2), IBM AIX 5.3(64-bit)

Duration

February 2008 – March 2009

Project : Fresh Installation, Setup and maintenance of Oracle Application 11.5.10.2, Cloning Oracle Applications & Patching

DB size : 150+GB

Responsibilities:

Working as Assistant Consultant, as supporting the implementation of Oracle Applications Release 11.5.10.2 on IBM AIX 5.3(64-bit).

Applying Application Patches using AD utility- Adpatch

Administering & Maintaining Oracle Application with AD utilities- Adpatch, Adadmin, Adctrl, Adclone, Adsplice.

Experience in Clone of Oracle application environment using Rapid clone.

Tracking invalid objects, compiling and validating the invalid objects.

Created a number of database instances for development, testing and production.

Resolving issues with thorough working knowledge of Oracle Support Metalink.

Personal Profile:

Sex : Male

Languages : English, Hindi and Telugu

Marital Status : Married

Nationality : Indian

Passport# : N0795379

References : Furnished upon request

Relocation: YES

Vamsi Vijaya krishna

Contact this candidate