SUMMARY

• Over 10 years of IT experience as Senior Oracle Database Administration and Developer Ver. 11G/10G/9i/8i on a variety of UNIX (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 8.0.5, 8i, 9i, 10g,11g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus etc.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g, 11g applied oracle patches.
• Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
• Worked on different technological Platforms, Golden Gate, RAC, ASM, configured Data Guard for Standby Database, GRID Control.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader, EMC Clone, RMAN.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• 24*7 production database support with Support to developers & end-users.
• Have implemented ORACLE STREAMS, and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC).
• Involved in Configuring and managing the listener files and setting up of multiple listeners using MTS.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability working with Oracle 9i and 10g partitioned tables.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Excellent Communications and Presentation skills

TECHNICAL SKILLS

OS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP

RDBMS: Oracle 11g/10g/9i/8.x/7.x, Oracle 10g Real Application Clusters (RAC)SQLServer2005.Oracle Streams

LANGUAGES: SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting.

TOOLS: ORACLE 8.x/9i/10i/10g, Recovery Manager (RMAN), Real Applications Cluster (RAC)EBS, STATSPACK, ERWIN 6.0/4.7, Teradata, Clusters, VERITAS Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential, Rahway, New Jersey

Sr.Oracle DBA

Responsibilities:

• Managed and provided production Oracle Database instances.
• Managing Oracle Argus pharmacovigilance systems for comprehensive drug safety.
• Involved with installation and maintenance of ORACLE 10g/11g RAC, ASM Database for high availability.
• 10g/11g RAC Design/Installation/Configuration/Support: Design/Install 3 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Performed Backup and Recovery using manual and RMAN and written shell scripts for scheduled online backups.
• Managing HA RAC services.
• Adding Deleting RAC instances on clusters
• Administration of RAC clusters and ASM Disk groups.
• Applied patches for both Applications and Database using ADPATCH and Opatch and extensive experience in using AD Tools like adadmin, adctrl AND ADSPLICE.
• Have done Creation and deletion of RAC Database up to 4 node RAC Databases.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non RAC Databases.
• Installing and upgrading OCFS Cluster, RAC cluster ware, ASM software and oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Managing ASM for RAC Databases.
• Configured Oracle 10g/11g oracle database for GRID performance monitoring and availability
• Installation and configuration of VERITAS Netbackup for Oracle and MS-SQL Databases.
• Administration of ONAMES and OID Databases.
• Experience in 10g Grid Control for managing the high availability databases.
• Extensive production experience supporting a clustering environment (Life Keeper or VERITAS) and replication (GGS or Share Plax).
• Determine your most critical instance alarms from Quest-fog light and immediately take action to resolve performance issues.
• Cloning/ Data Refresh from production to setup test and development environments.

Environment: Sun OS 8.0/9.0/10.0 , AIX 5.3/6.1, Linux, Windows NT/2000/2003, Oracle 9i/10g/11g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL*Loader, Guardium, CTRL-M, Autosys, DGMGRL

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Install and configured the agents for the databases.
• Performing and troubleshooting backup and recovery.
• Tuning the database and the sql's for the quick output to the users.
• Administering the database for the better space utilization, database security.
• Interacting with the clients to better understand their needs.

Confidential, Columbus, OH

Senior Oracle DBA

Responsibilities:

• Installed different versions of oracle for implementation work of re-hosting applications as well as new applications.
• Created databases for new as well as re-hosting applications on AIX, LINUX servers.
• Worked on re-hosting existing legacy databases to new AIX, LINUX servers.
• Installation and configuration of 2 node RAC with ASM.
• Implemented and enable database auditing before go-live for database audit.
• Configured database backups using Control-M/ Autosys and Net Backup, tested and Scheduled database backups using RMAN and other database jobs.
• Executed data conversion scripts for legacy database conversion and upgraded the databases as per business requirement.
• Performed database tuning using AWR, ADDM, TKPROF, Enterprise Manager and TOAD
• Performed database recovery using User-Managed, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery.
• Supporting various RAC databases.
• Worked with development team for resolving various performance issues.
• Supported various applications until and after go-live activity.
• Worked on database migrations, upgradations and applying PSU and interim patches.
• Documented application support procedures for PROD. DB's and worked in a highly critical environment.
• Activated change control tickets for various production applications within the group.
• Configured and managed physical standby database using dgmgrl, active dataguard for disaster recovery on a different production databases.
• Performed data guard switchover/failover with dgmgrl as per the business requirements.
• Worked with Oracle Support for resolving various database errors and issues.
• Provided 24x7 on call production support.
• Extensively worked in tuning ad-hoc SQL queries with both OLTP and data warehouse databases.
• Resolved incident tickets regarding various issues with production databases.
• Documented various implementation procedures for future needs and shared within the team.
• Analysis of alert log for error tracing and resolving the oracle errors.
• Modified existing UNIX backup shell scripts as per the environment.
• Installed and configured OEM Agents on multiple servers and implemented standard monitoring and alerting procedures.
• Worked with the development team for deploying application code patches and builds during implementation work.
• Worked with system administrators for various OS level administrative tasks.

Environment: Sun OS 8.0/9.0/10.0 , AIX 5.3/6.1, Linux, Windows NT/2000/2003, Oracle 9i/10g/11g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, Tivoli, SQL*Loader, Guardium, CTRL-M, Autosys, DGMGRL, DBVerify

Confidential, NYC, New York

Oracle DBA/ Application DBA consultant

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• 10g RAC Design/Installation/Configuration/Support.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Creation of Database, Tablespaces and Schemas.
• Managing data security and user access.
• Manage TAR's and Production Support.
• Manage large partitioned databases on Windows 2000 for MS SQL Server.
• Upgrading MS SQL Database .
• Database migration from MS SQL to Oracle and Oracle to MS SQL Server.
• Oracle replication solution from Shareplex and Replicate critical data and applications for high availability.
• Designing Logical and Physical Layout of the databases.
• Evaluate the database replication strategy using Streams.
• Implementation of replication strategy in PoC environment using Oracle Streams.
• Implementation of Oracle Advanced replication environment and mechanism.
• Patch application working with AD utilities- ad patch, adadmin, admerge, adctrl, adclone.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Rebuild index for better performance.
• Coordinated with Oracle for technical issues.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Managing Flex clones with Netapp for test databases.
• Monitoring Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC database for high availability.
• Determining the Oracle10g RAC architecture.
• Responsible for Database Replication.
• Performance tuning for Oracle Real ApplicationClusters (RAC)

Environment: Oracle 9i/10G on AIX/Sun Solaris/Linux/Windows

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Managing more that 300+ Oracle & Sql Server databases which are running on all flavors of Unix and Windows. Oracle database versions to support are from old 7.3.4 to the latest 10g.
• Activities involved on these databases were Installation of Oracle, Sql Server Software, Configuring of databases, upgrading the database to a higher version, Patching etc.
• Planned the Backup & Recovery procedures. Changed the setup of RMAN backup processes which were initially going to tape to disk. Restored and cloned the database as and when needed by the application team.
• Solely applied the latest CPU patch to more than 300+ databases across the entire region in US.
• Installed and administer Oracle 10g node RAC on linux to distribute the load balance of a database.
• ASM was used for storage management for key databases.
• Implemented and managed the Oracle Grid management (OEM) to monitor the databases and other targets.
• Supported the Data Guard environment, implemented the physical standby database on 10g.
• Tuned and optimized performance of the database, sql queries by getting a request from the application owner or by analyzing the AWR report.
• Administer and managed SQL Server 2005 & 2008 databases w.r.t database creation, user and role creation and security, backup & recovery.
• Handling of all the escalation issues which could not be supported by Level 1 & 2.
• Part of the On Call team, to support the system during the off hours.
• Part of the data center migration and SAN migration team.
• HP OVO is used to track and monitor the ticket.
• Coordinating with the offshore team for the request or change assigned to them.

Environment: Oracle 8i/9i/10g, SQL Server on HP-UX, AIX, Linux, Sun OS, Windows

Confidential, Plymouth Meeting, PA

Oracle DBA

Responsibilities:

• Installed, configured, upgraded and maintained the Oracle databases and related software, managed users and maintained security, populated databases.
• Implemented Data Guard for disaster recovery.
• Migrated database from SQL server 2000 to Oracle 10g using Oracle Migration Workbench
• Implemented RMAN for full and incremental backups.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Implemented procedures to detect the poor database performance, collecting required information, root cause analysis, successfully tuned and improved the performance of the database.
• Involved in database administration and continually maintaining the hit ratios of production databases.
• Replicated data using Oracle GoldenGate and import/export.
• Developed shell scripts to monitor the databases, scheduled cron jobs and generated daily reports.
• Developed disk layout, disk striping for better I/O.
• Associated and involved with Sys Admin in RAID configuration and disk striping for optimized database I/O performance.
• Coordinated with end user and Confidential to resolve application and performance issues.
• Administration of IBM Tivoli Storage Manager (TSM) and Tivoli Backup Server
• Advised and supported development and testing teams.
• Assisted data warehouse team in design/development of logical/physical database
• Designed ETL processes.
• Involved in troubleshooting and supporting databases, applications and development tools, generated trace files, debugged and resolved database and listener errors.
• Experienced in tuning SQL statements using Explain Plan, SQL Trace and TKPROF.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g/9i, Windows 2003, 2000, SQL server 2000, Linux 9, IBM AIX, Import/Export, DBArtisan, SQL and PL/SQL, RMAN, Statspack and OEM, OWB, Cognos

Confidential, New York NY

ORACLE DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Intel and HP boxes.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Installation, Upgrade and Configuration of Oracle (8i, 9i, and 10g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 10g and worked on ASM.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings
• Configuration, maintenance and tuning of Oracle 10gRAC.
• Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
• Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Data Modeling, Database Design and Creation using ER-Win.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.
• Oracle replication using streams.
• Partitioning large objects to improve the performance and manageability
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Used Active Dataguard makes a read-only replication of a given database.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager's (OEM's), Oracle cost based optimizer, SQL analyzer, top session, top SQL, Performance Manager, Statspack, TOAD. For SQL tuning using "Explain plan", "TKPROF", "SQL TRACE", Optimizer modes, using Optimizer hints, Gathering statistics, Statspack.
• Create database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database. Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.
• Writing scripts for backup and recovery, Import and export procedure.

Environment: Sun Solaris 8.0/9.0/10.0 , HP-UX 11, Red Hat Linux, Windows 2000/2003, Oracle 9i/10g, Oracle Enterprise Manager, RMAN, ORACLE Warehouse Builder, Reports, 10G, Streams, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008, Toad V9.7 and SQL Navigator V6.1.