Manager Oracle
Resume:
Name: Singarao
E-mail: ********.****@*****.***
Mobile: +91-740*******
Professional summary
• Around 4.2 years of experience in Oracle Application DBA with good analytical and problem solving skills.
• Experienced of managing administering 24/7 running Databases.
• Good Knowledge on Installation of Oracle Application with single node and multi nodes in 11.5.10.2 on Linux environments.
• Hands on experience with AD Utilities: Adadmin, Adpatch, Adconfig, Adctrl, Adsplice & Adrelink.
• Application of Patches using Adpatch and consequently troubleshooting the errors during patching
• Tracking Invalid Objects, Compiling and Validation them from Ad-admin tool.
• Applying database patches using Opacth.
• Troubleshoot problems with Apache, Concurrent managers and Forms.
• Relinked the application product executables using adrelink.
• Sysadmin tasks like creating user, assigning responsibilities, registering forms, concurrent programs.
• Securing Oracle Applications by periodically changing Apps and schema passwords using FNDCPASS.
• Experienced in cloning by Rapid clone for test server from production server.
• Experience in Space management which includes creating table spaces and adding data files as per the requirement.
• Performing Daily and weekly backups using various Backup strategies.
• Experienced in Performed user managed & RMAN backups and recovery.
• Creating Database links. Export/Import of schemas and tables from production to test.
• Experience on OAM.
• Experience on R12.
Educational Qualification
B.Sc (Bachelor of Computer Sciences) from Nagarjuna University, Guntur.
Technical Qualification
ERP : Oracle Applications 11.5.9, 11.5.10 & R12.
Languages : C and C++, SQL, PL/SQL
Databases : Oracle 9i. & 10g and 11g
Operating Systems : Windows9x/XP/NT, UNIX, RHLAS3, AS4,
Solaris 5.8/9/10,HP UX
Tools : Toad, Putty
Tuning Tools : OEM, Stats pack, OAM, Tkprof.
Ticketing Tool : Remedy
Work experience
Working as Apps DBA in Accenture, Bangalore from May 2010 to till date.
Worked as Apps DBA and Core DBA in V2Soft Pvt Ltd, Bangalore from Oct 2008 to Apr 2010.
Project 1:
Client : Deutsche Bank, NY
Environment : Oracle-Applications E-Business Suite 11i and R12 on Linux 4.0
Role : Oracle Apps DBA.
Description
Deutsche Bank is a leading global investment bank with a substantial private client’s franchise. Its businesses are mutually reinforcing leader in Germany and Europe, the bank is continuously growing in North America, Asia and key emerging markets.
Responsibilities
• Support and Administration of Production and Test Instances.
• Performing health checks like checking the status of important services like concurrent manager, form server, web server, Application Listener, Database Listener etc.
• Troubleshooting various Apache, Forms and Concurrent manager related issues.
• Troubleshooting various Patching errors.
• Experienced in using AD utilities-adadmin, adpatch, autoconfig, adrelink, adsplice, admrgpch, adctrl.
• Managing system configuration by using AutoConfig.
• Used Autoconfig to make configuration changes like Apache Port etc.
• Clone the EBS production instance for test and development purposes.
• Applied various Patches using adpatch on Application file System.
• Find the file versions using adident.
• Used FNDCPASS for managing passwords.
• Creating Users from the front end and assigning them the appropriate responsibilities.
• Monitoring DB growth, Creating table spaces, Adding, Resizing, Renaming Data files.
• Backup, Restore, Recovery and DB cloning using RMAN.
• Creating database links.
• Generating AWR reports every day in Production database.
Project 2:
Client : Balfour Betty, UK.
Environment : Oracle-Applications E-Business Suite 11i on Linux 4.0
Role : Oracle Apps DBA.
Description
Balfour Betty is a leading global infrastructure business, with operations in over 80 countries. It has the expertise and resources to address every stage of the infrastructure lifecycle, from financing, to planning and design to construction, maintenance and support.
Responsibilities:
• Creating and managing tablespaces.
• Performing operations like Creation of Users and Granting Privileges to users.
• Experienced on using OPatch Utility.
• Used Rapid clone method for the Cloning of the Test and Development Instances.
• Export/Import, Hot and Cold Backups, RMAN Backups on DEV/TEST Databases.
• Involved in Database Upgradation from 10g to 11g.
• Involved Creating database links.
• Find the file versions using adident.
• Knowledge on handling various SYSADMIN activities.
• Experienced in using AD utilities-adadmin, adpatch, autoconfig, adrelink, adsplice, admrgpch, adctrl.
• Reduced the timelines of patching using various features like admrgpch etc.
• Relinked the application product executables using adrelink.
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & troubleshooting problems.
• Install NLS software when new language support is required.
• Resetting the Application user Passwords using FNDCPASS.
Project 3:
Client : General Motors (U.S)
Environment : Oracle Applications 11i
Role : Oracle Apps DBA
Responsibilities:
• Checking alert & apache log files on regular basis.
• Monitoring/Administration of Concurrent Managers.
• Analysis and Applying Apps and DB Patches by using adpatch and Opatch utility.
• Maintaining Oracle Application File System and Database using AD Utilities.
• Creating and maintaining the db users, privileges and profiles and managing security of db user access.
• Troubleshooting expertise for all tiers (Concurrent, Apache, Forms, Admin, Jinitiator and Database).
• Creating and Managing and monitoring of table spaces, data files.
• Temporary and Undo table spaces management.
• Taking Backup on Daily & Weekly Basis.
• Data Migration using EXP/IMP schemas, tables, table spaces.
• Configure the listener using netca utility
• Generating AWR, Stats pack & ADDM reports for analysing performance issues.
• Performed user managed & RMAN backups and recovery.
• Installed patch sets and Upgraded Database from 9ig to 10g.
• Creating and maintaining the db users, privileges and profiles and managing security of db user access.
• Resetting the Application user Passwords using FNDCPASS.
• Resolving system errors, disk space problems
Singarao
Contact this candidate