Oracle Computer Science

Safran Ahmed

Oracle Apps DBA

Telephone: +91-727*-***-***, +91-916*-***-***

E-mail: ******.*****@*****.***

Objective

To work in a company or organization where my technical and computer knowledge can best be utilized and enhanced.

Experience

LPO Legal Advantage Pvt. Ltd. Hyderabad November 2013 – Present

During my career working with this company, I gained experience in the following fields:

●Very good understanding of Oracle E-Business Suite R12 and oracle database 11g architecture.

●Cloning Oracle E-Business Suite R12 using rapid clone and oracle database 11g cloning manually and as well as using RMAN tool.

●Patching Oracle E-Business suite application tier using AutoPatch utility and oracle database using Opatch utility.

●Performing Oracle E-Business Suite maintenance tasks using AD admin utility.

●Performed troubleshooting of errors and managing concurrent managers.

●Proficient in using Rman.

●Creating and managing tablespaces and datafiles in oracle database.

●Managing the physical database structure by maintaining, multiplexing and mirroring of data files, control files, redo log files, and archived log files.

●Changed Oracle E-Business suite R12 users passwords using FNDCPASS utility.

●Implement and maintain database security using roles and profiles.

●Creating users, granting and revoking privileges.

●Assigning users to tablespace and quota, Locking and unlocking users.

●Configuring and troubleshooting Oracle Net Listener, Local Net Service Names, and ARCHIVELOG mode

●Strong technical background excellent analytical ability, good communication skills, team player and highly professional with a commitment towards excellence.

Courses &

Certifications

Oracle Certified Professional (OCP)

Oracle Certified Associate (OCA) Certified diploma in Oracle Apps DBA Certified diploma in Oracle DBA

Education

Bachelor of Computer Application (BCA) 2010

I am a bachelor of Computer Application and graduated from Dr. Babasaheb Ambedkar Marthwada University, Aurangabad

Masters in Computer Science (MCS) 2013

I also mastered in Computer Science from the aforementioned university

Project

Platform Software & Modules

R12 Implementation and Support Red Hat Linux, Sun Solaris 10 Oracle E-Business R12 (GL, AP, AR, CRM)

●Installation Oracle EBS Suite 11i and R12 on Linux.

●Managing concurrent manager related issues.

●Oracle applications login related issues.

●Handing the oracle application maintenance activity through OAM.

●Creation of user and assigning responsibility.

●Implementation the backup strategy for Oracle Application R12 and 11i instances.

●Installing Oracle Application R12 on Red Hat Linux.

●Patch implementations.

●Cloning the Applications.

●Adhoc troubleshooting.

●Hands-on experience with RMAN as well as manual backup and recovery techniques.

●Database cloning from hot & cold backups.

●Oracle Database Minor Upgrade (Patch set Upgrade).

●Monitoring the undo tablespace and temporary tablespace use.

●Planning and maintaining database backups Cold, Hot, RMAN, and logical backups.

●Monitoring performance of the database.

●Creating manually database if required.

●Adding and resizing data files.

●Managing the users profiles.

●Checking alert log files to monitor the database activities.

●Checking whether Listener is running or not.

●Adding and resizing the data files as per requirement.

●Can Support 24x7 Production Database Environments.

●Responsibility for preparing documentations of all the activities and handover to team.

Furthermore, I have experience with the programming languages of SQL, PL/SQL, Unix Shell Scripts, and Perl, with the knowledge to manage on Linux (Red Hat, Solaris), Windows (XP and beyond), and OEL (4,5). I have used the Oracle tools RMAN, OEM, OAM, AWR, and Data Pump.

Safran Ahmed Syed

Contact this candidate