SUMMARY

• 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 withOracle RACinstall and configuration using ASM onOracle10g/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

PROFESSIONAL EXPERIENCE

Senior Oracle Applications DBA

Confidential, MD

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, and 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 Datagaurd (DR)

Lead Oracle Applications DBA

Confidential, GA

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 Datagaurd (DR), OBIEE, SSO-OID

Oracle Applications DBA

Confidential

Responsibilities:

• 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 E-Business 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.
• 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 Datagaurd, Shell Scripting

DBA Consultant

Confidential

Responsibilities:

• 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 file system.
• Gathering 11gR2 RAC database installation pre-requisites like system requirements, network information and worked with system administrators, network administrators to thoroughly in corporate 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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 analysing the reports for bottlenecks.
• Analysing 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 E-Business systems including Cloning, patching.

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

Database Administrator

Confidential

Responsibilities:

• 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