Oracle Manager
Resume:
NARESH GANGIREDDY
***********.******@*****.***
Ph: 917-***-****
PROFESSIONAL SUMMARY:
Expertise in Oracle Applications Architect and E-Business DBA in production, development and test environments.
Good experience in Oracle E-Business patching, upgrading and Load balancing.
Expertise in Oracle Application and Database Administration experience on variety of Database versions 10g,
11g on UNIX, Solaris, HP-UX, AIX, Linux, Windows NT 4.0/2000 with HRMS, (HR, Payroll), Financials (AP,
AR, GL, FA), Order Management, Compensation, modules using Apps (12.13 11.5.10), Oracle Application
Server 9iAS, Developer (Forms 9i and Reports 9i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers
etc).
Experience in Oracle Database Administration, Oracle Applications, Analysis, Design, Server Optimization
Techniques, Production environment and Applications support
Experience in developing applications using OBIEE.
Applied Oracle application patches, DST patches, critical patches, security patches, end of the year patches,
mini packs, family pack patches and Oracle database patches using Opatch utility.
Well versed in Rapid Install, adpatch, adadmin, adsplicer, adlicmgr and adctrl utilities for Oracle Applications
and involved in Apache Load Balancing.
Oracle Applications cloning from Production to Test, Dev and Patch instances using Rapid Clone. Installed SOA
suite on oracle E -Business suite 11.5.10 and 12.1.3
Experience implementing Oracle Single Sign-On (SSO), Oracle Internet Directory (OID), Oracle Identity
Management, Oracle Grid Control, Oracle SOA Suite, Oracle Business Intelligence Enterprise Edition (OBIEE),
Oracle Data Integrator, Oracle Transportation Management (OTM), Real Application Clusters (RAC), or high-
availability Oracle operating environments.
Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention
Resolution, Defrag etc. scenarios for the various Environments.
Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
Scripts to take HOT, RMAN and Export Backup daily and Cold Backup weekly.
Configured the following according to DMZ requirements: Oracle WebCache, Oracle HTTP Server, Oracle
Single Sign-On Server, HTTP Loadbalancer, Secured HTTP (HTTPs), Oracle Internet Directory.
Good experience and knowledge in Oracle Applications system administration such as Managing Concurrent
Programs and Requests, Configuring Printers, Reports, Administering Concurrent Managers and Work Shifts,
User Registration (RBAC), Customization and Assignment of Responsibilities, Incorporating Custom programs
and Managing Profile Options.
Troubleshooting Login, Self Service Application, Concurrent Processing, Jinitiator and Network related issues.
Automated regular activities like hot backup, daily database refresh, database health check and space monitoring
using shell programming and Building Schema Index bugs
Good knowledge of Oracle XML Publisher, developing the XML Reports in Microsoft word and integrate to the
Oracle E-Business Suite.
Expert in installation, configuring, managing and troubleshooting of Oracle Audit Vault (10.2.3) on AIX, HP-
UX and Linux. Experience in implementation RAC Database with 2 and 4 nodes.
Installed Oracle Cluster s/w, database 10g and implemented two nodes 10gRAC on Linux Environment.
Creating maintaining, Tuning Standby databases, Disaster recovery using data guard Broker.
Creating high availability environment using Oracle Real Application Clustering (RAC), 10g Grid, RMAN,
Flashback Query, ASM, OEM, Diagnostics, Tuning, Configuration and Provisioning Pack.
Expertise in Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, and Separating
of tables and indexes on different locations. Applications Tuning of Database using EXPLAIN PLAN, TKPROF,
SQL TRACE, ANALYZE, HINTS etc.
Analytical problem solving and a good team player with strong interpersonal and communication skills.
TECHNICAL SUMMARY:
Oracle Applications 12.1.3,12.0.6, 11.5.10, 11.5.9, 11.5.8, 11.5.7, 11.5.5, 11.5.2 Forms
ERP environment 6.0, 4.5, 10g. Reports 6.0, 4.5, 9i, 10g.
Third Party tools EMC TimeFider, SRDF (disk to disk mirroring), IBM XIV Snapshot, Shareplex
(Object level replication) Noetix, Veritas software, OID, Oracle Portal, Erwin and
DBArtisan, SQL* Loader, VMware Workstation.
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK
DB Management: TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control (RAC), RAT.
Databases Oracle 11.2, 11.1.0.6,10.2.0.4,10.2.0.3,10.2.0.2, 9.2.0.7, 9.2.05, 9.2.0.4, 8.1.7.4(32,64-
bit)
Programming Unix Shell Scripting PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, SQL,
PL/SQL, HTML,
Operating Systems HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RED HAT
LINUX 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server
3.0.x/3.5.0.
Hardware SunFire 15K with 72 CPUs 144GB Memory, SunFire 6900 with 40 CPUs 80 GB
Memory, E6900, IBM XSERIES_346 with 4 CPU’s 12GB Memory.
PROFESSIONAL BACKGROUND:
Client: Kinetic Concepts Inc JAN’10 to till date
Project: TSS - Data Extracts
Role: Oracle Applications Architect
Project Description: Extracting Oracle E-business data to 3rd party applications.
Designed E-Business suite Architecture for data extract project.
Implemented automated cloning scripts using shell scripting.
Involved with off-shore development team to design PLSQL using CM tiers ‘utl_file_dir’ for the extracts.
Created scripts to zip US and EMEA data extracts and Split 5 TB data to 600 MB each.
Created scripts to move split files from internal CM tier to External FTP server for new company FTP
Prepared end-to-end documentation/Cookbook for the Data Extract Project SIT / UAT.
Prepared scripts to end date EBS users according to ORG ID.
Prepared automated cloning scripts and deployed to TEST/DEV/QC environments (RAC and non-RAC).
Worked closely with the Network team to resolve issues with the FTP process.
Helped the client with Change Management / Code migrations for the packages which were delivered by off-
shore development team.
Migrated custom Configurations using tools such as FNDLOAD, Oracle iSetup, Oracle Change Management
(OEM)
Project: TSS - Divestiture Project
Role: Oracle Applications Architect / E-Business DBA
Project Description: Divestiture one Oracle E-Business system to two Systems.
Designed architecture of Oracle e-Business Suite R12 / OBIEE / Custom Applications
Analyzed and provided solutions/recommendations on Oracle System Architecture (Oracle e-Business Suite R12
/ SOA / OBIEE)
Created Cookbook - 40 hrs implementation in-detail and in sequence - tasks, scripts, patching and sub-setting.
Captured timings with earlier Cookbook run and automated most of the configurations using FNDLOAD and
shell scripts.
Configured and setup of Oracle 11gR2 RAC databases with ASM storage for OBIEE
Configured Informatica_ILM_5.3.6 ILM_STAGE Schema for Sub setting and Masking Organizational
Divestiture.
Prepared E-Business cloning scripts using IBM XIV Snap shots, for Sub setting and Masking using Informatica
ILM.
Designed architecture of Oracle e-Business Suite R12 and its Oracle Database 11g for Disaster Recovery at
Production Site level.
Prepared automated cloning scripts to create TEST/DEV/QC environments (RAC and non-RAC).
Worked closely with the client and provided recommendations on deployment best practices after Go-Live
operations.
Helped the client with Change Management / Code migrations of different Oracle E-Business Suite, SOA,
Custom Applications using Source Control SVN
Migrated custom Configurations using tools such as FNDLOAD, Oracle iSetup, Oracle Change Management
(OEM)
Implemented iSetup module on R12 for migrating setups from source to target. Expertise with iSetup tools such
as iSetup migrator, iSetup reporter and iSetup administration.
Client: IBM / Kinetic Concepts Inc JAN’10 to
APRIL’12
Project: Oracle E-Business Suite R12 (12.1.3) Upgrade
Role: Oracle Applications Architect / E-Business DBA
Project Description: Upgrading from E-Business from 11i to R12
Performed Oracle E-Business Suite R12 upgrade complete steps along with its database upgrade to
Oracle11gR2.
Upgrade from Oracle Applications (E-Business Suite) 11i (11.5.9, 11.5.10) to R12/12i (12.0.6).
Migrated Oracle10gR2 database directly to Oracle11gR2 database using transportable table space model.
Captured timing of upgrade steps, analyzed and compared its timing with its previous runs.
Documented details upgrade steps and provided to offshore and onshore DBA team members.
Implemented Rapid Cloning procedures for Oracle E-Business Suite instances using EMC BCV splits.
Sync Split activity (hot and cold) through EMC BCV's.
Maintained and supported different releases of Oracle E-Business Suites.
Involved in analyzing the patches, applying patches, applications performance tuning, troubleshooting
outstanding issues.
System Administration activities like user creation setups, creation of function, menus, responsibilities, register
concurrent programs, printer setup.
Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM
down issues etc.
Provided support to both technical and functional team.
Developed procedures for Oracle Database Backup and Recovery.
Scheduled Go-Live team meeting; provided architectural recommendations on Oracle E-Business Suite R12
environment to handle the post go-live issues such as system hang, database performance, Oracle SOA service
intermittent restarts, application performances etc.
Performed health checks of client's E-Business Suite environments and recommended to scale up the database
and concurrent manager servers.
Prepared both detailed and high level Project Plan with time and parallel activities to meet the go-live downtime
period.
Implemented security in a DMZ environment. Like Implementing SSL, Implementing an external firewall,
implementing a reverse proxy between the external users and the external web server.
Lead the client DBAs team and off-shore DBA teams with detailed action plan on performing tasks.
Troubleshot Concurrent service and Concurrent manager issues.
Developed custom build patch script using SVN Version history and the driver file.
Project: Global COA
Role: Oracle E-Business DBA
Project Description: Changing the Accounting structure from a 5-segment chart to a 9-segment chart globally.
Responsible to manage clone Create and Maintain E-Business instance
Configured ‘eprentise’ Transformation software for 11i E-Business Suite.
Analyzing the database table space, performance tuning, troubleshooting outstanding issues while ‘eprentise’
software is running.
Scripted custom code migrations of Oracle E-Business Suite R11i database using a driver file.
Integrated source control (SVN) to Oracle E-Business Suite for auto deployment of client custom code.
Tuning system I/O, which includes Separating of Data files and Redo log files on different locations, and
Separating of tables and indexes on different locations. Applications Tuning of Database using EXPLAIN
PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS while ‘eprintise’ load is running.
Database health check, pinning of objects, Monitoring the Database Growth and increasing the tablespace sizes,
Reorg of Tablespaces, Identifying and Recompiling invalid schema objects and Building Schema Index bugs.
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch,
Security patches etc on 11.5.10.2 instances.
Customized technology stacks components (Apache, Form servers).
System Administration activities like user creation setups, creation of function, menus, responsibilities, register
concurrent programs, printer setup.
Wrote UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing
exhaustive documentation for all activities performed.
Using Export, Import and Loading data using SQL*Loader, Punchout and Bulk Loader.
Implemented backup and recovery strategies using RMAN (Recovery Manager).
Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM
down issues etc. Periodically purged log files, trace files, concurrent request log and out files.
Performing performance tuning by using Oracle utilities like StatsPack, AWR report for addressing performance
bottlenecks.
Prepared Go-live Cutover Document and shell scripts to meet time line and parallel activities during the go-live
downtime period.
Project: EMEA Oracle E-Business Implementation
Role: Oracle E-Business DBA
Project Description: New Implementation of Italy/Austria/Japan/Switzerland to Oracle E-Business
Installed Oracle Applications E-business suite 12.0.6 on RHEL 5.1 Kernel- 2.6.18-53 Multi-node installation
and upgraded oracle applications E- Business suite 11.5.10 to R12 and 10gAS.
Used Oracle Application maintenance utilities like adadmin, adpatch, adctrl and adrelink etc.
Implemented iSetup module on R12 for migrating setups from source to target. Expertise with iSetup tools such
as iSetup migrator, iSetup reporter and iSetup administration.
Used Oracle iSetup for comparing, transforming and automating of setups from source instance to target
instance. Customized technology stacks components (Apache, Form servers).
Installed subversion 1.6.x (SVN) a version control for scripts developed, R12 patches using a fast secure file
system (FSFS) repository and Berkley DB.
Developed Server hook scripts (UNIX) when a file is locked/unlocked, Email group list when a file is
committed, Checks for Parallel development of files in Subversion repository.
Development Client batch scripts (windows) for deployment of patches from client machine to subversion
repository.
Installed and configured oracle 10giAS, OID, Idiscoverer via the Application Server Portal.
Implemented security in a DMZ environment. Like Implementing SSL, Implementing an external firewall,
implementing a reverse proxy between the external users and the external web server.
Expertise in managing and troubleshooting Oracle Audit vault, Database vault, using tools AVCA, AVCTL,
AVORCLDB.
System Administration activities like user creation setups, creation of function, menus, responsibilities, register
concurrent programs, printer setup.
Configured Oracle 10G Data Guard for disaster recovery. Implemented Oracle 10G Flashback feature for
recovery operations. Data export/import using Data pump an oracle 10g feature.
Performing day-to-day database and oracle apps tasks like code movements, package and Oracle Database
Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g RAC.
Environment: Oracle applications 12,11.5.10.2, Oracle 10g,, 11g 10g RAC, RMAN, 10g Data Guard, Oracle 10g
Flashback, Datapump, PL/SQL, SQL *Loader, tkprof, Statspack,Pstools, Forms 6.0, 4.5, Report builder, OBIEE
10g/11g, Subversion SVN, Oracle Application Express.
Client: TJX Company INC. OCT’07 to
NOV’09
Role: Oracle E-Business DBA
Responsible to Support Oracle E-business Suite 11i and Administration on 24x7 critical production and large databases
of over 4 TB using Oracle 10g RAC.
Responsible for both creation and manage Production, Development, Unit and Test instances of Oracle Version
9.2.0.6,10g & Oracle Applications 11.5.10.2 on windows 2003.
Installed Oracle Applications E-business suite 11.5.10.2 (Single node and Multi-node installation) and upgraded
oracle applications E- Business suite 11.5.8 to R12 and 10gAS.
Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log
monitoring and many other maintenance activities.
Installed and Configured Oracle Application Server 10g(10.1.2.x & 10.1.3.x SOA) with Portal and Discoverer as
an active applications.
Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in
developing exhaustive documentation for all activities performed.
Experience in taking Export, Import and Loading data using SQL*Loader, Punchout and Bulk Loader.
Used Oracle Application maintenance utilities like adadmin, adpatch, adctrl and adrelink etc.
To Review the team members weekly status reports, preparing Customers Monthly status Report.
Database health check, pinning of objects, Monitoring the Database Growth and increasing the tablespace sizes,
Reorg of Tablespaces, Identifying and Recompiling invalid schema objects and Building Schema Index bugs.
Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory.
Installed and configured oracle 9iAS, 10giAS, OID, Discoverer, Idiscoverer via the Application Server Portal.
Configured Oracle 10G Data Guard for disaster recovery. Implemented Oracle 10G Flashback feature for
recovery operations.
Data export/import using Data pump an oracle 10g feature. Data movement using Transportable Tablespaces.
Cloning Oracle Applications 11.5.10.2 for testing and development purpose.
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch,
Security patches etc on 11.5.10.2 instances.
Customized technology stacks components (Apache, Form servers).
Implemented backup and recovery strategies using RMAN (Recovery Manager).
Troubleshot Concurrent service and Concurrent manager issues.
Day to day monitoring and maintenance of automated BPEL workflows.
Creation of Reports through report builder, reports registration, forms registration etc on 10g RAC.
Strong experience in performance tuning Crystal Reports, SQL and PL/SQL.
Performed disaster recovery, wide area network data transfer and data warehousing purposes using MGA.
Installed, configured and maintained Oracle 10g Real Application Cluster (RAC) . Production support for Oracle
database 9i/10g/10g RAC and SQL server 2000.ASM and CRS installation and new database creation for 10g
RAC.
SSL and DMZ implementation, Mentoring and Training on topics including: Perl, LDAP, MS Exchange, UNIX,
Configuration Management, System Administration and Systems Architecture and Regression Testing.
Performing day-to-day database and oracle apps tasks like code movements, package and form compilations and
troubleshot various issues related to java class deployment using load java. Oracle Database Administration on
24x7 critical production and large databases of over 4 TB using Oracle 10g RAC, 9i, 8i, 7.
Environment: Oracle applications 12,11.5.10.2, Oracle 9i, 10g,10g RAC, RMAN,10g Data Guard, RAT,Oracle
10g Flashback, Datapump, SQL *Loader, tkprof, Statspack,Pstools, CWRsync, Forms 6.0, 4.5, Report builder
Client: Value Momentum JAN’06 to SEP’07
Role: ORACLE APPS DBA
Provided apps DBA support to Value Momentum which is a global provider of professional services and pre-packaged
IT solutions to the Insurance and Financial industries. Being an Oracle Application DBA I was responsible to Support
Oracle E-business Suite 11i.
Responsibilities:
Responsible for, both manage and support all Production, Development and Test instances of Oracle Version
9.2.07, 9.2.0.5 & Oracle Applications E-Business suite 11.5.9, 11.5.8, 11.5.2 and 10gAS.
Maintaining (VLDB) OLTP databases in 24x7 Production environments on Multiple Applications Tiers with
Load balancing of forms tiers. Upgraded QA instance from 11.5.9 to 11.5.10.
Implemented a 10g Application Server with Oracle Single Sign-On (SSO).
Handled database migrations of Oracle Applications 11.5.10 production (3-tier), test and development instances.
Cloning Oracle Applications 11.5.10 from production system, for testing and development purpose.
Managing and working on different 11i modules, Application Developer (AD), Financials, Service Contracts,
Order Management, Advanced Pricing, and Discoverer.
Worked on Configuration of Parallel Concurrent Processing (PCP).
Implemented a Green Belt Project by developing automated complete clone Using shell scripting. The script is
designed to perform preclone, database removal, restoration (datafiles and application binaries restoration), db
recover, Adconfig (on both DT and AT), postclone, generating validation report in HTML format.
Developed a UNIX shell script to reduce the restoration (datafiles) to half the actual time.
Installing Oracle Internet Directory with Microsoft Active Directory and Integrating Oracle Application Server
with Microsoft AD synchronization in Oracle E-business suite 11.5.10.2.
Implemented the rsync methodology to reduce the time on restoration of binaries during a clone.
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch,
Security patches etc on 11.5.2 through 11.5.10 instances.
Fine tuned Memory, I/O and Database Objects.
Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic
Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
Worked with SQL Performance Analyzer(SPA) to allows for the comparison of SQL performance statistics for
changes in response times for SQL after making any change, like parameter changes, schema changes, hardware
changes, OS changes, or Oracle upgrades.
Maintenance tasks like bouncing the production database, services through veritas.
Implemented security in a DMZ configuration.
Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking
whether all databases are running, listener is running, disk space availability, checking for errors in alert logs
etc and Building Schema Index bugs.
Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking
issues etc.
Troubleshot Concurrent service and Concurrent manager issues
Sync Split activity (hot and cold) through EMC TimeFinder using BCV's.
Document standards and operating procedures.
Proficiency in the tools and utilities bundled with Oracle Software viz. Export, import, RMAN, listener,
sqlplus, OEM (Oracle Enterprise Manager), Oracle Grid control, Perl, Java, Oracle Streams and RAC. Worked
with Replication tools such as BCV Splits. Configured and Maintained Physical Data Guard for High
Availability and offline reporting.
Environment: Oracle applications 11.5.10, 11.5.9, Oracle 8i,9i, Sun Solaris 2.10, EMC TimeFinder, SRDF,
PL/SQL, SQL*Loader, SPA, statspack, tkprof, Forms 6.0, 4.5, Reports 6.0, 4.5, OID.
Client: National City Bank FEB’05 to
NOV’05
Role: Oracle Apps DBA
Provided apps DBA support to National City Bank for multiple large databases in production, development and test
environments.
Responsibilities:
Installation of Oracle Application 11.5.2.
Cloning of Application Instance -- Single node to two node Using AD Clone. Applied the patches using
ADPATCH.
Performed Application admin tasks using ADADMIN utility. Applied India Localization patches & resolving
with Oracle.
Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs
and Request Groups.
Created Responsibilities and Application Users System Administration of 11i Setting up of printers in
applications.
Maintenance of concurrent processing requests and concurrent managers. Created and resized the new Data
files. Pinning of Packages, Procedures and functions in SGA Run preparatory scripts -- admin server.
Reset ORACLE schema passwords update configuration-related profiles apply product customizations to
environment and files.
Set rollback segments for normal use validate and compile APPS schema Creation of Schema objects and Space
Management. To take backups as per the corporate policy and perform recovery as and when required.
Developed Data Loading Scripts designed the database structures for the custom module Performed the
maintenance of Database and Production support.
Environment: Oracle applications E-Business suite 11.5.2, 11.0.3, Oracle 8i, SunSolaris 2.2, EMC TimeFinder,
SRDF, PL/SQL, Forms 4.5, Reports 4.5.
CERTIFICATIONS:
OCA - Oracle Database 11g Administration
EDUCATIONAL QUALIFICATIONS:
Bachelor of Engineering (B.Tech) from JNTU, Hyderabad India.
Contact this candidate