SUMMARY:

• Over 12 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation. 
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g RAC, 11g RAC on RHEL, Solaris, IBM AIX, HP - UX, Oracle Enterprise Linux, Windows environment and migration of oracle server from 8i to 9i, 9i to 10g and 10g to 11g applied oracle patches.
• Performed database tuning by using various tools such as ADDM (Automatic Database Diagnostic Monitor) from AWR (Automatic Workload Repository), OEM (Oracle Enterprise Manager) and STATSPACK .
• Performed SQL Tuning using Explain Plan , TKPROF with SQL trace and STA (SQL Tuning Advisor).Coordinated with System administrators, application developers and other DBAs.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Installed Oracle 10g,11g RAC software with ASM & ACFS File systems
• Expertise in Installation, maintenance, administration, backup and recovery of RAC Databases.
• Experience in configuring Standby Databases / Data Guard.
• Experience in basic and advanced replication using Shareplex, Oracle Streams & Golden Gate
• Having hands-on experience on implementing, upgrading and configuring the Golden Gate software for Oracle Database.
• Experienced in using 11g features Datapump, Flash-Back Recovery, AWR, ADDM, and Grid Monitoring.
• Performed backups and tested recoveries using conventional cold, hot & RMAN.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Proficient in Database Administration activities such as Upgrading, Patching, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning.
• 24*7 production database support with Support to developers & end-users.
• Have experience in setting up SQL Server 2005, and have done backup, recovery and performance tuning.
• Proficient in SQL, PL/SQL such as Triggers and Stored Procedures.
• Management of schemas, objects, Partitioning the tables and indexes to enhance the Performance.
• Installation and Configuration of Oracle Grid Control.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Experience in Database Security and Auditing.
• Used the standby database for doing different operations like taking backups, recoveries, collecting statistics and running various reports without touching the production database
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Worked on different types of storage structures (SAN/NAS).
• Replicating the data using the Materialized views, making them fast or complete refresh and scheduling the jobs. Monitoring the jobs.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Experience in Upgrading and Oracle database migration of Oracle 10gR2 from Solaris 5 to windows server 2003,Solaris 5 to Linux, higher version and other platforms using Oracle Database Upgrade Assistant (DBUA), Database Migration Assistant (DBMA) and (TTS) Transportable Tablespace
• Performed Data Migrations using Data Pump and Transportable Tablespaces.
• Installed Oracle Clusterware and Oracle Database Software on RHEL AS 4.
• Experience in supporting DC migration projects.

TECHNICAL SKILLS:

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

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

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

SOFTWARE / APPLICATIONS/ TOOLS: ORACLE 7.x/8.x/9i/10g/11g,OAS 10g Recovery Manager (RMAN), Data Pump, Real Applications Cluster (RAC), STATSPACK, Veritas Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5/ 9.7.2, Oracle Enterprise Manager, Linux on NFS,ACFS

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Sr. ORACLE DBA

Confidential, Dallas, TX

Responsibilities:

• Experience on Oracle Database Administration in variety of environments like HP UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Installed, Upgraded and configured various Oracle software packages, troubleshooting and development tasks on various platforms. 
• Hands on experience in test, production and development databases. 
• Proficient in database design for Data warehouse systems (OLTP and OLAP) 
• Extensive experience in Backup and Recovery of Databases on Oracle 9i, 10g, 11g. 
• Expertise in supporting client server GUI software and Operating system. 
• Created development, testing, staging, production, RAC and standby databases. 
• Extensive experience in Dataguard, Grid control. 
• Installing and configured agents on various production servers. 
• Installation and Configuration: Operating System, Grid Infrastructure (Clusterware, ASM, Disk Groups), Private
• Network for Interconnect and Public Network (VIP, SCAN), Shared Storage, Secured Shell, OCR and Voting Disk, Cluster verify utility (cluvfy) 
• Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS File systems. 
• Hands on experience in Installation of high availability RAC environment (2 node clusters) and upgraded standalone databases to 10g RAC environment. 
• Migrated existing databases into RAC configuration. 
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning. 
• Experience in data loading utilities like SQL*LOADER, Logical backups using full export, import and DATA PUMP. 
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATA GUARD. 
• Experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. 
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery. 
• Disaster recovery using Standby database or Data Guard. 
• Expertise in maintaining Database Security using security compliance auditing. 
• Database replication using snapshots, materialized views and advanced replication methods. 
• Experience in implementation of Golden Gate features to extract and replicate the data between various topologies. 
• Experience in applying security patches to the databases. 
• Effective troubleshooting of database and Performance problems. 
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNS Names, V$ and DBA views. 
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures. 
• Environment: Oracle 9i/10g/11g/12c, RAC, Datagaurd, RMAN, ASM, Grid Control, Exadata,golden gate, HP-UX PA RISC/IA, Linux AS (RHEL) 4.x,AIX 5.1,6.1 and Windows server, Toad

Sr. ORACLE DBA

Confidential, Champaign, IL

Responsibilities:

• Installed Oracle 10g and 11gR1, 11gR2 RAC database on HP-UX 11.0, Redhat4,IBM AIX 5.1,5.2,6.1
• Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases with in the maintenance window.
• Installed RAC on Oracle 10g, 11g and worked on ASM feature of Oracle on IBM AIX 5.1,6.1. Worked on the ACFS file system and scheduled backup using RMAN on ACFS file system sharing between the nodes
• Maintained a 2-node RAC environment on LINUX AS 4.0(RHEL) for the staging purpose to support the business requirements and provide High Availability.
• Upgraded the databases from 10g to 11gR2. Installed golden gate and configured extract,replicat.
• Installed and configured veridata for monitoring the replication during the time of replication
• Configuring golden gate high availability for the RAC nodes using oracle services
• Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases Confidential one time, biggest database around 30 TBytes
• Responsible for Database Backup and Recovery, daily monitoring of database & network issues
• Deployed Grid Control to monitor and manage all the databases on clients
• Re-designed the database applications to fix the performance issues and faults
• Worked on the Load Balancing issues on the Server side by creating the services.
• Worked on fixing the listener issues by creating the Hard dependencies
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Experience in Data Modelling concepts like Data Vault and also in Advance security like DB Auditing, Labeling.
• Data loads using SQL*Loader and used export/import for backing certain tables
• Ministering the databases using Grid Control including but not limited to Space Management, Performance Tuning, and Workload Analysis (AWR, ADDM)
• Involved in setting up disaster recovery sites using Data Guard technology. Configuring the Physical Standby, active data guard and snapshot standby database
• Created and managed the RAC clustered databases on Solaris and HP-UX used ASM
• Worked on building 2 Node RAC on ACFS file system on AIX 6.1, Using BBDA tool and by manuall installation procedure.
• Upgraded Grid and Databases from 11.2.0.2 to 11.2.0.3. By creating a new home of 11.2.0.3 and relinking it

Environment: Oracle 9i/10g/11g, RAC, Datagaurd, Streams, RMAN, ASM, Grid Control, golden gate, Solaris 5.10, Linux AS (RHEL) 4.x,AIX 5.1,6.1 and Windows server 2003,SAN(Storage Area Network),Toad, SQL Server 2005

Sr. ORACLE DBA

Confidential, Milwaukee, WI

Responsibilities:

• Responsible for RAC 10g/11g database, client installation Software for 9i, 10g and 11g Enterprise Edition.
• Resolving performance issues using Oracle utilities including EXPLAIN PLAN, TKPROF, SQL Trace and AWR/STATSPACK
• Analyzed & Fine-tuned the Oracle performance Confidential regular intervals monitoring the Log files & Trace files
• Gathering statistics of data objects using Analyze and DBMS STATS
• Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
• Created development, testing, staging, production for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Devised, developed and implemented RMAN backup and recovery strategy using IBM Tivoli tape devices.
• Migrated and upgraded Oracle database from 10g to 11g and applied database one-off and security patches.
• Monitored database and application, tuned SQL queries, indexes, Oracle initialization parameters, and clustered application servers.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• 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 optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics, Statspack etc.
• Configured Physical standby for high availability and for disaster recovery (Data Guard)
• Planned and performed daily, weekly and monthly backups; tested and implemented restore procedures (DR Tests) for complete and incomplete recovery using RMAN.
• Database performance monitoring, application performance monitoring, database tuning and application with efficient database parameters.
• Capture, Propagation, Apply using Golden Gate and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Automated the replication process using materialized views for reporting databases.
• Applied patches to 10.2.0.1 to 10.2.0.4 and also for 9.2.0.6 to 9.2.0.8 and Performed RAC installation.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced Queues feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Replicating the data using the Materialized views, making them fast or complete refresh and scheduling the jobs. Monitoring the jobs in Data warehousing environment.
• Working with Oracle Support to fix the production issues and also to get the merge patches.
• Environment: Oracle 9i/10g,11g, HP-UNIX PA RISC/IA, Solaris 9, IBM-AIX, DBCA, OEM, STATSPACK, GRID Control

Oracle DBA

Confidential

Responsibilities:

• Responsible for installation of Oracle version 10g, 9i and 8i databases.
• Specified appropriate storage specifications for indexes, tables and tablespaces partitioning.
• Upgraded oracle 9i databases to oracle 10g.
• Volume sized production database with over 10 terabyte (TB) of data. Specified I/O distribution using a capacity plan model and measured throughput.
• Setup backup and recovery procedures using RMAN.
• Implement effective database security practices and procedures.
• Worked extensively on Space management, database sizing and capacity planning, Database Backup and Restore.
• Designed Index organized Tables to manage Space Conservation and performance benefits.
• Import and Export of schema, Creation of Test and Production Database, Batch Processing through PL/SQL.
• Monitor and tune SQL scripts, upgraded scripts for production database.
• Responsible for implementing policies and procedures to ensure the integrity, security, availability, and accessibility of company databases.
• Used PL/SQL extensively for data integrity testing.
• User and security management
• Provided technical/user documentation and training.
• Provided on-call support.
• Setup of physical standby databases and check any delay of archive logfiles.

Environment: Oracle 9i, 8i, PL/SQL, Toad, RMAN, Microsoft Windows NT (4.0, 2000, XP, 95, 98), Solaris, HP-UX, AIX, Shell Scripting