SUMMARY

• Oracle Professional with 6+ years of experience in Installation, Upgrade, Monitoring, Performance Tuning, Database Backup and Recovery, performance tuning on Linux, UNIX and Windows environments.
• Oracle expertise includes in - depth knowledge of database architecture, evaluation of application products, development and SQL Performance analysis using Explain Plan, SQL Trace, Statspack, AWR and SQL Trace (10046/10053 ).
• Excellent team player with good analytical, planning and interpersonal skills. Highly motivated, enthusiastic and self-starter.
• Production Experience in administering Oracle 11g/10g/9i and upgrade from Oracle 9i to 10g and Oracle 10g to 11g.
• Experience in Maintenance, Patching, Cloning and troubleshooting.
• Experience as on-call 24x7 production DBA support, and worked On-Call rotation support.
• Expert level day to support on 9i/10g/11g databases on heterogeneous platforms like UNIX, Linux, AIX and Windows.
• Expertise in operational and maintenance Database Administrative tasks including installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indexes and performance tuning.
• Proficient in troubleshooting performance issues and automating the daily maintenance activities by developing shell scripts using, SQL scripts.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Extensively used Backup and recovery of Oracle databases using conventional methods and RMAN in different scenarios and experience with Oracle Flashback technology.
• Expertise in implementing Standby Data Guard for disaster Recovery.
• Experience in implementing 10g/11g RAC with ASM & Data guard for various instances and provided support in troubleshooting and monitoring.
• Experience in writing procedures, functions, triggers and packages in Oracle database server.

TECHNICAL SKILLS

Operating Systems: Redhat Linux, Windows, Solaris, HP-UX, AIX.

Languages: SQL, PL/SQL, UNIX shell scripting, Perl scripting, AWK, C, C++, Visual Basics, Java.

Databases: Oracle 11g migration/10g migration/9i, SQL server, MS Access

Design & Development Tools: SQL*PLUS, TOAD, PUTTY, OEM, RMAN, SQL* Loader, IMP/EXP, DATA PUMP, PL/SQL developer, RAC.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Oracle DBA

Responsibilities:

• Incident and problem ticket resolutions for tickets received from the Integrated Project Manager (IPM).
• Responsible for handling Database Change Requests on all environments.
• Handled Monthly production maintenance release.
• Responsible for database Hot & Cold backups using RMAN, Export/Import Unix command line etc.
• Implemented 11gR2 RAC on Development, UAT and Production in ASM.
• Setup backup and recovery procedures and create primary objects including tables, views, indexes, etc.
• Setup Golden Gate replication for reporting database.
• Setup Golden Gate Active-Active Two way replication for Test database.
• Creating users & roles and granting roles and privileges to users.
• Performing Oracle upgrade to 11g from 10g in test environment and also Production environment.
• Performing Listener Fixes in 10g (10204,10205) databases as well as 11g (11203) databases.
• Migration of huge data from Production environment to Reporting using stored procedures and to development and test environment through EXPDP/IMPDP.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Setup Oracle standby - Stream replication, Shareplex Replication and Oracle Golden Gate Replication.

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, RHEL, PL/SQL, Oracle Golden Gate, Shareplex, RAC, ASM, TOAD, SQL *Plus and SQL Developer.

Confidential, MT Laurel, NJ

Sr. Oracle DBA

Responsibilities:

• Incident and problem ticket resolutions for tickets received from the Global Service Desk (GSD).
• Responsible for handling Database Change Requests on all environments
• Handled Quarterly production maintenance release.
• Co-ordinate with development team to performance and tune the application and Database related issues using explain plan SQL trace and generating the reports.
• Creating database on Solaris, and Linux, Design a Complete architecture of the entire database including production as well testing database.
• Creating new user accounts, profiles, roles, and privileges and assigned to the user based on application team and providing security.
• Creating Snapshots to get the remote database data into the local database for development and stress testing environments.
• Implemented Partitioning on huge tables to improve the performance and reduce the maintenance.
• Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index.
• Transported tablespaces from production database and plugged-in it in development database for the usage of developers.
• Responsible for database Hot & Cold backups using RMAN, Export/Import Unix command line dd etc.
• Created physical standby database for disaster recovery
• Implemented 11gR2 RAC on dev, qa and production in ASM.
• Monitor alert logs, trace files and automated alarm generation for schema changes.
• Setup backup and recovery procedures and create primary objects including tables, views, indexes, etc
• Migrating Database from Raw Volumes to use ASM Disk groups.
• Supported single instance & RAC databases on Raw Volumes.
• Supported replication of databases using Shareplex.
• Proficient in using Informatica Workflow Manager Tools like Task Developer and Workflow Designer. Trouble shooting and Error handling in workflows..

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, PL/SQL, Informatica, Shareplex,, RAC, ASM, TOAD and SQL *Plus.

Confidential, Taylor, TX

Oracle Database Administrator

Responsibilities:

• Evaluating, Supervising and planning Oracle 9i/10g Database servers.
• Installation of Oracle 11g, 10g, 9i under Linux and Windows 2003.
• Upgrading to new versions, co-coordinating with hardware changes and applying database patches.
• Oracle 9i/10g upgradation for 64bit for Windows 2003, DB cloning.
• Installed and configured OEM Grid control.
• Re-organizing the database architecture to work efficiently and for better response time.
• Performed Online and Offline database backups on schedule.
• Backup plan designing and implementation using RMAN backup technology.
• Implemented backup strategies which involved taking an incremental level 0 backup of the database every week, a level 1(cumulative) backup every night, and enabled the block change tracking feature.
• Database creation, database refreshing/reorganization, sql statement tuning.
• Worked in the matters of performance issues, major reorganizations and auditing the required down times.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Migrated flat files from different sources into Oracle Database using SQL*Loader.
• Performed Cross Platform transformation of the databases.
• Extensive use of data moving utilities like export/import.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Implemented single source one way replication using Oracle Stream.
• Worked with Real Application Cluster (RAC) with ASM database for various instances.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Successfully providing 24x7 supports for production, development, and test database.
• Train users/developers from time to time regarding the environment they are supposed to work on, training on database coding standards.
• Planned and acquired the new technologies for evaluation and implementation.

Environment: Oracle 9i/10g/11g, OEM Grid Control, RMAN, RAC, SQL*Loader, Import/Export, Data Guard, SQL*PLUS, Perl, Shell Scripting, Redhat Linux ES4 and Sun Solaris.

Confidential, Houston TX

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 10g, 9i under Linux and Windows, Upgrading to new versions and applying patches as required.
• Creating Database, Tablespaces, Rollback Segments etc.
• Installed and configured OEM Grid control.
• Extensively used data moving utilities like EXPORT/IMPORT, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
• Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.
• Monitoring frees space in tablespaces, Archivelog destination, Database/Listener availability, Blocking Locks monitoring etc.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Physical and Logical Database design, entity modeling and architecture.
• Implemented Data Guard to ensure high availability, data protection and disaster recovery.
• Setup Oracle standby - Stream replication.
• Worked with Real Application Cluster (RAC) database in test environment.
• Tasks involved extensive usage of Unix Shell Scripting.
• Successfully providing 24x7 supports for production, development, and test database.
• Performed Cross Platform transformation of the databases.
• Created service request with Oracle Support for technical assistance.

Environment: Oracle 9i/10g, OEM Grid Control, RMAN, SQL*Loader, RAC, Import/Export, Data Guard, streams, SQL*PLUS, Shell Scripting, Redhat Linux ES4 and Sun Solaris.

Confidential, Philadelphia, PA

Oracle Database Administrator

Responsibilities:

• Installed, Upgraded and Configured Oracle 9i/8i.
• Creating Database, Tablespaces, Rollback Segments etc.
• Creating users & roles and granting roles and privileges to users.
• Writing Procedures, Functions, Triggers and Packages.
• Capacity Planning, Estimating Database Size and SGA size.
• Designing and developing backup and recovery strategies.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Successfully recovered corrupted databases.
• Enhanced overall performance by performing SQL tuning.
• Tuned the Database and applications using AWR, ADDM, and STATSPACK.
• Allocating system storage and planning future storage requirements.
• Monitoring the growth of Table spaces to see the fragmentation and available space for growth.
• Tasks involved extensive usage of SQL, Unix Shell Scripting and Oracle Server utilities like SQL*loader and Export/Import.
• Setup Oracle standby - Stream replication, Oracle Materialized view replication.
• Implemented and maintained Oracle 10gR2 RAC on Red Hat Linux.
• Designed, developed and generated reports to provide up-to-date information for production planners.
• Successfully provided 24x7 supports and monitoring of databases.
• Worked with cross-functional teams of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Implemented the data migration from the previous database.

Environment: Oracle 9i/10g, SQL*PLUS, SQL*Loader, Import/Export, OEM, RAC, RMAN, Erwin, Shell Scripting, Solaris, Linux, Windows 2000.