Sameer Khan
Oracle Applications Consultant
919960172646
Professional Summary
Oracle Applications Database Administrator with 5.8 years of IT experience, currently working with Unionsys Technologies, Pune India, as a Oracle Apps Consultant. Experience as Oracle Applications DBA on platforms like Linux, HP-UX, AIX, Solaris, Microsoft. Strong experience in supporting production, development and test environments.
● Performed Oracle Applications eBusiness Suite upgrades from 11.5.9 to 11.5.10.2, 11.5.10 to R12.0.x, 12.0.4 to 12.0.6 ,12.1.1 12.1.2 and 12.1.3
● Database Upgraded from 9i to different 9i releases ,to 10G to different 10G releases and 10G to 11G upgrades.
● Good Hands on experience in Cloning Oracle Application instances for 11i and R12 releases. Cloning of the Applications using Rapid Clone ,Autoconfig , Manual of production, development and test instances.
● Performed Database cloning and Database refreshes using hot and cold backups.
● Performing Refreshes using Datapump and imp/exp utilities.
● Performed Schema Refreshes using Datapump.
● Patch analysis and application in various test, development & Production instances & documenting the technical instructions for patch application. Proactive analysis of CPU Patches and other patch-sets to keep the system updated.
● Extensively used Oracle Applications AD utilities like adconfig, adadmin, adpatch, adctrl, adsplice etc.
● Worked on Hot, Cold Backups. Did recoveries whenever required.
● Upgrade of individual Oracle Applications products and product families by applying Mini-Packs and Family Packs.
● Configured Databases for RMAN Backups..
Education
PG Diploma in Computers Datawarehousing and Datamining.(University of Greenwich.)
Bachelors Degree in Information Technology (MAHE University)
Software Skills
Operating Systems : Unix (Linux, SUN Solaris,AIX),Windows X,NT/200X.
Languages : SQL,PL/SQL,C, Java ,VB .
RDBMS : Oracle 8i ,9i,10g,11g
RDBMS Tool : SQL*Plus ,Enterprise Manager ,Server Manager .
Web Technology : Core Java , HTML.
Web Server : Oracle 9iAS,10GiAS ,Web Logic
Applications : Oracle Apps 11,11i,12
Professional Experience
Present Organization : UnionSys Technologies Pvt Ltd, PUNE.
Duration : May 2010 – Till Date
Job Profile : Oracle Application DBA.
Responsibilities as Oracle Apps DBA
Installation and upgradation of EBS Suite from 11.5.9 to 12.1.1, Maintenance of installed Oracle Application R12, Oracle database 10gR2 RAC with two nodes.
Cloning and Patching activities.
Cloning of Oracle Application & Database to Create new Test & Development Environments.
Adding node in 10g RAC environment.
Applying Patches using adpatch in multi-node environment and database patches (OPATCH).
Maintaining Oracle Application File System and Database using AD Utilities.
Troubleshoot problems with Apache, Concurrent managers and Patch Failures.
Creating Custom responsibilities, request group, menus and concurrent manager.
Creating, updating and monitoring SR activities.
Database Cloning using RMAN, Hot backup & Cold backup.
Planning and Maintaining Database Backups using RMAN Logical and Physical.
Implementation of Application security with Database security assigning privileges to users .
Working with 3rd party tools.
Worked on 24/7 high availability environments.
Coordinating with Oracle support for troubleshooting major issues.
Previous Organization : Fizzback, London .
Duration : April 2008 – April 2010.
Job Profile : Oracle Application DBA.
Responsibilities as Oracle Apps DBA & DBA
Maintenance of installed Oracle Apps Rel 11.5.10 suite and Troubleshooting.
Cloning and Patching activities.
Cloning of Oracle Application & Database to Create new Test & Development Environments.
Applying Patches using adpatch.
Maintaining Oracle Application File System and Database using AD Utilities.
Sysadmin maintenance task such as creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting.
Registering of Printers and Concurrent programs.
Managing Concurrent managers.
Monitoring and Updating SR activities.
Database Cloning using RMAN, Hot backup & Cold backup.
Installation and upgradation of databases such as Oracle 9i and 10g
Played an active role in oracle 10g Upgrade on production.
Planning and Maintaining Database Backups both Logical and Physical.
Applying database patches (OPATCH).
Configuration of Physical Stand-by database.
Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
References:
Available on Request
