PROFESSIONAL SUMMARY:

• Over all 12+ years of experience in Oracle e - Business Suite 11i and R12. (ERP) applications.
• Over 9+ years of extensive experience as Oracle Applications DBA involved in life cycle implementations.
• Over 9+ years of experience in providing support to 120 plus production, development, test instances comprising of complex and challenging environments from versions R12.2.X, 11.5.X,9i,10g,11g.
• Implementation experience in Cloud Control 12c and monitoring system for very large environment to monitor Oracle database, Oracle e-Business Suite and Middleware products.
• Experience in 11i & R12 Installation, Cloning, AD utilities and System administration.
• Involved in Multi-node setup of R12.1.3 and R12.2.4 Oracle e-Business Suite, Shared Application file-system implementation (with PCP setup & SSL implementation) and Load balancing setup.
• Experience in performing DMZ/External tier setup and JAR signing.
• Experience in WebLogic administration and deployments.
• Experience in upgrading Oracle ERP and Oracle Database on different versions and on different platform.
• Moderate experience in maintain and upgrading other application like OTM, Demantra on Exalogic platform.
• Experience on Real Application Clusters maintenance and day to day operations for 11g RAC on Exadata Platform.
• Experience on Oracle 9i, 10g and 11g installation, maintenance activities like patching, database upgrade, code movements, shell scripting, backup & recovery, hot/cold backups and proactive health check of the database.
• Experience in basic maintenance of half RACK and Quarter RACK Exadata machine.
• Experience in Performance tuning of different versions of Oracle databases on RHEL, HPUX, and Sun Solaris.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Expertise in automated task scheduling using crontab.
• Knowledge on Kintana and STATS code migration tools.
• Excellent analytical, problem-solving and learning skills as well as a keen interest in mastering and utilizing leading edge technologies and tools in applications.
• Excellent team player with problem - solving and trouble- shooting capabilities.
• Excellent inter-personal and leadership skills with 2 years onsite experience in client locations- USA (Illinois, Maryland, Connecticut) and UK (London). Valid H1B available.

TECHNOLOGY SUMMARY:

OS Versions: Oracle Enterprise Linux x64, Windows, Solaris, AIX and Exadata/Exalogic(Linux)

Scripting language: Shell Scripting, Perl Scripting

Databases: Oracle 8i,9i,10g,11g,12c

Application / Web Servers: Oracle 11, 11.5.X, 11.5.10.2, R12.1.3, R12.2.4, Weblogic 11g, OTM, Demantra

Administration Tools: SQL Developer, TOAD, 11g and 12c Enterprise Manager

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

DBA

Responsibilities:

• Daily monitoring and deployments done while supporting R12.2.6 ERP applications. Incident Management and Change Management activities.
• Troubleshooting the cloning issue, Application problems, Resolving installation, and Resolving application/database hanging issues.
• Helping the users noticing the Oracle Application performance issues and working with them to fix it at the earlist.

Environment: Linux -5.10, TOAD,SQL Developer, R12.2.6

Confidential, Shelton, CT

Oracle Apps DBA Lead

Responsibilities:

• Daily support of R12.2.3 ERP applications. Incident Management and Change Management activities.
• Troubleshooting on cloning, Application problems, Resolving installation, and Resolving application/database hanging issues.
• Implementation of shared application file system architecture.
• Applying application patches and implementing housekeeping methodologies using shell scripting.
• Working for IBM Urban Code deployment tool.
• Troubleshooting system critical issues and performance tuning of concurrent requests.

Environment: AIX -7.1, Oracle SQL, PL/SQL, Shell Scripts, 12.2.3; Database 11g,12c, Oracle Enterprise Manager Cloud Control, SQL Developer

Confidential, Hanover, MD

Sr. Oracle Apps DBA.

Responsibilities:

• Upgrading Oracle ERP instance 11.5.10.2 to latest version 12.2.4 with database migration on Exadata platform.
• Implementing Tablespace encryption and column level encryption - Transparent Data Encryption (TDE).
• Upgrading and maintain several Oracle Database 11.2.0.4 instances from 11.1.0.7.
• Implementing shared APPL TOP, PCP, and DMZ.
• Applying database, weblogic, OTM and Demantra patches.
• Performance tuning using AWR report, ADDM advisory, OEM 12c.
• Backup and recovery via RMAN scripts and troubleshooting.
• Monitoring of Oracle database with automated error notification.
• Handling memory related issues and Concurrent Manager Issues.
• Responsible for Space management and resolving dead lock issues.
• Maintaining the user account and responsibility access.
• Sanity check for all applications after completion of outages.
• Run UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking databases, listener status, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• Coordinating with Development team for SIT, UAT upgrade smoke testing.
• Performance tuning of concurrent requests. Monitoring and releasing locks on objects from different servers.
• Handling tablespace, segment, schema and object related issues.
• Working with Oracle on Service requests related to upgraded instances.

Environment: Linux -5.10, 6.4 on Exadata Quarter Rack and Windows 2013, Oracle SQL, PL/SQL, Shell Scripts, Oracle EBS 11.5.10.2, 12.2.4; Database 11g,12c; OTM, Demantra, Oracle Enterprise Manager Cloud Control, TOAD, Sql Developer

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Migration of R12.1.3 on Linux Exadata Half Rack using RMAN.
• 3rd party Solix tool setup for data purging and data compression.
• Installing, Discovering and setting up Oracle Enterprise Manager Cloud Control 12.1.0.4 with Application management pack for EBS monitoring.
• Planning, applying and monitoring Oracle Applications patches on different instance.
• Controlling database and Applications Security.
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, admrgpch, adident etc).
• Other day to day DBA activities and Shell Scripting.
• Troubleshooting issues for all tiers (Apache, Forms, Concurrent, Admin and database).
• OTM/GTM and Demantra upgrade assistance.
• Performance tuning using AWR report, ADDM advisory, OEM 12c.

Environment: Oracle Enterprise Linux on Exadata Half Rack, Oracle SQL, PL/SQL, Shell Scripts, Oracle EBS R12.1.3, Oracle Enterprise Manager 11g, Cloud Control 12c, TOAD, Sql Developer, Solix

Confidential

Oracle Applications DBA/Team Lead

Responsibilities:

• Real Application Cluster clone and data refresh activity.
• Retrofit of custom objects and revert back all the customizations after any changes.
• Incident Management and Change Management assistance.
• Code migration through Kintana.
• Patch analysis and patch application including application and oracle patch.
• Sys-admin work including workflow, printer setup, profile setup etc.
• Shell scripting for automation of hot and cold backups and scheduled as per business need.
• Import and export back up and data refresh activity on user requirement basis.
• Database heath checks and recovery.
• Other several DBA day to day activities.
• Troubleshooting issues for all tiers (Apache, Forms, Concurrent, Admin and database)
• Performance tuning using AWR report, ADDM advisory, OEM 12c.

Environment: Sun Solaris 5.8, Oracle SQL, PL/SQL, Shell Scripts, Oracle EBS R12.1.3

Confidential, Northbrook, IL

Technology Specialist/Technical Lead

Responsibilities:

• Database upgrade from 10.2.0.4 to 11.2.0.3 version.
• E-Business suite 11.5.10.2 clone and refresh activities.
• Workflow mailer setup, oracle printer setup & other sysadmin activities.
• Standby server setup and failover.
• Export-import, Schema and table refresh using Export and Import Dump method.
• Code migration setup through STAT tool.
• Concurrent manager issues and resolutions.
• Databases restore using hot backup/cold backup and RMAN recovery.
• Patch analysis and patch application including application and oracle patch.
• Server health checks and process monitoring.
• Working with AD-utilities and autoconfig.
• Scheduling shell scripts in crontab for several database activities.
• Perform regular core DBA activities.
• Quarterly CPU analysis and patching.
• Performance tuning using AWR report, ADDM advisory.
• Weekend on-call support on a 24X7 environment.

Environment: Sun Solaris 5.8-5.10, OEL on Exadata Quarter Rack, Oracle SQL, PL/SQL, Shell Scripts, Oracle 9i, 10G, Oracle EBS (11.5.10.2), R12.1.3

Confidential

Software Engineer

Responsibilities:

• Resolving service requests logged by Internal/External Clients on Oracle Products.
• Contributing to proactive support activities according to product support strategy & model.
• Solving escalations and functioned as a Cluster Technical Coordinator.
• Contributing to new processes & tools (Oracle Web Conferencing), diagnostic methodology, health checks, scripting tools, etc.
• Looked into knowledge management entailing content creation, using Oracle Diagnostics Methodology (ODM).
• Played a key role in root cause and corrective actions activities as per client requests, working with product development teams on product improvement programs as required and logging bugs for bug related issues.
• Being part of development week for hands-on experience on Oracle Apps Installation, Migration, Cloning and upgrade activities every month.

Environment: Red Hat Linux, Sun-Solaris, IBM AIX, Windows 2000, Oracle SQL, PL/SQL, Shell Scripts, Oracle 9i, 10G, ORACLE EBS 11, 11i and R12.0.1