Summary: 
Senior Oracle Database Administrator with 10+ years of IT experience in Database Administration, Installations, Upgrade and Migration, RMAN backup and Recovery, Performance Tuning, Advanced Replication, Database optimization, Schema management, Real Application Cluster (RAC), Data Guard, Grid Control, Development and Production support in local and remote environments on Operating Systems viz. Linux, Sun Solaris, HP-UX and Windows 2000/NT Server.

Strong DBA Skills:

• Upgrading Oracle 9i, 10g databasestoOracle 10g/11g.
• Configuring backup and recovery solutions using RMAN.
• Extensive knowledge in Installation and Configuration of Oracle Products like Oracle Enterprise Edition Server and client, Oracle Enterprise Manager, OAS and 3rd party tools like Benchmark Factory, Quest software (TOAD), PL/SQL Developer, SSH Secure shell server.
• Installing and configuring Oracle Enterprise Manager Grid Control 10g/11g Server/Agents to monitor various databases and servers.
• Experience in collecting Oracle 10g/11g ASH, ADDM & AWR report for performance tuning, tuning the databases for optimal performance at OS level and Oracle level.
• Configured and maintained physical standby database using Data Guard for disaster recovery and high availability configuration.
• Expert knowledge on UNIX Shell scripting and Perl Scripting for pro-active database monitoring.
• Experience in Oracle 10g/11g FLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
• Good knowledge of Oracle Real Application Clusters (RAC). Installed and configured 10gR2 CRS on the 2 node Solaris cluster nodes and converted single instance to a 2 node RAC.
• Installed ASM Lib 2 and setup of ASM instance on a 2 node cluster.
• Installing and setup of Oracle OAS 10g.
• Applying Oracle Patch on databases for security and migration.
• Very fluent in creation of Instances, Tablespaces, IOT tables, Partitioned tables, Indexes,Materialized Views, PLSQL packages, objects, roles etc
• Load balance test for RAC database using Quest Benchmark Factory.
• Identifying and resolving performance issues affecting Oracle databases and real application clusters (RAC) using Quest Spotlight.
• Experience in using Data Modelling tool Erwin, ER/Studio for forward and reverse engineering and maintaining the databases in sync with the data model.
• Experience with advanced replication to provide a database replicated environment.

Skills:

DBMS : Oracle 9.x, 10g, 11g 
Language : SQL, PL/SQL, Shell scripting, Perl scripting
OS/Environment : Red hat Linux, Sun Solaris 5.8, 5.9 & 5.10, AIX, HP/UX and  Windows XP, 2000 
Tools : Pl/Sql Developer, TOAD, ERWIN 3.5.2, ER Studio, SSH Secure Shell, Putty,  Cygwin, smartCVS and Benchmark Factory

Project Information:

Client: Confidential, MA. Apr 2007 – Present
Sr. Oracle DBA
Responsibilities: 
Database administrator for 50+ Oracle databases which are running for Customer Asset Management System, Forward Capacity Tracking System, Market Information System, Settlements Market System, Enterprise, Financial Transmission Rights, and Auction Revenue Right etc.

• Installed and configured Oracle 10g and 11g database on Dev/Test/Integration/Prod systems.
• Developed UNIX shell scripting to monitor databases, RMAN backups and recovery procedures
• Writing Perl scripts for various databases activities.
• Using table online redefinition changed partition key column for partition tables.
• Installing and configuring 10gR2 CRS on the 2 node Solaris cluster nodes and converting single instance to a 2 node RAC.
• Installed ASM Lib 2 and setup of ASM instance on a 2 node cluster.
• Applying critical patch on various development/test/integration databases.
• Upgrading Oracle 9i/10g database to Oracle 10g/11g databases.
• Cloning/Refreshing of development/test/integration databases from production databases using RMAN duplicate and RMAN active database duplicate.
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
• Setup of Oracle streams on development database.
• Testing new Oracle 10g/11g features and preparing test case documents.
• Logical and Physical data model design with ER Studio data modelling tool.
• Creating DDL’s for schemas from data model using ER Studio and applying those changes on development database.
• Installing and configuring Oracle 10g/11g client.
• Configuring Oracle databases on Grid control for monitoring and maintenance activities.
• Configuring and setting up RMAN backup for development databases.
• Creating and Managing SR’s for the issues faced on databases.
• Export/Import using Data Pump (expdp and impdp).
• Migrated database from Solaris 64 bit to Linux 64 bit server using RMAN cross-platform transportable tablespace.
• Converting 32 bit word size to 64 bit word size for Oracle database on Linux.
• Working closely with Systems Administrators as well as applications development team to design, implement and test new features and functionality.
• Providing daily database support such as creating, dropping and altering tables, indexes or views, dropping and recompiling procedures, packages, functions as well as inserting, updating and deleting data. Maintaining database security by granting privileges to different roles or users.
• Implemented Oracle Workspace Manager to provide unlimited history.
• Developed SQL Loader scripts to extract, transformed and loading (ETL) data into table.
• Configured Auditing to audit information about database activity.

Environment: Oracle 10g, 11g, Red hat Linux, Solaris 5.8, 5.9 & 5.10, PL/SQL Developer, ER Studio, 
Cygwin, Putty and Spotlight

Client: Confidential, NC. Dec 2006 – Mar 2007
Oracle DBA
Responsibilities: 
DBA for 100+ Oracle databases which are running for Retirement Plans, Individual Retirement Accounts, Education Savings, Mutual Funds, After-Tax Annuities, Life insurance, Brokerage Services, Trust Services and Beneficiary Services.

• Handling Highly Crucial 24 x 7 environment Production Databases in Multi O/S environment.
• Applying Oracle Patch on Databases for security, migration and daylight savings.
• Cloning of Oracle database using RMAN Backup and duplicating target databases.
• Writing Shell scripts for monitoring the databases for alert log errors, availability, and tablespaces usage.
• Creating RMAN backup scripts for cold and hot backup.
• Upgrading Oracle 8i Database to Oracle 10g Databases.
• Implementing Change controls on production databases and QA databases.
• Configuring Oracle 10g single instance Dataguard.
• Data Purge activity for Production databases.
• Sizing the tables and indexes.
• Reorganising oracle datafiles.
• Creating users, assigning roles and creating profile.
• Maintenance of database regular activities.
• Managing of Indexes to improve the performance during I/O operations.
• Managing TAR's and Production Support.
• Providing support for Oracle Real Application Clusters (RAC) setup.

Environment: Oracle 8i, 9i, 10g, Solaris 5.8, 5.9, AIX, HP/UX, Putty, Toad, PL/SQL Developer, Foglight.

Client: Confidential, CA. Mar 2006 – Oct 2006
Oracle DBA
Responsibilities: 
Responsible for the database administration of 80+ Oracle databases which are running for Banking domain activities like Retail trading, Credit card services, Mutual funds and housing loan.

• Handling Highly Crucial 24 x 7 environment Production Databases in Multi O/S environment.
• Responsible for Database Installation, Configuration and Migration.
• Writing Shell scripts for monitoring the databases.
• Scheduling Backups and various performance related scripts. Also taking full, incremental and log Backups using RMAN.
• Database 10g Upgrade activities.
• Implementing Change controls on production databases/QA databases.
• Building managed Standby databases and maintenance.
• RMAN backup and restore of databases.
• Data Purge activity for Production databases.
• Database Cloning.
• Sizing the tables and indexes.
• Maintenance of database regular activities.
• Reorganising oracle datafiles.
• Managing Indexes to improve the performance during I/O operations.

Environment: Oracle 9i, 10g, Solaris 5.8, Erwin, Putty, PL/SQL Developer, Toad and SSH Secure Shell.

Client: Confidential, Utah. Nov 2004 – Feb 2006 
Oracle DBA
Responsibilities:

• Scheduling backups and maintaining recovery process.
• Daily monitoring of data reports for space usage, fragmentation issues, daily backups, alert logs for typical oracle errors.
• Executing database change requests for all the production.
• Creating users, roles, objects and tablespaces.
• Creating/Editing Shell scripts for various database maintenance activities.
• Keep updating the database standards and adhering the same.
• Applying patch for upgrading database from 9.2.0.4 to 9.2.0.6.
• Tuning SQL Query.
• Upgrading databases from 9i to 10g.
• Periodical Monitoring of database performance using STATSPACK and tuning the database for best performance.
• Working on the multiple scope documents which includes Requirement analysis, Time Estimation, Coding, Testing, Documentation & Implementation Support
• Creating ETL tool for data migration.
• Developing data models using Erwin.

Environment: Oracle 8i, & 9i, Solaris 5.8 & 5.9, Erwin, SSH Secure Shell, Toad and DB Artesian.

Client: Confidential. Sep 2001 – Nov 2004 
Oracle DBA
Responsibilities:

• Overall Database activities like creation of tablespace, users, schemas, objects, defining roles and access privilege to users.
• Developed PL\SQL stored procedure, package, triggers, cursors, and views.
• Installed Oracle 9i Database server software and database creation.
• Oracle database migration from 8i to 9i and 9i to 10g.
• Portlets developed in Oracle JDeveloper and deployed to Oracle WebLogic for consumption in Oracle WebCenter
• Installed and configured WebLogic, Apache Application Server for deployment.
• Handling user requests, database health check, ensuring the database availability and monitoring the database.
• Cloning of Databases.
• Daily monitoring of data reports for space usage, fragmentation issues, daily backups, alert logs for typical oracle errors.
• Import and Export using transportable tablespace.

Environment: Oracle 8i & 9i, Solaris 5.8 & 5.9, Erwin, SSH Secure Shell, Toad and DB Artesian

Education:

• Bachelor of Engineering (B.E)
• Master of Business Administration (M.B.A)

Certifications:

• Oracle 9i Database Administrator Certified Professional (OCP)