SUMMARY

• 8+ years of progressive experience in the field of Information Technology as an Oracle DBA in Oracle Installation, Database configuration and Administration, Backup and Recovery, Database Migrations, Standby database setup, and troubleshooting of issues in various Oracle Products/versions working on several OS platforms.
• Excellent experience with Oracle Real Application Cluster 11gR2 and 10gR2 with ASM, Oracle 8i/9i/10 g R1,R2/11 g R1,R2 on heterogeneous operating systems including Sun Solaris, HP - UX, IBM-AIX,Windows, and Red Hat Linux.
• Experience in Installation, Configuration, Migration and upgrading (patches) Oracle databases.
• Experience in upgrading Oracle Databases from 9i to 10g and from 10g to 11g by applying Patches and patchsets.
• Expert experience in Monitoring Oracle Databases using Oracle Enterprise Manager, Grid Control and TOAD and Experience in Backup & Recovery with RMAN .
• Experience in registering Databases to Oracle 10g Grid Control and registering Databases to RMAN Catalog.
• Experience in Data Loading using External Tables and SQL*Loader.
• Experience in Capacity planning and experience in refreshing data from Production to Development databases and Reorganization of Databases using Export/Import, Experience in Data Pump.
• Excellent experience in Performance tuning of oracle databases using AWR, ADDM, STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Experience with Dataguard environment, Physical Standby Databases, and Logical Standby Databases.
• Created and configured a Physical Standby database to meet Disaster Recovery situations.
• Excellent programming experience in writing Stored Procedures and writing Database Triggers using SQL and PL/SQL and application development experience.
• Experience in Database design including creation, modification, and deletions of table spaces, data-files, rollback segments and schema's, Create Schema (Tables, Indexes, views, sequences, synonyms, users and roles).
• Experience in using 10g features like Flash-Back Recovery.
• Experience in RMAN database backup, Recovery, DATABASE CLONING using RMAN with VERITAS Net backup.
• Managing Database Structures, Storage allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Experience in understanding GoldenGate(GG)
• Tested the GoldenGate in Multiple direction and bio-directional by using the tables in the schema.
• Experience on Unix Shell Scripting for automating the DBA tasks.
• Effective and efficient team player with excellent interpersonal skills, analytical & problem solving skills.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, HP-UX, AIX, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

Databases: Oracle 11gR2, 10gR2 /R1, 9i, 8i; RAC 10 g R2, 11 g R1, 11 g R2.

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM

Tools: & Utilities: Export/Import, RMAN, Data Pump, Putty, Winscp3

Languages: C, C++, JAVA, Unix shell scripts, PL/SQL

Web Tools: HTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Database Administrator

Environment: SOLARIS, ORACLE 10g/11g R2 RAC, OEM, 10 g GRID CONTROL, AWR, ADDM, Shell Scripting, Data guard, RMAN, Data Pump.

Responsibilities:

• Installation and configuration of Oracle 10g/11g servers and creation of databases in LINUX and SUN SOLARIS environments.
• Installing and configuring 10g/11g Real Application Clusters (RAC). Troubleshooting performance problems.
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, ASSM and ASMM to improve performance and manageability
• Creation of users, and provided maintenance of privileges, profiles, roles schemas, Table spaces and other database objects.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Table spaces.
• Establishing and monitoring database RMAN backups and export schemes (hot/cold).
• Implementing Oracle 11g Dataguard for high availability.
• Cloning the database by using RMAN
• Migrating and upgrading the Oracle 9i database to Oracle 10g/11g and incorporating the changes in the database design.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs.
• Implemented Data Pump, Import and export techniques for Schema level export and imports.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Implemented database level performance tuning using AWR, ADDM and Statspack.
• Installing Oracle applications on server and client machines, and developing Scripts for common Oracle tasks.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Create PL/SQL Stored Procedures, Triggers, and Packages, Functions, Views and Materialized views.
• Performing SQL*Loader jobs for loading data from text files.
• Creating and maintaining Database Links between different Oracle databases.

Confidential, Minneapolis, MN

Database Administrator

Environment: Oracle 10g/11g, RAC, RMAN, DATA GUARD, DATA PUMP, AWR, ADDM.

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23
• Migrating applications from non-clustered oracle 9i/10g databases to new
• 10g RAC Database environments.
• Monitoring and supporting Applications using OEM 10g Grid Control.
• Configured two node Oracle 10g RAC cluster.
• Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
• Write and modify UNIX shell scripts to manage Oracle environment
• Performed Data Migration as a part of enterprise data warehouse project
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Daily Health Check Up of the Database using Statspack, AWR, ADDM.
• Registering Databases to Oracle 10g GRID.
• Registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Datapump.
• Written shell scripts for digitization the process.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Monitor CPU usage, I/O contention, memory paging on UNIX server.
• Write SQL scripts to monitor table space and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Confidential, Detroit, MI

Oracle Database Administrator

Environment: Oracle 10g RAC, ASM, Oracle 10g Grid Control, Oracle 9i,HP-UX 11.23, VERITAS Net Backup, Datapump, Dataguard and RMANSTATSPACK, AWR, ADDM, MS SQL SERVER 2005.

Responsibilities:

• Installation and configuration of Oracle 10g servers and creation of databases in Windows environments.
• Installing and configuring 10g Real Application Clusters (RAC). Troubleshoot performance problems.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs.
• Establishing and monitoring database backup and export schemes (hot/cold).
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Develop Load scripts using SQL*Loader.
• Developed PL/SQL Packages, Stored Procedures and functions.
• Involved extensively in performance tuning as we were processing more than a million records Confidential a time.
• Tuned packages and anonymous blocks by studying the pattern of data flow.
• Participated in Performance Tuning using Explain Plan and TkProf.

Confidential, Hartford, CT

Database Administrator

Environment: Sun Solaris, RHEL, IBM AIX, Oracle 8i, Oracle 9i, RMAN, External Tables, Export/Import, OEM and TOAD.

Responsibilities:

• Installed Oracle 9.2.1 on Sun Solaris, Red Hat Enterprise Linux.
• Created and maintained development, Testing, and Production databases.
• Migrated Oracle database from Oracle 8.1.6 to Oracle 9.2.1.
• Created stored procedures, functions, database triggers and Form level triggers using PL/SQL and Oracle packages.
• Partitioned large tables to improve the performance of queries.
• Created schemas and db objects. Allotting space to the users, creating and assigning roles to users.
• Identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views etc.
• As a part of Database Performance tuning, used STATSPACK to check the waits and as a part of application tuning, checked V$SQL and found SQL scripts which have more resource consumption and tuned the scripts for better performance by using Explain plan, SQL Trace, TKProf utilities and Hints.
• Monitoring development, test, and production databases using TOAD.
• Monitor IO, CPU and memory bottlenecks and suggest appropriate measures.
• Checking tablespaces, adding data files.
• Cloning databases using scripts as well as RMAN.
• Planned and implemented archival, backup / recovery of databases.
• Managed import/export of relevant data using. Archiving and removal of backup data according to the data expiration policy.
• Taking logical and physical backups, assigning cron jobs for logical backups.
• Checking objects’ status, constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Confidential 

Database Administrator

Environment: Oracle8i/9i, Linux, Sun Solaris, Import/Export, TKPROF, EXPLAIN PLAN.

Responsibilities:

• Installation and configuration of Oracle database 8i/9i on various OS platforms like HP-UX, Linux, and on Solaris platform.
• Created procedures, functions, packages, and triggers using PL/SQL.
• Oracle database administration on Solaris platform.
• Involved in the Design (Logical & Physical) and maintenance of Databases.
• Creating Databases and all database objects. Designing Table spaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth.
• Creating and dropping of users, granting and revoking privileges as and when required.
• Setting up and maintaining user accounts and profiles, Space management.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Preparing Backup and Recovery Plan.
• Creating and implementing backup and recovery strategies.
• Experience in working with cold and hot backups and recoveries.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks.