Sr Oracle DBA

Name :Mohan Singh.G

Email:*****.*********@*****.*** Mobile: +91-720*******

Objective

To prove myself dedicated, worth full and energetic as an Oracle APPS DBA in a progressive organization that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.

Summary

• Over 3.5 years of experience in Oracle Apps 11i/R12

• Good Knowledge in Oracle core DBA and Oracle APPSDBA

• Very strong in database management, database architecture, data dictionary and storage management.

• Experienced of managing and administering 24 X 7 running databases.

• Excellent communication and interpersonal skills. Very good team player as well as self motivated hard worker and a good learner.

Education Qualification

Bs.c. (comps) from Nagarjuna University, Guntur, A.P.

Skill Set

Operating Systems : Windows XP Professional, Windows 2000 Server, Windows 98, Red Hat Linux

Languages : SQL.

Database Servers : Oracle 9i/10g

ERP : Oracle Applications (Release 11i) e-Biz suite.

Tools/Utilities : SQL * Plus, SQL * Loader, RMAN, OAM, AD Utilities.

Professional Experience

• Working as Oracle Apps Dba in Atlas logistics, Bangalore From Dec 2008 to Till Date.

• Working as Oracle Apps Dba and Core Dba in V2Soft Pvt Ltd, Bangalore From Aug 2007 to Nov 2008

Project Details

Project Name :Production Support for Oracle Applications

Role : Oracle Apps Dba

Environment : Oracle E-Business Suite 11i, Red Hat Linux,Oracle 9i,10g.

Duration : Dec 2008 To Till Date

Responsibilities:

• Performed Oracle Apps 11.5.10 System administrator tasks.

• Responsible for Creating Setting Up Users and Assigning Responsibility in various Operating Units

• Setting System and User Profile Values

• Create and maintain custom responsibilities and menus.

• Create custom concurrent requests to perform database maintenance.

• Create and configure custom applications.

• Workflow Administration

• Setting Profile Options (Site level, User level)

• Create database objects for custom applications.

• Apply database and applications patches

• Developing Strategies for Oracle Applications Upgrades from a lower version to higher version and performing the upgrades

• Applied product specific fix patches, family packs, and maintenance packs -- all types of patches using adpatch utility.

• Troubleshoot problems with web server, web listener, forms server, concurrent managers, and database.

• Relinking applications executables

• Monitoring user’s activity using sign-on audit reports

• Tuning Concurrent Managers, Defining Work Shifts, configuring specialization rules.

• Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink)

• Cloning Oracle Applications 11.5.10

• Managing system configuration by using AutoConfig

• Compiling forms/pll's, DB invalids, creating DB links

• Developing Backup strategies (Hot, Cold) for weekend backups of important environments

• Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues.

• Creation of Database Users and Registering in Oracle Apps

• Created tablespace for custom based user data tables and indexes

• Monitoring the environments from OAM

• Install NLS software when new language support is required.

Project Details

Project Name : Enterprise Tracking System

Role : Oracle Apps Dba and Oracle dba

Environment : Oracle E-Business Suite 11i, Red Hat Linux 4.0,Oracle 9i,10g

Duration : Aug 2007 To Nov 2008

Responsibilities:

• Installation of 11.5.10 on single node and multiple nodes.

• Installation of Web applications server, Oracle Applications server and Oracle Forms server.

• Apply database and applications patches

• Create and maintain custom responsibilities and menus.

• Create custom concurrent requests to perform database maintenance.

• Create and configure custom applications.

• Upgrades from a lower version to higher version and performing the upgrades

• Applied product specific fix patches, and family packs -- all types of patches using adpatch utility.

• Resolving system errors, disk space problems.

• Managing system configuration by using AutoConfig

• Install NLS software when new language support is required.

• Troubleshoot problems with web server, web listener, forms server, concurrent managers, and database.

Responsibilities: (9i/10g Database): As DBA

• Monitoring tablespaces and adding data files or resizing data files.

• Managing Physical structure tof database like data files, Redo log file and control files

• Monitoring temporary tablespaces and taking proper actions.

• Monitoring the growth of Tables pace and taking proper actions.

• Creating Database objects, Users, Roles, Profiles for the databases.

• Troubleshooting errors in Database.

• Data files relocations.

• Backup, Restore, Recovery and DB cloning using RMAN.

• Creating databaselink&materialized views.

• Experience in logical backup using Data pump, Export and Import.

Cloning of production database to the test environment using Recovery Manager (RMAN).

• Reorganizing Data using Logical Backup, Export, Import and Transportable tablespaces.

• Database software upgradation from Oracle 9i to Oracle 10g.

• Managing and Monitoring Production Database Instance.

• Applying patches on database, using Opatch utility.

Contact this candidate