PROFESSIONAL SUMMARY

• An astute Oracle DBA with around 9 years IT experience in Oracle products, both production and development environments spanning several industries: Health care, Telecom and high - tech. Hands on experience in administering 24X7 mission critical production environments on UNIX based HA systems with SLA’s of 99.999% availability.
• Expertise in Oracle Database Administration for Oracle 11g, 10g, 9i and 8i with experience in very large scale database environment (VLDB) and mission critical large OLTP and OLAP systems.
• Experience in Real Application Cluster (RAC) administration with Auto Storage Management (ASM) on Oracle 10g & 11g RAC Grid infrastructure and standalone 11g new features.
• Hands on experience with managing ORACLE rdbms on various flavors of UNIX such as Oracle Enterprise Linux 5.5, IBM AIX 5.3 & 6.1, HP-UX 11, Solaris 8/9/10, LINUX SUSE and REDHAT LINUX 5.7
• Experience with SUN ORACLE DATABASE MACHINE (EXADATA) Half Rack / Full Rack with 8 Database Nodes & 14 Storage cell nodes using Infiband Connectivity.
• Experience in managing SUN ORACLE EXADATA FLASH CACHE, GRID DISK, CELL DISK and ILOM.
• Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability and DR configuration.
• Configured and implemented Oracle STREAMS at Table Level Local capture unidirectional for high availability. Exposure to conflict resolution for bi - directional oracle streams replication.
• Experience with Oracle Golden Gate and its components. Performed POC at table and schema level unidirectional homogeneous oracle to oracle rdbms replication.
• Administration and support of Oracle databases together on separate servers using OEM Oracle Grid Control 11g. Installed Oracle Grid control 11g and configured agents on all remote Hosts.
• Extensive experience designing and implementing backup and recovery strategy using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
• Experience with various database Recovery methods like PITR, TSPITR, Export/Import, Datapump and Flashback Technologies.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, Transportable Tablespace (TTS).
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch and runinstaller.
• Troubleshoot Database performance issues and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self developed scripts, Oracle Enterprise Manager, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) engine and Active Session History Reports (ASH).
• Experience with Database SQL tuning and query optimization tools like SQL Tuning Advisor, SQL Profiles, SQL Plan Management, TKPROF, EXPLAIN PLAN, SQL TRACE, UTLBSTAT and UTLESTAT.
• Hands on Experience in Memory / Instance Tuning using Automatic Shared Memory Management (ASSM), 11g Automatic Memory Management (AMM) and V$ advisory Views.
• Manages Locally and Dictionary Managed Tablespaces, Database files, Redo log files, Control files, Spfile, Parameter file, Rollback Segments, Temp segments, Views, Sequences and other database objects.
• Partitioning of large tables using Range, List, Hash, Split, Exchange and Composite partitioning techniques and creation of Indexes on large tables to improve the Performance and Experience in creating SR’s in METALINK, escalating issues to Oracle support and working closely with Oracle support.
• Strong Understanding of Oracle Internals (Memory, Dictionary, Optimizer etc...) and PL/SQL package, function, stored procedure, triggers, Materialized view, to implement business logics of oracle database and to interface application with Database system.
• Experience in full software development life cycle (SDLC) of database administration.
• Extensively worked on SQL*Loader, which loads data from flat files into Database tables, UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading..
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.
• On call Rotation for 24x7 support.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, IBM-AIX 5.1, 5.2, RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/20003.

RDBMS: Oracle 11g,10g/9i/8.x, Sql Server 2000, 2003, 2005, 2008

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting, PERL Scripting

SOFTWARE / APPLICATIONS/ TOOLS: ORACLE 11g,10g,9i,8.x, (RMAN), AWR, ADDM, DBMS STATS,STATSPACK, ERWIN, Clusters, VERITAS Net Backup, SQL Loader, TOAD, SHAREPLEX, PL/SQL DEVELOPER V6.0, SQL DEVELOPER 1.2,OEM, NETCA, DBCA, ASM, SRVCTL, CRSCTL.

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• Provided and Implemented Clustered (RAC) architecture for the Tier-1 Mission critical application and migrated the data from the current standalone 10.2.0.5 production environment to 11.2.0.3 Grid Infrastructure with 10.2.0.5 RDBMS Version.
• Installed and Configured 11.2.0.3 Oracle Clusterware with 10.2.0.5 RDBMS on Solaris version 10 with ASM file system from the scratch.
• Performed de-installing the cluster and re-install after fixing failed root.sh script on other nodes in the cluster due to an issue with the jumbo frames on private interface.
• Reviewed thoroughly and validated Network Requirements to Implement “JUMBO FRAMES” on Private Interface for Node connectivity.
• Experience in using Network utilities to trace the data packets and hops using “tracert”.
• Experience in Managing Clusterware using “CRSCTL” commands, IP Interfaces using “OIFCFG” commands and Database management using “SRVCTL” commands.
• Created Various Disk groups for OCR, Vote Disk, C/R/D Files and archived logs with normal redundancy for High Availability.
• Exposure to pin the nodes in the cluster using “OLSNODES” command for hybrid environment with 10.2.0.5 RDBMS using 11.2.0.3 Grid Infrastructure.
• Experience with Attaching Oracle RAC RDBMS Home to the existing oraInventory using OUI in silent method.
• Performed Cloning RAC database using RMAN to refresh the data from the Production database to the Lower Environment on demand.
• Configured high availability services TAF, load balancing and SCAN features for clustered databases.
• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.
• Performed Various Destruction Testing scenarios to validate RAC cluster stability.
• Created Reports and documented the 11g RAC health Check as well as implemented best practices.
• Installed Physical Standby Database as a part of disaster recovery for RAC production system with Max Performance Mode, LGWR Async and Real Time Apply with ASM file system on Solaris 10.
• Data guard Architecture: 2 Node RAC primaries with ASM file system having non-RAC database as physical standby database with ASM file system on standby site.
• Performed Switchover, Failover, Network Failure Tests and well documented the steps for the customer’s DBA survival guide
• Resolved GAP issues between primary and standby using Manual method by copying the missing archive logs and registering at the standby site.
• Performed RMAN SCN incremental backup to roll forward the standby database to keep in sync with the primary database when there was huge Gap between primary and standby.
• Implemented shell scripts to monitor data guard environment.
• Implemented RMAN incremental backup and performance parameters for the backup to finish fast.
• Created DB console for the customer and implemented monitoring alerts and configuring targets and threshold values.
• Actively participated and communicated with various Business, System Engineer, Network Admin and Sungard storage teams to make this project go live without unexpected issues.
• Completed all the above Tasks within given timelines and conducted knowledge transfer to the client’s DBA team as well as provided documentation for reference as survival guide.

Environment / Tools:Oracle 11g, Oracle 10g, SOLARIS 10, Grid Control (OEM), 11g RAC, 11.2.0.3 Oracle Clusterware, ASM, Grid Infrastructure, RMAN, Export / Import, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, Winscp, Psftp.

Confidential, ATLANTA, GA

Oracle Database Administrator

Responsibilities:

• Provided Primary architectural and administrative support for new projects.
• Experience with business process models for IT support such as ITIL, Change Control and Change Advisory Board (CAB).
• Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live” without any unexpected issues.
• Experience in using various Ticketing systems Remedy, HP, Nexus and Home grown ticketing Applications.
• Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.
• Exposure to SOX, PCI and HIPAA security compliances.
• Provided 24x7 on-call support for production systems during on-call rotation.
• OEL 5.5, X86 64, EMC power path and fiber HBA for SAN/TAN connectivity, Gigabit Ethernet for cluster interconnects, EMC symmetric SAN storage, CRS configuration files on RAW and ASM for database files, 4 node cluster and oracle 11gr2 rdbms version.
• Configured high availability services TAF, load balancing and SCAN features for clustered databases.
• Extensively used SRVCTL, CRSCTL, CLUVFY, OCRCONFIG, ADRCI and ASMCMD control.
• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.
• Hand on experience in installing and managing ASM instance, diskgroups, asm disks, asm rebalancing and asm data dictionary views.
• Design, Development & Implementation of large volume OLTP and large scale Data Warehouse/DSS environments.
• Experience with oracle Golden Gate replication tool and its components.
• Installed and Configured oracle Golden Gate unidirectional table level / schema level between homogenous oracle to oracle rdbms replication.
• Good understanding of Golden Gate components like Extract, Replicat, Trail Files, GGSCI commands, Translog options etc ….
• Performed replication between databases using Materialized Views and DB links from a remote database.
• Experience in handling large database up to 6 TB in size with 4 nodes cluster on various flavors of UNIX.
• Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, asmcmd, Memory parameters, Incidents etc....
• Configured Oracle 11g /10g Physical Standby Database for DR purpose using ORACLE Dataguard.
• Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache, GRID DISK, CELL DISK, ILOM, INFIBAND, PDU & KVM SWITCH.
• Experience in Patching / Upgrading SUN ORACLE EXADATA MACHINE (RDBMS / Grid infrastructure & Storage cells).
• Experience in managing SUN ORACLE EXADATA using command line utilities such as CELLCLI & DCLI.
• Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache using hot blocks.
• Worked closely with oracle support to resolve EXADATA hardware / Flash Disk / Battery Replacement / Storage software issues.
• Experience in recreating Flash Cache after replacing Flash cards as a part of Flash Disk Failure.
• Experiencing in diagnosing EXADATA storage / firmware / Cell and Grid disk issues.
• Hands on experience in patching EXADATA storage cells / RDBMS / GRID infrastructure.
• Implemented 11g Advanced Compression based on the business requirements.
• Implemented Cell offloading on EXADATA to push the sql’s to the storage and thus improving the I/O performance on the queries.
• Hands on experience with storing the hot blocks / hot objects in flash cache in order to achieve performance through memory instead of disk I/O.
• Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience in cloning the GRID infrastructure binaries onto different server.
• Installed 11.1 agents on all remote databases to manage them using OEM grid control.

Environment: Oracle 11g, Oracle 10g, RHEL AS 5, OEL 5, Grid Control (OEM), RAC, Oracle Cluster, Oracle Clusterware, ASM, CRS, Materialized Views, RMAN, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, Winscp, Psftp.

Confidential, PLANO, TX

Oracle Database Administrator

Responsibilities:

• Installed Oracle 11g Database and upgraded database from 10.2.0.4 to 11.1.0.6 on UAT, DEVL, PROD databases.
• Supported Production, DR, UAT and Dev databases of multiple applications with size more than 2 Terabytes.
• Installed, Configured and Administration of 3 node RAC on Linux RHEL AS 4 and Oracle Clusterware (10.2.0.4) with ASM on Oracle 11g and 10g.
• Configured and Administered RAC environment using SRVCTL, ASM and CRSCTL command line utilities.
• Configured Physical Standby database in Maximum Performance Mode for Disaster Recovery using Oracle Dataguard. Successfully implemented switchover and failover roles using DGMGRL.
• Implemented Oracle Streams, replication of databases at Table level Local Capture Uni-Directional for High Availability. Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions and events.
• Installed/configured 10.2.0.5 OEM Grid Control on Linux and configured agents on all remote databases and Upgraded existing grid control environment to 10205 from 10201.
• Manage Administration and Supported Databases using Grid Control.
• REFRESH/CLONINGof Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patch using OPatch and runinstaller.
• Applied Patchset 4 for oracle database 10.2.0.4
• Manually tested UNIX administration options like System Process, Backup logs, swap info, disk usage, Cronjobs menu, system messages, system activities menu, defunct process etc with actual commands.
• Tuning Heavy database loads at O/S level using commands such as top, sar, vmstat and i/o stat.
• Tuning Application sql’s using Explain Plan, SQL Trace and TKPROF.
• Monitoring databases andPerformance tuning using AWR, ADDM engine, ASH and ASSM.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Performed general DBA tasks, such as user privileges, monitor space usage, monitor physical resources (disk space, memory, CPU, etc.) set up database performance alerts, daily error checks, database health and trouble shoot database related issues.
• Monitoring row chaining and row migration.
• Raising TAR/SR with Oracle Support and using Metalink to resolve the bottlenecks and Bugs in the database environment.
• Implement RMAN full and incremental backups to schedule for off working hours for all Production, UAT and Development Databases.
• Defragmented Database segments in Tablespaces by releasing space by Reorganizing application specific objects for large size database.
• Worked extensively on PITR, TSPITR and CLONING databases using RMAN
• Experience working with Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Provided Primary architectural and administrative support for new projects.
• Provide Production DBA support, as needed, on a 24/7 basis.

Environment: Oracle 11g, Oracle 10g, AIX 5.2,5.3, Solaris 8, 10, RHEL AS 4, Grid Control (OEM), RAC, SUN Cluster, Oracle Clusterware, ASM, CRS, Oracle Dataguard, Oracle Streams, Materialized Views, RMAN, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, ERWIN, Winscp, Psftp.

Confidential, FL

Sr. Oracle Database Administrator

Responsibilities:

• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Good knowledge in Oracle 11g new features, having certified 11g on Test and DEVL Databases.
• Involved in performingmigrationfrom Oracle 9i, 10g toOracle 11g Release1 RACdatabase with ASM.
• Configured TAF (Transparent Application Failover) and Server/Client side Load Balancing for RAC environment.
• Added additional instances to the existing two node RAC database on oracle clusterware.
• Migrated single instance 10.2.0.4 database to 11.1.0.5 RAC database on Linux RHEL AS 4.
• Worked Extensively on Cross Platform Database Migration from HP-UX IA 64 bit (Big Endian) to LINUX IA 64 bit (Small Endian) using both Transportable Tablespace as well as Export/Import DATAPUMP utilities.
• Involved in setting upData guardfor High availability and configured Data guard Broker.
• Implement and support the Development (DEVL), Test (QA) located, and the Disaster Recovery (DR) databases.
• Monitoring theStandby Database implemented usingOracle Data Guard and Oracle streams and troubleshooting it if and when required.
• Experience in basic and advanced replication usingOracleStreamsand experience in using OEM, TOAD,and Data Migrations using export/import, benchmarking using load testing tools.
• Performed databaseReplicationfor high availability.
• Monitoring day to day activities, Schedule jobs to run on daily/weekly/monthly basis and generating reports in DWH using Informatica.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Performed Cloning using RMAN.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Applied High priority, security patches downloaded from Metalink.
• Applying PSU Patches 10.2.0.4 and applying Oracle One off Patches on Oracle database.
• Database monitoring and Performance tuning using AWR, ADDM, ASH and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc..
• Improving the performance by Using the Hints, Indexes, Explain Plan, SQL Trace and TKPROF for effective retrievaland processing of queries used for retrieving the data.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Worked on import/export, export /import data pump and SQL- loader.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Database Restore using RMAN, Cold Backup and Export.
• Responsible for Troubleshooting ORA - messages and Block Corruption
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Coding and tuning Stored Procedures, Triggers & Functions using SQL, PL/SQL language.
• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and considers the implications of business solutions to the current and future environment.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle.
• Supported Users and SOX Audit requirements for all Finance and General Ledger Databases.
• Shell scripting, PERL scripting and PL/SQL programming to resolve business problems of various nature.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• On-Call 24x7 DBA support for production databases.

Environment: Sun Solaris 9.0, Linux 4.0, Windows 2003, Windows 2005, HP-UX IA, Oracle Streams, ASM, CRS, Oracle 11g,10g/9i RAC, Putty, Secure CRT, Winscp, Legato, VERITAS Net Backup, Netca, DBCA, SQL*Plus, OEM, TOAD, PL/SQL Developer, ERWIN.

Confidential, PLANO, TX

Oracle Database Administrator

Responsibilities:

• Worked in a Datacenter hosted with 150+ databases on various flavors of UNIX environment.
• Extensively worked on different environments like Production, Development and lab.
• Successfully performed setup and creation of two node cluster (RAC) with 10gR2 database using oracle cluster ware and ASM storage / file system.
• Involved in migration of SPARC database with 15000+ tables from Oracle 9i version on OpenVMS O/S to Oracle 10g RAC with Automatic Storage Management (ASM) on Linux server and oracle clusterware.
• Successfully performed installation, setup and creation of Primary & Standby database using DATA GUARD to deliver no data loss with maximum performance mode.
• Setting up replication between two oracle databases using Shareplex.
• Exposure to replication between heterogeneous RDBMS databases using Transparent Gateway.
• Exceptionally done well in Database upgrade from 9.2.0.8 to 10.2.0.3 for more than 10+ databaseswhichare Dataguard databases and Standalone primary databases.
• Exceptionally done well on applying CPU Security patches released in a quarterly basis to databases on all flavor of UNIX.
• Worked with oracle support to raise SR, report bug and apply patch and for news updates using Metalink.
• Successfully implemented ASM as a database storage, created ASM instance, migrated non-ASM database to use ASM which addedrebalancing.
• Conducting sizing & capacity planning for Oracle databases.
• Extensively used RMAN with catalog and NO catalog for database backup (cold, hot, full, and incremental) & recovery (database point-in-time, tablespace, datafile).
• Taking Backups on scheduled time andMonitoring Scheduled Backups.
• Successfully conducted switchover and failover operation as and when app owner requested.
• Extensively used imp / exp / expdp / impdp utility to load data to & from databases.
• Successfully performed Cloning of development & test databases from production using RMAN and traditional copy method using begin backup / end backup command.
• Extensively worked on Partitioning and also created script to automatically identify & delete the expired daily / weekly / monthly partitions.
• Actively involved in tuning SQL and PL/SQL scripts to improve performance.
• Performance tuning for optimized results using tools like AWR, ADDM, ASH and STATSPACK reports.
• Experience in Identifying performance bottlenecks on high volume transaction systems.Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Installed and configured OEM for monitoring multiple databases.
• Used SQL*Loader to load the external file data into Oracle database
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Support to on-call operation as to make sure databases & applications are up and running 24x7.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i/ 10g, RAC, Sun Cluster, OEM, Grid Control, RMAN, DBCA, Data Guard, Shareplex, Transparent Gateway, Putty, Java, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0, Secure Copy, PL/SQL Developer, VERITAS Net Backup.

Confidential

Oracle Database Administrator (Offshore Support)

Responsibilities:

• Provided excellent offshore support for UHC, MN for all Oracle Databases.
• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 9i on, Sun Solaris and Windows 2003
• Performed replication between homogeneous Oracle Databases using GOLDEN GATE.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup and Export.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Data refresh from production to test and development, maintain Database Security.
• Performed block recovery using RMAN. Performed backup validations using RMAN
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Corporation and installation of patches.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• OLAP on Oracle platform using Oracle Express (OLAP server), Data Migration as part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Environment: Oracle 8i/ 9i, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, Sun Solaris, DBCA, Data Guard, Golden Gate, Transparent Gateway, Putty, Java, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0, PL/SQL Developer, VERITAS Net Backup.