Summary

• IT Professional with 8 Years of experience as Oracle DBA and Oracle Apps DBA.
• Installation, Upgradation and Patching different versions of Oracle 11g/10g/9i.
• Installed Oracle 11i Applications E-Business suite 11.5.10.2 and R12.
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Generated .dbc file to trouble shooting OAM connectivity.
• Cloning and maintenance of application system and database on Linux platform.
• Maintaining the Control files, Redo Log files, & Data files
• Managing Privileges, Roles, Users Management, Views, Indexes and Data Integrity Instance and Media Recovery.
• Applying patches to 11.5.9, 11.5.10.2, R12 versions of e-business suite.
• Backup and Recovery - RMAN, User Managed-Physical and logical Backups, Export/Import, DataPump.
• Segment Space & Extent management
• Monitoring and managing the RAC database with 2 nodes.
• Use of ASM in a clustered environment.
• Installation of OBIEE.
• Well versed in Optimizing Query Plan, Performance Tuning.
• Managed the Production and Non-Production Databases with performance tuning feature to provide fast access and retrival of data to end users requests.
• Involved with the Business usersfor Requirement gathering.
• Provided Mentoring to the juniors with functional and technical knowledge.
• Extensive use of Toad for all DBA related activities like Performance and Backup of data.
• Involved in query level performance tuning using Explain Plans, SQL Trace and TKPROF utilities to pin point time consuming SQL's and tuned them by creating indexes and forcing specific execution plans.
• Good Experience in writing UNIX Shell Scripts to automate day-to-day operations.
• One of the most Disaster recover tool provided by Oracle : Standby database (Data Guard)
• Experience in Flashback technology.
• Fast Learner, good communication, coupled with very positive user interaction & team spirit

Education & Certifications

• Bachelors of Engineering (IT)

Technical Skills

Databases: Oracle 11g/10g/9i, ASM,RAC
ERP: Oracle E-Business Suite 11i,R12
Languages: SQL, Shell Script
Database Utilities: SQL*Plus ,Putty ,Toad ,OEM, Import & Export ,Data Pump ,RMAN ,Explain Plan TKPROF, AWR ,SRVCTL,CRSCTL
Applications Utilities: ADADMIN, ADPATCH, AD Splice, ADCONFIG, FNDCPASS, RunInstall
Middleware: As400 administration.
O/S: HP Unix, OEL , RHEL 3.0,4.0,5.0, Solaris ,AIX, Windows 95/98/XP/2003

Professional Experience

Client: Confidential, Green Bay, WI (October 2008 - Till Date)
Role: Oracle APPS DBA / Oracle DBA Consultant Project: Quest

Schneider is global leader in logistics and transportation services. It provides logistics and transportation solutions. Schneider is implementing complete suite of Oracle which includes and not limited to Oracle Database administration and other related product for complete automation and to replace legacy system.

Responsibilities:

• Installed, Configured, Upgraded and Supported Oracle Applications 11i e-business suite
• Monitored production, development & test databases and applications.
• Installed Oracle Applications11i e-business suite 2 node with using Rapid Installation and performed cloning and patching.
• Worked with Developers in developing and loading the scripts
• Created production, test, and development databases according to the application's requirements.
• Performed data Loading and re-organizing data from production database into development and test database.
• Upgraded Oracle Applications 11i e-business suite to R12 for test, development environments.
• Perform 10g database upgrade to 11g database.
• Installation of OBIEE .
• Performed Pre-patch analysis for the patches and document preparation with pre and post patch
• Reviewed backup strategy, I/O balancing and database parameters.
• Applied patches using ADPATCH, ADCTRL utilities
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps
• Monitoring the RAC Database with 2 nodes using SRVCTL utility.
• Backup of OCR and voting Disks.
• Reorganizing data with EXPORT and IMPORT.
• Upgrade Oracle Database 9i (9.2.0.6) to Oracle Database 10g (10.2.0.4) on Linux.
• Performing tablespace and Rollback segment management.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• Very good experience in creating SR's through Metalink.
• Monitoring and Maintaining the Database in RAC environment using SRVCTL utility.
• Performed Backup and Recovery Using RMAN.
• Implementation Of Oracle DataGurad features for Disaster Recovery
• Set-up Unix cronjob scripts for different environments.
• Fine Tuned SQL & general Performance Tuning using various tools & technique such as SQL Trace and TKPROF, EXPLAIN-Plan.
• Extensive use of Automatic Workload Repository (AWR) for SQL Statement performance tuning.
• Worked with application teams to assess SQL statements performance..

Environment: Oracle 11g/10g, EBS 11i suite/R12, SQL, RAC, TOAD, Sun Solaris, Linux, Windows XP.

Confidential, INDIA (August 2005 - September 2008)
Oracle DBA Consultant

HSBC - Being a Banking Domain supports Corporate & Investment Banking in the countries like UK/US/
Paris .CIBM production support is project that provides support to database servers across the CIBM UK/
US & Paris entity in 16*7 supports. It is a part of private banking 1st generation.

Responsibilities:

• To provide support to Production and non-production environments.
• Troubleshooting the daily database related issues.
• Worked with developers in deploying the scripts to different environments.
• Batch/Job monitoring & failure analysis.
• Tablespace and Disk space Management
• Creating roles, profiles and privileges and assigning roles to users
• Monitored and analyzed alert log files and system performance
• Performed export/import and hot/cold backups
• Responsible for Database maintenance and Support
• Oracle performancetuning using TKPROF, Explain Plan, Enterprise Manager and OS utilities.
• Ensure Oracle Database and Application availability 24*7
• Planning and testing Disaster Recovery using Data Guard.
• Write shell scripts for various purposes.
• Write SQL scripts for various purposes.
• Write shell script to perform, manage and schedule (crontab) various database related tasks
• Provided mentorship for new hires.
• Backup and Recovery Using Export/Import, RMAN.
• Provided quick technical problem resolutions.
• Team player and excellent organizational, interpersonal and communication Skills

Environment: Oracle 9i/10g, SQL, PL/SQL, DataGuard, TOAD, Putty, Sun Solaris, Windows XP.

Client: Confidential, KANSAS, MO (June 2003 - July 2005)
Role: Oracle DBA Consultant

Project 1: MkIS (Marketing Information System):

MkIS is a data-warehouse built for marketing purpose of Sprint. It holds data which is used by Marketing Operations (like Marketing campaign) of Sprint. The project focused on data-warehouse functioning over the weekends which was an off time for users (in this case the database tables were used by users directly by using PL-SQL reports). Under MKIS there were multiple projects like ICR, D7632. The project functionality includes handling large number of Oracle Databases with following responsibilities involved.

Responsibilities:

As an Oracle DBA my responsibilities includes to administer over 30 Production and non-production Database instances, daily routine DBA support tasks and business specific DBA projects. These tasks include but not limited to:

• Performed routine DBA tasks such as backup/recovery, AWR report generations and performance tuning
• Create, Manage and Monitor non-production environment.
• Installs, configures, and upgrades Oracle 9i Database server, tools, and applications in a Windows environment.
• Performed backup and recovery operations in sub-prod environment.
• Responsible for setting up and monitoring RMAN backups. Monitors, tunes, sizes, and analyzes Oracle databases.
• Supports developers in tuning DB and apps for optimal performance.
• Designs and implements DB security and user management.
• Row Chaining and Row Migration reports.
• Responsible for 24 X 7 Primary production support.
• Responded to trouble tickets opened by developers in a timelymanner, according to established corporate SLAs.

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, AIX, Windows XP, D2K.

Client: Confidential, INDIA (June 2002 - May 2003)
Role: Oracle DBA

Project: HRMS (Human Resource management System & Payroll)

HRMS is an Integrated & Comprehensive Human Resource & Payroll package for effectively managing employee information with very precise human resource policies of employees. It cares to a vast plethora of human resource and payroll activities, especially in Public Sector/Government Setup

Responsibilities:

• Installation of Oracle Database on Linux, AIX, Windows.
• Creation and Maintenance of Data files, Control files and Redo log files.
• Maintain development databases.
• Strategically planned and executed database backups and recovery using RMAN, User Managed, Export and Import.
• Write shell scripts for various Automation Processes.
• Maintained the database structures resolving space related issues.
• Developed multiple Unix/SQL/PLSQL scripts for custom monitoring and automating DBA activities.
• Coordinating with clients, in their regular activities in troubleshooting.
• Escalating to Project Leader about the daily activities and Performance.

Environment: Oracle 8i, SQL, PL/SQL, Windows 98, UNIX.