SUMMARY:
6 years of working Experience and 5 year of strong experience as Oracle DBA on a variety of UNIX (Solaris, Linux, AIX, HP-UX), Windows platforms having in-depth expertise with all facets of Database design, Administration, Production Support, Installation, Configuration, Patches, Upgrades, Migration, Performance Tuning, Backups and Recovery, Cloning, Space Management, database security, Disk Space, File System Management and Monitoring.

• Experience in Installation and configuration of Oracle 11g, 10g, 9i, 8i on Solaris, AIX, LINUX, HP-UX and Windows environment.
• Planning and Implementation of DR Solutions Using Oracle 10g, 9i Data Guard.
• Strong experience in installation of one-off patches using OPatch utility.
• Worked on development, testing, production and very large databases (VLDB) with sizes of terabytes and excellent customer handling skills
• Worked extensively in Hot/ Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Lots of Data Migrations using Export/Import as well as Data Pump.
• Experience working with Materialized Views, Partitioned Tables and Indexes.
• Good Experience working with various platforms like Linux, Solaris, HP-UX, AIX and Windows.
• Experience in OEM 11g, 10g Grid Control Implementation and monitoring.
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup & Recovery using RMAN, Shell Scripting, Partitioning, Trouble shooting production issues, Performance Tuning, Logical & Physical Database design, SQL & PL/SQL skills.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, STATSPACK, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve instance/database performance.
• Hands-on Experience on OLTP as well as DSS (Data warehouse) databases with a large-scale (multi TB) database.
• Job scheduling through Autosys, CRONTAB, O/S updates and upgrades, patches loading.
• Provided extensive support for Application development Team for resolving the issues concerning to databases
• Experienced in Oracle Support processes for technical requests through MOS (Metalink) and other Support Procedures.
• Driving high-availability, secure and robust 24x7 production environments.

Education:

• M.S. in Engineering
• B.Tech. in Engineering (GPA 3.5/4.0).

CERTIFICATIONS:
Oracle10G Certified (OCP).
TECHNICAL SKILLS:

Database : Oracle 11g, 10g, 9i, 8i, SQL SERVER 2000/2005.
Operating Systems : Sun Solaris 5.9/5.10, HP-UX, IBM AIX, CentOS 4, Windows NT.
Database Tools : OEM, RMAN, AWR, ADDM, TOAD, DB Artisan, IMP, EXPDP, IMPDP,
ERWIN, GRID CONTROL.
Technologies : RAC (Real Application Cluster), DataGuard
Utility Tools : Putty, Hummingbird Connectivity.
Languages : Oracle PL/SQL, Conversant with C, C++, Mat lab.
Change Management : Clear Case, Clear Quest, Remedy.
Scheduling Tools : Autosys, Crontab.

PROFESSIONAL EXPERIENCE:

Confidential,NJ April’07 - Present

Confidential,MN – Current Assignment
Oracle DBA

Responsibilities:

• Working on a series of on-going development projects within implementation and development (I & D) team.
• Provide development support for DB’s, build database for user requests, fix the incidents identified during project development using current information technology.
• Responsible for analyzing system, develop test and troubleshoot sophisticated Database issues under direct supervision.
• Breaking down complex situations to discover and resolve root cause that applies to both technical issues and process issues.
• Experience in evaluate user requirements for new or modified Database.
• Experiencing in providing proactive support to present business flow.
• Experience in Compiling documentation to describe changes made during the

development process.

• Experience in supporting both SAP and Non-SAP database environments.
• Experience in working with BRtools.
• Experience in working with Oracle 11g, 10g, 9i databases and Oracle 11g RAC databases.
• Experiencing in deploying and troubleshooting Oracle 11g Standby databases.
• Experience in Refreshing Pre-Prod, Development and Test Environment using Production data.
• Experience in upgrading Grid agent to 11g Agents on Linux, HP and Windows servers.
• Working experience with disaster recovery solution using Data Guard Broker – both Physical and logical standby, performed switchover/Failover.

Confidential,Colorado Springs, CO
Oracle DBA

This project involves Oracle 9i, 10g and 11g databases on multiple UNIX platforms (HP-UX, Solaris, Linux, and AIX) with high availability environment of RAC and Standby servers with ASM. Its primary focus to implement the OEM 11g Grid Control Systems into their environment replacing their age-old tool DBAmon. Configuration of all the events currently being monitored using OEM via Out-of-Box and using OS and SQL UDM’s. Also includes supporting the operation task within the environment.

Responsibilities:

• Responsible for the complete implementation of the OEM 11g Grid Control.
• Experience in installation of grid control 10g and 11g agents using various methods.
• The environment is includes 190 servers and around 412 database instances on UNIX and Windows platforms
• Experience in working with the DBAmon tool Perl Scripts to monitor the database environment.
• Experience in Creation of OEM OS and SQL UDM’s for the customized events present in DBAmon tool.
• Experience in configuration of Default and Customized notification to the database and server owners and also to Business partners.
• Experience in generating out-of-box and Customized reports and also generation of public reports.

Environment: Oracle 8i, 9i, 10g, & 11g Sun Solaris, AIX, HP-UX, Linux, Windows, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl.

Confidential,Dallas, TX
ORACLE DBA

Responsibilities:

• Experience in working with oracle 9i, 10g databases.
• Database Upgrade from RBO to CBO working in 10g.
• Installed and Configured of Oracle 9i & 10g servers on UNIX (HP-UX, Solaris)
• Experience in database Upgradation and Migration from 9i to 10g.
• Handled day-to-day activities on 9i and 10g servers
• Migration of production database from one server to another.
• Database patches and configuration of Oracle 9.2.0.3 to Oracle 9.2.0.7 Server on HP-UX, Solaris and Windows environments
• Monitoring 8i, 9i and 10g databases with own scripts for (Tablespace, Rollback Segment, Table and Index fragmentation and Audit User Access)
• Peak time monitoring 9i and 10g databases with use of 9i and 10g Statspack
• SQL and PL/SQL tuning using various diagnostic tools like Explain Plan, Trace, TKPROF, Statspack
• Server managed backup & recovery using 9i and 10g RMAN, logical Export/Import as the backup & recovery tool, developed SQL Scripts for cold and hot backups
• Customize and Implement SQL * Loader utility for loading the data
• Creating Users, Schemas, Tablespaces, Tables, Partitioned Tables and Index, Indexes, Sequences, Synonyms on 8i, 9i and 10g
• Responsible for administration of SQL Server databases including backup / recovery, user management and disk space management.
• Created databases and users using SQL Server Enterprise Manager.
• Refresh SQL Server databases with production data.
• Experience in working with partitioned database environment.
• Respond to database fatal alerts in Quest Foglight.
• Created roles and enabling, disabling roles on all databases(8i, 9i, 10g)
• Provided 7x24 & on-call supports

Environment: Oracle8i, 9i & 10g, HP-UX,Linux, Solaris, Windows, SQL*Plus, PL/SQL, TOAD, RMAN, Putty, Quest Foglight/Spotlight, DB Artisan 8.1.1, Rational Clear Case/Clear Quest.

Confidential,Plymouth, MN
ORACLE DBA

Responsibilities:

• Installation and configuration of Oracle 9i/10g binaries and databases.
• Real application cluster (RAC) 9i/10g Installation, configuration, managing Nodes, node addition deletion and monitoring.
• Installation, creation and administer the ASM databases.
• Experiencing in the Database Decommission.
• Experience in Backup and Recovery using RMAN with TSM as media manager layer and used Autosys as the scheduler.
• Experience in Refreshing Pre-Prod, Development and Test Environment using Production data.
• Involved in refreshing lower environment schemas with production data periodically using EXP/IMP and Data Pump
• Apply regular CPU patches.
• To develop logical and physical design of the database and estimate size of the database objects.
• Creation of users with passwords and assigning them tablespaces like user data and temporary, granting privileges (system and object) through roles and profiles.
• Generated SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Application Query tuning on all modules using Tkprof, Explain plan & Statspack.
• Responsible for applying Oracle Patches using the OPatch utility.
• Monitoring Database Activities, Checking for tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.
• Experience in creating and refreshing the Materialized views.
• Experience in Monitoring of the database using the OEM Grid Control.
• Experience in working with Oracle Identity Management and Oracle Internet Directory.
• Experience in installation of Grid Agent on the database and application servers.
• Experience in working with Application Development teams to design the database architecture (logical and physical) and build database objects to meet project needs.
• Change management using ClearCase/Remedy.
• Documented standard procedures and policies.
• Provided 24x7 On-call Support for all the Production databases.

Environment: Oracle 10g/9i, 10g RAC, Sun Solaris, IBM AIX, Hummingbird Connectivity 4.2, Autosys, BMC Remedy, RMAN, TSM Media Management.

Confidential,India Dec’06 - Apr’07
ORACLE Admin (Intern)

Responsibilities:

• Installation and configuration of Oracle 8i/9i/10g databases.
• Provided System support for both development and 24/7 production environment.
• Applied regular CPU patches (bug fixes), security patches, ensure that all the SOX requirements are met.
• Migrated earlier version of Oracle database to Oracle 10g environment.
• Capacity planning and space management, tablespace reorganization.
• Introduction to the Data guard (standby databases) environment.
• Configure client connectivity using TCP/IP to ensure user and developer access.
• Used Export/Import utilities to migrate data.
• Developed small UNIX scripts as per the requirement.
• Extraction of data from different flat files into Oracle Database using SQL*Loader.
• Established constraints to ensure data integrity and consistency.
• Reorganizing the Database for every three months ensuring performance growth.
• Worked with RMAN (Recovery Manager) tool for taking backups (Database level and Incremental sets) with ORACLE 10g database. Practically aware of most recovery operations to be performed using RMAN tool.
• Performed both Hot / Cold backups and coordinated with TSM team to solve any backup issues.
• Basic programming using sql, plsql and shell scripts.
• Defined backup procedures using daily hot backups and weekly cold backup
• Management of table space growth, monitoring data files additions, extent growth
• Archiving backups and maintaining backup’s library. Continuous monitoring for free space at backups archive destination.
• Documentation of Data Base Setup and administration of Server Environment.

ENVIRONMENT: Sun Solaris 5.8, Linux, Oracle, SQL, SQL*Loader, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM), Perl, Windows 2000, TOAD, Data Guard.

Confidential,Dayton, OH Sept’05 - May’07

Confidential,Dayton, OH

• Worked at University Campus Dining Services.

Confidential,Dayton, OH

• Worked as a Teaching Assistant for undergraduate course work on RDBMS and MS Office.

Confidential,Mahbubnagar, India Aug’04 - Apr’05
System Admin (Intern)
Responsibilities:

• Installed and Configured and maintained the operation and functioning of Windows and Unix environment with over 80 server, client setup.
• Worked as an administrator for the WAN network.
• Involved in Tuning for the performance improvements of the servers.
• Involved in Cloning of the server configuration.
• Worked with Security team for possible security threats to network, configured servers to their recommendations.
• Involved in Creating and Managing multiple licensed software’s and packaged on the WAN network.
• Troubleshooting problems in different stages of network build and at different levels