Oracle Manager

[pic] [pic]

Kartheeka Byrichetti

*************@*****.***

Phone: 337-***-****

PROFESSIONAL SUMMARY

. Around 8 years of experience in Oracle Applications administration and

Oracle database administration providing 24/7 support to many

Production, Development, Test instances comprising of some of the more

complex and challenging environments on Various Platforms.

. Extensive knowledge in UNIX platforms includes SOLARIS, AIX, HP and

Linux & Windows platform.

. Experience in Installation, Setup, Implementation, Customization &

Product Support of Oracle Applications 11i - 11.5.8, 11.5.9, 11.5.10,

11.5.10.2 and R12.

. Experience in Installation and configuration of Oracle 8i, 9i, 10g and

11g in UNIX/LINUX, Solaris, AIX and Windows environment.

. Installation of RAC and maintaining RAC database.

. Pre-patch analysis of patches and document preparation with pre and

post patch installation steps.

. Involved in Multiple upgrades and installations of Oracle applications

11.5.10 to R12.

. Upgrade of Databases from Oracle 8i to 9i, 9i to 10g and 10g to 11g.

. Extensively worked on Single node and multi node/Shared architectures

using Autoconfig.

. Extensive knowledge of AD utilities like adpatch, adadmin, adclone,

adident, adctrl, admrgpch etc.

. Implementing, troubleshooting and maintenance of Concurrent Managers

and Parallel Concurrent Processing (PCP).

. Deployed large number of custom codes.

. Installation and configuring Discoverer 10g and 11g and integrated

with EBS.

. Installation of Web logic server.

. Experience in registering reports and printers in Oracle Application

servers.

. Installed R12 on Linux and tested its features for future

implementation prospect.

. Experience on IDM, SSO implementation.

. Proficient in Database Administration activities such as Upgrades,

Patches, TAR-Support, Cloning, Backup and Recovery, Performance

Tuning, capacity planning, script development, and documentation.

. Analyzing new patch releases for each quarter and its implementation.

Applied Rollup Patches ATG RUP5, ATG RUP6, CPU's & HRMS patches.

. Extensive knowledge of Cloning Oracle 11i and R12 Instance using Rapid

clone and manual cloning.

. Experience in administration of Oracle 9i/10g Application server.

. Sizing and planning the database storage. Hot and cold Backup and

recovery of oracle 10g database by Scripting and scheduling using

tools like RMAN.

. Good experience in shell scripting, SQL and PL/SQL.

. Involved in Database performance tuning using STATSPACK, TKPROF, SQL

Trace and Explain Plan.

. Management of schemas, objects & partitioning the tables & indexes.

. Extensive experience with monitoring Oracle Apps, concurrent manager

administration and space management issues.

. Creating and managing user profiles and also creating responsibilities

and assigning to the users.

. Monitoring and managing table spaces.

. Supporting developers and deploying code into the production boxes.

Working on cutover activities along with the developers and business

people.

. Experience in using tools and utilities: SQL Navigator, TOAD, SQL*

Plus, PL/SQL, OEM, Net8, oracle Discoverer and Data Loader

. Have good Analytical and Problem Solving skills and Excellent

Communication and Interpersonal Skills, ability to understand and

adapt to new technologies and environments faster.

. Proven ability to work independently as well as in a team. Ability to

interact with developers, coordinate and manage the tasks assigned,

backed by strong technical knowledge.

TECHNICAL SKILLS

Operating Systems UNIX (AIX 5.3, Linux 4.x, Sun Solaris 2.x/8, HP-UX 11i,

10.x), Windows

ERP Oracle Applications 11i (through 11.5.10.2), R12.1.1,

R12.1.3

RDBMS Oracle8i, Oracle 9i, Oracle 10g, Oracle 11g

Languages SQL, PL/SQL, Java, C, UNIX Shell, Perl

Tools SQL*Plus, tkprof, STATSPACK, OPatch, Oracle Diagnostics

Pack, AD Utilities, Oracle Applications Manager (OAM),

WF Builder, Application Data Export (ADE), Application

Desktop Integrator (ADI), Web ADI, Oracle Enterprise

manger (OEM), Recovery Manager (RMAN), Discoverer, Quest

Software TOAD, Exceed, Telnet, SSH Secure Shell,

X-windows clients,

Web Tools HTML, XML

Fusion Middleware Oracle Application Server(10gAS),Discoverer 4i,Discoverer

10g,Identity management, SOA

PROFESSIONAL QUALIFICATION:

. Bachelor of Engineering in Computer Science, India.

. Oracle Application Server 10g Administrator: Certified Associate

. Oracle 11i Ebusiness Suite OCP

. Oracle R12 E-business Suite OCP.

. ITIL-V3 Certified Professional

TRAININGS UNDERGONE:

. Oracle Database 11g: Administration workshop I at Oracle University.

. ITIL V3 Foundation training at Oracle Corporation

. Oracle 11i/R12, SOA trainings from third party consultant

PROFESSIONAL EXPERIENCE

Client: Walgreens Inc, IL Duration: Sep

2013 to Present

Role: Oracle Applications DBA

Implementation and support of R12.1.3 Oracle E-Business Suite (EBS)

Financial module on Exadata.

. Cloned/Upgraded 11gR2 RAC and ASM with 11gR2 .

. Conversion of single instance database to RAC

. Implementation of GL, FAH, AP, FA modules in R12.1.3 Ebusiness Suite.

. Configured PCP(parallel concurrent processing ) in Multinode RAC

environments

. Configured and used PPM tool for code migrations

. Configured oracle applications database on exadata machine.

. Applied Developer Patch sets.

. Integrated OAM, SSO, OID with Oracle E-Business suite.

. Installed third party software More4Apps financial reporting tools

for Oracle to help upload Excel to

Oracle E-business Suite.

. Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS,

ASM, database and

applications) using ADCLONE utility and ADCFGCLONE on single,

multi and RAC to RAC cloning.

. Created users and assigned the responsibilities to them

. Created new responsibilities and menus for multiple organizations

. Configured Concurrent managers and SSO and Load balancing for

applications (EBS)

. Created Cronjobs for database alerts

. Installed printers and registered them with Oracle Applications

. Supported Oracle APPS R12.1.3 with 11gR2 for day to day activities

. Troubleshooting day to days user problems in oracle apps with

functional and DBA perspective.

. Implemented level0, 1 and incremental backup strategy's using RMAN.

. Placed Cronjobs for backups and for clearing up all logs and a dump

files on daily scale.

. Manage and executing daily DBA tasks for offshore installation,

administration and maintenance of

11gR2 (11.2.0.1) RAC Database with R12 (EBS) in a multi-tier

architecture

. Cloning all Production databases from PROD to UAT, DEV,SIT,TRAIN

. Performing Applications System Administration tasks like Registering

new forms, reports, Fixing Printer

Issues, Setting Profile Options, Creating/Assigning

Responsibilities, Creating APPS Users etc

. Cloning TEST and DEV instance monthly once for resolving PROD

issues and applying patches

. Administration and maintenance of Oracle Apps R12(EBS)with 11gR2 RAC

. Used AWR,TKPROF and ADDM for resolving performance issues

. Worked with Rapid Install, Data installer, AD Patch, AD admin, AD

relink, AD splicer, Adctrl utilities

for oracle applications (EBS) for maintenance

. Configured Oracle 11g, 12c EM & managing multiple databases through

EM.

. Applied Critical patches, one-off, Family pack patches on DEV, TEST

and PROD, used OPATCH for

applying database patches

. Health check and troubleshooting

Client: Laclede Gas,St.louis, MO

Duration: Jan 2013 to Aug 2013

Role: Oracle Applications DBA

Upgradation and Support of R12.1.3 applications with 11gR2 RAC

. Cloned/Upgraded 11gR2 RAC and ASM with 10gR2 data using data pump's

and went live.

. Installed 11gR2 Clusterware and ASM to upgrade from 10gR2 to 11gR2.

. Applied patches on RAC databases and Clusterware.

. Configured PCP(parallel concurrent processing ) in Multinode RAC

environments

. Applied Developer Patch sets.

. Integrated OAM, SOA, Powerplan, OID, OBIEE with Oracle E-Business

suite.

. Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS,

ASM, database and

applications) using ADCONE utility and ADCFGCLONE on single,

multi and RAC to RAC cloning.

. Created users and assigned the responsibilities to them. Enabled

Multi-Org after interacting with

functional team members

. Created new responsibilities and menus for multiple organizations

. Configured Concurrent managers and Apache web server for applications

(EBS)

. Enabled Mobile Web Application (MWA) server through telnet

. Created Cronjobs for database alerts

. Installed printers and registered them with Oracle Applications

. Supported Oracle APPS 11i with 11gR2 for day to day activities

. Troubleshooting day to days user problems in oracle apps with

functional and DBA perspective.

. Implemented level0, 1 and incremental backup strategy's using RMAN.

. Placed Cronjobs for backups and for clearing up all logs and a dump

files on daily scale.

. Supported Hyperion, Maximo, Powerplan and CC&B environments

. Manage and executing daily DBA tasks for offshore installation,

administration and maintenance of

11gR2 (11.2.0.1) RAC Database with 11i/12i (EBS) in a multi-

tier architecture

. Cloning all Production databases from PROD to UAT, DEV, IT1, IT2

. Checking Alert log, Apache log, and concurrent manager log files

daily

. Performing Applications System Administration tasks like Registering

new forms, reports, Fixing Printer

Issues, Setting Profile Options, Creating/Assigning

Responsibilities, Creating APPS Users etc

. Cloning TST and DEV instance monthly once for resolving PROD

issues and applying patches

. Administration and maintenance of Oracle Apps R12(EBS)with 11gR2 RAC

. Used AWR,TKPROF and ADDM for resolving performance issues

. Worked with Rapid Install, Data installer, AD Patch, AD admin, AD

relink, AD splicer, Adctrl utilities

for oracle applications (EBS) for maintenance

. Configured Oracle 11g, 12c EM & managing multiple databases through

EM.

. Created users and assigned the responsibilities to them. Enabled

Multi-Org

. Extensively worked on Oracle Financial s (AP, AR, and GL)

. Developed scripts to Monitor Table space issues

. Applied Critical patches, one-off, Family pack patches on DEV, TEST

and PROD, used OPATCH for

applying database patches

. Health check and troubleshooting

Client: Oracle India Pvt. Limited, Hyderabad India

Duration: Aug 2008 to Nov 2012

Role: Technical Analyst - Oracle Applications DBA

Major responsibilities:

. Worked in 24x7 Production Oracle Applications Administration.

. Support for Production, Development, Test, Staging and UAT Instances.

. Performed database upgrade from 10g to 11g.

. Working closely with Functional/Developers and helping them in issues.

. Implemented PCP.

. Periodic cleaning of Log/Output files.

. Compiling invalid objects in the database.

. Registering users, responsibilities and Organization ID's.

. Organizing table spaces, data files and other database objects as per

OFA standards.

. Managing schemas, tables, tablespaces, datafiles, dblinks.

. Scheduling and Administration of backups and recoveries strategies.

. Creation of menus, request groups and responsibilities.

. Taking care of performance issues, created indexes and rebuilding the

table structure whenever necessary.

. Patching, cloning, using AD utilities like adpatch, adadmin, admrgpch,

adclone.

. Database and Application cloning from production to test instances.

. Monitoring and handling Concurrent Managers related issues.

. Monitoring and administrating Oracle Workflow.

. Registration of New Oracle Apps users and System Printers.

. Administering and configuring Oracle HTTP web server

. Single-node Install & Multi-node Install of R12 Oracle Applications on

test instances as part of future enhancements.

. Support functional and development teams for customization or

development requirements.

. Good hands on experience in using tools TOAD, SQL* Plus, PL/SQL

. Deploying Code and testing on development instances once the

developers provide code builds migrating the deployment to production.

. Auditing the Database at the user, object, session and privilege

levels.

. Monitoring the instance statistics and tuning the database to improve

performance.

. Good knowledge in system architecture of 11i Applications

implementation of various Financials and CRM modules like GL, AP, AR,

FA, OR and SCM etc.

. Compiling or registering forms using f60gen utility.

Client: InetFrame Technologies, Bangalore India.

Duration: June 2007 to July 2008

Role: Oracle Applications DBA

Major responsibilities:

. Guarding and administrating environments for Production, Development,

Test, Staging and UAT Instances.

. Developing, registering custom forms and reports for Oracle Apps.

. Single-node Install & Multi-node Install of R12 Oracle Applications on

test instances as part of future enhancements.

. Scheduling and Administration of backups and recoveries strategies.

. Involved in a custom tool for code migration process using shell

scripting.

. Patching, cloning, using AD utilities like adpatch, adadmin, admrgpch,

adclone.

. Database and Application cloning from production to test instances.

. Monitoring and handling Concurrent Managers related issues.

. Creation of menus, request groups and responsibilities.

. Monitoring and administrating Oracle Workflow.

. Registration of New Oracle Apps users and System Printers.

. Compilation of custom forms and libraries.

. Administering and configuring Oracle HTTP web server

. Configuration on Workflow Notification Mailer.

. Worked with functional and development teams for customization or

development requirements.

. Good hands on experience in using tools TOAD, SQL* Plus, PL/SQL

. Code migration and testing on development instances and migrating the

code to production.

. Monitoring and Auditing the Database at the user, object, session and

privilege levels.

. Reorganizing the database to reduce disk contention, migration and

chaining.

. Monitoring the instance statistics and tuning the database to improve

performance.

. Creating Users and Assigning the Responsibilities.

. Registering Concurrent Programs.

. Performed database upgrade from 9i to 10g.

. Periodic cleaning of Log/Output files.

. Organizing table spaces, data files and other database objects as per

OFA standards.

. Compiling or registering forms using f60gen utility. Compiling invalid

objects in the database.

. TAR management with Oracle support.

Client: ALCOA, Pittsburg PA Duration:

May 2006 to May 2007

Role: Oracle Applications DBA

Major Responsibilities:

. 24x7 Production support for Oracle Applications (11.5.10.2)

Administration and Database Administration including Oracle 10g.

. Implementation of Oracle E-Business Suite 11i Architecture in SSL &

DMZ Configuration.

. Involved in upgrade of Oracle applications 11.5.8 to 11.5.10.2.

. Involved in upgrade of Oracle Database 9i to 10.2.0.2.

. Managing, troubleshooting and resolving oracle database, and EBS 11i

issues.

. Installed R12 on Linux and tested its features for future

implementation prospect.

. Supporting development teams. AR, AP, GL, HR, INV modules were

supported. Custom code written by the developers was deployed into the

server.

. Pre Patch Analysis.

. Cloning Oracle 11i Instance using Rapid clone and manual cloning.

Cloning from multinode Production instance to single node development

instance.

. Implemented AUTOCONFIG in Apps environment and used ADCONFIG, ADBLDXML

commands.

. Configuring Workflow Notification Mailer settings according to the

test environment.

. Handling Production Crisis calls - Tier 3 support and finding the RCA.

. Monitoring Apache logs to troubleshoot Web connection issues & Alert

log to troubleshoot database issues.

. Tuning concurrent manager and troubleshooting the concurrent manager

and handling PCP issues.

. Working on Apache server, Forms and report servers. Bouncing server or

trouble shooting the servers.

. Experience in using tools TOAD, SQL* Plus, PL/SQL.

. Debugging errors, supporting the users.

. Doing periodic health checks on the oracle applications and data base.

Taking periodic backups.

. Monitoring Table spaces and users connected to the database by using

10g OEM GRID CONTOL.

. Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain

Plan.

. Compiling or registering forms using f60gen utility. Compiling invalid

objects in the database.

. Creating Application users, Profiles, Responsibilities, Menus,

Functions for the user.

. Worked closely with user group to ensure timely implementation of ERP.

. Performance tuning of Oracle Applications, database and queries.

. Raising TAR's and working with oracle in solving the issues.

. Writing shell scripts to automate post cloning work.

. Writing cronjobs and scheduling the requests.

Client: Convergys, Hyderabad India

Duration: July 2005 - Apr 2006.

Role: Oracle Database Administrator

Major responsibilities:

. Creating and sizing of database objects ( tablespaces, tables and

indexes)

. Installation of Oracle Application. And Oracle 9i (9.2.0.3) on Red Hat

Linux AS3.

. Rebuilding indexes for faster access and to reduce disk I/O.

. Management of Users, Roles and Privileges.

. Performing all the Database Administration activity like space

management in database, user and roles administration, schema

management, checking alert log of all the databases.

. Performed database performance monitoring and tuning using

UTLBSTAT/UTLESTAT, STATSPACK and SQL scripts.

. Diagnose the bottlenecks and problems causing poor performance.

. Performance tuning of the database like Memory Allocation Tuning, I/O

Tuning and Tuning Contentions.

. Used Tkprof, Explain plan, hints, and SQL Trace utilities for SQL

tuning.

. Remote Database Maintenance.

. Planning Backup and Recovery Strategies for various database

environments.

. Carried out Backup and recovery with Online - HOT and Offline - COLD

strategy.

. Cloning/ Refreshing the Oracle Databases from Production environment

to Test, Development, and other instances as needed.

. Pre-patch analysis for patches and document preparation with pre and

post patch installation steps.

. Applying RDBMS Patches on Development, Test Instances and promoting

them to Production.

. Recovery of Database.

. Partitioning strategies for very large tables. Partitioned large

objects to improve the query performance and manageability.

. Used Export, Import for database backup and defragmentation and SQL*

Loader for data loading.

. Created stored procedures, packages, tables, indexes, views,

partitioned objects, synonyms, and sequences.

. Created Database Link for remote database access.

. Used Job scheduling for purging temporary tables such as Audit trails

on a periodic basis.

Contact this candidate