Professional Summary:
Over 6 years of experience as Oracle Database Administrator (8i/9i/10g/11g) on different Operating Systems.

• Installation, configuration and administrating Oracle GoldenGate replication between oracle-oralce and oracle-nonoracle.
• Installation, configuration and administrating Oracle RAC databases.
• Expert in Installation and Configuration of oracle /9i/10g/11g databases, Oracle Grid Control and Management of agents on Operating Systems such as UNIX (AIX /SunOS- Solaris / RHEL / HP / AT & T / Linux), Win-NT/2000/XP in production and development databases.
• Experience in working in high availability, 24/7, standby, development, test and production databases as well as Online Transaction Processing (OLTP) and Decision-Support System (DSS) databases.
• Successfully implemented physical and logical standby database using DATAGUARD feature for High availability configuration. Experience in DATAGUARD Broker to centralize the creation, maintenance, and monitoring of Data Guard configurations.
• Experienced in tuning, diagnosing and troubleshooting databases, using V$ views, Data Dictionary views, Statspack, OEM, TKPROF, AWR, ADDM, SQL tuning advisor, and SQL access advisor. Used different type of partitioning for large tables. Good knowledge on database waits events and oracle internals.
• Database backup concepts and options such as User-managed backup, RMAN-managed backup with or without catalog, Operating system backup, Cold and Hot backup, Full backup, Incremental and Cumulative backup
• Extensive knowledge of UNIXshell scripting and automated task scheduling using crontab, written scripts for monitoring mount points, for monitoring alert log errors, for monitoring the tablespace sizes, for checking high enquires.

• Extensively used Oracle Enterprise Manager Grid (OEM) for maintaining and monitoring databases.
• Excellent understanding of Oracle Internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management (ASM) and System Management.
• Knowledge of Oracle Flexible Architecture (OFA) Standards, applying software patches and Version upgrades such as 8.x to Oracle 9.x, Oracle 9.x to Oracle 10.xand Data migration, Listener TNSNAMES configuration.
• Good understanding of 10g Flashback Features.
• Extensively involved in Database Cloning manually as well as using RMAN.
• Experience in using Oracle supplied packages such as DBMS_STATS, ,DBMS_FLASHBACK, DBMS_SCHEDULLER,DBMS_JOBS, and UTL_FILE
• Tuning and diagnosing of database performance by QueryOptimization and tracing facility Monitoring users, free spaces, table spaces and indexes.
• Experience in Data transfer and loads using utilities such as exp/imp, expdp/impdp, SQL * Loader, and External Tables.
• Expert in creating users, granting privileges, and creating roles.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Excellent experience with SQL Server 2000 & 2005 and MS - Access.

Professional Experiences:-

Client: Confidential, Kenosha, WI August 2010- Till Date

Role - Oracle DBA/ Oracle Goldengate
Snapon tools incorporationis a leading global innovator, manufacturer and marketer of tools, equipment, diagnostics, repair information and systems solutions for professional users.
Responsibilities:

• Installation, configuration and administrating Oracle GoldenGate replication between oracle databases. The largest database size was 8TB (terabyte).
• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Part of the team for Oracle database upgrade from 10.2.0.4 to 11.2.0.3.
• Part of the team for databaseupgrade from 10.2.0.2 to 10.2.0.4with logical and physical standby in place.
• Configured and administer Oracle 10g/11g data guard physical and logical standy as for reporting and DR databases.
• Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Used Oracle database migration assistant and export/import to migrate the databases.
• Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• Registered database in recovery catalog & Configured RMAN backups for many databases and subsequently took the RMAN backup.
• Configured databases in OEM 10g grid control for monitoring purposes.
• Performed SQL tuning by using Explain Plan, AWR, ADDM and Tkprof. Had troubleshot the top 5 timed wait events in AWR to tune the database performance.
• Had tuned many problematic sql with Oracle SQL tuning advisor and SQL access advisor
• Automated the database creation scripts through crontab and Windows Control M software.
• Re- org of tables using new segment management feature of 10g and Quest Live-Reorg tool.
• Provided 24X7 supports for production problems
• Supported 40 production databases.
• Worked in a team of 5 Oracle DBA.
• Excellent experience with SQL Server 2000 & 2005 and MS - Access.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) and DTS packages.

Environment:
Oracle 11g/10g/9i, data guard with physical and logical standby databases, Sun Solaris 10 on M5000/M3000, HP servers, Oracle Enterprise Manager, SQL, TOAD, AWR, ASH, ADDM, TPROF, Explain plan, STATSPACK, SQL tuning advisor, SQL access advisor and Oracle GoldenGate replication from oracle to oracle databases.

Client: Confidential, Pittsburgh, PA December 2008- July 2010

Role - Oracle DBA/ Oracle RAC
PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. It provide deposit, lending, cash management and investment services to more than5 million consumer and small business customers across 19 states and the District of Columbia.
Responsibilities:

• Installation, configuration and maintenance of Oracle10gRAC database.
• Converted single instance into multiple instances (RAC).
• Provided 24X7 supports for production problems
• Supported 26 production databases.
• Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Recovery of database in case of database crash, disk/media failure, etc.
• Provided System support for both development and 24/7 production environment.
• Prepared plans for up gradation of all critical Production Databases from 10g to 11g on Linux and DATAGUARD implementation.
• Implemented new features of Oracle 9i like Log Miner, Transportable Tablespaces, Locally Managed Tablespaces, and Hot Standby Databases for fail-over situations, Multiple Archive-Log Destinations that support Hot Standby Databases etc.
• Performed capacity planning and sizing of databases based on input from business.
• Taking care of all alerts for space issues and user requests.
• Created and Managed the Server Parameter file.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) and DTS packages.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries.
• Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.
• Performed database cloning from old system to new system.
• Used EXPORT/IMPORT for table level and full database de-fragmentation.
• Transported tablespaces between production and development databases.
• Running scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Environment: Oracle 11g, 10g, 9i, Server Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0,AIX,HP-UX,Solaris Windows Server 2000, UNIX Shell Scripts, TOAD and TKPROF.

Client: Confidential, Houston, TX April 2007- November 2008
Role - Oracle DBA
CGGVeritas is the world\'s leading international pure-play geophysical company delivering a wide range of technologies, services and equipment through Sercel, to its broad base of customers mainly throughout the global oil and gas industry.
Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g and DATAGURAD /Standby switchover/failover technologies to reduce database downtime using DATAGURAD broker.
• 24 X 7 Production Database Administration, Support and monitoring to ensure proactive problem recognition and resolution of database issues.
• Actively participated in upgrade and Migration of production and development Database from 9.2.0.6 to 10.2.0.2 using DBUA and applied/rolled-back DB patches whenever required.
• Performed daily database administration tasks like user management, web connectivity, space monitoring and management, session traffic, load balancing, checking archive space, apply rate monitoring, performance monitoring and tuning.
• Plan and perform point-in-time recovery of databases as part of disaster recovery implementation.
• Monitor full and incremental backups by using Recovery Manager (RMAN)
• Configured OEM (grid control) 11g,10g for diagnosing and monitoring performance related problems such as buffer get, CPU utilization, top DB wait events and top SQL etc .
• Write SQL/Unix Shell Scripts for gathering capacity planning information, automated AWR/Statspack report collection and compiling estimates based on new client requirements.
• Reviewing DB application patches before applying also advised changes whenever required.
• Monitor logical Backup and Recovery by import & export, Data pump, for databases.
• Troubleshooting, analyzing explain Plan, STATSPACK, ASH, AWR reports and tracing user sessions for performance analysis.
• Working with Oracle Support, raising SR's for different Oracle issues using Oracle METALINK
• Ensuring high availability of Production, Test, and development databases for users to minimize database downtime.
• Performed database restore for test and development database.

Environment: Oracle 11g, Oracle 10g, Oracle 9i, AIX ,HP-UX, Solaris, Windows Server 2000, TRIVOLI storage manager , ASM,NIX Shell Scripts, DBA Support Portal(ticket system), Oracle Metalink ,TOAD, TKPROF, Putty.

Client: Confidential, India April 2006 - March 2007
Role - Oracle DBA/Oracle Developer.
Our core competency is research, artificial intelligence, developing world-class web-based financial software application for the future. Designing 'intelligent corporations\' by way of AI-built applications that are easy to implement, friendly to adopt and smart to learn & support the ever changing world dynamics.
Responsibilities:

• Performed Database Performance Tuning and Monitoring of Databases.
• Design and implement Security Policies.
• Deploying roles, privileges, profiles policies for group of users
• Configuring the Auditing of database at DB or OS level, to monitor illegal use of database
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
• Controlling and monitoring user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet
• Created schemas with partitioned external tables for a production environment, using SQL Plus.
• Involved in extensive design of Sql and shell scripts.
• Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
• Configuring the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
• Administered Oracle 9i and Infrastructure support using Oracle OEM.
• Performed test and implemented upgrade of Oracle 8i databases to latest Oracle version (9.2.0) on UNIX.
• Performed requirement analysis, capacity planning for databases and system infrastructure.
• Created and managed multiple Instances on one server for testing and development.
• Recovered and rebuild databases on crashes and media failures.
• Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
• Used Stored Procedures for performing complex business logic involving database access and for validating information
• Responsible for supporting the database with logical backup as well as cold and hot backups
• Created variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
• Built Databases and refreshed them by executing the scripts.
• Developed shell scripts for day to day database administration activities.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Developed validation procedures and error reporting on the data in the intermediate tables
• Worked on handling exceptions
• Written SQL Loader Scripts for data extraction and transformation
• Created Stored Procedures and functions to be used as a part of development work.

EDUCATION:-
Bachelor in Computer Application (B C A).