RAMESH BABU TALARI

Mobile: 858-***-****

Email: acvoyx@r.postjobfree.com

Summary:

Around 9 years of experience in providing ERP solution in IT industry in various roles like Technical Analysis, Data Modelling, Designing, Development, Database Administration, Database Architect and Production maintenance, Database upgrades, ERP R12 RBAC and R12.2.5 ERP Applications upgrade and support.

My experience with Oracle RDBMS with installing, patching, cloning, upgrades, monitoring, maintaining, performance tuning.

Hands-on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard and Oracle replication and OEM 12C and Oracle Golden Gate.

Hands-on experience on configuring and supporting on Golden Gate replication.

Hands-on experience on Oracle Database upgrades from 10.2.0.4 to 10.2.0.5, 10.2.0.4 to 11.2.0.2 and 11.2.0.2 to 11.2.0.4 versions.

Hands-on experience on Oracle E-Business suite Applications upgrade from R12.1.3 to R12.2.5

Completed 2 implementation of Oracle E-Business Suite applications upgrade from R12.1.3 to R12.2.5 for Non-prod and production applications.

Production support and maintenance of Oracle Applications R12.1.3 and 11.5.10.2.

Extensive experience in Oracle E-Business Suite from application as well as database side.

Involved in complete software development lifecycle (SDLC) for Oracle Implementations and Upgrade.

Supporting and maintaining the Application responsibilities access control in system

Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as project management.

My database and application knowledge, experience and expertise includes, RDBMS versions 11g, 10g, 9.x, e*Business Suite 11.5.9, 11.5.10, and R12.1.3 and Sun Solaris Administration and Linux Server management.

Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

Provide Level 3 application database administration production support to resolve problems including on-call support and closing of helpdesk tickets.

Coordinate with data security to provide appropriate security, SOX compliance and secondary authorization.

Hands on experience in Oracle ERP performance tuning, both infrastructure side turning, and code tuning.

Had experience managing environments using Weblogic Admin Server console, Enterprise Manager, Node manager and other server administration utilities.

Monitor hardware, OS and application performance through available utilities.

Monitoring and controlling the standard JVM monitoring utilities.

Have the experience on analyze and troubleshoot deployment issues in a timely manner.

Act as primary customer contact for deployment related inquiries and issues.

Strong issue fixing and debugging skills.

System administrator maintenance and Support, Role Based Access Control.

Supporting and maintaining the Application user’s access control in system.

Assigning the required responsibilities to the internal/external users.

I am a result driven, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.

CERTIFICATIONS:

Oracle Database Certified Associate (OCA).

Oracle Database Certified Professional (OCP).

EDUCATION:

M.C.A - Master of Computer Applications from Osmania University, 2007.

B.Sc. - Bachelor of Science from Sri Venkateswara University, 2003.

A.D.S.T - Advanced Diploma in Software Technology from CT&T Institution, 2003

SKILLS & TOOLS:

Operating systems: Linux 5.10, IBM AIX, HP-UX, Sun Solaris 10, Windows 2008, Windows NT

Databases: 11gR2/11gR1/10g/9i

Specialization:

PLSQL Developer, Toad, SQL PLUS, SQL Developer, Oracle Workflow Builder, SQL Navigat or, Oracle Golden Gate.

Hyperion Essbase and Planning Applications

Putty, WinSCP, PsFTP

GRC CCG and AACG applications,

VSS, SVN, SDM12, Remedy and HP PPM tools

OEM 12C

Storages: Oracle ASM, Disk groups RMAN Backup, EMC DDBoost RMAN Backup

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script.

EXPERIENCE:

Worthington Industries Inc. Columbus, OH OCT 2014 – Current Date

Oracle Apps DBA

Responsibilities:

My experience with Oracle RDBMS with installing, patching, cloning, monitoring, maintaining, performance tuning.

Hands-on experience on Oracle E-Business suite Applications upgrade from R12.1.3 to R12.2.5

Upgraded the R12 applications for Development, Tech and Production environments.

Hands-on experience on R12.2 Applications performance Tuning and troubleshooting.

Hands-on experience on Fusion Middleware Applications and installing and supporting.

Hands-on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard and OEM 12C.

Configuring and monitoring the databases through OEM 12C.

Hands-on experience on configuring and supporting on Golden Gate replication.

Building the Golden Gate replication instance through network.

Good understanding of Golden Gate architecture and workflow process.

Database upgrade from 11.2.0.1 and 11.2.0.3 to 11.2.0.4 version for Non-production and Production databases.

Hands-on experience on cloning and refresh of the databases from Production to Test and Development environments.

Hands-on experience on Performance Tuning and Troubleshooting the database and concurrent jobs.

Production support and maintenance of Oracle Applications R12.1.3 and 11.5.10

Patching applying on R12.1.3 and 11i E-Business Suite applications.

Hands-on experience on E-Business Suite R12 Applications Upgrade.

Extensive hands on experience on Patch analysis and applying for database and applications.

Involved in complete software development lifecycle (SDLC) for Oracle Implementations and upgrades.

Supporting and maintaining the Application responsibilities access control in system

Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.

Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

Participates in the 24/7 on-call support on rotation.

Implemented the Roles Based Access Control (RBAC) in DEV, UAT and Production ERP Applications.

System Administrator responsibilities maintaining.

Creating the roles for different category of modules and assigning the responsibilities.

Creating the permission sets and assigning to respective roles.

Provide Level 3 application database administration production support to resolve problems including on-call support and closing of helpdesk tickets.

Coordinate with data security to provide appropriate security, SOX compliance and secondary authorization.

Managing RMAN, Cold and Hot backups from database side.

ERP Application user creation.

Responsibilities creation.

Supporting and maintaining the Application user’s access control in system.

Supporting and maintaining the Application responsibilities access control in system.

Assigning the required responsibilities to the internal/external users.

Built up of new database and cloning the database and applications as per Business requirement.

Provided the ERP and Non-ERP Healthy database and Applications to users

Performed multiple SYS Admin activities.

Creating and managing DDBoost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.

Maintaining and supporting the Oracle Demantra Applications and Value Chain Planning and databases.

Applied the up-to-date and required patches for all the applications.

Defined and documented the real time error handling strategy documentation.

Closely worked with the programmers and the functional team to bridge the gap between them.

Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.

Performing various post clone activities on the newly refreshed instances.

Applying one-off patches, CPU patches, RUP patches to various instances.

Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.

GRC Applications support and administration.

UPK database and applications support and administration.

Environment: R12.1.3 ERP Applications, Oracle Database 11g/10g databases, Oracle Demantra Applications, OBI services, RAC, RMAN, ASM, Data guard, GRC Applications, UPK Applications, OEM 12C & RBAC.

McGraw Hill Education, Columbus, OH MAY 2013 – SEP 2014

Oracle Apps DBA

Responsibilities:

My experience with Oracle RDBMS with installing, patching, cloning, upgrades, monitoring, maintaining, performance tuning.

Hands-on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard, Oracle replication and OEM 12C.

Hands-on experience on Oracle Database upgrades from 10.2.0.4 to 10.2.0.5 and 11.2.0.3 and higher versions.

Hands-on experience on cloning and refresh of the databases from Production to Test and Development environments.

Hands-on experience on Performance Tuning and Troubleshooting the database and concurrent jobs.

Upgraded the R12 applications for Development, Tech and Production environments.

Involved in complete software development lifecycle (SDLC) for Oracle Implementations and upgrades.

Hands-on experience on configuring and supporting on Golden Gate replication.

Building the Golden Gate replication instance through network.

Good understanding of Golden Gate architecture and workflow process.

Hands-on experience on patching on R12.2 Applications.

Hands-on support and installation experience on Fusion Middleware applications.

Supporting and maintaining the Application responsibilities access control in system

Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.

My database and application knowledge, experience and expertise includes, RDBMS versions 11g, 10g, 9.x, e*Business Suite 11.5.9, 11.5.10, and R12.1.3 and Sun Solaris Administration and Linux Server management.

Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

Participates in the 24/7 on-call support on rotation.

Built up of new database and cloning the database and applications as per Business requirement.

Provided the ERP and Non-ERP Healthy database and Applications to users

24*7 supported for all Production, UAT, SIT and Development database and applications both ERP and Non-ERP applications in Offshore and Onsite locations

Performed multiple SYS Admin activities.

Creating and Managing DDBoost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.

Build Oracle Demantra applications and databases.

Build Oracle Demantra OBI services.

Maintaining and supporting the Oracle Demantra Applications and databases.

Applied the up-to-date and required patches for all the applications.

Defined and documented the real time error handling strategy documentation.

Closely worked with the programmers and the functional team to bridge the gap between them.

Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.

Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non-production environments.

Performing various post clone activities on the newly refreshed instances.

Applying one-off patches, CPU patches, RUP patches to various instances.

Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.

Installation, monitoring and troubleshooting of other Oracle Databases.

Environment: Oracle R11, R12.1.3 ERP Applications, Oracle Database 11g/10g/9i databases, Oracle Demantra Applications, OBI services, RAC, RMAN, ASM, Data guard.

Cricket Communications, San Diego, CA FEB 2010 - APR 2013

Oracle Apps DBA

Responsibilities:

Database upgrades from 10.2.0.4.0 to 10.2.0.5.0 and from 10.2.0.4.0 to 11g versions.

Managing space in table spaces and important files systems (like UDUMP,BDUMP etc)

Working with databases with single instances and High Monitoring database for locks and issues like temp distribution in RAC instances.

Applying RDBMS patches (OPatch) in single and RAC instances.

I have experience with Installation, Configuration, Administration and Performance tuning of Oracle Weblogic Application Servers running for Oracle Service Bus/Business Activity Monitoring/Oracle SOA Suite.

Have the exposure on Oracle Service Registry/Oracle Enterprise Repository in a clustered environment.

Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

Developed and maintain automated deployment systems.

Hands-on experience on E-Business Suite R12.1.3 on Support.

Had experience managing environments using Weblogic Admin Server console, Enterprise Manager, Node manager and other server administration utilities.

Monitor hardware, OS and application performance through available utilities.

Monitoring and controlling the standard JVM monitoring utilities.

Have the experience on analyze and troubleshoot deployment issues in a timely manner.

Act as primary customer contact for deployment related inquiries and issues.

Strong issue fixing and debugging skills

Automation of cloning processes using UNIX and sql scripting.

Performance tuning of Oracle databases.

RDBMS binary and database upgrade.

Monitoring and troubleshooting the failed batch jobs and backups

Refreshing Database on multiple levels using EXPort/IMPort utilities.

Experience in working on Single Node and Multi Node installations involving both dedicated and shared application configurations for Production, User acceptance Test, SIT and Development Environments

Troubleshooting patch issues.

Patch analysis.

Cloning applications in single and multi-node environments manually using auto config.

Refreshing database and Applications using the existing binaries and Production backup

Moving applications across nodes.

Automation of certain cloning processes using UNIX and sql scripting.

Pro-active maintenance like checking health of instance monitoring databases, concurrent programs, form sessions, general performance issues etc.

Sys admin activities involving managing users and responsibilities.

Workflow configuration in Oracle applications

Discoverer configuration in Oracle applications

Bouncing and troubleshooting the Non-ERP applications like JDA, Ariba, Vertex, DRM and CATS

Patch applying in Non-ERP applications like JDA, Ariba, Vertex and CATS

Released Tax Tables(Sales Use Tax and Consumer Use Tax) updating in Production, UAT, SIT and development Vertex applications

Providing support for SRs with Oracle

Monitoring and maintaining Hyperion Essbase and Planning Applications

Providing required access for Hyperion Essbase and Planning Applications to users.

Built up and supporting the GRC Production CCG and AACG Applications

Patches applying in CCG and AACG applications

Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.

Developed method of Practice for various DBA activities like cloning, shutdown/startup of services.

Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non -production environments.

Performing various post clone activities on the newly refreshed instances

Applying one-off patches, CPU patches, RUP patches to various instances.

Check-in and checkout the code from VSS and deploying it to various instances.

Interacting with the users who raise Helpdesk tickets for any Database issues and work on resolving and closing the tickets.

Installation, monitoring and troubleshooting of other Oracle databases.

Environment: Redhat Linux 5, Oracle 11g RAC (11.1.0.7), Oracle 10g RAC (10.2.0.5 & 10.2.0.4), Oracle ERP Applications 11.5.10 and R12.1.3

British Telecommunications Plc, Kolkata, India July 2009 - January 2010

Oracle Apps DBA

Responsibilities:

Database Schemas migration from 8i database to 11i database.

Managing RMAN, Cold and Hot backups from database side.

Built up of new database and cloning the database and applications as per Business requirement.

Provided the ERP and Non-ERP Healthy database and Applications to users

24*7 supported for all Production, UAT, SIT and Development database and applications both ERP and Non-ERP applications in Offshore and Onsite locations

Performed multiple SYS Admin activities.

Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

Creating and Managing DD Boost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.

Build Oracle Demantra applications and databases.

Build Oracle Demantra OBI services.

Maintaining and supporting the Oracle Demantra Applications and databases.

Applied the up-to-date and required patches for all the applications.

Defined and documented the real tine error handling strategy documentation.

Closely worked with the programmers and the functional team to bridge the gap between them.

Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.

Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non-production environments.

Performing various post clone activities on the newly refreshed instances.

Applying one-off patches, CPU patches, RUP patches to various instances.

Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.

Installation, monitoring and troubleshooting of other Oracle Databases.

MS SQL Server Databases support and administration.

Contacting and approaching different business stake holders.

Environment: Oracle 10g Database Server, Web logic Application Server, Oracle ERP Applications 11.5.10.

Experion, Kolkata, India November 2008 to June 2009

Oracle Apps DBA

Responsibilities:

• Cloning Oracle Applications 11.5.10 from two-node/single node environment to two/one node environment.

• Analyzing and Patching Oracle Applications, Maintenance Pack, Family Pack, Mini Pack and etc.

• Monitoring Concurrent Processing and troubleshooting all managers related issues.

• Use AD tools, FND scripts to maintain Apps Instances.

• Maintain 5 Application Servers in different platforms.

• Table space management

• Troubleshooting the long running concurrent programs.

• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.

• Troubleshooting for all database space related problems.

• Help Desk Support to different Experian servers in Oracle Application Servers.

• Sys admin activities like creating apps Users, responsibility, Menu according to the requirement.

• Working with Oracle through SR.

• Responsible for gathering requirements from the business.

• Completing and delivering the components for Production, UAT, Development applications in the right time.

• Supporting the Production, UAT and Go-Live of the components

• Authoring all technical design documentation to the client.

Environment: Oracle 9i, Oracle 10g, Oracle Apps 11i and Release R12

Contact this candidate