Oracle Dba Golden Gate

Jagadeesh Kondreddy

Email ID: ****************.*@*****.***

Contact: +1-972-***-****

Having 13+ years of experience (Onsite-6yrs and offshore) in TCS as Oracle DBA (9i, 10g,11g and 12c and AWS RDS and EC2)/Exadata Admin/Golden Gate Admin/Hyperion Admin/Peoplesoft Admin/Oracle Apps DBA which includes Installation, upgrade, network maintenance, UNIX Servers, Cloning, patching, user support, Trouble shooting, Performance tuning, Space management and Providing 24x7 support of Production, Development & UAT environments on Various Platforms.

Professional Experience:

Experienced in Planning, Installation, Physical Database Design, Cloning, Refreshing Databases on Oracle Applications.

Installation of Oracle ASM and Filesystem 12c on Linux Servers.

Experienced in Performance tuning of Applications & database using Oracle OEM, AWR, stats pack, SQL scripts.

Experience in OCI(Oracle Cloud) administration for managing apps,databases and OS related activities

Supporting 2 Node Exadata RAC system including Patching activities of Exadata software, Grid and Oracle home using PATCMGR utility.

Exadata RACK components (ILOM,IB S/W, Compute Node, Storage Node) monitoring using OEM 12c

Working with Oracle to perform Exadata Disk replacement, Battery, CPU and Cache replacements

Exadata QFSD patching

Golden Gate Monitoring, trouble shooting replication/extraction issues

Experience in Configuring, Monitoring, Patching, Cloning, maintenance on various oracle DB versions.

Experience OCI Admin(server provisioning, VPN, Security list..)

Provisioned EBS cloud manager VM from OCI Marketplace image

Provisioned DB systems on VM, associated DataGuard database instances in OCI environment.

Creation of Users, managing schema and privileges, assigning quota on specific Table space, creation and managing roles, user profiles

Expertise in Oracle applications e-Business Suite i.e., from 11.5.10.2 to 12.1.3, 12.1.3 to 12.2.5

Experience in Troubleshooting Oracle DB in production environments on high volume DB

Experience with Oracle DBA Activities and daily maintenance tasks

Experience in AWS RDS and EC2 instance support(Version upgrades,daily support activities using AWS console)

Experience in troubleshooting related to OS on database or application servers in production

Have good experience on applying patches using patchmgr,adpatch, opatch, adop and BSU utilities.

Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.

WebLogic installation, configuration, upgradation, and administration (10.3.3,11g and 12c)

Discoverer installation, configuration, and administration

Excellent communication, problem-solving and Client Management skills

Expertise in Coordinating with Other teams in getting the required work done

Experience in requirement gathering and working closely with Business Users

Having good experience on Data Guard on Normal and RAC databases(Logical,Physical and Active Data guard)

Have good experience on Shell and Perl scripting languages.

CERTIFICATIONS:

Introduction to Oracle 9i: 1Z0 – 007

Program with PLSQL: 1Z0 – 147

Oracle Certified Associate (OCA): 1Z0 – 052 ‘Oracle Database 11g Administration1

1Z0-1085/997-21 Oracle Cloud Infrastructure Certifications

TECHNICAL SKILLS:

Applications Versions

EBS 11i, R12, R12.2, Exadata X5 and X6, Golden Gate 12,AWS,Hyperion,Peoplesoft and Oracle Cloud Admin

RDBMS

ORACLE 11g,12c, 19C, AWS RDS and EC2

Languages

shell scripts, Perl, SQL/PLSQL

Tools and Utilities

RMAN, OEM, SQL Loader, OEM GRID CONTROL, CONFIO(Solar winds), GOLDEN GATE,NETBACKUP, ACTIFIO, CyberArk, STAT, ServiceNow, BMC Remedy and JIRA

Operating System

LINUX, AIX,SUN SOLARIS,WINDOWS and HP-UX

Webservers

WebLogic, Tomcat,Oracle Cloud

QUALIFICATION:

Master’s in computer applications (MCA)

Work Experience

•J.C.Penney Company Co.

Working as Oracle ERP (EBS, Hyperion and Peoplesoft) DBA from Jun 2018 to till now

•Maurices

Worked as Cloud ERP Admin from Jan 2018 to Jun 2018

•Cardinal Health Care -Dublin, OH

Oracle Exadata/AWS Admin from Nov 2016 to Dec 2017

•Sun Edison Energy - St Louis, MO

Oracle Apps (Ebs, Hyperion, GRCC,SOA) DBA from Jan 2015 to Dec 2016

•Omnitracs LLc - Dallas, Texas

Oracle Apps DBA(EBS upgrade) from May 2015 to Dec 2016

•Motorola Solutions Inc., - Schaumburg, IL, Chennai and Hyderabad

Oracle DBA from Feb 2008 to May 2015

PROFESSIONAL EXPERIENCE:

Project#6

Client: J. C. Penney Company, Inc

Project Duration: May 2018 – till date

Role: Oracle ERP Administrator

Project Type: Production Support-Oracle ERP DBA (Exadata X8,R12.2 EBS,STAT, Panya and OATS)

Description

J. C. Penney Company, Inc. (NYSE: JCP) is a chain of American mid-range department stores based in Plano, Texas, a city north of Dallas. Its business consists of selling merchandise and services to consumers through its department stores and through its Internet Website at jcp.com. It sells family apparel and footwear, accessories, fine and fashion jewellery, beauty products through Sephora inside JC Penney and home furnishings

Responsibilities:

•Cloning of the Oracle EBS Applications of R12.2.5 Instances using rapid clone.

•Applying the patches of both data base and application as per requirement using OPatch

and ADOP utilities.

•Implémentation of TLS1.2 in Oracle EBS Applications.

•Migrating the code using STAT tool from non-prod environments to production.

•Monitoring the DR database sync with production database

•Monitoring the Workflow notification mailer services and rebuild the workflow if it is

necessary.

•Troubleshooting the database performance issues such as long running queries etc.

•Resolving day to day user related issues.

•Apps and weblogic password change activity for every quarter.

•Perform the table re-org for highly fragmented tables.

•Applying the CPU Patches which are released by Oracle for every quarter.

•All schéma password change activity for SOX/audit compliance.

•Tracking invalid objects, compiling and validating the invalid objects.

•Oracle Applications Trouble shooting on Apache (http Server) and Concurrent Manager.

•Supporting the development, Test and UAT instances.

Project#5

Client: Maurices, Inc

Project Duration: Jan 2018 –Jun 2018

Role: Oracle Cloud ERP Administrator

Project Type: Cloud Migration from On premises to Oracle Cloud(EBS,SOA,Hyp..)

Description

Maurices Inc., stylized as Maurice, is an American women's clothing retail chain based in Duluth, Minnesota. Founded in 1931 in Duluth, the chain comprises more than 1,000 stores in the United States and Canada, primarily located in shopping malls and smaller towns.

Responsibilities:

•Worked with network team on VPN compartment.

•Configured DRG, LPG, Route Tables and Security Lists for OCI VPN transit routing.

•Designed OCI architecture, compartments, VCNs and subnets.

•Provisioned EBS cloud manager VM from OCI Marketplace image

•Used IDCS for OCI authentication.

•Créâtes IGW/NGW for public/private subnets and SGW for Object storage.

•Created Security Lists using Terraform code for third party whitelist.

•Provisioned DB systems on VM, associated DataGuard database instances.

•Created LBaaS with listeners, backend sets, path route set and rule set.

•Built compute instances with OCI Marketplace images with iSCSI attached volume.

•Created and configured DR environments, copied backup files to another region using OCI CLI.

•Configured remote peering between two regions.

•Customized SOACS/MFTCS cluster HA PaaS environments provisioning to allocate WebLogic servers

•and DB servers to private subnets.

•Defined network profile for EBS cloud manager.

•Provisioned customized EBS environments from backups in object storage.

•EBS infrastructure architecture design and with external application tier in DMZ, sizing servers and

•Storage for multiple apps servers and RAC DB servers.

•FMW SOA/OSB and ODI architecture design, domain selection and support for enterprise integration.

Project#4

Client: Cardinal Health Care -Dublin, OH

Project Duration: Jun 2017 – till date

Role: Oracle Exadata, Golden Gate and AWS DBA

Project Type: Production Support-Oracle DBA (Exadata X4,X5,GG 12C,Oracle 9i,10g,11g and 12C and AWS RDS)

Description

Cardinal Health has many Oracle Database Server instances to support their hospitals & services operations throughout the World. These Oracle Database Server instances include many modules mainly pharmacies, hospitals and ambulatory care sites etc. There are around 250 databases are supporting which includes oracle 9i,10g,11g and 12c.

Responsibilities:

Exadata X2-2, X3-3,X4-2 and X5 Database Machine administration experience.

Managing oracle databases in a EXADATA environment

Experience using Golden Gate for data replication and migration

Successfully utilized iLOMs for managing and troubleshooting storage cells and compute nodes

Managed Oracle active data guard standby database

Installed ASR and activated Exadata ASR assets for hardware fault monitoring

Used OEM, SRVCTL, and CRSCTL commands extensively to maintain the RAC environment like add/remove node, start/stop clusterware app services

Initiated media recovery, Instance and crash recovery using RMAN and performed database point-in-time recovery

Implementing and testing space optimization methods

Managing the gaps in archive logs to bring the standby in sync with primary database.

Migrating the schemas using traditional exp/imp and Oracle Data pump utilities

Prepared different recovery scenarios using Actifio backups.

Setting up cronjobs for close monitoring of systems .

Performs database re-organization’s as required to assist performance and performed online re-org for DBFS filesystem to reclaim space.

Experience in resolving table space issues for PROD

Experience in various recovery scenarios.

Experienced in maintenance of security infrastructure, identification/authorization security and maintaining Database Security using auditing

Supporting AWS RDS and EC2 instances

Expertise version upgrades for RDS instances using AWS console.

Daily DBA support activities forAWS RDS instances.

Worked on various SOX compliance requests

Co-ordinated and implemented quarterly CPU PSU patches

Planning and executing Quarterly Full stack patching with no downtime (100% availability)

Environment:

Exadata X4,X5,Golden Gate, Oracle 9i,10g,11i and 12C,AWS RDS and EC2

Project#3

Client: Sun Edison Energy - St Louis, MO

Project Duration: May 2016 – Jun 2017

Role: Oracle Applications DBA support (EBS R12.2, SOA, UPK and Hyperion)

Description:

Sun Edison Energy Division currently has different ERP systems like Timberline, SAP, and Oracle R12 implemented across geographies. This project is to phase out all existing ERP systems and build single global ERP instance with Oracle EBS R12.2.4. I am responsible for design, plan and Production support of Oracle R12.2.4 instances, SOA, GRC, UPK and Hyperion environments.

Responsibilities:

Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of application and database issues

Installation of Oracle EBS R12.2.4 instance on single node and multi nodes.

Installation of Vertex OSeries Tax Link and integrate with Oracle EBS 12.2.4

Install GRC(AACG) and configure multiple data sources and integrate with Oracle EBS 12.2.4

Troubleshoot and fix GRC access synchronization, user provisioning issues.

Install SOA 11.1.1.7 on RHEL 6 and integrate with Oracle EBS.

Setup Database links with heterogeneous databases like SQLServer.

Troubleshoot and remediate adworker failures during online patching.

Extensively used adadmin, adctrl, adpatch, adsplice, ADOP,opatch,bsu etc.

Cloning Development, QA, SIT etc. instances using different type’s backups and active database duplication.

Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance

Maintaining passwords through CyberArk.

Configure work mailer with SSL, office 365, import certificates and troubleshooting mailer is-sues.

Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.

Tuning database parameters relative to the EBS systems

Configured ADOP sync driver and resolved sync, custom code issues between RUN and PATCH file systems.

Installation of GL Wand financial reporting tool and integrate with EBS 12.2.4

Installation of Noetix views, a pre-build BI coverage for Oracle E-Business Suite environment.

Environment:

EBS R12.2, WebLogic Administration, GRC, SOA, UPK, Manage Engine, CyberArk and SharePoint.

Project#2

Client: Omnitracs LLc - Dallas, Texas

Project Duration: Apr 2015 – May 2016

Role: Oracle Applications DBA (R12.2)

Description:

Played a major role in database and application upgrade and support and build activities for Omnitracs LLC.

Responsibilities:

Involved in discussions with Omnitracs stake holders for gathering the requirements.

Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Upgraded database from 11.2.0.2 to 11.2.0.4

Upgrade EBS from 11i to 12.2.4

Discoverer installation and configuration

Applying Minimum Baseline, AD TUMS and GDF patches

Registering schemas using edition based redefinition

Weblogic installation and configuration

Apply ADOP readiness report patch and running Readiness report.

Installing and configuring ILINK, Excel for Apps.

Disable and Enable auditing.

Noetix Generator installation, configuration and upgraded noetix views.

Applying WebLogic security patches using BSU(Bea Smart Update)

Running ETCC report to verify DB patches

Running GSS with GATHER_AUTO

Troubleshooting Upgrade issues

Extensively worked on cloning of single and multi-node database and applications.

Provided database support for applications like FMW, AGILE, Vertex and DEMANTRA.

Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.

Manages concurrent programs and reports.

Configure and monitor workflow mailer.

OAF and Form customizations and migrations.

Performing Tuning of applications Concurrent Manager.

Environment:

EBS 11i,R12.2,Oracle 11.2.0.4,Discover Server, Weblogic Administration, Demantra, Noetix, Kintana, QC and JIRA

Project#1

Client: Motorola Solutions Inc., - Schaumburg, IL

Project Duration: Mar 2008 – Apr 2015

Role: Oracle Applications DBA

Description:

Played a major role in database support and build activities of Motorola Solutions Trilogy transformation project along with a team containing 4 members headed by TCS. Trilogy Project was for data transformation from many different systems/Applications running on SAP (ERP) and older versions of oracle to Oracle R 12 (ERP).

Responsibilities:

Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Added/removed nodes to/from a RAC cluster.

Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.

Extensively worked on cloning of single and multi-node database and applications.

Worked on ASM and Non-ASM databases/ troubleshoot ASM issues

Adding and dropping of ASM disks online.

Provided database support for applications like FMW, AGILE, OBIEE, GRCC, Vertex, IAM/OAM, EPM, DEMANTRA and ODI.

Involved in Implementation of Database Vault and Audit Vault.

Extensively worked on Import/export of schemas, tables and complete databases.

Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.

Coordinating and supporting the Business users during CAT (Customer Acceptance Testing).

Provide support for code movement using kintana and manual to production/development/Stage – Implementation.

Environment:

EBS 11i,Oracle 11.2.0.4,Kintana, BMC Remedy, QC and Service Now

Project#1.A

Client: Motorola Solutions Inc., - Schaumburg, IL

Project Duration: Mar 2008 – Apr 2015

Role: Oracle Applications DBA

Description:

Played a major role in database support and build activities of Motorola Solutions Trilogy transformation project along with a team containing 4 members headed by TCS. Trilogy Project was for data transformation from many different systems/Applications running on SAP (ERP) and older versions of oracle to Oracle R 12 (ERP).

Responsibilities:

Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.

Worked on ASM and Non-ASM databases/ troubleshoot ASM issues

Adding and dropping of ASM disks online.

Involved in Implementation of Database Vault and Audit Vault.

Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.

Participated in High availability Testing and Disaster recovery drills.

Extensively worked on Import/export of schemas, tables and complete databases.

Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.

Coordinating and supporting the Business users during CAT (Customer Acceptance Testing).

Environment:

Kintana, BMC Remedy, QC and Service Now

Project#1.B

Project: SETUP

Customer: Motorola Solutions

Role : Oracle Application System Administrator

Responsibilities:

Manages concurrent programs and reports.

Configure and monitor workflow mailer.

Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.

Creation of Responsibilities.

Performing Tuning of applications Concurrent Manager.

Creation of users and assigning the Roles and responsibilities

Creation of custom responsibilities as requested/discussed with client.

Creation of New Profile Options as requested by Clinet

Creation of Menu's, Forms and functions as requested by client.

Value sets and DFF creations

Registering to data group and assigning the profiles.

OAF Migrations

Form Personalization

Oracle Applications patches analysis

Provide support for code movement using kintana and manual to production/development/Stage – Implementation.

Project#1.C

Project: Trilogy

Customer: Motorola Solutions

Role : Oracle Apps DBA

Ensure service availability by proactively monitoring log entries, disk usage, memory usage, CPU utilization.

Handling SRT calls for Critical tickets and providing RCA to management.

Performing Backup’s and Restoration on Database and applications.

Managing Database alerts as for Table space, Listeners, CPU Utilization, Blocking sessions, etc

Applying Patches in Development/Testing/Production instances.

Creation of users and assigning Roles.

Completion of incidents (tickets) in SLA with priority.

Manages concurrent programs and reports.

Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.

Provided 24x7 on-call technical supports.

Project#1.D

Project: Schedule Sharing

Customer: Motorola Mobility

Role : Production Support

Description:

The Project involves Design, Development and Maintenance & Enhancement project of business critical Supply Chain system Schedule Sharing (SS) which enables the facilities to share their forecast and the up-to date receipts and Inventory details with the suppliers on regular basis

SS is a System of communications and guidelines which allows a material consuming organization ("facility") to represent their needs and communicate them to their material providers ("suppliers") who respond and react with the goal of shipping material quantities that achieve the facility target inventory levels.

Responsibilities:

Development, Enhancement and maintenance of the above System and provided end to end support.

Many business critical production bugs have been identified and fixed single handedly.

Worked in SS System replication into two instances and it went live successfully.

I have also involved in Data Base Re-org Activity to improve the Performance of our Batch Scripts which runs on a weekly basis.

Solving the tickets raised by the users through MONET (client application)

Analyzing the Design document thoroughly for feasibility study

Understanding the User Requirements and coming up with a proposed solution for the tickets raised by the customer in MONET.

Working of data from transactional system to Oracle Database by using TCS Specific Tool.

Production maintenance, respond to queries for the project and report to Motorola and TCS Management onsite

Document the changes in standard procedures & methodologies and upload the latest in COMPASS.

Programming Shell scripts for space/processes/listener/oracle alerts monitoring

Using TCS’ Web IPMS tool for tracking the status of work requests and overall project monitoring in accordance with TCS’ iQMS

Contact this candidate