SUMMARY

RDBMS : Oracle 11g/10g/9i/8.x/, Oracle 10g Real Application Clusters (RAC), My SQL
GUI : SQL loader, sql * plus, TOAD
Languages : SQL, PL/SQL
Operating systems : LINUX Admin, UNIX Admin, Windows NT, 2002AS, 2003AS Admin.
Utility tools : PUTTY, F-Secure,IBM OPTIM
Storage Technology : ASM, 10g RAC,

• An astute Oracle DBA with around 8 years IT experience in Oracle products, both production and development environments spanning several industries: health care, financials and high- tech .
• Extensive knowledge on database administration for Oracle 8i, 9i,10g,&11g with experience within very large scale database environment .
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$ and DBA views.
• Extensive knowledge of STANDBY creation and maintenance.
• 2.5 years of RAC (9i,10g&11g) with proficiency in setting up and administering 9i,10g&11g RAC.
• Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Implementing Oracle GOLDENGATE
• Expert in the Golden Gate setup,extract,pumping and replication processes
• Expert in handling the Golden Gate replication issues
• Expertise in supporting client server GUI software and Operating system.
• Extensive knowledge in Dataguard, Grid control, streams, replication.
• Experience in a variety of hardware and software platforms including; MS-Windows 2000, 2003, UNIX/Linux, Sun Solaris, HP-UX & AIX
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like Statspack, Tkpfof, Explain plan, Analyze AWR and ADDM
• Performance tuning and diagnosing DBMS and individual database.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
• Expertise in Oracle Enterprise Manager (OEM), Grid Control.
• Extensive knowledge on database backup/recovery strategy (RMAN), VERITAS Net Backup, Import/Export & Datapump, Replication (Streams) standby databases using Netapp filer/Snap Mirror, Oracle configuration management, Dataguard, database cloning, refresh and patch management.
• Good at co-ordinating , communicating with system administrators, business data analysts and development teams.

• Oracle certified Associate
• Cisco Certified Network Associate

Confidential,
Waltham, MA Nov 2008-Till Date
Role: Sr Oracle Database Administrator

• 24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation and Configurations of Oracle 9i, 10g, and 11g RAC on Linux.
• Working With Automatic Storage Management (ASM) ENVIRONMENTS.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tuning using stats pack and explain plan, tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation ,Configuration and Maintenance of Stand by database
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading from Oracle development and production databases 9i to 10g & 11g.
• Applied patches to Oracle Databases.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implementing Hot, Cold and Logical backup plans.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform all other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Active participation in Production maintenance

Environment: Linux 4.0, Windows 2003, Streams,GOLDENGATE ASM, Oracle 11g/10g/9i RAC, My SQL, SQL*Plus, Grid Control, TOAD.

Confidential, PA Jan 2007-Nov2008
Role: Sr Oracle Database Administrator
Description: Vanguard is one of the world\'s largest investment management companies, serving individual investors, institutions, employer-sponsored retirement plans, and financial professionals.Vanguard is internationally known for exceptional client service and the highest-value products in the industry

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Have worked as a team lead in a team of 7 DBA’s and have done performance evaluation for team members and coordinating meetings and provide solutions to mission critical relational databases.
• Installation and Configurations of Oracle 10g and 9i RAC on Linux.
• Migration Oracle databases from windows to linux.
• Database patching using opatch.pl perl script.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tunning using statspack and explain plan,tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation ,Configuration and Maintenance of Stand by database
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 10g.
• Applied patches to Oracle Databases .
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment : Linux 4.0, Windows 2003, Streams, ASM, Oracle 10g/9i RAC, SQL*Plus, Grid Control, TOAD 9.4, IBM RSA.

Confidential,Minnesota Feb 2006- Dec 2006
Role: Oracle Database Administrator

Description: Target is one of the leading and preferred shopping destinations with wide diversity and delivery outstanding value. Target is an upscale discounter that provides high-quality, on-trend merchandise at attractive prices in clean, spacious and guest-friendly stores Target establishes itself as one of the most visited retial in the world.
Responsibilities:

• 24x7 Production Database Administration and support
• The work involves overall maintenance of Oracle database, performance, tuning, backup, recoveries and other database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviours
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database
• Handling day-to-day activities.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles
• Space management
• 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.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment : Oracle 9i,Sun Solaris, HP-Unix, UNIX, Linux 4.0.,RMAN, DBCA, DataGuard, EXPLAIN PLAN Clonig,OEM,STATSPACK, TKPROF

Confidential,Jun 2005- Jan 2006
Oracle Database Administrator

LiquidHub is a global technology consultancy focused on partnering with clients in solving their unique business challenges and transforming their organizations.
Their consultants are focused primarily in the healthcare, financial services and insurance industries. They have also done work in the retail and government markets.

Responsibilities:

• Setup new database servers including the following tasks: Evaluated the database server hardware, designed table space layout based on Optimal Flexible architecture, installed Oracle, created Oracle database, configured the Net8 on different nodes.
• Monitoring Alert Log Report and system Error Logs.
• Performing backup and recovery procedures
• Resolving Hardware and Network problems. Providing Support solutions to a site consisting of nearly 60 users. The work involves planning, designing and implementing of LAN connectivity.

Environment: Oracle8i/9i/10g,UNIX,Linux4.0.,RMAN,DBCA,DataGuard,OEM,STATSPACK, TKPROF, EXPLAIN PLAN

Client: __Confidential,
Hyderabad, India Jan 2004-Jun 2005
Jr Oracle Database Administrator
Responsibilities:

• Installation, Implementation and maintenance the Oracle database
• Created and managing the database objects such as tables, indexes and views
• Create the users and roles
• 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: Oracle8i/9i/10g,UNIX,Linux4.0.,RMAN,DBCA,DataGuard,OEM,STATSPACK, TKPROF, EXPLAIN PLAN