Oracle Manager
Resume:
B.SATISH KUMAR
E- mail: ****************@*****.*** Contact No: +91
Objectives:
Seeking a challenging and responsible position in software environment
where award-winning experience, proven skills and superior work ethic
will add value.
Professional Experience:
Total 5+ years of experience as Oracle APPS DBA (11.5.x), Oracle DBA
(9.2.0.x and 10.2.0.x&11g) Administration and Maintenance
. Currently Working as an Oracle APPS DBA in NIPUNA SOLUTIONS, for
Pound Lands(U.K), Oger Emirates ( Soudi Arabia).
Knowledge in Oracle Apps DBA:
. Experience in installations of Oracle Applications 11.5.9/11.5.10.2
. Support experience in Oracle R12 Upgrade projects.
. Ability to do 10gAS Installation and configuration with Supervision
. Knowledge of Real Application Cluster, Load Balancing, Shared tech_
stack.
. Ability to do Installation, Patching, Cloning, System Administration,
Backup and recovery, administration and monitoring without supervision
. Installation of Oracle Application in Single Node and Multiple Nodes.
. Cloning of Oracle Application through Rapid Clone.
. Experience Database recovery manually as well as using RMAN.
. Applying patches in Production Environment following proper
methodology and documenting Pre-checks and CPU and PSU Validations.
. Understanding and troubleshooting issues in Concurrent Manager and
Load Balance Utility.
. Knowledge in configuring Oracle RAC, ASM and Oracle Clusterware.
. Involved in DB Upgrade and Migration Projects.
. Experience with adutilites (adadmin, adslicer, adident, adctrl,
adpatch...etc)
. Experience to work with OEM (oracle enterprise manager)
Other Tools & Technologies:
. Shell Scripting. Understanding perl Scripts.
. C, C++ Language, PL/SQL Code writing. Forms and Reports Designing.
. Handy on VMware Workstation on OS like Oracle Enterprise Linux 4 and
Windows Server 2003(Host Machines).
. Knowledge on IP networking and handy on tools like FileZilla (FTP
Client), Putty (SSH, Telnet clients) and configuring hosts at
different OS levels.
. Very good knowledge on Linux installation disk allocation, File
permission, Creating Users,ID,groups,Configuring System Settings
both GUI / CUI
Knowledge in Oralce Core Databases:
. Installation of Oracle server on Linux platforms.
. Creating & Maintaining of Databases
. Monitoring Alert logs for any errors, problems or processes running
. Backup, Recover and Clone the database.
. Creating / Altering Users as and when required and administer their
respective quotas.
. Create and Maintain Roles and assign necessary privileges to users
according to business requirements.
. Practical experience in monitoring and tuning a database using oracle
tools like AWR
. Database security imposition by creating and granting roles.
. Creating and Managing Table spaces and Data files.
. Planning and scheduling Backups, Database Recovery, taking Logical
Backups & Physical Backups.
. Incomplete recovery of complete database using Flashback Database.
. Knowledge in cloning using cold backup, hot-backup and RMAN backup.
. Migrating databases using various tools such as Import/Export and Data
pump.
. Extensive knowledge on database patching.
Educational Qualifications:
March 2006 - Diploma in Commercial and Computer Practice from SBTET - Hyd
March 2009 - Bachelor of Commerce (Computers) from Osmania University
Technical Skills:
Operating Systems : RHEL 4.x/5.x, Enterprise Linux 4.x/5.x
Database : Oracle 9i, 10g
Oracle e-business suite : Oracle Application Technology stack
11.5.9/11.5.10.2
Programming : SQL, Core Java, Hard Ware & Net Working
Assigned Project : Oracle Applications 11i - Maintenance
/Installation
Company : NIPUNA SOLUTIONS
Client : Pound Land (UK) and Oger Emirates (Soudi
Arabia)
Role : Application Database Administrator (Apps
DBA)
Environment : Oracle Application 11i and Linux
Period : Oct 2010 to Till Date
Responsibilities:
. Providing the first level troubleshooting by regularly verifying
database alert log files
. Troubleshooting Oracle Apps related issues
. Installed, configured and administered Oracle Applications 11i on
multinode
. Knowledge in Multi node, shared APPLTOP and load balancing
. Used Oracle Application tools for maintaining the database and
application like adpatch, adadmin, adctrl etc
. Applied RDBMS patches, maintenance packs, mini packs.
. Doing Prepatch analysis and documentation Applying patches after pre-
req analysis
. Using merged patch admrgpch for applying translation and compatible
patches
. Scheduling and minimizing the down time of the production system by
testing on a test system
. Creation of concurrent managers, programs and request sets
. Managing the Concurrent Managers and its operations like starting,
stopping the concurrent managers, re-schedule the requests, monitoring
of the concurrent manager operations.
. Cloning of Oracle Application through Rapid Clone
Assigned Project : Oracle Databases 9i&10g - Maintenance/Support
Company : Glansa Solutions, Hyderabad
Client : Spare Web Technologies
Role : Oracle DBA ( Support Oracle Apps DBA)
Environment : Oracle Database 9i/10g and Linux
Period : April 2009 to Oct 2010
Responsibilities:
. Installation of Oracle 9i,10g in LINUX environment.
. Installed, configured and administered Oracle Applications 11i on
multinode
. Used Oracle Application tools for maintaining the database and
application like adpatch, adadmin, adctrl etc
. Applied RDBMS patches, maintenance packs, mini packs.
. Doing Prepatch analysis and documentation Applying patches after pre-
req analysis
. Monitoring alert log for any kind of errors.
. Creating / Altering Users as and when required and administer their
respective quotas.
. Create and Maintain Roles and assign necessary privileges to users
according to business requirements.
. Database security imposition by creating and granting roles.
. Creating and Managing Table spaces and Data files.
. Creating and Rebuilding Indexes. Monitoring index usage.
. Applying patchsets such as 9.2.0.6, and applying one-off patches using
OPatch.
. Physical Database Backup and recovery (Hot and Cold Backups) using
RMAN.
. Logical Backup using EXPORT/IMPORT.
. Performed manual clone, RMAN clone from production to development.
. Responsible for implementation, support, maintenance of Production/
Development/ Test Databases on LINUX.
Assigned Project : Oracle Databases 9i&10g - Maintenance/Support
Company : BHEL R&D, Hyderabad
Role : Oracle DBA (Training)
Environment : Oracle Database 9i and Linux
Period : August 2006 to August 2007
Responsibilities:
. Installation of Oracle 9i,10g in LINUX environment.
. Monitoring alert log for any kind of errors.
. Creating / Altering Users as and when required and administer their
respective quotas.
. Create and Maintain Roles and assign necessary privileges to users
according to business requirements.
. Database security imposition by creating and granting roles.
. Creating and Managing Table spaces and Data files.
. Creating and Rebuilding Indexes. Monitoring index usage.
. Physical Database Backup and recovery (Hot and Cold Backups) using
RMAN.
. Performed manual clone, RMAN clone from production to development.
Personal Profile:
Date of Birth : 12/08/1987
Marital Status : Single
Languages Known : Telugu, English, Hindi,
Nationality : INDIAN
Contact this candidate