SUMMARY

• Over 8+ years of IT experience as Senior Oracle Database Administrator in Ver. 11G/10G/9i/8i on a variety of UNIX (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003.
• 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 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.
• Documented the Transition of Role from Primary to Standby and vice versa of Dataguard environment.
• Performed Migration of Database into Linux from Windows using RMAN (Convert) and Datapump.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Worked with Siebel, PeopleSoft and Agile Applications.
• 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.
• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader, EMC Clone, RMAN. ed rapid install and other Oracle Application maintenance utilities like OEM, EBS.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
• 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
• Installation and Configuration of Oracle Grid Control.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views and advanced replication methods.
• Worked on different types of storage structures (SAN/NAS).
• Extensive knowledge in reporting tools like Business Objects and crystal reports
• Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

Storage Technologies: OracleASM

Virtualization Technologies: VMware

Backup/Recovery Tools: RMAN, flashback,OracleSecure Backup, Export/Import, Datapump

Development and Administration Tools: Symantec I3, OracleEnterprise Manager Grid Control, TOAD, SQL developer, SQL*Plus,OracleForms and Reports, RMAN

Utilities: SQLLoader, exp/imp, expdp/impdp, and statspack

Replication Technologies: OracleData Guard,Oracle Streams

Operating System: RedHat Linux 4.x and 5.x, UNIX (HP-UX 11.11), Sun Solaris 10, Windows.

Clustering Technologies: OracleReal Application Clusters 11g and 10g(RAC),OracleClusterware (CRS), Transparent Application Failover (TAF),OracleCluster File System (OCFS2), NAS

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Oracle DBA

Responsibilities:

• Monitoring and supporting more than 60 databases and SME(subject matter expert) for 10 applications ( four P1 applications).
• Supported Major application CMDB(Configuration Management Data Base).
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Experience with streams in enqueuing and dequeuing messages.Starting and stoping streams processes.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Confidential, PA

Oracle DBA

Responsibilities:

• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Configured Oracle data guard and Streams.
• Oracle streams configuration and performance tuning.
• Data Modeling, Database Design and Creation.
• Design, review and maintenance of database structures.
• Query optimization for reporting and ETL.
• Performance assessment, SQL scripts, stored procedures, functions and transactions analysis
• Oracle Grid Control Management Server Installation
• Database backup and Database tuning for real time and batch systems
• Assisting customer setup, tune and maintain Oracle database.
• 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.
• Data extraction from various sources, transformation and loading into the target Oracle database using Informatica PowerMart.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, PL/SQL, Oracle 9i/10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN.

Confidential, KS

Oracle DBA

Responsibilities:

• Implemented Backup and Recovery strategy through RMAN with TSM as media manager layer and used Cron as the scheduler.
• Installing OEM grid control on rhel 4 for centralized computing
• Responsible for Installation, up gradation of Oracle 11g/10g databases.
• Cloning databases using RMAN for lower environment purposes.
• Provided 24x7 production supports for all the databases.
• Install RAC 10.2.0.2 on RHEL4 with clusterware and voting disk file system on ASM.
• Created/Dropped databases for different environments.
• Created/Modified/Dropped users as and when required.
• Enabled password management for all the users using profiles and administered privileges via roles.
• Apply regular CPU patches.
• Implemented disaster recovery solution using Dataguard.
• Assisted users in improving the database and SQL performance. Fine tune Oracle parameters for better performance.
• Configured Oracle clients using configuration files tnsnames.ora / sqlnet.ora.
• Assisted users in resolving Oracle client related issues.
• Performed both Hot / Cold backups and coordinated with TSM team to solve any backup issues.
• Responsible for restore / recovery of databases. Wrote/modified various shell/Perl scripts.
• Refreshing test databases with production data periodically using EXP/IMP utilities.
• Wrote/modified various shell and SQL scripts.
• Wrote PL/SQL stored procedures and packages.
• Oracle primary (carried pager) once a month.
• Documented standard procedures and policies.
• Installation, configuration, and tuning of a decision-support environment

Environment: Oracle 11g/10g/9i, RMAN, Data guard, Oracle streams, OEM, Shell Scripts, CRON, TSM, Putty, Sun Solaris, RHEL4.

Confidential, NJ

Oracle DBA

Responsibilities:

• Installation of Oracle 9i and creation of database.
• Performed regular Backups and Recovery as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Performed Partial, Complete and Metadata Exports & Imports.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Responsible for Oracle 9i logical and physical databases design, implementation and maintenance.
• Created Tables with appropriate Tablespace and Index.
• Created Users, Roles and Schemas with suitable Permissions.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Maintained Logs/Backups using Imp/Exp Utilities.
• Coordinated with Unix Administrators for Space Management on various servers &help in Oracle.
• Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
• Database monitoring for Deadlocked process.
• Installation and configuration of Statspack and analysis of Statspack.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Implementation and supported as Oracle Database administrator Datawarehouse projects.
• Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
• Created Users and Roles with appropriate Privileges.
• Created Materialized views and database links.
• Wrote shell scripts for monitoring the database.
• Designed logical and physical Data Models using ERWIN.

Environment: Oracle 9i/10g, T-SQL, UNIX, shell scripting, SQL server 2000, Windows.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Performed Database upgrade of Oracle 9i from existing oracle 8i system.
• Involved in analysis of market risk and claims data.
• Performing backups and recoveries using RMAN/conventional hot backups.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.
• Worked closely with senior DBA to understand the business and technical requirements.
• Developed entity relationship, data flow and functional diagrams.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization, and Rollback.
• Developed oracle forms and reports using oracle designer 2000.
• Involved in all phases of the software development life cycle.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Involved in documenting the entire system architecture and data flow
• Maintained control files, log file, data files, table spaces and rollback segments.
• Developed stored procedures and functions using PL/SQL for complex updates.
• Designed Entity-Relationship model and normalized database.

Environment: Windows 98/NT / 2000, UNIX, HP-UX, Oracle 9i/8i, TOAD, Database Tools/Utilities, Perl