SUMMARY:

• Senior Oracle Applications DBA/Oracle DBA with 11+ Years of good hands - on administering Oracle 9i/10g/11g/12c Databases Oracle RAC, ASM Databases and Oracle ERP Applications 11i& R12 with AD utilities, Patching, Cloning and Upgradation. Implementing R12.2.0 and upgrading to 12.2.4, Oracle Golden Gate, VERIDATA, Managing Oracle Weblogic.
• Fully conversant with Oracle Application DBA activities, Oracle ERP Implementation, Configuration, Remote administration, DEMANTRA Configuration, Administration & Migration, Cloning, Patch application and running AD Utilities.
• Expertise in Performance tuning of Top Wait events, Shared Pool, Buffer Cache, Log Buffer.
• Amazon AWS Certified Solutions Architect
• Well versed with Red Hat Enterprise Linux and Oracle Enterprise Linux Operating system, Installation, Configuration, troubleshooting, fine-tuning.
• Strong ability to work independently, and own the responsibility of reviewing and resolving issues across multiple systems.
• 6 Years of experience in System Administration on Linux platforms involving Installation, Support, Configuration and Maintenance of Linux operating system under heterogeneous environments as Web, Application and Database Servers.
• Experience in System Administration, Troubleshooting, Security, Backup, Disaster Recovery, Performance Monitoring and Fine-tuning on LINUX Servers. Root cause analysis and diagnosing issues during installing, configuring and deployment of different hardware, OS, and applications.
• Experience in Planning and support high availability, data replication.
• Extensive experience in server provisioning, systems integration, security tuning and performance management using manual build and automation tools.

TECHNICAL SKILLS:

Operating System: Red Hat Enterprise Linux 5, 6 & 7, OE Linux 5, 6 & 7, Cygwin tool, Windows server 2003\2008 Scripting Languages Unix Shell (Bash) Cloud Applications

Oracle EBS Suite/ERP, Reporting Tool: Oracle Business Accelerator, Oracle Applications 11i &R12, PCP, Shared APPL TOP, APEX Configuration, Discoverer, OBIEE, ASCP, Demantra,, SSO, Upgrades.

Databases & Tools: Oracle 9i/10g/11g/12c Databases, RAC, ASM, RMAN, Dataguard, AWR, Oracle Weblogic, OID, OAM, Oracle Golden-Gate, VERIDATA,11i to R12 upgrades, Install 12.2.0 and upgrade to 12.2.4.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA/APPS DBA

Operating Systems: OE Linux 6.7, 6.8 and 7.3

Database: Oracle 10g / 11g RAC and ASM

ROLES & RESPONSIBILITES

• Key Player to support Oracle RAC and ASM Data Center Migration Activities.
• Oracle EBS Upgrades from 11i to R12.1.1 and from 11i to R12.1.3 with many modules in place.
• Oracle Database upgrades from 9i to 10g, 10g to 11g for different versions within the Database level.
• Actively involved to support Server Build and Data Center Migration activities on complex web hosting configuration components, including firewalls, load balancers, web and database servers.
• Implemented Oracle Golden Gate 4-way replication for 2 new & 2 old datacentre’s.
• Monitoring and tuning Linux systems to achieve optimum level of uptime and performance.
• Responsibilities are to perform configuration management, provisioning, monitoring and trending, firewalls and general system administrative support to developers and middleware administrators.
• Setup Oracle Golden Gate between 2 new and 2 old datacentre’s during Data Centre Migration and were retained till everything was fine on new Datacenters.
• Implementing ASCP and Demantra configuration.
• Design of RMAN backup strategy.
• OID and OAM Configuration and integrating with EBS.
• Configuring/Scheduling RMAN backup and recovery procedures.
• ASM Migration from VNX to Extreme IO.
• Implemented R12.2.0 with Dual filesystems and Upgrading to 12.2.4
• Enabling Online patching on Database using EBR Patches. (Edition Based redefinition)
• Applying patches using latest online patching method - ADOP.
• Finding the missing patches and code levels using ETCC.
• Tuning Oracle Application and Database for better performance.
• Shell scripting for automation of Health Check / Alerts.
• Good knowledge of implementing, upgrading and supporting 10g Oracle Application Server.
• Developing reports for Discoverer and OBIEE.
• Supporting EBS 12.2 and 11.5.10.2 with PCP and Reporting refresh instances.
• Mananging ASM Diskgroups and Rebalancing ASM Diskgroups whenever required.
• Testing and maintenance of new features provided in upcoming versions of Oracle applications Release 12, Oracle Application system database and Troubleshooting Oracle Apps related Problems.
• Shell Scripting of alerts for pro-active monitoring of Oracle Applications and Database.

Senior Oracle DBA/APPS DBA

Operating Systems: Red Hat Enterprise Linux 5, 6, 7

Database: Oracle 10g / 11g RAC and ASM

ROLES & RESPONSIBILITES

• Demantra Migration from One EBS environment to another EBS environment which also includes upgradation of Oracle Application Server 10.1.3.1.
• Actively involved to support Server Build and Data Center Migration activities on complex web hosting configuration components, including firewalls, load balancers, web and database servers.
• Migrating DEMANTRA from one EBS to another EBS & Demantra Windows Configuration.
• Setup Bi-Directional Oracle Golden Gate between different databases and administration.
• Automating DEMANTRA Analytical Engine using Cygwin which provides Unix like environment on windows.
• Responsibilities are to perform configuration management, provisioning, monitoring and trending, firewalls and general system administrative support to developers and middleware administrators.
• Monitoring and tuning Linux systems to achieve optimum level of uptime and performance.
• Enabling SSH on Demantra Windows Server using Cygwin tool.
• Supporting many modules like AP, AR, GL, OPM, ASCP, OM, PO, FA.
• Supporting Oracle EBS 11.5.10.2.
• Good knowledge of implementing, upgrading and supporting 10g Oracle Application Server.
• Configuring SSO for DEMANTRA.
• Implemented R12.2.0.
• Implemented R12.2.0 with Dual filesystems & Upgraded to 12.2.4
• Focus on QA automation, work on documentation, reporting & metrics.
• Performance tuning of Concurrent requests. Tuning SGA, Shared Pool and different wait events.
• Cloning R12.2 with Dual filesystems
• Cloning Database using RMAN Duplicate
• SSO Implementation with Demantra.
• Work with development team on daily basis to handle custom code migration, data fixes and extracts, and fixing performance issues
• Review failures and provide formal root cause analysis to prevent future occurrences Evaluate proposed changes to the environment and deploy them to QA, pre- production, and production.
• Implemented Standby Disaster Recovery DR (Datagaurd) for 11g Database and R12 Application.
• Testing and maintenance of new features provided in upcoming versions of Oracle applications Release 12, Oracle Application system database and Troubleshooting Oracle Apps Related Problems.
• Tuning bad SQL’s, analyzing statspack, tracing the session with binds and generating TKProf.
• Shell Scripting of alerts for pro-active monitoring of Oracle Applications and Database.

Senior Oracle DBA/APPS DBA

Operating Systems: OE Linux 5.8.

Database: Oracle 9i / 10g / 11g RAC and ASM, Oracle GoldenGate.

ROLES & RESPONSIBILITES

• Supporting Oracle RAC and ASM setup with daily activities on VMWARE Virtual Machines.
• Oracle EBS Upgrades from 11i to R12.1.1 and from 11i to R12.1.3 with many modules in place.
• Integrating OID and OAM with Oracle Fusion 12.2.4.
• Installing and configuring bi-directional GoldenGate replication.
• Supporting day to-day issues of GoldenGate replication.
• Oracle Database upgrades from 9i to 10g, 10g to 11g for different versions within the Database level.
• Implementing ASCP and Demantra configuration.
• Migrating DEMANTRA from one EBS to other EBS & Configuring SSO for DEMANTRA.
• Configuring/Scheduling RMAN backup and recovery procedures.
• Automating DEMANTRA Analytical Engine using Cygwin which provides Unix like environment on windows.
• Implemented R12.2.0 & Upgrading to 12.2.4
• Enabling Online patching on Database using EBR Patches.(Edition Based redefinition)
• Implemented R12.2.0 with Dual filesystems.
• Cloning R12.2 with Dual filesystems
• Cloning Database using RMAN Duplicate
• Finding the missing patches and code levels using ETCC & Applying patches using ADOP.
• Tuning Oracle Application and Database for better performance.
• Shell scripting for automation of Health Check / Alerts.
• Good knowledge of implementing, upgrading and supporting 10g Oracle Application Server.
• Developing reports for Discoverer and OBIEE.
• Supporting EBS 12.2 and 11.5.10.2 with PCP and Reporting refresh instances.
• Work with development team on a daily basis to handle custom code migration, data fixes and extracts, and fixing performance issues
• Mananging ASM Diskgroups and Rebalancing ASM Diskgroups whenever required.
• Configuring Custom Concurrent Managers for PCP configuration.
• Review failures and provide formal root cause analysis to prevent future occurrences Evaluate proposed changes to the environment and deploy them to QA, pre- production, and production.
• Implemented Standby Disaster Recovery DR (Datagaurd) for 11g Database and R12 Application.
• Bouncing Workflow Notification Mailer for email notifications and Agent Listeners.
• Implementing and Scheduling RMAN backups.
• Performance tuning of Database and Applications.
• Managing Incidents and clearing the alerts, within SLA.
• Testing and maintenance of new features provided in upcoming versions of Oracle applications Release 12, Oracle Application system database and Troubleshooting Oracle Apps related Problems.
• Tuning bad SQL’s, analyzing statspack, tracing the session with binds and generating TKprof.
• Shell Scripting of alerts for pro-active monitoring of Oracle Applications and Database.

Confidential

Operating Systems: RedHat Enterprise Linux 5,6, OE Linux 5.8 and IBM AIX

Database: Oracle 10g / 11g RAC & ASM

ROLES & RESPONSIBILITES

• Implemented Oracle Business Accelerators (OBA) with Oracle EBS R12.1.3,
• Implemented ASCP and Demantra.
• Demantra Configuration and integration with EBS R12.
• Supporting Multiple Databases and EBS Applications after go-Live.
• Work with development team on a daily basis to handle custom code migration, data fixes and extracts, and fixing performance issues
• Handling Sev1 SR’s and follow up with Oracle Support to close the issues.
• Was on-Call whenever required and during critical phases of project.
• Review failures and provide formal root cause analysis to prevent future occurrences Evaluate proposed changes to the environment and deploy them to QA, pre- production, and production.
• Configured Printers on Linux and Oracle Applications.
• Implemented Standby Disaster Recovery DR (Datagaurd) for 11g Database and R12 Application.
• Configured Workflow Notification Mailer for email notifications.
• Configured Backup scripts for taking RMAN backups.
• Configured outbound Email Notifications for PO emails.
• Perform application and database tuning, performance monitoring and trouble shooting
• Oracle SQL/PLSQL Programming, developing forms and reports.
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, admrgpch etc).
• Upgrades, migrations, cloning and patch management of Oracle E-Business Suite environments
• Planning, applying and monitoring Oracle Applications patches on different instance and other Oracle applications DBA activities and Controlling database and Applications Security in Release12 Instance.
• Tuning bad SQL’s, analyzing statspack, tracing the session with binds and generating TKprof.
• Shell Scripting of alerts for pro-active monitoring of Oracle Applications and Database.

Confidential

Senior Oracle DBA/APPS DBA

Operating Systems: OE Linux 5.3 and HP-UX

ROLES & RESPONSIBILITES

• Designed system architecture and did Hardware sizing.
• Oracle EBS Upgrades from 11i to R12.1.1 and from 11i to R12.1.3.
• Oracle Database upgrades from 9i to 10g, 10g to 11g for different versions within the Database level.
• Demantra Configuration and integration with EBS R12.
• Create and maintain database access systems including tables, indexes, views,
• Upgrades, migrations, cloning and patch management of Oracle E-Business Suite environments
• Oracle SQL/PLSQL Programming, developing forms and reports.
• Worked 24/7 whenever required and fixed the issues.
• Was on-Call whenever required and during critical phases of project.
• Added new languages to oracle Applications i.e German, French and Dutch using NLS Patches.
• Configured Printers on Linux and Oracle Applications.
• Configure Workflow notifications, Configured and Scheduled RMAN Backups.
• Perform application and database tuning, performance monitoring and trouble shooting
• Configured Backup scripts for taking RMAN backups.
• Review failures and provide formal root cause analysis to prevent future occurrences Evaluate proposed changes to the environment and deploy them to QA, pre- production, and production.
• Shell scripting for alerts and CRON jobs.

Senior Oracle DBA/APPS DBA

Operating Systems: RedHat Enterprise Linux 5,6, OE Linux 5.8 and IBM AIX

Database: Oracle 10g / 11g RAC & ASM

ROLES & RESPONSIBILITES

• RAC installation, configuration and troubleshooting
• Automated cloning activity.
• Adding Disks online to the system and Database.
• Good knowledge of implementing, upgrading and supporting 10g Oracle Application Server
• Rebalancing data on newly added disks.
• Changing ASM POWER LIMIT for better performance.
• Well versed in Rapid Install, AD utilities for Oracle Applications.
• Designed system architecture and did Hardware sizing.
• Upgrades, migrations, cloning and patch management of Oracle E-Business Suite environments
• Work with development team on a daily basis to handle custom code migration, data fixes and extracts, and fixing performance issue
• Used DATAINSTALLER for installing Legislative Data for different countries.
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, admrgpch etc).
• Planning, applying and monitoring Oracle Applications patches on different instance and other Oracle applications DBA activities and Controlling database and Applications Security in Release12 Instance.
• Worked 24/7 whenever required and fixed the issues.
• Testing and maintenance of new features provided in upcoming versions of Oracle applications Release 12, Oracle Application system database and Troubleshooting Oracle Apps related Problems.
• Concurrent Manager Administration
• Shell scripting for alerts and cron jobs.
• Review failures and provide formal root cause analysis to prevent future occurrences Evaluate proposed changes to the environment and deploy them to QA, pre- production, and production.
• Tuning bad SQL’s, analyzing statspack, tracing the session with binds and generating TKprof.
• Created Backup scripts and implemented RMAN backup.

Senior Oracle DBA/APPS DBA

Operating Systems: RedHat Enterprise Linux 5,6, OE Linux 5.8 and IBM AIX

Database: Oracle 10g / 11g RAC & ASM

ROLES & RESPONSIBILITES

• Installing, configuring and administering Oracle R12 applications with database in a Multi-tier Architecture
• Well versed in Rapid Install, AD utilities for Oracle Applications.
• Trouble shooting& maintaining EBS.
• Supporting RAC instances.
• Adding Disks online to the system and Database.
• Rebalancing data on newly added disks.
• Perform application and database tuning, performance monitoring and trouble shooting
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, admrgpch etc).
• Planning, applying and monitoring Oracle Applications patches on different instance and other Oracle applications DBA activities and Controlling database and Applications Security in Release12 Instance.
• Concurrent Manager Administration
• Worked 24/7 whenever required and fixed the issues.
• Work with development team on a daily basis to handle custom code migration, data fixes and extracts, and fixing performance issue
• PCP Configuration & Concurrent Manager Administration.
• Upgraded the Oracle Apps from R12.0.0 to R12.0.3 and then to R12.0.6
• Created Backup scripts and implemented RMAN backup on10g database for Oracle Applications R12.

Support Engineer

ROLES AND RESPONSIBILITIES:

• Part of DBA team in B’lore Team.
• Managing Daily DBA activities.
• Complete administration of Production, Development & Test instances 24/7.
• Managing and supporting RAC Instances.
• Cloning RAC to non-RAC systems.
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, admrgpch, adident etc).
• Cloning of Oracle Applications 11i Database in a single node, multi node environment.
• Monitoring RMAN daily PROD backup.
• Installing Agents, Oracle Enterprise Manager (OEM) & Configuring databases for monitoring.
• Monitoring Oracle Applications through OEM
• Resolving user issues and documenting.