SUMMARY:
Over 8 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, auditing.

• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Worked with a team to provide 24x7 on-callproduction database support.
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent experience in Installation and configuration of Oracle8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Experience in installation and maintenance of Oracle 10g RAC using both ASM and OCFS2 File System
• Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Management of schemas, objects & Partitioning the tables & indexes.
• Development experience in creating Procedures, Pro*C, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Involved in the data migration from sql-server/DB2 to Oracle.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and 10g OEM Grid Monitoring.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle 10g Standby Databaseusing Oracle Data Guard, 9i and 10g.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, 10g OEM Grid Monitoring custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, SQL Developer ,Data Migrations using export/import, benchmarking using load testing tools
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Worked on different types of storage structures (SAN/NAS).
• Good written and verbal communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Operating Systems

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

RDBMS

Oracle 11g/10g/9i/8i, SQL Server 2000.

Languages

SQL, PL/SQL, C, C++,UNIX Shell Scripting

Tools

TOAD9.5, SQL Plus, SQL Developer RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp , impdp , ERWIN, DTS ,Informatica.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK

Other

VERITAS, NetBackup, EMC

Web Tools

HTML, XML

CERTIFICATION:

• Oracle 10g Certified Associate

PROFESSIONAL EXPERIENCE:

Confidential,Boston ,MA. Jan2008 – Till Date
Role: Oracle Database Administrator

Responsibilities:

• Installation and Configurations of Oracle 11g ,10g and 9i on Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Involved in performing migration from Oracle 10g to Oracle 10g RAC database
• Installation and configuration of 32 bit and 64 bit 9i/10g RAC on UNIX and Windows environment
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like Erwin
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Handling large database environments (Datawarehouse) using ETL tool Informatica and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production 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.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Upgradation and migration from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Manage data architects, data administrators and client enhancement requests.
• Have setup snapshot replication database for reporting purpose.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Expertise in Client server GUI software and different Operating systems.
• Migrated from SQL server to oracle .
• Worked on import/export, export datapump/import datapump and SQL- loader.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Oracle Streams.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using Cold backup/ Hot backup/ Logical.
• Setup backup and recovery procedure using Netbackup ,Rman.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace,TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Worked on SQL Navigator for tuning database, developing and testing stored procedures, schemas, and SQL scripts.
• Wrote UNIX shell scripting to automate tasks and crontab and dbms_schedulerfor scheduling jobs

Environment: Oracle 9i/10g, RAC, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, Rman, ASM, Tkprof, Statspack, SQL Loader ,AIX ,Linux, HP-UX, Windows NT/2000.

Confidential, NY. March2007 – Dec2007 
Role: Oracle DBA
Responsibilities:

• Have worked on different environments like test, development and production databases.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Analysis of the existing Data Warehouse system to understand existing functionality
• Have worked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i, 10g databases on Production and Test Solaris servers.
• Installed and configured Oracle 10g Real Application Clusters (RAC) on linux.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Database Restore using RMAN, Cold Backup and Export.
• Worked on VERITAS volume manager and VERITAS Cluster Service.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Used importdp/exportdp and SQL- loader to load data into tables.
• Identified, designed and developed all Oracle PL/SQL Packages, Procedures, Functions, Triggers and arrays.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0.

Confidential , Columbus ,OH. June2006 – Feb2007
Role: Oracle Database Administrator

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 9i on, Linux and Windows 2003
• 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.
• 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, RHEL

Client : CONFIDENTIAL, Reston , VA Dec 2005 – May 2006 
Role: Oracle Database Administrator

Responsibilities:

• The work involved overall Maintenance of Oracle Database, Performance Tuning, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database. Handling day-to-day activities.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Sun Solaris 2.5, 2.6, UNIX Shell scripting.

Confidential, Philadelphia ,PA May 2004 – Nov 2005 
Role: Oracle Database Administrator

Responsibilities:

• Support & Maintenance of Production/Development Databases on various servers.
• Install and create database, managing servers of other groups on call duty.
• Logical and Physical Modeling.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle Installation, Upgrading from 8i to 9i.
• Capacity Planning, Storage Allocation and Space Management.
• Creating users, tables, database links, Performing Exports/Imports.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups
• Database Tuning – Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Created PL/SQL Packages, Procedures and Functions for maximum performance
• Tuning Rollback segments, Sizing the database for future growth.
• Performing Database monitoring for deadlocked process and maintaining logs/Backups using Imp/Exp Utilities & VERITAS Backup system.
• Automating the process/Scheduling Jobs using DBMS_JOB.
• Writing scripts for monitoring the database, Configuring SQL* Net. Integrating multiple application databases with multiple corporate entities, receiving business data feeds.
• Fine Performance Tuning the Databases for optimization, Tuning Application, Estimating Table & Index Size in TOAD7.5.5/7.6, Diagnosing the contentions, troubles using v$views.
• Stored procedures, packages & triggers to support the Front end/e-commerce.
• Supporting the Development team, supporting production Environment, Setting up passwords for SVRMGR and Listener, Sending out e-mails/alerts from the Database using UTL_SMTP.

Environment: Oracle 8i/9i, OEM, DBCA, TOAD, Data Guard, XML, Sun Solaris, Test Director, CVS, Erwin, FTP, UNIX, Windows XP.

Confidential Sept 2001 – March 2004

Role: Jr. Oracle DBA/ Developer

Description:
Siemens is often at the forefront in responding to new trends in the healthcare industry and has built its operations through internal growth, strategic alliances and mergers and acquisitions. I worked with SEDA - Sorian Enterprise Data architecture – Clinical and Financials. 

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Analyzed the structures using Analyze command. Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Developed PL/SQL functions and procedures to provide APIs for the front-end developers to manipulate the database efficiently.
• Involved in application Testing, Deployment, Production Support.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script Cron Utility.

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

EDUCATION:

• Bachelor of Technology in Electronics and communication