Professional Summary

• 7+ years of experience as Oracle DBA in various platforms like WINNT 4.0 / 2000/ 2003, SUN SOLARIS 8/9 , HP UNIX 11 , Red Hat Enterprise Linux 3.x/4.x and IBM AIX 4.3.3/5.2/5.3.
• Strong knowledgeonOracle 9i, 10g & 11g Database Concepts, RAC, Backup recovery.
• Worked on Oracle RAC, Data guard and Replicated databases.
• Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 9i ,10gand 11g databases.
• Experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 11g/10g/9i.
• Participated in Data migrations which include migrating the source from flat file to the Oracle Database using SQL*Loader (control files), expertise in Datapump, moving over link, RMAN duplicate, and transportable tablespace.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script development and documentation.
• Well versed withOne way schema replication using Oracle GOLDEN GATE
• Extensively used Oracle DATA PUMPand Transportable tablespaces for migration of data between Database servers.
• Performed backups using Cold, Hot backups and RMAN and also tested various crash recovery procedures.
• Experience with Oracle 10g features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Hands-on experience in high-performance SQL query tuning on very large databases.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Extensive expertise in I/O tuning, Capacity planning, space management, Memory Tuning, Performance Tuning, Backup and Recovery, Optimization, script development, and documentation
• Upgraded Databases from 9i to 10g and 10g to 11g using dbua utility.
• Applied patches to databases using OPATCH utility.
• Planned and implemented disaster recovery for physical standby database.
• Managed team of Oracle DBAs and implemented new process as and when required.
• Proven ability of providing production support for 24X7 on multiple databases.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs,Scheduled Tasks (Windows).
• Good understanding of Oracle support models, very good team player with exposure of team management.
• Knowledge of database technology TimesTen
• Experienced in using 11g features like DatabaseReplay, Partitioning, LogMiner, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.
• Good knowledge on data guard physical standby databases, working knowledge on Oracle streams BCV'S, SRDF, and managing of partitions and clustering of tables.
• Experience with VERITAS NETBACKUP, HP Data Protector & IBM TSM.
• Expertise on Cold/Hot/Logical/RMAN backup and recovery strategies and implemented automation scripts for RMAN full/incremental backups.
• Installed, configured and maintained ASM enabled 11g RAC and Migrated single instance databases toRAC environment.
• Installed, configured and maintained 11gR2 RAC with Grid Infrastructure.
• Installed and configured 3 node RAC on 10g Database with ASM.
• Upgraded 10g RAC databases to 11g.
• Familiar with set up and operation of Golden Gate between different Oracle RAC versions and character sets on AIX systems
• implemented fine-grained replication using oracle streams
• Installed, configured and supported Golden gate version 9.5 and 10.
• Installed and configured Golden Gate and Performs GoldenGate replication monitoring, tuning, and capacity planning.
• Experienced in installation and managing Grid Control, Handling alarms inGridControlbased on DB server performance thresholds.
• Working experience with SQL, Toad, OEM Grid control & other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger, partition tables etc
• Strong Technical background with excellent problem solving skills.
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.

RDBMS : Oracle 11g/10g/9i with DBA experience.
Operating systems : Unix ,Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional), RedHat Linux RHEL 3, RHEL 4, RHEL 5, Solaris10,9,8, AIX 4.3, AIX 5.3
DBA tools : SQL Navigator, SQL*Loader, Sql *Plus,10g OEM, Grid
Control, RMAN, DBCA, DBUA, 10g Data Pump, Toad, Data
Guard, Export / Import, TKPROF, Statspack.Languages
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.
Utility tools : PUTTY, F-Secure
Storage Technology : ASM
Languages :C, C++,SQL, PL/SQL, Unix Shell Scripting

• Bachelor of Technology in Computer science

Having More than 7+ years of Experience in the Oracle Database related projects as a DBA and currently working with Multiplan Inc.

Confidential, Waltham, MA 2. First National Bank, Omaha,NE
Role Played : Oracle DBA Role Played : Oracle DBA
Experience : April 2010 to till date Experience : Feb 2009 - Mar 2010

Confidential, NJ 4. Netcore Solutions Pvt. Ltd
Role Played : Oracle DBA Role Played : Oracle DBA
Experience : Aug 2007 - Jan 2009 Experience : Feb 2006 - May 2007

Confidential,
Role Played : Oracle DBA
Experience : May 2004 - Dec 2005

Work Experience

Client : Confidential, Waltham, MA

Duration : April 2010 - Till date
Role : Oracle DBA.
Project Type : Maintenance / Support and configuration

Responsible for:

• Managing more than 120 production, test and development instances in 24*7 environment.
• Administering ORACLE Databases 10g (10.2.0.4), 11g (11.1.0.7) with over 5 TB in size.
• Involved in Installation of 11gR2 with ASM, Grid Control and Database upgrade from Oracle 9i to Oracle 11gR2 and applied patches as required.
• Setup of High Availability of the database using ASM enabled RAC for 10g/11gR2.
• Involved in 24x7 on-call support for 800GB 2 Node Production RAC database.
• Golden gate has been implemented and expertised.
• Migrated and Replicated the production to the Reporting database through Golden gate.
• Performed unidirectional replication from source to target Database using golden gate.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Configured Data guard in maximum availability mode.
• Implemented Flashback Recovery for Oracle 11g Databases which helped in the recovery of the data in the systems several times.
• Configured RMAN for backups and implemented backup strategies
• Upgraded RMAN RECOVERY catalog database
• Currently working / Testing on RMAN VTL backups
• Scheduling scripts using crontab
• Implemented Shell scripts to send automated alerts on status of standby
• Migrated data using export and import utilities.
• Migrated data from Oracle 10g to 11g using Datapump Export and Import.
• Instrumental in finding the sessions causing high memory SWAP issues.
• Resolved Latch Contention Issues
• Session monitoring included identifying Long Idle sessions and High Active sessions, High CPU consuming sessions, long running sessions, blocking sessions and resolving them without effecting the performance.
• Generating ADDM reports for tuning
• Experience in query tuning using OEM, EXPLAIN PLAN, ANALYZE, DBMS_STAT, TKPROF and so on
• Performance tuning, troubleshooting & monitoring using ADDM and Automatic Workload Repository Advisor in Oracle and SQL Profiler in SQL Server for very large OLTP databases (VLDB'S).
• Close watch on Plan flips, session waits, segment growth patterns.
• Performed Application tuning (Blocking Sessions)and sql tuning
• Preventive Maintenance included gathering statistics, recompiling invalid objects, rotating log files, rebuilding indexes, purging and archiving data.
• Exports and Imports using traditional exp/imp utilities and DATA PUMP
• Participated in Disaster Recovery Drills using Dataguard, Experienced in setup and managing Active data guard configuration using DGMGRL.
• Fixing the Archive log shipping in DATAGUARD
• Transportable tablespaces for moving schema across the database
• Involved in Quarterly maintenance
• ONS-RAC configuration for more effective load balancing
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs,Scheduled Tasks (Windows).
• ASM Implementation

Environment: Oracle 10g, 11g, RAC, RMAN, Red Hat Linux, Unix, Solaris 9, 10, Database Grid Control, Windows 2003, HP-UX, Dataguard, TOAD, VERITAS NetBackup, Sun25k, Sun 10k

Role : Oracle DBA
Project Type : Installation / Maintenance / Support and configuration

Responsible for:

• Involved in administration of over 150 Oracle Instances.
• Testing Disaster Recovery solutions using RMAN hot backup & Dataguard.
• 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.
• Linux shell scripting for monitoring Oracle database status, security & backups.
• Shell scripting & SQL scripting for refresh of Oracle 9i & 10g test databases using hot backups.
• Implemented scripts for space, database and concurrent managers alerts.
• Generated ADDM reports for tuning the database
• Very instrumental in fixing latch contention issues
• Sql tuning and suggested the development team with better coding techniques
• Tuning the sessions causing high waits
• Created new schemas and objects for custom applications
• Restored database from backups when required
• Prepared the backup strategy for the Oracle APPS Instances and Implemented Backup scripts.
• Fixed database, user and applications problem.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Complied invalid objects after instillation of application and patch
• Gather statistics of the database objects
• Estimation and Planning future storage requirements for the database / Application system
• Session monitoring included identifying Long Idle sessions and High Active sessions, High CPU consuming sessions, long running sessions, blocking sessions and resolving them without effecting the performance.
• Exports and Imports using traditional exp/imp utilities and DATA PUMP
• Participating in team lead meeting, weekend plan meeting and process meetings
• Performance stats generation and administering various issues using the OAM
• Cloning of oracle database and application environments from production to TEST, DEVELOPMENT, instances.
• Configured Data guard in maximum availability mode
• Fixing the Archive log shipping in DATAGUARD

Environment:Oracle 10g/11gR1 with RAC, ASM, Oracle 9i, TOAD, HP-UX 11i, AIX, Linux, RMAN, OEM, Grid Control, Windows NT/2000.

Client : Confidential, Hightstown,NJ.
Duration: Aug 2007 - Jan 2009
Role : Oracle DBA.
Project Type : upgradation and reactive monitoring

Responsible for:

• Provided 24X7 support for all the production and development databases .
• Installed and configured Oracle 10g.
• Performed upgrades from Oracle 9i to 10g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning.
• Implemented scripts for space, database and concurrent managers alerts.
• Session monitoring included identifying Long Idle sessions and High Active sessions, High CPU consuming sessions, long running sessions, blocking sessions and resolving them without effecting the performance.
• Generating ADDM reports for tuning
• Performed Application tuning and sql tuning
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Suggested better indexing strategy to development team
• Scheduling scripts using crontab
• Preventive Maintenance included gathering statistics, recompiling invalid objects, rotating log files, rebuilding indexes, purging concurrent requests, purging workflow history, purging and archiving data.
• Exports and Imports using traditional exp/imp utilities and DATA PUMP
• Configured Data guard in maximum availability mode
• Fixing the Archive log shipping in DATAGUARD.
• Involved in few recovery scenarios

Environnement: Linux As4.0 64 bit and 32 bit, Oracle 9i, 10g RAC

Client : Confidential, INDIA.
Duration : Feb 2006 - May 2007
Role : Oracle DBA.

Responsible for:

• Oracle STREAMS bi-directional table replication implementation in HUB and SPOKE Architecture
• Implemented scripts for space, database and concurrent managers alerts
• Instrumental in finding the sessions causing high memory SWAP issues .
• Session monitoring included identifying Long Idle sessions and High Active sessions, High CPU consuming sessions, long running sessions, blocking sessions and resolving them without effecting the performance.
• Generating ADDM reports for tuning
• Performed Application tuning and sql tuning
• Suggested better indexing strategy to development team
• Scheduling scripts using crontab
• Preventive Maintenance included gathering statistics, recompiling invalid objects, rotating log files, rebuilding indexes, purging concurrent requests, purging workflow history, purging and archiving data.
• Exports and Imports using traditional exp/imp utilities and DATA PUMP
• Configured Data guard in maximum availability mode
• Fixing the Archive log shipping in DATAGUARD
• Oracle DATA PUMP and Transportable tablespaces
• Involved in few recovery scenarios

Environment: Oracle 8i, 9i, SQL, PL/SQL, Win NT/Unix, Sun-Solaris, PVCS, TOAD

Client : Confidential, Hyderabad, India
Duration :May 2004 - Dec 2005
Role : Oracle Developer/DBA
Project Type : Migration, support and Maintenance

Responsible for:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• 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.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to ensure the SOX standards were not voilated.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle Server 9i/8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting