SUMMARY:

• Having 6.5 years of professional experience as an Oracle Database Administrator having excellent experience in production support, installation, configuration, upgrades, patching, tuning, backup and recovery, cloning, space management, database security, auditing of Oracle Databases.
• Strong knowledge on Oracle Database Architecture and various phases of query processing.
• Experienced in working on Oracle database versions 9i, 10g & 11g running on environments like Sun Solaris & Red Hat Linux.
• Experienced in Installation, Configuration & Up gradation of Oracle Server Software & related products.
• Experienced in Advanced Database Technologies like Automated Storage Management (ASM) & Real Application Clusters (RAC).
• Experienced in Configuring & Managing Stand - by or Disaster Recovery (DR) database using Data Guard.
• Experienced in Performance Tuning using STATSPACK, AWR, ADDM, EXPLAIN PLAN, SQL TRACE, TKPROF.
• Experienced in RDBMS Tools like Statspack, Data Pump (expdp/impdp), RMAN, OEM Grid Control.
• Experience in working on IBM Data replication tool called IBM Info sphere Change Data Capture (CDC).
• 24X7 On-Call Support for Production, Stage, Development & QA Databases, Applications and Critical Processes.
• Handling Emergency and Integration Releases and Database changes.

TECHNICAL SKILLS:

Operating System: Solaris 9/10, RHEL 5.2, Windows Server 2003/2008

Languages: PL/SQL, SQL, Shell scripting, C

Database: Oracle 9i/10g/11g

Tools: & Utilities: Grid Control/Oracle Enterprise Manager, RMAN, Oracle Universal Installer, Oracle Database Configuration Assistant, Remedy 6.5, Infra, Service Now, IBM Info sphere Change Data Capture, Ignite, Statspack, Explain Plan, TKPROF, Import/Export, Data Pump, Data Guard.

PROFESSIONAL EXPERIENCE:

Confidential, San Rafael, CA

Oracle DBA - Sr.Consultant

Responsibilities:

• Provided L2 support to the clients for Oracle databases.
• Installation of Oracle 9i/10g/11g on Solaris and Linux.
• Upgrading of Oracle database 9i & 10g to 11g.
• Applying the Bug and PSU patches on Oracle DB 10g/11g and applying the CRS bundle patches on DB & CRS Home.
• Support Automatic Storage Management (ASM) & Real Application Cluster (RAC).
• Maintaining OEM 10g/11g Grid control for monitoring the database & scheduling jobs for running backups.
• Configuring & Managing Stand-by or Disaster Recovery (DR) database using Data Guard.
• Monitoring the data replication using IBM CDC.
• Writing shell scripts, setting up CRON jobs to Email reports and database status to various users.
• Creating, Monitoring and Managing table spaces for distributed databases.
• Create the Database Users and Database security administration using Roles, Profiles and Privileges.
• Daily DB backups (Full & Incremental) & recover of database using RMAN.
• Export/Import of Tables/Schemas/Database using traditional export/import techniques and Data pump.
• Creation and Rebuilding of indexes to improve the performance.
• Re-organizing the tables and Collection of the statistics for Tables/Schemas.
• Performing Stage Refresh Activities (Refresh the Stage with Production data).
• Tuning SQL using Explain Plan, TKPROF, STATSPACK, ADDM & AWR utilities.
• Experience in identifying performance bottlenecks on high volume transaction systems & analyzing SQL statements, reorganize database objects and design indexes to improve response of queries.
• Experienced in Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Provided support on performance issues during project development resulting in improved response times and reduced contention.

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager, IBM CDC, Ignite, SYSSTATS, Service Now

Confidential, Chicago, IL

Oracle DBA - Consultant

Responsibilities:

• Provided L1 support to the clients for Oracle databases.
• Installation of Oracle 9i/10g on Solaris and Linux.
• Applying the Bug and PSU patches on Oracle DB 10g and applying the CRS bundle patches on DB & CRS Home.
• Maintaining OEM 10g Grid control for monitoring the database & scheduling jobs for running backups.
• Writing shell scripts, setting up CRON jobs to Email reports and database status to various users.
• Creating, Monitoring and Managing table spaces for distributed databases.
• Create the Database Users and Database security administration using Roles, Profiles and Privileges.
• Daily DB backups (Full & Incremental) & recover of database using RMAN.
• Export/Import of Tables/Schemas/Database using traditional export/import techniques and Data pump.
• Creation and Rebuilding of indexes to improve the performance.
• Re-organizing the tables and Collection of the statistics for Tables/Schemas.
• Tuning SQL using Explain Plan, TKPROF, STATSPACK & AWR utilities.
• Cloning the databases for development and integration testing.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Supporting and Handling Emergency and Scheduled System & Database Maintenance.

Environment: Oracle 9i/10g, Oracle Enterprise Manager, Remedy

Confidential, Waltham, MA

Oracle DBA - Consultant

Responsibilities

• Involved in Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Database cloning from Test and Development environments.
• Monitoring Table spaces and extent Growth.
• Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
• Job scheduling using crontab.
• Creation of database maintenance plans, rebuild indexes and integrity checks.
• Creation of catalog database for RMAN Backups.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups using RMAN.
• Ensured high availability of Databases at all time.
• Provided support on performance issues during project development resulting in improved response times and reduced contention.
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.

Environment: Oracle 9i/10g, Oracle Enterprise Manager, Sun Solaris, RMAN.

Confidential

Oracle DBA - Specialist

Responsibilities

• Installation, Configuration and Administration of Oracle 8i/9i databases.
• Created roles, profiles, users and assigned privileges to them.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.
• Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
• Provided partitioning of the large tables to reduce the access time.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Supported developers during batch jobs to increase rollback segments and archive log space for additional month end updates to the system.