SUMMARY

• I have 7 years of experience in activities relating to Oracle Apps DBA & Oracle DBA. Involved in the areas of installation and support of oracle applications 11x/R12x on single and multi - node systems and databases 9i/10g/11g. Databases and applications cloning/refresh, patches, upgrade of database/applications.
• Experience in administrating and managing oracle 11.5.10.2, R12.x applications WebLogic 11g.
• I have strong troubleshooting/logical abilities to identify organizational needs meet corporate goals and undertake full responsibility for delivering solutions which meets customer’s expectations /requirements.
• Having considerable working experience of oracle database administration using oracle rdbms and tools, thorough understanding of system administration including concurrent managers, applications security and printing.
• Oracle E-Business Suite Apps DBA (11.5.10.2, R12.1.3,R12.2.4)/Oracle DBA (9i/10g/11g) with experience on 24*7 Production environments for databases size 300G to 500G.
• Experience on upgrade of oracle applications 12.1.3 to 12.2.4
• Good Experience on oracle Application 12.1.3, 12.2.4, administration and WebLogic
• Extensive experience in the areas of installation, configuration, patching, cloning, upgrade, troubleshooting and support of Oracle E-Business Suit 11i & R 12.1.3/12.2.4 and Oracle Database (9i/10g/11g) instances on various platforms (e.g. Linux,, Sun Solaris, IBM AIX etc.).
• Experience in troubleshooting issues related to database and E-Business(Concurrent Managers, Forms, Apache, XML Publisher, workflow and Notification mailer).
• Strong knowledge on R12.2 online Patching
• Strong Trouble Shooting skill for R12.2 issue like fs clone, prepare online patching and application issues
• Extensive experience in handling Oracle E-Business Suite performance issues related to Concurrent program, forms, Self Service pages etc.
• Good Experience on R12.2 Clonings, Multinode to single node, Single node to Multi node on dev and test environments
• Installation of R12.2.4, 12.1.3&11.5.10.2 Applications, Oracle Databases 9i,10g,11g.
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation
• Strong experience in Space and User Management, Capacity planning, Backup & recovery (Import/Export,Datapump, RMAN).
• Oracle Database upgrade 10g to 11g & 11.2.0.3 to 11.2.0.4
• Code moves like creating packages/package bodies/table creation etc.
• Handling Ticketing system and resolutions for End-user issues
• Checking the status of important services like concurrent manager, form server, web server, application listener, database listener is up
• Involved in performance tuning of Oracle EBS Applications & Database systems.
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments.
• Involved in performance tuning of Oracle EBS Applications & Database systems using awr reports and sql advisor.
• Good experience in Backup / Recovery using User Managed / RMAN, export / import (Data Pump) and SQL Loader, etc.
• Expertise in resolving the view log/out files issue of concurrent requests, MOS support, Apache and Forms issues
• Monitor growth of Database with scripts and Responsible for High Availability.
• Monitoring Tablespace usage, Temp tablespace usage and undo tablespace usage.
• Implemented the shared appltop, application systems, Parallel Concurrent Processing and configured load balance to mid-tiers
• Extensive experience in supporting and managing multiple Production, Staging, Development and test instances and Oracle Applications environments of varied complexity
• Good working experience in Installation, Configuration and Trouble Shooting of Weblogic and Application Servers
• Involved in the configuration of WebLogic 11g domain with domain templates, configured clusters, servers, connection pool, JMS queues using console.
• Configured Machine, Node Manager to control server lifecycles remotely
• Deployed Applications (WAR, SAR, RAR, JAR&EAR) in Domain and Clustered environment.
• JDBC Connection Pool configuration with Oracle.
• Control Console to perform administrative tasks.
• Managing and Monitoring the JVM Performance by adjusting WebLogic heap size and garbage collection parameters
• Good experience in configuring and managing security realm for users and groups.
• Responsible for 24x7 on server and environment availability and monitoring.
• Quickly adapting new technologies.
• Involed in Installation of Goldengate.

TECHNICAL SKILLS

Operating Systems: Linux-OEL-6x,5X, SUN Solaris5x,10x AIX5x

Databases: Oracle 9i/10g/11g,Mysql 5

ERP: Oracle Applications 11i/R 12.13/12.2.4 , Fusion Application 11.1.8

Middleware: WebLogic 10g/11g, JBoss 5, Xampp(PHP)

Languages: SQL,PL/SQL,Java

Tools: & Utilities: 10g EnterpriseManager, Export/Import, Recovery Manager (RMAN), Toad, Kintana, Service-Now. SQL Developer, Putty, Winscp, Vnc

Virtualization Technology: OracleVMServer3.X,Citrix(xenhypervisor),Openstack(keystone,nova,neutron,glance)

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps DBA

Environment: 11.5.10.2 Database 11.2.0.3 On RHEL 5.9 Linux

Responsibilities:

• End-End production Support of Oracle Applications 11.5.10.2 and 12.2.4.
• R12.2.x installations, Online Patching Activities and support
• Cloning of oracle applications 11.5.10.2 and 12.2.4 on Dev and test environments
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Performed DB upgradation from 11.2.0.2 to 11.2.0.3
• Researched, recommended and applied Quarterly Oracle CPUs patches and addressed Oracle security alerts
• Provided support to developers with trouble-shooting, and performance tuning of long running concurrent requests and applications
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups, Logical backups using Exports and imports.
• Patching CPU/PSU/One-Off for databases and Oracle Applications
• Configured Oracle VM servers for different instance like DEV, TEST, UAT servers
• Configured SAN with VM server and separated as per requirement for TEST, DEV and UAT servers
• Demo installation of Oracle Fusion Application OFA(11.1.8)
• Support in Openstack Private cloud Architecture installation and configuration
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Handling tickets raised by users through vtiger ticking tool.

Confidential - New York

Apps DBA

Environment: R11.5.10.2 Database 11.2.0.2 OEL 5.7

Responsibilities:

• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Created Fresh DEV instance and cloned to TST .
• Working as part of a team and providing 24x7 Support when required.
• Exporting the 5 years Database from 11.5.10.2 and import into to R12.1.1 in stage schema.
• Upgrade APPS from R12.1.1 to 12.1.3
• Configured Printers in Application.
• Configured Notification mailer in Application.
• Create users and assigning responsibility and also move to other instance using FNDLOAD.
• Monitoring the tablespace growth periodically.
• Performing Backup's (Logical and Physical) when required.
• Extensively worked on Oracle Applications AD Utilities.
• Maintaining the health of Oracle applications system daily, weekly, monthly database and application health check
• Managing Oracle application services like Form Server, Report Server, and Concurrent Manager to ensure availability.
• Applying application patches in Test, dev and production instances.
• Troubleshooting of ongoing Oracle applications issues.
• Adding the printers into printer Queues and registering them in oracle applications and troubleshooting.

Confidential - Ohio

Apps DBA

Environment: R11.5.10.2 Databases: 11.2.0.2 OEL 5X

Responsibilities:

• 24/7 production Support and maintainance of Oracle Applications 11.5.10.2 and R12.1.3 instances.
• Cloning of Oracle Applications, database refreshes and backups using rman backup and hot backups
• Upgrade Oracle EBS from 11.5.10.2 to 12.1.3
• Own the plan for each DBA task. The plan will include preparation time, launch, schedules, checklists, contact names, etc
• Conversion of tablespace from FA to OATM.
• Used AD Utilities like adadmin, adctrl, adpatch, adrelink etc.,
• Starting the Concurrent Managers. Stopping the Concurrent Managers. Concurrent Manager Log files. Cleaning out Concurrent Manager Tables.
• Application user creation / responsibilities assignment
• Automated the purging of old trace / log files.
• Relinking the apps executables.
• Responsible for backup and recovery using automated and manual.
• Monitoring tablespace size,alert log, trace files.
• On time usage of Database Utilities like RMAN, Export and Import.
• Worked with UNIX Admins to setup the mountpoint structures for various instances.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Daily Health check of Production environments and Space Management.
• Administering concurrent manager, defining concurrent managers and work shifts
• Troubleshooting and fixing the issues by raising Service request with oracle support for permanent solution
• Created and Handover the Rapid Cloning Procedure document and patching documents
• Re-org of tablespaces and tables for reclaiming the un-used space
• Worked with UNIX Admins to setup the mountpoint structures for various instances.
• Worked on TAR and 24/7 environments.
• Worked with UNIX Admins to setup the mountpoint structures for various instances.
• Worked on TAR and 24/7 environments.

Confidential - Virginia

Oracle Apps DBA

Environment: R11.5.9,11.5.10 Database 10.2.0.3 Linux 5.6

Responsibilities:

• Support and maintain Oracle Applications R 11.5.9, 11.5.10.2 instances.
• Upgraded Oracle applications from 11.5.9 to 11.5.10
• Experience in working on technologies like Shared APPL TOP, Parallel Concurrent Processing (PCP)
• Cloning Oracle Applications from multi node to multi node and multi node to single node and shared appl top cloning.
• Coordination and communicate with Onsite DBA team
• Create and Manage Application Users, assigning Responsibilities, printer set up and configurations and troubleshooting
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities like adctrl, admrgpch, adadmin,adpatch.
• Maintenance included reliking applications objects and regenerating forms and reports.
• Applied various patch sets, application patches and rdbms patches.
• Daily Health check of Production environments and Space Management.
• Administering concurrent manager, defining concurrent managers and work shifts
• Cloning from Production database to DEV and TST.
• General Health check of Application Creating users, Responsibilities as part of system administration.
• Checking the concurrent manager status.
• Monitored and performed daily incremental backups, weekly backups using RMAN.
• Scheduling and managing Cronjobs
• Created Migration scripts for DEV environment.
• Checking invalid objects and compile through adadmin tool.
• Created Migration scripts for DEV environment.
• Taken Oracle support by raising TAR.
• Worked under the environment of 24X7 DBA support.

Confidential - Ohio

Oacle DBA/Apps DBA

Environment: JBOSS Database 10.2.0.4

Responsibilities:

• Creating different users and granting them appropriate privileges and roles.
• Maintenance of Oracle Databases as per the requirement.
• Extending tablespaces by resizing/adding datafiles when needed.
• Monitoring the tablespace growth periodically
• Performing Backup's (Logical and Physical) when require
• Multiplexing Control file and Redo log files