SUMMARY

• 7+ years of experience in Oracle working as an Application DBA in Production environment.
• Experienced in Oracle Application Releases (11.5.10.2 & R12), applying Patches, Upgrades, Multi - Tier Installations, routine DBA tasks, periodic Refreshes, oracle support dealing with Functional, Developers and end Users.
• Extensive experience in Oracle Databases (9i, 10g & 11g), Patching, Cloning, Installations, Upgrades, System Administrator activities, Backup and Recovery, Performance Tuning and Load Balancing. Knowledge on Oracle 12C database.
• Creation of Databases Manually and by using Database Configuration Assistant (DBCA) and Oracle Managed Files (OMF).
• Worked as DBA on diverse platforms on Oracle Databases covering HP-UNIX, IBM AIX, Sun Solaris and Linux operating systems.
• Hands on experience on Database 9i, 10g and 11g Refresh and Cloning of Oracle Apps 11i & R12 from Production to Test across multiple tiers.
• Expertise in maintaining ASM file system, Switching from Non ASM to ASM file system using RMAN (Recovery Manager) utility.
• Strong hold on RMAN utility for scheduled Backups, Recovery and Restoration of Database.
• Experienced in Installing, Configuring, Monitoring and Administering Oracle RAC (Real Application Clusters) Databases.
• Gained good skills on DATA GUARD by creating STANDBY database and maintaining file system on Standby. Can perform Switchover to Standby in case of Production Failure.
• Profound knowledge in Applying Database patches using Opatch utility and Application patches like One off, Mini pack, Maintenance, Family Pack, Consolidated, Rollup, Interoperability and NLS patches using AD Utilities like adadmin, adctrl, adpatch, admrgpch.
• Troubleshooting the HTTP server powered by Apache and Concurrent Manager Jobs.
• Installation of OEM grid control, configuration and installing agents on all database servers.
• Proficient in use of tools like SQL developer, Recovery Manager, Oracle Enterprise Manager.
• Involved in developing internal tools to monitor the database and applications.
• Experienced in handling Oracle Architectural components and Performance issues.
• Connecting to the servers using Telnet, SSH and FTP based on requirement.
• Managing Client specific ticketing systems to work upon raised issues within SLAs using tools like BMC Remedy, Collaborate.
• Proficient in Incident management, Problem Management and Change Management.
• Provided Oracle and UNIX expertise in Application Development, Troubleshooting, Performance Tuning, and Database Architecture to include Configuration, Installation, Migration, and Upgrades.
• Managed very large databases in 24x7 Production environment, provided on-call and Day-to-Day support.

TECHNICAL SKILLS

Databases: Database Administration 9i, 10g, 11g, Oracle Apps 11i/R12RMAN, ASM, DG/DR, RAC.

Operating Systems: Red Hat Linux, Sun Solaris, IBM AIX, HP UNIX.

Tools: & Utilities: SQL developer, Toad, Putty, SSH Tectia, Win SCPAuto putty, Xshell and BMC Remedy, Collaborate.

Programming Languages: C, C++, SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Senior Consultant

Technologies: Oracle Applications 11.5.X/R12 and Oracle 10g, 11g.

Responsibilities:

• Responsible for Database Administration of Oracle RAC and non RAC databases. Oracle Database Administration support activities includes database storage File maintenance, Backup and Recovery of databases, Export and Import of tables and schemas, client/server Database Connectivity, Database Security, Installation, Upgrade, Patching, managing Oracle and giving on-call support .
• Upgraded the databases from 10.2.0.4 to 11.1.0.7 version and Applications from 11.5.10.2 to 12.1.3 version.
• Database Cloning of Production servers using Hot /Cold and RMAN backups to Test Database.
• Applied oracle recommended Database patches and Application patches like One-off, Mini pack, Family pack and Maintenance patches on various modules to fix the issues.
• Converted Non ASM file system to ASM file system using RMAN.
• Created STANDBY database for PROD and maintained file system on Standby. Performed necessary actions when Standby is not in sync.
• Provided continuous support to fix issues when servers are on Maintenance based on Client’s requirement.
• Performed Export and Import of tables and schemas using DataPump.
• Administering Concurrent Managers and troubleshooting the issues in case of any Long Running and Pending Concurrent requests.
• Recovered databases from Database Crash due to the Block corruption errors on data files.
• Creating and following up Service Requests with Oracle Support for quick resolution.
• Monitoring OS level processes, regarding CPU Utilization, Load Average and Memory Utilization and taking necessary actions.
• Supporting day-to-day User related issues, troubleshooting and resolving them.
• Coordinating with Development team for SQL Statement Tuning, using SQL TRACE, TKPROF and Explain Plan.
• Monitor usage of the databases, critical tablespaces, mount point issues and perform Database Tuning to increase the performance. Plan for System growth and monitor capacity Usage for new hardware or software requirements and communicate these capacity requirements to storage management.
• Administering all Database objects, includes tables, views, packages, procedures, sequences and indexes.
• Oracle Application System Administration activities like User creation, adding new Printers, Responsibilities, Password resets, assigning new Roles and other requests as required by the user.
• Monitoring complete database and fixing the issues well in advance using Scripts.
• Proficient in Incident management, Problem Management and Change Management.
• Resolved tickets within SLAs using Collaborate ticketing system.
• Supporting Functional and Development team during the implementation of project to troubleshoot encountered issues.
• Managed and supported mission critical Production Oracle 10g/11g databases running 24x7.

Confidential, Livermore, CA

Senior Consultant

Technologies: Oracle Applications 11i and Oracle 9i, 10g.

Responsibilities:

• Upgraded database from 9.2.0.6 to 10.2.0.3.
• Upgraded the Applications from 11.5.8 to 11.5.10.2.
• Involved in applying various Application Patches like One off, Mini Pack, Family pack and Maintenance Patches and troubleshooting the performance issues using AD Utilities.
• Installed, created, monitored and administered Real Application Clusters database (10g).
• Performed successful SWITCHOVER from PROD database to Standby.
• Performed database Restoration and Recovery using RMAN utility.
• Performed scheduled Cloning using Hot/ Cold backups.
• Managing ASM file system and troubleshoot Performance issues.
• Worked on data migration activities using Export/Import utility.
• Administer the Concurrent Manager jobs. Keeping track of Long Running and Pending requests and fixing the issues to increase the performance.
• Scheduling various jobs to be fired through CRONJOBS like taking cold backup of Production Database, status of database and application server.
• Coordinating with Development team for SQL Statement Tuning, using SQL TRACE, TKPROF and Explain Plan.
• Creating and following up Service Requests with Oracle Support based on criticality of issues.
• Management of Tablespaces for different users by granting quota on Temporary tables paces, assigning roles.
• Resolving the Performance issues related to Forms for the betterment of efficient User access to Applications.
• Monitoring Mount point Size limits and taking necessary actions as and when required.
• Implemented Automatic Undo Management in oracle in order to manage undo segments efficiently.
• Coordinating with UNIX administrators to resolve database related Operating System Problems.
• Monitoring Operating System level processes, CPU Utilization, Load Average and Memory Utilization and taking necessary actions.
• Supporting Functional and Development team during the implementation of project.

Confidential, Aliso Viejo, CA

Consultant

Technologies: Oracle Applications 11i and Oracle 10g, 11g.

Responsibilities:

• Extensive Oracle 10g/11g Database Administration experience that includes monitoring and managing mission critical database running 24X7 to ensure the Server availability for users and perform capacity planning for databases.
• Installed and Configured Oracle 10G RAC in a UNIX environment for multiple nodes.
• Was part of a team of 3 DBA's supporting all the Database platforms.
• Scheduled Cloning using Hot/Cold backups from PROD to DEV and TEST databases.
• Used RMAN utility to take backup for the database & perform recovery in case of Database failures.
• Applied patches to maintain the database at current Patch level.
• Maintaining and administering ASM and RAC databases.
• Perform database capacity planning; create, administer and maintain databases.
• Implement disaster Recovery strategies; perform database backup/recovery and cloning; perform operating system performance monitoring and tuning; identify and resolve any database bottlenecks proactively; respond to raised problems quickly.
• Administration of OEM like monitoring the databases, Server load, Invalid objects, CPU utilization, long running sessions and blocking.
• Worked on Import and Export utilities to migrate data.
• Supporting day to day User related issues, troubleshooting and resolving them.
• Maintenance of Oracle Applications on test databases.
• Administration and maintenance of Concurrent managers.
• Fixing the Performance issues related to Applications.
• Managing sessions on all databases which are causing locking and as well clear INACTIVES which reduces performance of the database.
• Performing the jobs of System Administration for Oracle Applications.
• Implemented Automatic Undo Management in oracle in order to manage undo segments efficiently.
• Supporting the Development and Testing team during implementation of the Project and on all DBA related issues.

Confidential, Tinley Park, IL

Consultant

Responsibilities:

• Maintaining several Database instances running in Sun Solaris and Linux environments, monitoring and tuning Production Database.
• Involved in Installation of Oracle Applications Version 11.5.10.2.
• Involved in Upgrade of database version from 10.2.0.1 to 10.2.0.5
• RMAN utility to take scheduled backups and clone the database.
• Cloning Production Database to refresh test / development servers at regular intervals. Managing 24x7 Production Databases with huge number of End users connecting through multiple Application servers.
• Management of ASM File system and resolving performance issues.
• Apply patches using AD utilities suggested by oracle to fix issues related to applications and as well for upgrading or installing files on the Applications server.
• Managing Standby database and make sure it is in sync with PROD.
• Detect various problems in Database like locks, CPU utilization, Load crossing the threshold and higher number of Inactive sessions.
• Performing the jobs of System Administration for Oracle Application like creating new users, changing the passwords, assigning responsibilities, end dating the users.
• Resolving and troubleshooting Oracle Application Forms related issues.
• Import and Export of tables using DataPump.
• Monitoring alerts using OEM and resolving issues.
• Responsible for monitoring and diagnosing the database and tuning the database by querying various performance Dictionary Views.
• Scheduling various jobs to be fired through CRONJOBS.
• Identify and resolve any database issues proactively and respond to raised problems quickly.
• Supporting the development and testing team during implementation of the project and on all DBA related issues.