Summary

• 8+ years of IT experience as an Oracle Database Administrator having hands on experience in Installation, Management, Administration, Backup and Recovery, Performance monitoring and Tuning of Oracle RDBMS.
• Supported Oracle 9i/10g/11g & Oracle 10g RAC, 11g RAC databases in different environments like Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
• Designed and developed plans to achieve high availability, scalability, performance
• Experience in cross platform migration using Golden Gate, Transportable tablespaces and Datapump.
• Experienced in setting up standby databases, and hands on experience with 11g Data Guard new features like Active Data Guard and Snap shot standby.
• Experienced in Setting up and administering both Oracle 10g RAC and 11g RAC clusterware and instances.
• Experience in monitoring using OEM (Oracle Enterprise Manager) and Grid Control.
• Hands on experience with logical backups, Hot/Cold backups, RMAN incremental backups. Recovery, and cloning of databases using (RMAN) Recovery Manager.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Plugging the tablespaces between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using ASH, Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Extensive Experience in Oracle Architecture, Optimization, Memory Tuning, Performance Tuning and troubleshooting.
• Memory tuning by using ASMM (Automatic shared Memory Management).
• Experience in Rebuilding of Indexes for better performance
• Experience in User Management, Tablespace management, maintenance of Oracle Database.
• Experience in applying patches and upgrading databases.
• Experience in Monitoring and Tuning system resources associated with the database performance
• Expertise in maintenance, upgradation, administration, backup and recovery of Oracle Exadata systems.
• Experience with SQL, PL/SQL Programming, UNIX Scripting.
• Extracting, transforming and Loading (ETL) of data from source systems in the Data Warehouse.
• Installation, Configuration and administration of GoldenGate
• Replication using GoldenGate, Oracle Streams and Materialized views.
• Worked on Data Modeling, Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Experience in providing 24/7 production support for critical production databases.
• Excellent analytical, problem solving, communication and interpersonal skills.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• Strong Problem analysis and resolution skills.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.x,6.x,7.x, Red Hat Linux RHEL 4.x, 5.x,6.x and Windows NT/2000//XP.

RDBMS

Oracle 11g RAC/10g RAC/9i/8i, MySQL, MS SQL Server 2008

Languages

SQL, PL/SQL, XML ,UNIX Shell Scripting, C,C++

Tools

TOAD, SQL Tools, Informatica PowerCenter, Cognos 8

Oracle Tools

RAC,RMAN, ASM, OEM, SQL*Loader, exp/imp, DataPump(expdp/impdp), GoldenGate, Oracle Streams.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK,ASH, AWR, ADDM

Database Modeling

Erwin 4.0, Toad Data Modeler.

Other

VERITAS Netbackup, TSM

Education: Bachelors in Engineering .

Work Experience

Confidential,San Francisco, CA June 11 - Till Date
Sr. Oracle DBA
RESPONSIBILITIES:

• Involved in 24x7 on call production support.
• Installed and configured Oracle 11g, 10g databases
• Installed, configured and tested oracle 10g RAC and 11g RAC environment for High Availability.
• Upgraded Databases from 10g to 11g and applying patches whenever required.
• Implemented Standby Databases (Active Data guard) for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Performed Hot, Cols Backups, RMAN incremental backups.
• Migrated databases from Sun Solaris to IBM AIX, HP-UX to IBM AIX, Windows to Linux
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Wrote UNIX Shell Scripts, SQL, PL/SQL, stored procedures, functions, packages and triggers.
• Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• Performed data transfer between one database to other by using Oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Installation, Configuration and administration of GoldenGate
• Replication using GoldenGate and Materialized views.
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace TKPROF, STATSPACK, ASH, AWR, ADDM
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Performed Capacity Planning and Bench Marking.
• Partitioned tables for better performance and manageability.
• Logical and Physical Database design.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

ENVIRONMENT: Oracle 11g RAC/10g/9i RAC, HP-UX, IBM AIX, Sun Solaris, RedHat Linux, SQL, PL/SQL, SQL Developer, GoldenGate, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,Schaumburg, IL Feb 09 – June 11
Oracle DBA
RESPONSIBILITIES:

• Involved in 24x7 on call production support.
• Installed and configured Oracle 10g and 11g Databases for Production, Development and Testing.
• Installed, configured and tested oracle 10g RAC and 11g RAC Databases.
• Expertise in handling various security aspects of the database including VPD (virtual private Database).
• Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Wrote UNIX Shell, SQL, PL/SQL, stored procedures, packages, functions and triggers
• Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• Implemented Oracle Streams which enable the propagation of data from one database to another
• High speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
• Monitoring databases using OEM Grid Control.
• Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace ,TKPROF, STATSPACK, AWR, ASH, ADDM
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Scheduled Jobs through Job Scheduler
• Performed data modeling using Erwin data modeler.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

ENVIRONMENT: Oracle 11g RAC/10g RAC/9i, HP-UX, Sun Solaris, RedHat Linux, Oracle Enterprise Linux, SQL, PL/SQL, SQL Developer, GoldenGate, Oracle Streams, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,TX Dec 07 – Jan 09
Oracle DBA
RESPONSIBILITIES:

• Involved in 24x7 on call production support.
• Installation and configuration of Oracle 10g RAC for High Availability
• Installed and created Oracle 10g databases in development, Production and QA environment including configuration, backup & performance tuning.
• Implemented Oracle RAC (Real Application Cluster) with four nodes for Scalability and high availability.
• Loading data into a normalizedOracledatabase using SQL*Loader and External tables.
• Coding and preparation of Test plans.
• Upgraded databases from 8i, 9i to 10g, 10g to 11g and applied patches.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Created and monitored the Standby database Configuration for the Disaster recovery scenarios.
• Worked with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Implemented Replication using Oracle streams
• Design and implemented backup strategies, like, incremental, complete and cumulative Backup of the database using Recovery manager (RMAN). Used utilities like Export/Import and Data Pump. Performed Hot/Cold Backups.
• Design and developed scripts to monitor instance locks, long running queries, free space, extent growth.
• REFRESH/CLONING of Database using RMAN Duplicate for development, testing.
• Analyzing Alert Log and User Trace Files and diagnosing the problem.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace,TKPROF, STATSPACK, AWR, ASH, ADDM
• Performance tuning which includes creating indexes, analyze tables and optimizer hints.

ENVIRONMENT: Oracle 11g/10g RAC/9i/8i, IBM AIX, Sun Solaris, RedHat Linux, Oracle Enterprise Linux, SQL, PL/SQL, SQL Developer, Oracle Streams, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD

Confidential,NJ Jun 06 - Nov 07

Oracle DBA
RESPONSIBILITIES:

• Installed and created Oracle 9i and 10g databases for Production,Testing, Development.
• CLONING /REFRESH of Database for development, testing using RMAN, Export/Import, Data pump.
• Created and Managed Physical Stand by database for failover and switch over operations.
• Conducting sizing & capacity planning for Oracle databases.
• Responsible for setting and managing user accounts, granting privileges to users.
• Designing the security policies and database access strategies, Logical and Physical database structure.
• Logical and physical modeling using Erwin Tool.
• Implemented backup and recovery strategies, taking Backups on scheduled time and monitoring those.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN (Recovery Manager).
• Partitioning Strategies for very large tables. Implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Wrote monitoring/health check scripts, to send alerts like, database uptime/downtime status, sizing issues.
• Data refresh from production to test and development, maintain Database Security.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Identifying the expensive SQL statements and assist the developers during modification.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader for loading data from external files into the Oracle database.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using shell scripting with SQL*Loader.
• Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace,TKPROF, STATSPACK, AWR, ASH, ADDM

ENVIRONMENT: Oracle 10g RAC/9i/8i, HP-UX, IBM AIX, RedHat Linux, SQL, PL/SQL, SQL Developer, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,India Oct 04 – May 06

Oracle DBA
ENVIRONMENT: Oracle 8i, SQL, PL/SQL, RHEL, Windows 2000 Server.
RESPONSIBILITIES:

• Taking Cold and Hot Backups Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking permissions as and when required.
• Involved in the Design (Logical & Physical) of Databases.
• Involved in the installation of Oracle 10g, 9i Databases.
• Handling day-to-day activities and monitoring performance.
• Creating Databases and database objects, Tablespaces.
• Monitoring Tablespaces, Indexes, extents & performance tuning.
• Constantly monitor the Alert log files & Trace files.
• Perform database and SQL tuning using in-house scripts and database tools
• Enrolling the users and providing required previleges, and maintaining the system security.
• Ensuring proper Online and Offline backup, Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

ENVIRONMENT: Oracle 10g /9i/8i, IBM AIX, RedHat Linux, SQL, PL/SQL, SQL Developer, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,India Apr 04 – Sep 04

Junior Oracle DBA/Developer
RESPONSIBILITIES:

• Responsible for creating tables, views, synonyms.
• Writing PL/SQL Programs Functions, Procedures, Packages and Triggers
• Written Shell scripts for backups and monitoring
• Creating Roles and Users and granting required previleges.
• Created Indexes wherever required to improve the performance.
• Implemented Security management through grants and triggers. User account creation, group creation and setting up of privileges and accesses.
• Tuning the databases for optimal performance.
• Creating and modifying Stored Procedures and Database Triggers
• Design, developed, test, debug, PL/SQL Package, Procedures.
• Implement scripts to automate Oracle backups utilizing different approaches such as hot and cold backups and export and import utilities.

ENVIRONMENT: Oracle 10g /9i/8i, Sun Solaris, RedHat Linux, SQL, PL/SQL