Oracle Applications DBA

K Chaitanya

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

Ph: 949-***-****

EXPERIENCE

Oracle Applications DBA with 10 Years of experience in Oracle Applications, Oracle Database, Oracle Real Application Clusters (RAC) & Oracle Fusion Middleware Technologies.

Extensive Oracle Apps DBA experience ranging from EBS versions 11.x thru R12.1.x, R12.2.x and databases ranging from version 9.x thru 11g&12c.

Lead DBA supporting implementations and upgrades of EBS 11i to R12 including platform migrations.

Extensive experience in leading Oracle Apps DBA supporting Financials, HRMS, Supply Chain and Manufacturing modules.

Provided a health check of production EBS to address many instability and performance issues and documented findings and implement recommendations.

Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

Actively participate with project management team in strategic planning, goal setting and monitoring, providing status updates on a regular basis.

Aggressively ensures Service Level Agreements (SLA) goals are successfully met by DBA team

Proficient in multiple, large RDBMS Administration, Server Installation & Performance Tuning, Security Management, Backup & Recovery, Data/Code Migration & Data Integration of Oracle11g,10g &9i.

Extensive experience with Oracle RAC install and configuration using ASM on Oracle 10g/11g database.

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Hands-on experience in Oracle Standby databases and setting up Active Data Guard 11g.

Experienced in Oracle Fusion middleware technologies such as Discoverer, OBIEE.

Experience in performance tuning techniques, backup and recovery processes, database design and management, client interaction and support.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Setup Oracle Enterprise Manager (OEM) 10g, Grid Control 11g & Grid control 12c for database monitoring/performance/diagnostics.

Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.

Good experience in applying PSU and Critical Patch Update (CPU Patches) using Opatch Utility on Databases, Application Servers and Middle Tiers.

Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g by applying patches, patch sets and critical patch updates.

Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable table spaces.

Proficient with UNIX Shell Scripting, Partitioning, Rebuilding Indexes, Gathering Statistics, Logical and Physical database design.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)

Efficient in standardizing best database practices, processes and auditing databases for security.

Responsible for communicating and collaborating with client stakeholders, system architects, software engineers to establish a clearly defined and comprehensive view of all data and relationships necessary to support the system.

Excellent communication, project management and organization skills.

TECHNICAL SKILLS

ERP

Oracle E-Business Suite 11.5.9, 11.5.10(2), R12.0.x, R12.1.x, R12.2.5

Fusion Middleware

WebLogic Server, SOA, OBIEE

Databases

Oracle 9i/10g/11g, 12C, Oracle RAC 10g/11g

Application Services

9i/10g iAS

Operating Systems

Red Hat Linux, Sun Solaris, IBM AIX, HP-UX, Windows, DOS

Programing Languages

SQL, PL/SQL, Shell Scripting

EDUCATION:

Bachelors of Engineering from Acharya Nagarjuna University, India

Pre-University in Maths, Physics and Chemistry, from Board of Intermediate, India

PROFESSIONAL WORKEXPERIENCE

Senior Oracle Applications DBA – Active Health Management, CA Jul’16 –Present

Responsibilities:

Administration of Oracle E-business suit R12.2.5 applications.

Patching Oracle EBS R12.2.5 instances using ADOP utility and phases.

Cloning and refreshes of Oracle EBS 12.2.5 Instances.

Installation and upgrade of Oracle database 11G to 12c (12.1.0.2)

Scaling up Managed servers (oacore) for EBS R12.2 environment.

Install and setup PCP for failover and failback concurrent requests.

Tuning Concurrent Managers Parameters and settings for Custom Concurrent Manager.

Provide patch analysis and patch impact analysis using patch wizard.

Applied application and database patches using Adop and Opatch utilities.

Extensive experience in AD utilities like Adadmin, Adctrl, Adsplice etc.

Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environment.

Administration of Oracle E-Business Suite concurrent managers, jobs, PCP.

Troubleshoot and resolve Oracle EBS and databases related issues.

Open and follow-up with Oracle on service requests for Apps and DB related issues

Configuration of Oracle workflow notification mailer

Monitor and maintain Oracle databases health using Grid control (OEM)

Performed production disaster recovery testing of EBS 12.2.5 for Business continuity.

Document critical issues with root cause analysis, provide timely resolution of service tickets.

Environment:

Oracle E-Business Suite R12.2.5, 11g /12c, OAM 12C, Solaris, Active Dataguard (DR)

Lead Oracle Applications DBA – Nexref Technologies, Dallas, TX Oct’15 – Jun’16

Responsibilities:

Installation, Administration and maintaining Production Apps R12 instances.

Advanced configurations - Load Balancer, PCP with RAC

Patching using adop and Adpatch

Cloning of Oracle Apps Databases (11i, R12.1.x)

Cloning of 11i/R12 Applications on multi node

Installation, configuration and managing Fusion Middleware components Oracle SOA, HTTP server and web logic

Troubleshooting all Oracle Apps Issues like Forms, Apache and CM.

Patch application - Including Thorough Patch analysis.

Administration by using AD Utilities.

Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners.

Analysis and Application of quarterly CPU Patches in TEST, DEV and PROD instances.

Printer configuration and administration.

Setup new Data Guard Environments, Managing and Monitoring and troubleshooting to resolve the issues.

Scheduled daily/weekly Application backups through cronjobs

Environment:

Oracle E-Business Suite R12.1.3, 11g, RAC, RHEL, IBM AIX, Active Dataguard (DR), OBIEE, SSO-OID

Oracle Applications DBA – Galadari Brothers Group LLC, Dubai, UAE Aug’14 – Sep’15

Summary of Duties:

Planned and drafted strategy for instances, detailed layout of environments for Oracle Applications R12 Implementation Project.

Oracle ERP Database and Applications platform migration from IBM Power 7 to Oracle SPARC T5.

Installed and configured Multi node R12.1.3 Oracle eBusiness suite instances.

Installed and configured Oracle RAC 11gR2 database.

Conversion of Non-RAC database to RAC Database using RCONGIF.

Upgraded Database from 11.1.0.7 to 11.2.0.3.

Upgraded Oracle Applications from R12.1.1 to R12.1.3.

Setup of Workflow notification mailer using SMTP server and IMAP server.

Configured Parallel Concurrent Processing (PCP).

Configured Application Servers Load-Balancing using Big IP Hardware Load Balancer.

Configured Backups of database using RMAN and application file system using cron.

Code Migrated between different environments using FNDLOAD.

Provided support to EBS implementation team on day-to-day issues.

Installed and configuration of Oracle Access Manager for Single Sign on integration (SSO) with OID 11g and Active Directory.

Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Data guard for DR site.

Applied EBS 12.1.3+RPC3 patch set which includes the latest recommended patches and their dependencies for all Oracle E-business Suite products and product families like ATG, FIN, SCM, HRMS, and PRC etc.

Setup and configured Oracle Enterprise Manager 12c (OEM) on RHEL for administration, monitor performance bottleneck issues, AWR, ADDM reports etc.

Installed Discoverer 11g and integrated with EBS R12.

Installation and integrating OBIEE 11g with Oracle EBS R12.

Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.

Good experience in applying PSU and Critical Patch Update (CPU Patches) using Opatch Utility on Databases, Application Servers and Middle Tiers.

Provided 24*7 production database support with Support to developers & end-users.

Environment:

Oracle E-Business Suite R12.1.3, 11g, RAC, OAM 12C, Solaris, RHEL Active Dataguard, Shell Scripting

DBA Consultant–NTT DATA Pvt Ltd, Singapore Jan’14 – May’14

Summary of Duties:

Upgrade R12 EBS 10g Database 11gR2.

Install and configure 11.2.0.2 cluster on 2 nodes.

Integrate Oracle 11gR2 RAC with Oracle E-Business Suite R12.

Convert 10gr2 Non ASM instances to ASM filesystem.

Gathering 11gR2 RAC database installation pre-requisites like system requirements, network information and worked with system administrators, network administrators to thoroughly incorporate all the necessary changes.

24/7 production support for R12 Applications and Database.

Configured Oracle Data guard (ADG) for Oracle Disaster recovery on standalone databases using 11g Active Duplication.

Cloning of 11.5.10.2 and R12 instances.

Integration of R12 application with GL Wand for various clients.

Scheduling database backups and performed disaster recovery.

Created 11gR2 metadata repository for OBIEE as per the customer requirement.

Implemented new feature SCAN listener in 11gR2 RAC instances.

Installed OAM and configured OAM authentication schemas and policies.

Integrated OAM with R12 E-business-suite

Installing OEM repository and agents to monitor oracle database’s

Assisted OBIEE team in performance tuning for long running queries.

Environment:

Oracle E-Business SuiteR12, 11i, 10g, 11g, OEM10g, Solaris, Linux-x86, HPUX, DR, OAM, RAC, ASM,10g AS

Senior Systems Engineer –IGATE Global Solutions, Mumbai, India Apr’11 – Dec’13

Summary of Duties:

Database & Applications Upgrade from 10.2.0.4 to 11.1.0.7 and 11.5.10.2 to 12.1.3.

Involved in the project plan, provided input to timelines for important milestones.

Created detailed Production Upgrade Go-live plan by creating High level and Low level plans.

Performed 3 iterations of 11g and R12 upgrade.

Applying Oracle Applications and database patches (pre-patch analysis, adpatch, Opatch) and schedule downtime for applying of patch.

Work on cloning, Patching and Tickets on Regular basis with Strict SLA’s.

Applying database quarterly cumulative patch updates CPU.

Planning database and applications outages for maintenance window.

Weekend schedule activities like patching, re-org, database & application bounce, code migrations for Production.

Clone and Patch Oracle applications 11.5.10.2 & R12.1.3 Instances.

Cloning using rapid clone using cold, hot & RMAN backups.

Performance tuning in Oracle Applications and other productions Databases.

Assignment of work distribution and Managing the shift in shift lead role.

Attending MOM calls, Daily status update calls weekly and Monthly meetings.

Creating Data source for E-Business suite to SOA databases.

Working SOA bounces for weekend activities.

Weekly maintenance on production and Major Cut-Over activities.

Experienced in RAC administration, troubleshooting, adding new nodes in RAC cluster, applying PSU patches to Grid home and DB home.

Handling P1 Service requests, OWC calls with Oracle to resolve Production issues.

Prepared documentation for all type of activities and maintained shared repository for process orientated documentation.

Monitoring alerts for any critical issues in production databases.

Environment:

Oracle E-Business Suite R12, 11.5.10.2, Solaris, IBM AIX, OEM, 10g, 11g, SOA, RAC, ASM

Oracle Apps DBA - Techtimers Solutions, Mumbai, India Dec’10 – Apr’11

Summary of Duties:

Periodically refreshing the TEST, UAT and DEV instances from the PROD instances.

Managing Concurrent Managers and Concurrent Programs.

Monitoring Tablespace, Mount point and Archives logs on daily basis.

Monitor the database, resolving network issues & identifying and resolving user issues and Application patching.

Providing frontline Apps DBA support for 24X7 systems and maintaining the expected service levels.

Code Migration using the FNDLOAD Utility.

Scheduling the scripts in CRON Tab.

Managing Oracle Applications using AD utilities.

Running the AWR and analyzing the reports for bottlenecks.

Analyzing the EXPLAIIN PLAN and TKPROF to tune the SQLs to obtain the benchmark standards.

Actively participated in change management.

Actively participated in trouble shooting the performance issues.

Applying patches and performing ad activities and troubleshoot several worker issues.

Applying application patches by using adpatch utility.

Monitored and diagnosed database performance through alert log files, trace files.

Resolved the view log/out files issues of concurrent requests.

Perform overall health checks on the database at regular intervals to ensure smooth operation

Creating users, allocating Table spaces to users, managing privileges etc.

Troubleshooting issues relating to Concurrent Managers.

Troubleshooting issues related to database.

Provided Oracle Apps DBA support for eBusiness systems including Cloning, patching.

Environment:

E-Business Suite R12, 11.5.10.2, Solaris, IBM AIX, OEM, 10g, 11g, TOAD, PL/SQL

Database Administrator – Nalinsoft Pvt Ltd, Hyderabad, India Dec’06 – Dec’10

Summary of Duties:

Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.

Design Evaluation and Analysis of physical and logical model.

Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.

Involved in Schema management, Table space Management, User Creation.

Monitoring the Extraction and loading processes of Data.

Upgraded and applied patches as and when required on 8i, 9i, 10g.

Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.

Responsible for Oracle implemented backups like LOGICAL & PHYSICAL i.e. Export & import and also having experience with EXPDP & IMPDP.

Implemented Consistent exports using SCN.

Good experience with recovery managed backups i.e. RMAN.

Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.

Documented the complete project including all pre-installation, post installation and database configuration steps.

Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.

Experience in using automatic monitoring and management processes like batch processing using crontab for processes like import, export databases.

Used analyse table, analyse indexes to tune queries and increase performance.

Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.

Tuning Oracle 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Supporting oracle applications 11i production systems of size 700GB.

24/7 on call support on production systems.

Patching production, development, Test, UAT environments.

Patching two appl-tops and handling patching issues.

Applying both Application and Database Patches by following client standards which include preparing of Pre-Patch analysis.

Managing the Concurrent Manager related issues.

Cloning of Oracle Applications using Rapid Clone from Prod to Non-Prod Environments.

Troubleshoot problems with web server, form server and concurrent managers.

Coordinated with OS Team in moving the SAN Storage from Gold to Silver by providing DBA Support during Maintenance activity.

Monitoring database space requirements and adding spaces to required tablespace.

Regular checking of DB sessions for any locks and issues.

Provided 24/7 on call support during weekend.

Environment:

E-Business Suite 11.5.9, 11.5.10.2, RHEL, Solaris, OEM, 9i, 10g, RMAN, Shell Scripting, PL/SQL

Contact this candidate