## BIO
**Work Experience Summary**
2 Years (approx) of Experience, Primarily in Oracle and Oracle Apps administration, schema design and implementation with specialization in UNIX Shell Scripting and Integration Services (EAI/FTS)
Nov ’06 – Till Now: **Oracle & Oracle Apps (R11i) DBA**, Teradata India Pvt Ltd.
July ’06 –Oct’06: Project Associate, Indian Institute of Technology- Delhi.January ’05 – June ‘06: Research Trainee, Indian Institute of Technology- Delhi
*.*
**Education**
**Bachelor of Engineering (Computer Science)**
**Skill-Set Summary**
**Key Strengths**
*In-depth knowledge of Oracle 9i and 10g systems and Oracle Apps (R11i) as DBA; Specialization in Unix Shell Scripting and Development in Perl and C; Sound knowledge of Linux and Unix system Administration; Effective written and verbal communication skills, exposure to complete development lifecycle*
**Database Administration Skills**
· Administrating and troubleshooting Oracle Apps Instances in single & multi node environments.
· Up gradation of Oracle Applications (11i to 11.5.x) to current releases and current product-level by applying Mini packs and Maintenance patches on various platforms (Sun Solaris and Linux).
· Extensive experience in usage of AD Utilities like Adpatch, Adadmin, Adsplice, Adctrl, Adlicmgr, Admrgpch.
· Installation, patching, cloning, concurrent manager, Maintenance Pack application, JDK, JInitiator, Dev6i upgrade and handling day-to-day APPS DBA tasks
· Extensive Oracle DBA (8.x / 8i.x / 9i.x/10g) experience in administrating and troubleshooting single instance databases in Production, Support and Development environments.
· Up gradation of the Database from 8i to 9i and from 9i to 10g.
· Applying database patches with Opatch utility.
· Installation, backup and recovery, Export, Import, database security, standby DB, OAM/OEM, Net8, listener.
· Strong exposure to UNIX and Windows platforms (Sun / Linux / HP / Win-2k / Win-XP) to handle regular Sys Admin activities to support Oracle Apps Instances installed on Unix/Win boxes.
· OS installation, File system maintenance, Patch application, Installing 3rd party SW, User maintenance, Disk and Memory usage.
· Automation of jobs using crontab & at.
· Conversant in working with Metalink, TAR handling.
· Expertise in cloning and patching and can handle 4 clones at a time.
**Databases**
* *Oracle 9i and 10g, Oracle Apps (R 11i).*
**Languages**
* *PL/SQL, Shell Scripting, Perl and C.*
**Operating Systems**
* *Linux (RHEL3 and Fedora), Sun Solaris, Windows 2000/2003/NT*
**Tools**
* *GUI Oracle Developer 2000, RMAN, Sonic MQ and Connect: Direct*
**Web Technologies**
*HTML, JavaScript, VBScript and JSP.*
**Project Coordination and Team Management**
*Team Building Skills, Inter-team coordination, Strong Written & Verbal Communication Skills*
**Work Experience Details**
<u>**Teradata India Pvt Limited, Gurgaon (From Nov ‘06 – Till Now)**</u>
**Roles:**
1. **<u>Oracle 9i and Oracle Apps DBA</u>**
**<u>Responsibilities:</u>**
* Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
* Plan & oversee the patching and upgrade of Oracle apps servers
* Creation and Cloning of Applications and Databases (e.g. Manual, Autoconfig and Rapid Clone)
* Creation and maintenance of primary database storage structures (tablespaces), and primary objects (tables, views, indexes) after application developers have designed an application
* Database performance monitoring and optimization including database tuning during development
* Allocate system storage and plan future storage requirements for the database system
* Creating and adding datafiles to primary database storage structures.
* Controlling and monitoring user access to the database as a part of system security maintenance
* Planning & Execution of backup and recovery of database information
* provide any required application specific administration tasks
* Ancillary activities include customization and automation of regular DBA activities and operating system specific tasks by way of shell scripts and SQL scripts.
* Monitoring Database Growth.
* Provide Technical Support to End Users and Developers.
* Applying Patches as per end user or developer’s requests.
**<u>Major Challenges:</u>**
* Timely and high quality incident resolution focusing on root cause analysis, prevention, and knowledge transfer.; with a complete breadth of problem areas
* Quick understanding of the environments and their specific problems
* Managing Communication Issues with different clients
1. **<u>Integration Services/EAI</u>**
**<u>Responsibilities:</u>**
* Provide 24x7 support to all EAI interfaces for Teradata.
* Design and Develop interfaces on Sonic MQ to enable messaging among multiple applications
* Develop Shell Scripts and Perl scripts to facilitate File Transfer Interfaces between Teradata and its Customers using Connect:Direct.
* Design and Develop and Auto Monitoring System to monitor File Transfers.
* Create interfaces for external customers like JC Penny, American Express, ADP, etc… to interact and share the data
## Area of Expertise
**Skill-Set Summary**
**Key Strengths**
*In-depth knowledge of Oracle 9i and 10g systems and Oracle Apps (R11i) as DBA; Specialization in Unix Shell Scripting and Development in Perl and C; Sound knowledge of Linux and Unix system Administration; Effective written and verbal communication skills, exposure to complete development lifecycle*
**Database Administration Skills**
· Administrating and troubleshooting Oracle Apps Instances in single & multi node environments.
· Up gradation of Oracle Applications (11i to 11.5.x) to current releases and current product-level by applying Mini packs and Maintenance patches on various platforms (Sun Solaris and Linux).
· Extensive experience in usage of AD Utilities like Adpatch, Adadmin, Adsplice, Adctrl, Adlicmgr, Admrgpch.
· Installation, patching, cloning, concurrent manager, Maintenance Pack application, JDK, JInitiator, Dev6i upgrade and handling day-to-day APPS DBA tasks
· Extensive Oracle DBA (8.x / 8i.x / 9i.x/10g) experience in administrating and troubleshooting single instance databases in Production, Support and Development environments.
· Up gradation of the Database from 8i to 9i and from 9i to 10g.
· Applying database patches with Opatch utility.
· Installation, backup and recovery, Export, Import, database security, standby DB, OAM/OEM, Net8, listener.
· Strong exposure to UNIX and Windows platforms (Sun / Linux / HP / Win-2k / Win-XP) to handle regular Sys Admin activities to support Oracle Apps Instances installed on Unix/Win boxes.
· OS installation, File system maintenance, Patch application, Installing 3rd party SW, User maintenance, Disk and Memory usage.
· Automation of jobs using crontab & at.
· Conversant in working with Metalink, TAR handling.
· Expertise in cloning and patching and can handle 4 clones at a time.
**Databases**
* *Oracle 9i and 10g, Oracle Apps (R 11i).*
**Languages**
* *PL/SQL, Shell Scripting, Perl and C.*
**Operating Systems**
* *Linux (RHEL3 and Fedora), Sun Solaris, Windows 2000/2003/NT*
**Tools**
* *GUI Oracle Developer 2000, RMAN, Sonic MQ and Connect: Direct*
**Web Technologies**
*HTML, JavaScript, VBScript and JSP.*
**Project Coordination and Team Management**
*Team Building Skills, Inter-team coordination, Strong Written & Verbal Communication Skills*
Programming: C, C++, MATLAB,VB.Net, ASP.Net. Operating systems: Linux(Red-hat, Debian, Mandrake), win3.1/95/98/ME/ NT/2000. Web Development: HTML/XML, FrontPage, DreamWeaver, J.S.P., A.S.P., Java Script, VB-Script, Apache Server. Packages Used: ORACLE, Microsoft FrontPage, Microsoft Excel.