Oracle Manager

Karthika Byrichetti

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

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

PROFESSIONAL SUMMARY

• 7 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

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’s of Technology

• Oracle Application Server 10g Administrator: Certified Associate

• Oracle 11i 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 trainings from third party consultant

PROFESSIONAL EXPERIENCE

Client: Grainger, Chicago Il Duration: Oct 2010 to PRESENT

Role: Oracle Applications DBA

Implementation and Support of 11.5.10.2 applications with 11gR2 RAC

• Interacted with the Client/offshore to plan the installation.

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

• Cloned/Upgraded 11gR2 RAC and ASM with 10gR2 data using data pump’s and went live on new hard ware

• Installed and configured RAC setup for 11i (EBS) on 11gR2 RAC and ASM.

• Applied patches on RAC databases and Clusterware.

• Configured PCP(parallel concurrent processing ) in Multinode RAC environments

• Applied Developer Patch sets.

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

• Administrating and responding to Oracle Tar’s

• 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

• Health checkup of oracle application instances (Vision, Test, Development and Production)

• Checking Alert log, Apache log, and concurrent manager log files daily

• Supporting of various modules include AP, AR, GL, INV, I Store, WMS, PO, OM, Telesales, BOM etc

• 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 11i(EBS) (11.5.10 ATG RUP4) with 11gR2 RAC

• Used AWR,TKPROF and ADDM for resolving performance issues

• Installed new languages and products for rollover to other countries

• Worked with Rapid Install, Data installer, AD Patch, AD admin, AD relink, AD splicer, Adctrl utilities for oracle applications (EBS) for maintenance

• Configured OEM on RAC 10g/11g database

• Designed Online/Off-line Backup and recovery strategy using RMAN. Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.

• 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 Sep 2010

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