SUMMARY

• 8 years of practical experience as an Oracle Database Administrator and Oracle Applications DBA.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, HP - UX, HP-TRU 64 OS.
• Installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS, 11i, R12 applications.
• Good Knowledge of Oracle SQL & PL/SQL programming and query tuning.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR.
• Upgrading database from one server to another using Export and Import utility.
• Hands on experience in using Oracle DATAPUMP feature for bulk metadata and data movement.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• This includes database health check, active listeners, automatic backup (HOT backup or COLD backup), disk space availability, alert log errors etc.
• Setup a crontab jobs for production environment to receive automatic alerts related to TS issues, OS level space issues, locking issues etc.
• Installed and Configured Oracle Application Server 10g (10.1.2.x & 10.1.3.x SOA) with Portal and Discoverer as an active application.
• In depth understanding in UNIX administration, Project Management, Perl Scripting and Technical documentation.
• Configured, created and Managed Oracle Data Guard in a Real Applications Clusters (RAC) Environment
• Installed and Managed 10g Database R 2 10.2.0.4.
• Installed and Configured Oracle Application Server 10g SOA (10.1.3.4).
• Installed, Configured and deployed SOA on single node and cluster node.
• Applied patches to 11.5.5, 11.5.9, 11.5.10.2 versions of Oracle E-Business suite.
• Upgraded Oracle Database 9i (9.2.0.4) to Oracle Database 10g (10.2.0.3) and 10g to 11g (11.1.0.6).
• Worked on different load balancing techniques such as client side load balancing and failover, Server side connection load balancing.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Configured Web Server plug-ins for Application Servers.
• Applied patches using ADPATCH, ADCTRL utilities.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Daily activities include taking backups with RMAN, Hot and Cold Backups.
• Converted the database from 32-bit into 64-bit on Linux Environment.
• Setup a cronjobs using crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS

Databases: Oracle 8i, 9i, 10g RAC

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX, TRU 64OS

Languages: C, C++, PERL, SQL.

Performance Tools: TKPROF, STATSPACK, Explain Plan.

Others: AD Utilities, SQL * Loader, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr. Oracle Apps DBA /DBA

Responsibilities:

• Worked as Database architect and involved in installation of Oracle software
• Provided 24x7 Production support of Oracle Applications Administration & maintaining production, development and test databases and applications.
• Involved in Oracle BIEE 10 to 11.1.1.5 upgrade with BI apps and OBIEE clustering and enabling SSO.
• Upgraded OS from Linux 4.8 to Linux 5.7 application running EBS R12, OBIEE 11g, OID 11g, SSO 10g, Fusion Middleware 11g.
• Upgraded EBS from R12 12.1.2 to 12.1.3.
• Responsible for Oracle applications enterprise suite installations R12.
• Responsible for Cloning EBS R12 instances, RAC to RAC and RAC to non-RAC.
• Involved in OEM 10gR2 to OEM 11gR1 upgrade and waiting for ACP/AMP 3.1 pack once ACP/AMP for OEM 11GR1 release.
• Implemented jumbo frame for existing 11g R1 RAC instance and tuning kernel parameters.
• Implemented huge page with Oracle 11g R1 database.
• Involved in the build related activities, design and deployment
• Responsible for migrating Websphere from 6 to 8 versions.
• Involved in Release Management and Code Management using CVS
• Responsible for Administration job for Oracle, System, Websphere in all platforms.
• Worked on Websphere Clustering, Configuration and Installation.
• Involved in Application 64 bit Migration of Linux OS.
• Supporting for Linux migration from 4.7 to 5.7 version
• Involved in deploying and troubleshooting application code.
• Created database design for new project and implemented the same.
• Analyzed and suggested improvements to SQL/PLSQL queries and statements written by developers.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• Installed Oracle 9i, 10g on Solaris, Linux and Windows.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading datainto custom tables etc.
• Responsible for planning for storage spaces requirements and placing them for optimum I/O performance.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Involved in tuning the databases for optimal performance and monitoring CPU performance.
• Performed load test on oracle application server using SOA UI.
• Worked on Troubleshooting DMZ Setups for Apps.
• Responsible for installing, configuring and maintaining Oracle Grid control.
• Converted the database into Automatic Storage Management (ASM) enabled database

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Oracle Applications EBS 11i/R12 (12.0.4), Oracle 9i & 10g RAC, TOAD, Developer 6i

Confidential, New York City, NY

Oracle DBA/Apps DBA

Responsibilities:

• Installed, Configured, Upgraded and SupportedOracle Applications 11i e-businesssuite.
• Monitored production, development & test databases and applications.
• Upgraded Oracle Applications 11i e-business suite to R12 for testing and development environments.
• Responsible for Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC
• Involved in Data Guard Implementation on ASM File System TEST to RPOD
• Involved in Troubleshooting concurrent manager, discoverer, forms, reports servers and workflow mailer problems.
• Performed Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Applied patches using ADPATCH, ADCTRL utilities
• Configured DMZ setup for external applications
• Applied Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planning and Administration of backup and recovery strategies.
• Created Application Users, Profiles, Responsibilities, Menus, and Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely with user groups to ensure timely implementation of an ERP.
• Very good experience in creating SR’s through Metalink.
• 24x7 Production support of Oracle Applications Administration
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Implemented cloning of Production database in testing environment to provide users the live data for testing purposes.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Involved in Performance tuning of Oracle Database, applications and queries.

Environment: Solaris/Unix Oracle 9i&10g, Oracle Applications 11i TOAD, Developer 6i

Confidential, Chicago, IL

Oracle DBA/Apps DBA

Responsibilities:

• Involved in the installation of Oracle 8i on Windows and LINUX platform
• Prepared Backup and Recovery Plan
• Created tables, indexes, tablespaces, users, integrity constraints and supported all phases of a development cycle
• Analyzed and suggested improvements to SQL queries and statements written by others
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL
• Wrote Oracle scripts for the SQL and PLSQL requirements for various applications
• Optimized the SQL queries to meet the performance requirements
• Worked with database export and import scripts to backup database structures and automation procedures
• Involved in day to day Performance Monitoring and tuning of database
• Performed Monthly Cold Backup, Weekly Hot Backup and daily backups using Export
• Testing of Backups and documenting backup strategies. Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.
• Used TKPROF, EXPLAIN PLAN for better performance.

Environment: Linux Oracle 9i&10g, Oracle Applications 11i TOAD, Sql Developer

Confidential

Oracle DBA

Responsibilities:

• Startup and shutdown of database whenever it needs
• Monitor database for operations and issues
• Database archive files
• Database alertlog files
• Database redolog files
• Database temporary files
• Tuning the database when it needs.
• Perform on demand backup (Full cold backup)
• Schema migration (export and import, logical backup)planning of
• Backup strategy, creation of scripts for online/off-line as well as for logical backup and Set for automatic execution
• Tablespace and Storage Management Allocate and manage automatic storage management (put and watchdatafiles on autoextend mode).
• Address any storage issues on the mount point.Watch for storage growth and allocate storage by working withstorage management.
• Creating materialized view and run then using Cron jobs.

Environment: UNIX and Windows Oracle 9i&10g, TOAD, Developer 6i