PROFESSIONAL SUMMARY

• Extensive Experience in Oracle 9i/10g/11g Architecture, RMAN backups, Crash Recovery, Optimization, Performance Tuning, Troubleshooting in Production, Test and Development Instance environment.
• Diverse industry experience including Banking and Finance, Pharmacy, Insurance.
• Designed and developed plans to achieve high availability, scalability, recoverability of the Oracle RDBMS servers.
• Experience as On - Call 24x7 and day-to-day support production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience in working with Large Tables and VLDBs
• Involved with installation and maintenance of ORACLE 10g RAC 2 node and adding a node to this cluster database for high availability.
• Experience in a variety of hardware and software platforms including; MS-Windows, UNIX/Linux, Sun Solaris, HP-UX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation & administration.
• Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams Replication.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQLTrace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in PATCHING AND UPGRADATION.Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Extensive knowledge and experience on Data Warehouse using ETL.
• Worked extensively on Oracle Migrations.
• Exposed to Data Warehouse assignments in various domains like Medical services, Sales, Insurance, Financial & Bank, Inventory Distribution, and Production Data warehouses
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network File Storage (NFS)
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.
• Tune the new databases for Maximum performance
• Experience in Creating Duplicate databases using RMAN cloning as well as User managed cloning
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Data Stage
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams

TECHINICAL SKILLS:

DBMS & RDBMS: Oracle 8i, Oracle 9i, Oracle10g RAC, Oracle 11g RAC, MS - Access.

High Availability: Tuning & Monitoring ProductsOracle 10g RAC, Oracle 11g RAC, ASM, Streams, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR

ADDM, ASSM: Operating Systems

Oracle SQL Developer, TOAD, RMAN, Export/Import, EXPDP/IMPDP, SQLLoader.: ETL & Reporting Tools

Informatica, Power Center 8.5/8.0,: Business Objects Xi R26.1, Oracle Data Integrator, Sas

Backup Tools: Veritas NetBackup, NetApp, HP OmniBack, TSM,EMC, Comm vault

MS Office Tools: Excel, Word, PowerPoint, Outlook, Visio

Programming Languages: C,Asp.Net, XML,HTML,DHTML,CSS,Java

WORK EXPERIENCE

Confidential, MN

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g on SUSE Linux and also Upgraded from Oracle 10g to 11g.
• Involved in construction of DR sites for all the Production databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability.
• Supported different Databases like Production, Testing, Development and External.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Managing backup strategy for all production databases.
• Taking the RMAN incremental and cumulative backups.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Scheduling the databases backup Job using OEM GRID and Comm vault backup storage.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Creation of database objects like Tables, Indexes, Views, Fast and complete mviews and replicating data using materialized views etc.
• Supported as primary DBA for datawarehousing environment‘s DEV,QA,PROD. Worked with Informatica Team in resolving technical issues on partitioned tables and non partitioned tables and mainitaing the consistency between databases QA,PROD and retrofits by using PPM PACKAGES for migrating from one region to another region.
• Creating and maintaining new schemas for Informatica projects and replicating the schema objects from one schema to another scheme by using datapump utility. Working closely with Informatica Team on monitoring the performance issues by providing them TOP SQL’S AWR reports. As well monitoring the CPU spikes on Informatica bulk data loads..
• Involved actively in By-Monthly release cycles worked with Data Admins and Data Analyst on various code build deployments and aligned the projects from dev to post productions installs.
• Worked closely with Core-DBA Team and monitored the OEM Database performance pro-actively. As well involved in weekly and monthly DBA Team meeting.
• Worked as a on-call Core-DBA by monthly rotation, and taken care of the OEM GRID CONTROL CRITICAL ALERTS and Production issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: Oracle 11g/10g, SUSE -LINUX, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Cognos, Toad, Awr, Addm, Sql*Loader, Informatica, Putty, PPM, Comm vault, Pl/sql developer.

Confidential, Nj

Senior Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in construction of DR sites for all the Production databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability.
• Supported different Databases like Production, Testing, Staging and Training
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Managing backup strategy for all production databases (at least triple redundancy and least double redundancy for all development databases).
• Taking the RMAN incremental and cumulative backups.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Creating Logical and Physical database structure, Creating and altering Table spaces. Managing Users and Resources, Granting and revoking privileges through Roles.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of upgradation and migration.
• Replicated database using Oracle Streams.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Cloned schemas, objects and data on new server using Data pump.
• Managing databases on multiple servers
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, Awr, Addm, Sql*Loader, Informatica, VERITAS Net Backup.

Confidential, san francisco, CA

Senior Oracle DBA

Responsibilities:

• Implemented Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.Configured.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• 24*7 on call support for the production environment.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM,ASH
• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Dataguard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Implementation and configuration of Oracle golden gate.
• Extensive use of Oracle Datapump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Renaming and Resizing the databases.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Datapump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 10g, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, AWR, Datapump, sql*Loader, OEM, STATSPACK, TKPROF, Informatica, Pl/sql,Toad, Erwin 7.2.

Confidential

Oracle DBA

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat 4.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage
• Performance Tuning i.e., Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Configured, administered and monitored Streams environment using various tools like OEM Console.
• Involved in migration of applications of the clients. Used Data pump and Transport table spaces for that.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities
• Oracle Grid Control Management Server Installation
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Generated Reports using crystal reports
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, operating system and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/9i Rac, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, Rman, OEM, STATSPACK, and TKPROF,Toad,Pl/sql.

Confidential

Oracle DBA/Developer

Responsibilities:

• Supported different Oracle 8ig and Oracle 9i Databases of Production, Testing, Staging and Training
• Responsible for Data load on different databases using SQL*Loader
• Database Creation, Parameter Assignment in init file or session level assignment; database startup and shutdown process.
• Database configuration on parameter file and operating system file.
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking.
• Configured listener for external procedure calls.
• Database backup & Recovery with export and import for non archive database.
• Creation of database objects like Tables, Indexes, Views, Users, etc.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Provided guidance for developers in writing and tuning PL*SQL stored procedures and SQL queries.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Alert monitoring and Ticketing.
• Worked on Data Guard ie., setting the logical and physical standby database and setting the migration from primary to standby databases.
• Cloning the Test & Dev instance with PROD database
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 9i RAC on Solaris.

Environment: Oracle 9.2.0.7, Oracle Advance Replication, Window NT/2000/2003, Oracle Enterprise Manager, VERITAS Netback up, SQLDBA, PL/SQL, TOAD7.5, Shell Scripting, HTML, ASP, DBA, Stored Procedures, Triggers.

Confidentia

Oracle DBA/Developer

Responsibilities:

• Installation, Implementation and maintenance the Oracle9i database
• Created and managing the database objects such as tables, indexes and views
• Create the users and roles.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager.
• Created and managing the database storage structures which includes data table spaces, index table spaces, rollback table spaces and rollback segments
• Loading the database with SQL*Loader
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
• Performing the logical and physical structure of tables, indexes, modeling, normalization and foreign key constraints
• Database maintaining including backups, recovery, imports/exports
• Monitoring the database daily activities
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL

Environment: Oracle 9i, Quest Toad, SQL*Loader, SQL*Plus, SQL Server- 2000, Enterprise Manager, VERITAS Netback up, RMAN, RHEL Linux AS 3.0 and Windows 2000.

Confidential

PL SQL Developer/Jr DBA

Responsibilities:

• Installed and configured oracle 8i/9i databases.
• Created database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Designed and implemented backup and recovery strategies.
• Tuned application SQL using STATSPACK, SQL Trace and TKPROF.
• Optimized and fine-tuned the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Created users and assigned roles and profiles to users.
• Maintained data integrity, profiles, resources and password security.
• Used direct path loading vi SQL*Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, specifying NOLOGGING on staging table, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed PL\SQL code such as procedure, function, package or triggers as well as working with pre-defined oracle package to administrate database.
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintainace, security, backup & recovery, SQL coding guide lines.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Creation of users and Granting them privileges and roles.
• Provided production support on the various databases and resolved production issues proactively.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.

Environment: Oracle 8i,9i, SQL Server 7.0, PL/SQL, SQL Loader, RMAN, Oracle Parallel Server, Import, Export, Oracle Enterprise Manager (OEM), TOAD, Oracle warehouse Builder, Erwin Designer, SQL Navigator, HTML, JDBC, MS Access, Sun Solaris, HP-UX and Windows NT.