SUMMARY

• To be part of an organization, which would help, harness my technical capabilities and skills, thus contributing to the growth of the organization in turn. I consider avenues for growth into positions of high responsibility in an organization, an essential requisite for self - development.
• 9+ years of experience as an Oracle database administrator, providing 24X7 production and development support for 11g/10g/9i databases on various platforms, which include HP-UX, SUN SOLARIS, Windows and Linux.
• Having hands on experience in database administration, production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Expertise in implementation of High Availability solutions using Oracle 10g/11g RAC with ASM, Physical and Logical Standby Databases (Data Guard).
• Experience in Oracle Database 10g/11g Installation and Administration
• Experience in Oracle Discoverer 10g/11g integration with R12
• Configuration of Oracle 11g/10g OEM Grid Control to monitor databases.
• Experience in active database cloning from non-RAC to RAC on ASM and vice versa using RMAN Duplicate (11gR2).
• Experience in Oracle Application Upgrade from 11i to R12.
• Experience in RAC 10g/11gr2 implementation.
• SOA 10g implementation and configuration with RAC database.
• Experience in various DBA activities like Installation,Upgrade,Monitoring, Cloning, Patching, Performance Tuning, Backup and Recovery and other activities of 11i/R12 Application (RAC/Non RAC)
• Extensively worked in Oracle Technologies including Engineering, Architecture, Oracle Applications Installations and Upgrades, RDBMS installations and upgrades, Database Administration, Patching, Cloning, Performance Tuning, Backup, Restore and Recovery, Monitoring and Server Migration.
• Excellent shell scripting, batch programming. Automated several routine DBA tasks and schedule jobs in cron.
• Strong platform skills in Unix, Windows and Linux networking experience
• Knowledge of Forms Load Balancing & Parallel concurrent Processing
• Shell scripting for Unix, Linux Environment Systems and Batch Scripting
• Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Good Programming Skills inSQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, Logical and Physical Design, Backup and Recovery Procedures.
• Have strong technical background, leadership skills and excellent analytical and problem solving skills.
• Excellent analytical, problem-solving and learning skills and ability to quickly embrace and understand new technologies as well as a keen interest in the emerging technologies.

TECHNICAL SKILLS

RDBMS: Oracle 8i,9i, 10g and 11g

ERP Administration: Oracle Applications 11i, R12

Others: 10g Application Server/10g Web logic/ 10g OEM Grid/RMAN/11g Discoverer

Oracle Tools and Utilities: SQL*NET, Export & Import, RMAN, Putty, Toad and Backup Tools like Commvault and Bright store

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Operating System: Linux 32 bit/64 bit, AIX,HP Linux, Suse Linux, Sun Solaris and Windows XP, Windows NT4.0/2000

Programming Languages: SQL*Plus, PL/SQL, Shell Scripting, awk, Batch(DOS), MS SQL 2005,Microsoft Office, C,C++,Java, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, St. Louis

DBA Lead

Responsibilities:

• Migration from AIX to Linux, Upgrades 10g to 11gr2RAC
• High availability DR BUILD CONFIGURATION
• Non-ASM to ASM conversion.
• Managing 170 DBs
• Worked on creating the standby database for production oracle E-Business Suite instance (R12.1.1 with 11g RAC database)
• Patching security vulnerabilities as part of quarterly release, applying mini packs, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Retiring DBs
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Handling Escalations, Sev1 Cases and other Critical cases.
• Upgrade from 11i to R12
• Highly experience in Cloning of Oracle application environment using Rapid clone and adconfig.
• Upgraded CRS, ASM from 11.1.0.7 to 11.2.0.3 (grid Infrastructure) & Database from
• Installation, Configuration and implementation of Oracle E-Business suite R12 and oracle11g
• RMAN Backup and cloning Database using RMAN Active Duplicate
• Cloning of R12 E-Business Suite
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Exposure to Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Managing Workflow and its components through OAM.
• Setting up profiles for users.
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
• Gather stats using DBMS stats and FND stats to improve performance.
• Tracing Concurrent requests, forms, and database session.
• Installed and configured OBIEE 10g and 11g (11.1.1.6).
• DB Refreshes(Created Shell script and automated)
• Providing support (24*7) and troubleshooting user (remedy) tickets.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Environment: Prod, UAT, Test, Dev Redhat Linux, Hp Linux, Windows, Solaris, AIX

Confidential, Austion, TX

DBA

Responsibilities:

• Provide Technical Help to DBA’s, wherever necessary, for the execution of work.
• Perform reviews, analyze defects and take appropriate measures for their elimination prior to submission to Client
• Migrated database from AIX to Redhat Linux.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Applied RDBMS, CPU/Quarterly patches using Opatch.
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Configured AUTOCONFIG for handling customizations and Security issues.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Identifying the best plans using sql tuning advisor and migrating the sql profiles from one database to another database using ‘dbms sqltune package’.
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Highly experienced with Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Attends Status meeting with Client on periodic basis for the Projects.
• Delivery Weekly status report of DBA team to Client.
• Handling Escalations, Sev1 Cases and other Critical cases.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Environment: Prod, UAT, Test, Dev, ASCP instance and 10g Discoverer Linux, Solaris, AIX

Confidential

DBA

Responsibilities:

• Upgrade of Database from 10g to 11gr2
• Installation and configuration web cache 10G
• High availability DR BUILD CONFIGURATION
• Convert NON-ASM to ASM
• Configured oracle applications Release 11i with 11g RAC.
• Upgraded Oracle E-Bussiness Suite 11.5.10.2 to R12.0.4
• Database DB refresh, Performance Tuning
• RMAN backups and restores, cold and hot backups to tapes and file system.
• PCP configuration.
• Highly experience in Cloning of Oracle application environment using Rapid clone, OEM GRID and adconfig.
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Installation and configuration of oracle E-business suite 11i on shared file system (shared APPL TOP).
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Experience in installation and using Oracle Enterprise Manager (OEM) 10g GRID for some of the maintenance tasks.
• Patching security vulnerabilities as part of every quarterly release.
• Cloning of R12 E-Business Suite
• Interaction with Oracle Support Services to resolve mission critical issues.

Environment: Prod, UAT, Test and Dev RedHat Linux,HP-UX, Sun Solari,Windows 2000

Confidential

DBA

Responsibilities:

• Database Upgrade
• Database DB refresh(created Shell Scripting and automated)
• Experience in Oracle RDBMS software installations.
• Security CPU Patching, Performance Tuning
• Applied RDBMS, CPU/Quarterly patches using Opatch.
• Patch Application using Ad patch and Opatch utility
• Upgrade of Applications from 11i to R12
• Migration from Single tier to three tier architecture with an external DMZ istore node
• Platform migration from Sun Solaris 5.8 to Oracle Enterprise Linux 5.2.
• Cloning of R12 E-Business Suite
• Applied day light saving patches.
• Solve Locking issues at Database/ Apps level.
• SSO implementation
• Troubleshooting Workflow notifications issues.
• Interaction with Oracle Support Services to resolve mission critical issues.

Environment: Prod, UAT and Dev RHEL

Confidential

DBA/implementation/Support

Responsibilities:

• Performing Daily Health check to ensure the proper functioning of the production database and the Application server, ad-hoc support.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Patching Quarterly released security vulnerabilities released by oracle support.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.
• Installation of Oracle Application 11i
• Setup and configure Standby databases for high availability.
• Using auto config to configure Oracle Applications.
• Installation and using Oracle Enterprise Manager for some of the maintenance tasks.
• Using auto config to configure Oracle Applications, Implementing Change requests.
• Designed, documented, implemented and maintained all Disaster Recovery procedures
• Providing ad-hoc support to the development team, maintenance of the Database. Monitoring database growth and managing space.
• Oracle Application Maintenance.
• Applying Patch and cloning of E-Business Suite(11.5.10.2)
• Helped performance teams by providing TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADD).M reports for database tuning.
• Backup and Recovery using RMAN, Oracle Database cloning/refresh and Troubleshooting Refresh related issues.
• Diagnose and troubleshoot Database issues.
• DBA activities like Disk space management, User management, restarting Services(Database, E-Business and SOA
• Database Installation.
• SOA Installation and integrating Database with RAC
• SOA upgrade from 10.2.0.3 to 10.2.0.4
• E M configuration
• Database Maintenance
• Cloning Oracle Applications with rapid clone for development and testing and incorporating customizations. Using auto config to configure Oracle Applications.
• Maintenance of oracle applications through AUTOCONFIG.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Troubleshooting Refresh related issues.
• Interaction with Oracle Support Services to resolve mission critical issues.

Environment: Dev and Prod Linux