Sr Developer/DBA

TAJINDER SINGH

***** ****** **** ** *****: *******@*****.***

Tecumseh Ontario N8N 2M1 Mobile: +1-519-***-**** __________________________________________________________________________________

OBJECTIVE:

To pursue a challenging position in development, implementation and support of DBA with a reputed organization that offers professional growth, constant learning opportunities and effective utilization of my skills, experience and abilities.

SUMMARY:

• Around 5 years of total IT experience of which 3 Years as Apps DBA in supporting , Maintaining, patching and cloning of 11i and R12 Instances and 2years as an Oracle DBA

• Strong skills in Oracle Applications 11i and R12 and Oracle 9i/10g/11g Database Administration including System Administration of Oracle Apps

• Experience in Upgraded E-Business suite application instances from 11.5.9 to 11.5.10.2

• Experience in upgrade from 11.5.10.2 to R12

• Experience in Managing Concurrent Managers

• Extensive experience in Maintaining Single Node, Multi Node of Oracle Applications 11i and Release 12

• Excellent experience in Oracle Applications Cloning using rapidclone

• Cloned the instances using manual cloning method when needed

• Excellent experience in cloning from multi node to single node

• Excellent experience in Oracle Applications Patching using adpatch utility

• Administration of Oracle Applications using OAM & Sysadmin

• Experience in Cloning databases using RMAN

• Creating Users with restricted access with required Privileges

• Exporting and Importing database backups using Exp & Imp and Datapump utilities

• Having Knowledge on configuring ASM Disks, Asm Disk groups & ASM Instances

• Knowledge on DATAGUARD and Create and maintaining Physical standby database

• Troubleshoot the issue as and when required

• Analytical and able to adapt to new environments and learn new technologies quickly.

JOB PROFILE:

• Worked as an Oracle Apps DBA with Wipro Technologies, Hyderabad from Sept 2010

to April 2011.

• Worked as an Oracle Apps DBA and Oracle DBA with INFOSYS, Hyderabad from July 2006 to Feb 2009.

EDUCATION QUALIFICATION:

• Bachelor of Electrical and Computers Engineering, Jawaharlal Technological University, Hyderabad, India from May 2002 to June 2006

• Masters in Computers and Electrical Engineering , University Of Windsor, Canada. Sept 2009 to August 2010.

SKILL SET:

ERP : Oracle Applications 11i, R12

Database : Oracle 9i, 10g & 11g, Sql Server 2000/2005/2008 Microsoft

Access

Operating Systems : Linux/Unix , Windows

Languages : C, C++, java

Tools/ Utilities : OAM, OEM, RMAN, AD utilities, FND utilities, putty, Ms Office

PROJECT DETAILS:

Project : Support & Maintenance

Company : WIPRO

Client : Business client, USA

Work Location : Hyderabad

Designation : Oracle Apps DBA

Duration : Sept 2010 to April 2011

• Cloned the instances for the Patch and Development.

• Cloned multi-node instances to single node.

• Support and Monitor Oracle Application instances

• Applying Patches and Cloning instances

• Cloned the instances using manual cloning method when needed

• Application cloning through Rapid clone.

• Planning and Maintaining Database Backups

• Responsible to take offline/online and RMAN Backups and to recover when needed

• Monitoring Concurrent Manager activities

• Creation of user accounts and granting privileges to users

• Implementation of disk quotas to various users

• Expertise in monitoring the activities through various tools such as OEM

• Prepared the Backup and Recovery Strategy.

• Maintaining and administering Application Users.

• Support and Monitor Oracle Application instances

• Upgraded E-Business suite application instances from 11.5.10.2 to R12

Project : Support & Maintenance

Company : INFOSYS.

Client : Medplexus Inc, USA

Work Location : Hyderabad

Designation : Oracle Apps DBA

Duration : Sept 2007 to Feb 2009

Roles & Responsibilities:

• Monitoring Concurrent Manager Activities.

• Performing daily Health checks.

• Applying Patches and Cloning instances.

• Performed Multi node to single node cloning.

• Created and migrated responsibilities from TEST to PROD instance.

• Regularly monitored the table spaces for space allocation.

• Planning and Maintaining Database Backups.

• Complete data migration .

• Routine analysis of SQL for tuning opportunities

• Recommendation of indexing to improve SQL performance

• Responsible to take offline/online and RMAN Backups and to recover when needed

• Interacted to with Whole team to get the sysadmin work done along the support project

• Upgraded E-Business suite application instances from 11.5.9 to 11.5.10.2

• Implemented shared appltop after upgrading to 11.5.10.2

• Troubleshoot the issue as and when required

Project : Support & Maintenance

Company : INFOSYS.

Client : The Great West Life Annuity.

Work Location : Hyderabad

Designation : Oracle DBA

Duration : July 2006 to Aug 2007

Roles & Responsibilities:

• Involved in design the databases, implementation

• Export/Import of tables, tablespaces and schemas

• Managing undo segments redo logs

• Regular checking alert log and trace files for errors

• Security management through creating user accounts, user privileges, roles

• Planning/implementing backup/recovery strategies, maintenance the databases

• Regular backup, restore and recovery of the databases using RMAN

• Applying RDBMS Patches and Cloning

• Upgraded database from 9i to 10g

• Identification of poor SQL statements and creation of indexes or embedded hints to improve performance.

• Production of an informal list of SQL performance tuning guidelines to improve the quality of future code development

• Troubleshoot the issue as and when required

REFERENCES:

Provided on request.

Contact this candidate