• About 7 years of experience in 11g 10g 9i and 8i on AIX HP-UX Linux and Windows servers experience with RMAN and standard backup and recovery procedures practicality of Data Guard upgrades and patches knowledge of SQL Server databases have database experience in the pharmaceutical banking media e-commerce and manufacturing industries highly motivated and detail oriented.
• Aboutr 3 years of extensive experience on Oracle Supply Chain Manufacturing Applications consulting including Quote to Cash and Procure to Pay.
• Expertise in Order Management Shipping Inventory Purchasing modules.
• Good hands on Experience on Advance Pricing Quoting and EDI modules.
• Extensive experience in the Functional aspects of Oracle Applications 11i Release 12.0 and 12.1.
• Experience includes execution of Oracle Applications implementations including the exposure to e-Business suite Release 12 numerous Application Support projects with high level of Customer Satisfaction.
• Adept in reviewing and analyzing the as-is business scenarios processes and activities evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Log view access monitor follow-up and close Service Requests SRs online - Oracle MetaLink and Oracle Applications Patch Management.
• Working according to Oracle On Demand Policies.
• Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
• Strong communication leadership skills with an ability to interact with business users and lead business projects.
• Experience in Implementing and performing Disaster Recovery. Implementedand managed Data guard.
• Extensive experience in Production and Application development support.
• Hands on experience in Installing Migrating Upgrading Patching and Maintaining different oracle versions on HP-UX UNIX AIX Linux and windows Platforms.
• Expertise in development testing and implementation of Backup and Recovery strategy Using RMAN Data pump and Export/Importutilities.
• Also worked on SQL tuning advisor using Grid control.
• Involved in Configuring Managing Standby Databases Data Guard
• Strong understanding and Expertise in administration of UNIX Systems and File System.
• Knowledge of Oracle 11g/10g Flashback Queries and Enterprise Manager Console.
• Experience in Data Loading using SQL Loader Oracle External Tables 11g
• Handling Tools such as OEM and SQLWorksheet
• Support to Developers End-Users.
• Proficiency in standby database Data guard installation configuration maintenance and administration for disaster recovery
• Strong Experience in Database Performance Tuning - Tuning involved Data model Tuning
• SQL code tuning Physical Tuning Configuration Tuning OS and Network tuning.
• Expertise in using ADDM AWR EXPLAIN PLAN TKPROF SQL TRACE and WAIT INTERFACE for Performance Tuning.
• Used Oracle scheduler and Unix Cron utility for automating jobs.
• Proficient in PL/SQL SQL and UNIX Scripting.
• Experience in Oracle Security Auditing and Capacity Planning.
• Perform daily monitoring of Oracle instances using Oracle Enterprise Manager TOAD users table spaces memory structures rollback segments logs and alerts.

COMPUTER SKILLS

Oracle E-Business Suite Supply Chain Management SCM Applications - 11i Release 12.0 Release 12.1

Databases Oracle 11g 10g 9i 8i

Languages SQL PL/SQL

Operating Systems Unix Linux Windows

Servers Linux HP-UX AIX Windows

Others C PHP HTML5 MySQL Microsoft Office Adobe Creative Suite etc.

PROFESSIONAL EXPERIENCE

Confidential

Title Sr. Oracle DBA

Responsibilities

• Set up Transaction Types Applying Releasing Holds Credit Checking Advanced Pricing Price List Pricing Agreements and Pricing Attributes Defining Modifiers Qualifiers GSA Price List Pricing Formula Defining Standard Internal RMA and Drop shipment Orders Define Pick Release Pick Release rules Shipping Parameters ATO PTO Models ATP Checking Availability
• Delivered excellent service and support to internal business customers also was responsible for monitoring progress against service level agreements. Also responsible for ensuring each reported problem is resolved in a timely manner tracked according to standards and escalated as appropriate.
• Coordinated activities with testing and the technical team to resolve daily reported production issues. Facilitated discussions with end-users/managers to gather functional requirements on their issues.
• Co-coordinated with client through Concalls and WEBEX sessions with offshore team to provide onshore timely support.
• Lead a small team of Oracle DBAs to manage over 65 Oracle databases 10g 9i 8i on both Linux and Windows servers.
• Was responsible for upgrading 8i and 9i databases to Oracle 10g.
• Was responsible for creating new databases installing Oracle binaries creating backup policies and applying patches and patchsets.
• Used RMAN for cold hot and archivelog backups through Tivoli Storage Management.
• Created scripts to assist in monitoring databases for performance and security issues.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30 production databases.
• Installed agents on database servers and configured enterprise manager.
• Migrated Database between servers using Data pump Export/Import
• DDL replication using Golden Gate
• Participated in the development of project plans and contributed effectively for planning control
• Administered all database objects including tables clusters indexes views sequences packages and procedures.
• Troubleshoot data related configuration and performance problems on both application and database layers
• Created tools and processes to automate jobs and monitor database performance Shell Scripts .
• Performed daily database administration tasks User management Space monitoring
• Performance monitoring Alert Log monitoring and backup monitoring.
• Performed Backup and Recovery tasks in SQL server 2005 using SQL server Management Studio.
• Provided Database Technology training to the IT staff and users.
• Rotated after-hour on-call duties with other DBAs.

Confidential

Title Oracle DBA SCM Consultant

Responsibilities

• Performed all the setups for OM Shipping and Advance Pricing AR INV modules.
• Worked with the Business team to baseline NPI As Is Process and derive To Be flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap put collaborative effort with the Technical team to address the same through Technical Specification.
• Facilitated Pricing IT Business to obtain clarity on the Business Rules and capture the same.
• Worked on both CTO and ATO Models Flow in OM.
• Also responsible for both Oracle versions 10g 9i and Windows Server 2000 databases.
• Assisted development/QA team with production rollouts.
• Worked with system administration team to manage space for database growth in both UNIX and Windows environments.
• Performed a database migration of a 500 gigabyte database to multi-byte language UTF8 using Oracle data pump.
• Created materialized views to keep company within SLA requirements.
• Migrated several SQL Server databases over to an Oracle environment.
• Responsible for creating new databases installing Oracle binaries creating backup policies applying patches and patchsets and performing database upgrades.
• Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.
• Administer RAC Database servers using SRVCTL VIPCA OEM Grid control V /GV views and System wide tuning using UTLBSTAT and UTLESTAT.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Configured ASM and suggested feasible workarounds for ASM Metadata corruption and
• Oracle Documentation and knowledge transfer. Oracle Cluster ware installed to provide infrastructure for RAC in production testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Rebuild Indexes table partitioning tuning memory usage and SQL tuning using Explain Plan SQLTrace TKPROF and Statspack for best performance.
• Manage alerts notification jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.
• Rotated after-hour on-call duties with other DBAs

Confidential

Title Oracle DBA

Responsibilities

• Been part of the Scope analysis for supply chain domain
• Collated the issues in the current version and requirements in the latest version
• Prepared AS IS and TO BE process documents.
• Performed all the setups for ABC Analysis.
• Interacted with Business System Analyst for requirement Gathering.
• Prepared Functional specification document and High level Design document.
• Exhibited good coordination with Technical team for Design and Development.
• Prepared Unit test plan and scripts for verifying the conversions
• Conversion and verification together done within the timelines.
• Worked on 11g OEM migration project with the team.
• Installation/Creating new databases.
• Worked on performance tuning Supported on-call rotation 11g OEM install/config Agents and deploying used export import and Data Pump.
• Used RMAN Backups to refresh databases Set up crontabs to automated jobs as required Brief Advance Compression.
• Providing 24 7 supports for all production and non-production databases.
• Automated workarounds by creating baselines.
• Handling all day to day issues in production environment.
• Reorganizing the database That is to eliminate excessive database fragmentation and to move data between different table spaces.
• Analyzing and providing solutions to performance problems of databases.
• Space maintenance across tablespaces and data files.
• Coordinate deployments with offshore DBAs

Confidential

Title Oracle DBA

Responsibilities

• Installation and configuration of Oracle Database Software 10g Installing and troubleshooting Red Hat Enterprise Linux 3.0 and 4.0 for Oracle 9i and 10g and RAC setup with ASM automatic storage management .
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Worked on backup recovery and disaster recovery strategy using RMAN.
• Administered 11g/10g RAC in OLTP.
• Data Warehouse environments on RHEL Win 2003 24 X 7 Production database support and administration.
• Performed backup and recovery using RMAN and conventional hot cold backups.
• Converting data files across different platform using RMAN convert Transportable Tablespaces Export/Import and Data pump expdp/impdp .
• Part of a 3 member DBA team which is involved in Upgrade of Oracle 10gR2 to Oracle 11gR2 and even involved in maintenance of Oracle 11g/10g RAC databases for the Production and development environments and Migrated Database between servers using Data Pump.
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE STATSPACK etc.
• Documentation of Oracle database operations and training of backup personnel Technical Problem-solving Hardware issues
• Worked on Database acquisitions and databases migrating Backup Export/Import database security disaster recovery and various database issues
• Handling all backups issues archive backup failures issues and NetBackup related errors.
• Worked on Database creation from scratch with UNIX Team.
• Handled Temp table space related issues.

Confidential

Title Oracle DBAConsultant

Responsibilities

• Worked for the client IMG World
• Experience with SQL DDL DML DCL PL/SQL coding stored procedures functions packages triggers
• Configured database entries and Monitoring of all the databases using Oracle Enterprise Manager OEM 10g/11g grid control and TOAD.
• Explored 10g s improved Automatic Optimizer Statistics Collection using Automatic Workload Repository AWR Proactively monitoring identifying areas that need to be improved in the application and database using Stats Pack AWR ADDM and 10g OEM Grid Monitoring.
• Database Capacity Planning configuration redo and stream sizes design staging schema and use of DBMS STREAM ADM packages
• Detect corrupted blocks by using DBVERIFY utility and schedule jobs by DBMS scheduler
• UNIX Shell scripting for database monitoring backup and to simplify day to day activities
• Partitioning tables by determining the suitable methodology to improve performance and manageability and other activities like applying RDBMS patches security patches Cloned/Refreshed environments to create test development and QA environments
• DBA activities which include Creating Users Roles and Profiles Privilege management with role-based security of databases tablespaces indexing data maintenance user management and maintenance and solving critical errors like ORA-600 ORA-7445
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication
• Regular DBA activities like Undo segments Rollback segments database auditing space management database issues locking creating database links managing user groups and tuning Applied CPU patches
• Managed and resolved design issues during development
• Restore and Recover Previous years data using Recovery manager Designed coded and implemented backup scripts Tuning and refining queries of various applications
• Monitoring database objects like rollback segments temp segments and tablespaces
• Diagnose and troubleshoot Database problems and failures Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN
• Creating and dropping of users granting and revoking rights as and when required
• Involved in on-call rotation and provide support to production and non-production databases