PROFESSIONAL SUMMARY

• Over Seven Years of extensive experience in the IT industry involving Oracle Database Administration, Oracle Applications Administration. Worked extensively on Oracle 11g, 10g, 9i, and 8i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security
• Excellent experience in installation, configuration and administration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX and Windows environment.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script Development, and documentation.
• Installation, administration and maintenance of Oracle 10g RAC,11g RAC
• Worked extensively on Oracle Installation, Oracle Version Upgradation, Migrations (from 8i to 11g) and patching
• Involved in performance tuning and database reorganizations. Worked on Disaster Recovery and Implementation
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planningand efficient usage of the disk space. Performed SAN analysis and provided recommendations
• Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life - Cycle (SILC).
• Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data
• Supported Streams Database where Database, Schema, Table level Replication is done. Worked on Partitioning and Materialized views
• Extensively usedDatabase Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD
• Monitoring VLDB (Very Large Databases) using Grid Control and also working off-shore while monitoring
• Wrote several Purging shell scripts on Linux which have been using as standard script at the workplaces
• Designed complex ER diagrams, Data Flow Diagrams/Process Diagrams to detail the specifications
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, datamigration, dataclean-up, data archiving, etc
• Developed RMAN scripts for database back up and recovery including- hot and cold backup
• 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
• Good at Data Dictionary views, User Security and Auditing.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases

TECHNICAL SKILLS

RDBMS: Oracle 11g RAC/10g RAC/9i/8i

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1 Red Hat Linux RHEL 4.x, 5.x and Windows 98/NT/2000/2003/XP

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

TOOLS: RMAN, ASM, SQL*Loader, DataPump, TOAD, DBCA, DBUA, OEM/GridControl, Oracle Data Guard, ERWIN, TOAD

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

ETL: Informatica, External Tables

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Senior Oracle Database Administrator

Responsibilities:

• 24x7 Production Database support
• Installation and configuration of multi node Oracle 11g RAC, 10g RAC, Standby databases (Active DataGuard) for high availability and disaster recovery purpose.
• Upgrading databases from Oracle 10g to Oracle 11g
• Applied patches to Oracle RDBMS.
• Applied quarterly CPU patches
• Cloned/Refreshed Oracle Databases for development and testing.
• Setup backup and recovery procedures using RMAN incremental backups
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Extensively worked on SHARE PLEXwhich is used for replication
• Setup, configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery
• Performance tuning using SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• Worked on Listner Fixes as a part of Oracle mandatory security fix on both standalone and RAC
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users

Confidential, Houston, TX

Senior Oracle Database Administrator

Responsibilities:

• 24x7 Production Database support
• Installation and configuration of multi node Oracle 11g RAC, 10g RAC, Standby databases (Active DataGuard) for high availability and disaster recovery purpose.
• Upgrading databases from Oracle 10g to Oracle 11g
• Applied patches to Oracle RDBMS.
• Applied quarterly CPU patches
• Cloned/Refreshed Oracle Databases for development and testing.
• Setup backup and recovery procedures using RMAN incremental backups
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Setup, configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery,
• high availability and data protection
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM
• Database monitoring using OEM/GridControl
• Wrote shell scripts for backup automation, cloning, purging trace and log files
• Supported 6 applications at the same time and coordinated with application team for any changes
• Written SQL, PL/SQL programs (Functions, Procedures, Packages and Triggers)
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies
• Supported Data Modeling, Database Design using ERwin
• Supported& maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Undo Segments, and Constraints.

Environment:Oracle Server 11g RAC, 10g RAC, 9i, RedHat Linux, IBM AIX, Sun Solaris, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, ERWIN, Active DataGuard, GoldenGate, SQL, PL/SQL

Confidential, Carrollton, TX

Oracle Database Administrator

Responsibilities:

• Provided technical support for Oracle Server to customers for Production Database
• Supported customers including international customer to install the developed application on different operating system e.g. windows, UNIX flavors on Oracle Database (8i, 9i, 10g,11g)
• Also provided support to customers to manage their operational data ranging from GB to TB in Oracle database, solving of space problem, data loading problem
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database, prepared Oracle database environment for the application analyst
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Analyzed SQL queries causing performance problems
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• 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
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc
• Applied patches both Server side and Client side
• Worked on setting up new environments (Development, Production etc).
• Supported the Upgradation from Oracle Server 8i and then to 9i/10g.
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Performance tuning using SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Cloned 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
• Data Modeling, Database Design and Creation using ERwin
• Supported 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 Server 11g RAC, 10g RAC, 9i, RedHat Linux, Sun Solaris, HP-UX, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, ERWIN, DataGuard, Oracle Streams, SQL, PL/SQL

Confidential, New York, NY

Senior Oracle Database Administrator

Responsibilities:

• Installed, created and managing database servers and on Call duty
• Coordinated with UNIX administrators for space management
• Installed RAC on Oracle 10g,11g on HP-UX 11.0 and worked on ASM feature of Oracle
• Upgrading Oracle databases from 8i,9i,10g to 11g
• Worked on Capacity Planning, Storage Allocation and Space management
• Worked on Golden gateand Oracle Streams to replicate multiple copies of Oracle database
• Good experience in applying Oracle Patches
• Created users, tables, database links, Performing Exports/Imports
• Planned Backup/Restoration Strategy, scheduled backups, took logical backups.
• Worked on database tuning - Tuning Applications, Tuning Memory and Tuning Disk Usage
• Tuned rollback segments, sizing the database for future growth
• Performed Database monitoring for deadlocked process and maintained logs/backups
• Used Data Pump for export and import
• Automated the process/scheduling jobs using DBMS JOB
• Wrote scripts for monitoring the database
• Performed tuning the queries using OEM and also set up base lines from OEM
• Worked on Application databases with multiple corporate entities, received business data feeds
• Estimated table & index Size diagnosed the contentions, troubles using views
• Used stored procedures, packages & triggers to support the front end

Environment:Oracle Server 10g RAC, 9i, 8i, RedHat Linux, Sun Solaris, IBM AIX, HP-UX, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, ERWIN, DataGuard, Oracle Streams, SQL, PL/SQL

Confidential ., San Jose, CA

Senior Oracle Database Administrator

Responsibilities:

• Supported production environment on 7/24 bases for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database processes in the Client environment
• Design Evaluation and Analysis of data model implemented for PLM
• Involved in Installation and customization of Databases for the PLM Setup
• Involved in Schema management, Tablespace Management, User Creation and management for the PLM domain. Monitored the Extraction and loading processes of Data
• Created and corrected Materialized Views for Refresh Layer Population in Data Mart
• Handled Performance and Tuning issues from code level to server level
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK
• Index creation and management for optimization of DB Processes
• Extensive use of tools like TKPROF, STATSPACK, SQL advisorfortuning application and instances
• Used ASH for session monitoring and performed memory management
• Involved in I/O tuning by moving data files and redo log files to faster disks
• Used analyze table, analyze indexes to tune queries and increase performance
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Performed tuning of Packages and Procedures using the Profiler utility
• Monitored and tuned Database for Java Application and involved in Java Memory management and analysis
• Import and Export of Schema and databases across various stages of the project

Environment:Oracle Server 10g RAC, 9i, 8i, RedHat Linux, IBM AIX, HP-UX, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, SQL, PL/SQL

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 9i, 10g 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.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans, RMAN backups. tested the backups periodically for consistency and reliability
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application

Environment:Oracle Server 10g RAC, 9i, 8i, RedHat Linux, Sun Solaris, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, SQL, PL/SQL