SUMMARY

• 7 plus years of experience as Oracle Data Base Administrator, providing 24/7 support for both production and development databases running on Oracle 11g/10g/9i/8i databases on varity of Opertating System platforms.
• Extensive experience in installation and configuration of Oracle 8i, 9i, 10g &11g databases in UNIX/LINUX and Windows environment.
• Having excellent problem solving and decision making capabilities, interpersonal skills, capable of multi - tasking and understanding the priorities for client satisfaction.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, capacity planning, and documentation.
• Experienced in features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring
• Experience about Oracle 11g RAC.
• Experience in Standby / Data Guard
• Efficient in troubleshooting of database and performance problems.
• Worked with development teams and data administration staff to enhance Database and application performance. SQL query tuning, troubleshooting, debugging, and issue resolution.
• Assists IT&T staff and clients with data base technical issues.
• Experience in different OS environments like AIX, HP-UX, SUN SOLARIS, Linux and Windows.
• Knowledge on Oracle Support processes for technical requests through Metalink
• Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.
• Develops, follows, and coordinates implementation of database standards.
• Experiance in performance tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF.
• Proficient in using OEM and RMAN.
• Result oriented, self-motivated, team player, ability to work independently.
• Experience in Oracle Applications 11i refreshes, troubleshooting and migration and applying application patch
• Experience on Oracle 10g, 9i & 8i environments running Oracle Apps, Peoplesoft
• Experience on large SAP installations, SAP Database systems hosted in UNIX/Linux environment with Oracle backend.
• Experience in handling critical timebound projects viz. database and server migrations, OS upgrades on database servers and Oracle Applications servers
• Experience in HOT and COLD BACKUP of databases and tested crash recoveries using conventional cold, hot & RMAN backups
• Worked on BCV (EMC) backup’s, validation of SRDF copy of production database to refresh dev/qa instance
• Experience with SAP Database refreshes
• Experience in seting up and managing ASM database instances.
• Experience with Logical and physical design of database.
• Experience in Oracle database upgrades (from 9.2.x to 11g, 10.2.x to 11g)
• Experience in ticketing tools like Remedy.
• Experience in documentations
• Preliminary experience in MSSQL Server 2008

TECHNICAL SKILLS

Operating Systems: AIX 6.1, HP-UX 10.x, 11.x, Sun Solaris 9/ 10, RHEL 5.x / 6.x and Windows 2003/2008

RDBMS: Oracle 11g(RAC) / 10g, Oracle 9i, Oracle8i, MSSQL Server 2008,SAP Database.

Languages: SQL, PL/SQL, UNIX Shell scripting

Tools: RMAN, OEM, SQL*Loader, EXP,IMP,TOAD, EXPdp, IMPdp, Brtools, Oracle Net Manager, Configuration & Migration Assistant

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

PROFESSIONAL EXPERIENCE

Confidential, Sterling, VA

Oracle Database Administrator

Responsibilities:

• Database Creation/Maintenance (database instances), managing logical and physical database structures.
• Conducted sizing & capacity planning for Oracle databases.
• Installation of Oracle11gR2 on Unix systems
• Database Reorganization regularly for removing row migrations and fragmentation using export and import utilities.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required
• Configuring Archive Log Mode for Database and Maintaining Archive files.
• Monitoring backups.
• Adhere to database management standards and guidelines
• Database backup validation and Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption).
• Completed setup of ASM on Windows/Linux database and supported ASM instance
• User management. Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Database upgrades from 10g to 11g and migrated database to LINUX operating system.
• Data guard setup for high availability, Setup of Standby database and monitor the sync process. Experienced with DATA GUARD IMPLEMENTATION.
• InstallingSQLserver, backup and recovery.

Environment: Oracle 9i/10g/11g, SQL Plus, Toad, OEM, ASM, DATA Guard, Windows, and LINUX, HPUX, RMAN

Confidential, Santa Clara CA

Oracle Database Administrator

Responsibilities:

• Handle new project requests from requirement gathering to closure.
• Create databases for Testing, Development and Production.
• Backup and Recoveryusing RMAN with external tape backup system.
• Installation of 11gR2 binaries, database creation, backup and monitoring setup for new database
• Upgrade databases from 10.2.x to 11g.
• Implement new features of 11gR2 in existing environment.(Compression, flashback database)
• Supporting Oracle databases in SAP and Non-SAP environment.
• Installing, Upgrading, Configuring, Cloning, Patching, Backup-Recoveries, Data Archiving, Index Management, Space Management, Troubleshooting and Administering with SAP databases
• Managing SAP databases using BR tools.
• Schema refreshes (using expdp/impdp, EXP/IMP mechanism).
• Interface setup for upgraded (11g R2) databases.
• OEM agent installation for managing and maintaining the hosts and its targets.
• Manage/resolved central inventory issues for multiple databases.
• Worked on OEM GridControlto monitoring, administration of databases
• Installed Oracle 11g RAC on Linux platform using ASM for a storage manager•
• Scheduled jobs through Cron.
• Basic project management tasks includingplanning, status reportingand scope management.
• SQL Tunings for Performance of Objects.
• Databases / schema / table re-organization for faster performance.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Data refresh from production (using hot backup/SRDF copy) to test and development.
• Worked on project Oracle stabilization. Oracle applications 11i.
• Migration of applications and db servers to new servers (hardware). Domain name change in all apps configuration files.
• LNK, DEV, QA oracle apps environment systems migration. On success of these pipeline env. Changes were implemented in production database server and prod apps server.
• Implemented DR plan for oracle apps production systems after a successful go live of the project.
• Post go-live support.

Environment: Oracle 9i/10g/11g, SQL Plus, Toad, Oracle Enterprise Manager (OEM) Grid Control, ASM, RAC11g, Windows 2003/XP, AIX and Solaris, HPUX, Oracle Applications 11i, RMAN

Confidential

Oracle Database Administrator

Responsibilities:

• Provide 24x7 support (On call after office hours)
• Supporting both production and development activities.
• Create databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, Statspack, OEM.
• Installation of Oracle version 10g on Solaris and AIX
• Apply database CPU patches whenever required.
• Data refresh from production to test and development
• Involved in developing adisaster recovery(DR) plan & conducting/implemented a DR exercise.
• Continuous Performance monitoring and tuning of the databases and application usingOEM Tuning Pack, Diagnostics Pack, STATSPACK.
• Tablespace management.
• Performance tuning of Oracle Database Objects.
• Taking periodic backup of the database and the software.
• Analyze alert log and user trace files and provide root cause.
• SQL Tunings for Performance of Objects.
• OS level activities likespace monitoringof Mount points
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for analyzing of tables and rebuilding of indexes.
• Write scripts to check Oracle errors in alert log file and send email notification.
• Configure monitoring for the databases.
• Performance reviews of production databases along with the application team
• Planning and execution of Table space reorgs in production databases
• Refreshing Oracle Applications env and troubleshooting Oracle apps related issues
• Worked on oracle applications bringing up and down form, web servers and concurrent managers whenever required for routine maintenance. Troubleshooting Oracle Apps issues for Concurrent Manager..
• Experience in Oracle Applications 11i refreshes, migration and applying application patch
• Administration of concurrent managers
• UsedRMAN for backup and recovery.
• ImplementedHot, Cold and Logical backup plans, Performed backup validations
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Database review for capacity planning. Every month for production database and quarterly for their pipeline database. And meet with application team for any discrepancies.
• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for Oracle databases.
• Supporting mission critical Oracle databases in SAP and Non-SAP environment, SAP Systems including Sandboxes, Development, Quality, and Production SAP Systems (with multiple Application Servers) in ECC, BI, SRM, EP, MDM on Oracle 11g
• Managing SAP databases using tools like BR tools. SAP Database refreshes.

Environment: Oracle 8i, 9i, 10g, Oracle Apps 11.0, SQL plus, RMAN, TOAD, Sun Solaris and HP-UX, LINUX, Windows Server, SharePoint

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle 10g on HP - UX
• Created duplicate production environment for Database
• Recover new database from prod backup
• Transfer of archive logs for 1 month. And apply them in new env to keep it updated with original production database.
• Backup setup(Hot and cold backup, arch backup )
• Database monitoring setup.
• Post go-live support
• Same way migrated QA, dev and test env to new servers.

Environment: SQL*Plus, Oracle 10g, HPUX.

Confidential

Oracle DBA

Responsibilities:

• Involved in oracle 9i DBA activities for supporting development and production environment.
• Providing the full database dumps and schema/table level dumps to DEV/QA database environment
• Performed DBA tasks such as: adding data files to table spaces, creating users and granting privileges, checking all instances are up and running, checking new alert log entries and backup issues.
• Creation of Tablespace, datafiles, indexes, rollback segment and monitor them.
• Coordinate Backup and Recovery operations for the entire databases, ensuring 100% recoverability
• Creation and maintenance of control files, redo log files and data files.
• Configuration and handling of hot backups and cold backups.
• Recovering the databases from disasters.
• Checking for invalid indexes and rebuild the unusable index.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Performed Database Tuning. Performed Database Security and Integrity.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 9i, UNIX (Sun Solaris), Windows (2003), TOAD, SQL*PLUS, Explain Plan.