SUMMARY

• Over 7 years of experience as an Oracle Database Administrator in a variety of database environments like Online Transactional, Data Warehousing and General purpose database and having expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, auditing and designing databases.
• Expertise in Installation, Configuration, Upgradation, Patching, Migration, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g databases on UNIX, LINUX and Windows environments
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for off - line and on-line Backups.
• Hardworking, result oriented good interpersonal and communication skills
• Experience in working with RAC environment.
• Created and configuredData Guard (Standby Database)
• Experienced in Oracle 8i/9i/10g/11g features (RMANDuplicate database, Data Guard, and Standby Database).
• Worked in performance tuning in SQL, database server configuration, Shared Pool and Buffer Cache.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK,Explain Plan and TOAD.
• Experience with standby (Data Guard) databases configuration and maintenance.
• Intensively used 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases,and used the notification tool to send the alerts in OEM Grid Control.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Experience in migration from Oracle 10g to 11g using direct and indirect methods.
• Supporting development 24/7 production systems. Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Experienced with tools/utilities: OEM, RMAN, Statspack, TKprof, SqlTrace, AWR, ADDM, TOAD, SQL Navigator,and SQL* Loader, Data Pump (expdp/impdp).
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience with testing and pre-production and production of Oracle 11gR2 with 2 node RAC on Red Hat Linux with ASM
• Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Implemented data replication through materialized views.

TECHNICAL SKILLS

• Oracle 8i 9i 10g 11g
• MS SQL Server 2000/2005/2008
• MS Access
• Oracle Enterprise Manager-Database Control
• Grid Control
• RAC and Dataguard
• ASM
• Import Export
• Datapump
• SQL*Loader
• Statspack
• AWR
• ADDM
• Oracle Scheduler
• Tkprof
• Data Pump
• Shell Script
• PERL Scripts RMAN
• AWR
• Toad
• Cron jobs
• MS DOS
• Windows 98/NT/2000
• Red Hat Enterprise Linux
• Sun Solaris
• HP-UX
• IBM AIX
• UNIX
• C
• C++
• PERL
• SQL
• PL/SQL
• UNIX Shell
• T-SQL
• Citrix Metaframe Server
• ArcMAP
• Arc GIS
• Network Engineer
• IIS
• Websphere
• HTML
• XML

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

Oracle DBA

Responsibilities:

• Moved database from one data center to another using data guard.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracledatabases.
• Upgraded databases from 10g to 11g R2.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Implemented anefficient RMAN backup and recovery strategy and implemented it with business requirements.
• Performed recovery of databases.
• Refreshed data using exp/imp and data pump on a regular basis.
• Implemented 2-node, 4-node RAC Cluster from scratch.
• Helped in improving the performance by using the many techniques like Hints, Indexes, collecting stats, histogram tuning, sql tracing, reading explain plan, ASH, AWR, ADDM etc. Performed tuning of SQL statements using tkprof.
• Regular Installations of Oracle9i, 10g,11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Regular installation of database on VMWare.
• Administered few VMWare environments.
• Data modeling / Logical database design andimplementation (including index design)
• Migration of system and applications from Oracle 9i to 10g.
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Created servers to installmultiple 11g databases on RHEL5.
• Schedule backup in 11g using DBconsole / Cron jobs.
• Investigated connectivity issues using Oracle net, tnsnames, listeners and OID.
• Constant monitoring of database space and space management
• Set up 11g Physical standby Data Guard and Active-Active Data Guard.
• Setting up of Oracle and Application user accounts, user profiles and monitoring application security
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.

Environment: Oracle 9i, 10g, 11g, RHEL, SUN Solaris, Windows 2008, RAC, Data Guard, TOAD

Confidential, Princeton, NJ

Oracle DBA

Responsibilities:

• Responsible for managing multiple databases of more than25 terabytes, taking advantage of ASM and RMAN features using FRA. The setup included DR site with Physical Standby using DG broker.Also replication was done using GoldenGate 10.4.Well versed in setting up GoldenGate pumps, extracts, replicatsand trouble shooting the problems using ggsci and logdump. Tuned GoldenGate replication by defining right key cols and indexing. Established monitoring of intensive work load and balancing it out using Resource Manager.
• Responsible for planning, and upgrade of Oracle 10g RAC Release 2 (two nodes), to Oracle 11g RACRelease 2, including CRS, ASMand Database. This includes careful testing of downstream applications.
• Heavily involved in performance tuning and SQL tuning effort. Expert in making use of explain plan, tkprof, AWR reports, OEM and Toad. Tuned several environments and improved the results to many folds. Improved Billing job, GUI interface, and several other frontand backends by tuning not only SQL and database but network and application threads.
• Responsible for infrastructure of database setupand implementation of Oracle 11g Real Application Clusters (RAC). Extensive hands-on implementation of RAC cluster. Installed, stabilized and tuned the database for data warehouse projects. Implemented table partitions, parallel queries, load balancing and failover to improve the business needs.Involved in stress tests of applications and helping developers to improve their design, SQLs, and implementations in RAC environment.
• Responsible for day to day trouble shooting, andmaintenance.Responsible for automating database monitoring usingOEM and shell scripts.
• Responsible for migration / upgrade design for databases and clusters. Designed / tested and implemented backup and recovery methods and procedures including full, incremental and FRA image backups, using RMAN and Netbackup.
• Responsible for helping developers writing efficient PL/SQL code.

Environment: Oracle 11g, Oracle 11g RAC Rel2, GoldenGate 10.4, PL/SQL, Oracel 10g, Oracle 9i, AIX, HP, Sun, Linux, Windows, 500+ servers, 1000+ instances.

Confidential, Joppa, MD

Oracle DBA

Responsibilities:

• The database is used by online applications, customer service over the phone, automated (phone recognized) response service, check printing application.
• The database is very active with 250+ active sessions during business hours and 100+ active sessions during off hours.
• Mostdatabase operations are select only but have predefined SLAsto keep up with printing machines and to serve the customers in time.
• Heavy use of stored procedures.
• Migrateddatabases from Oracle 8i, 9i,10g release1, SQL server to oracle 10g.
• Upgradedthe mission Critical standalone databases toHigh Availability bysettingup RACenvironmenton different nodes withVERITAS Cluster Services.
• Installed and configuredthe oracle10gdatabasewith2nodesRACusing VERITAScluster service.
• ConfiguredRAC listenerusing NETCA
• Wrote variousshell scripts to automate taskssuch as creation of database, configuring data guard. And maintained and modifies them when needed.
• Createdtable spacesand managedtable spacesadding/deleting/ resizing data files.
• Created schema(tables, Indexes, views, sequences, synonyms, roles, packages), grant roles to users.
• Monitored indexesand analyzed their status for performance tuning and query optimization.
• Developedbackup and recovery strategies for the database.
• Responsible for takinghot backupsof the database and individual table spaces.
• Responsible for taking logical backup of data usingexpdpandimpdp(datapumputility).
• Usedbackup and recoverytechniques usingRMANand conducted disaster recovery drills.
• Cloning & duplicating databasesusing scripts as well as RMAN.
• UsedSQL loaderto transfer data from a flat file.
• Performance tuningof Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• PerformedSQLandPL/SQL tuning, oraclecontentionandmonitored production database usingSQL Trace, TKPROF, STATSPACK, Explain Plan, automaticworkload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Createddb linkfor inserting large tables directly without taking export.
• UsedSTATSPACKfor Database Monitoring and Database Performance.
• Created and configured physical standbydataguardfor the production database.
• 24x 7 production supportwhen required(forthe issues like installing new system,production issuesand the problems with the production scripts etc).

Environment: Oracle 8i, 9i, 10g, 10g RAC, windows 2003/xp, RHEL 4, toad 8.5, Erwin 4.0, VERITAS cluster environment.

Confidential, Snoqualmie, WA

Oracle DBA

Responsibilities:

• 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.
• Monitoring of database objects like rollback segments, temp segments and tablespaces.
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in 24x7 Production Database Administration and support.
• The work involves overall maintenance of Oracle database, performance, tuning, backup, recoveries and other database related activities.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Monitoring and Troubleshooting of Database Replication issues.
• Good with PL/SQL Programming to resolve business problems of various nature.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting Oracle databases using sqltrace utilities.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Performance monitoring of database Replication using shareplex Oracle Streams for high availability.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using TOAD and OEM, Tuning Pack, Diagnostics Pack, and STATSPACK.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup
• Monitoring the Standby Database implemented using Oracle Data Guard, Oracle streams and Quest Shareplex and trouble shooting it if and when required.

Environment: Oracle 9i,10g, Solaris 10 Windows Server 2003, Erwin, Toad, RMAN, Data Pump, OEM, SAN, NetApp, Micro strategy 9, Informatica Power Center 8.6.

Confidential

Oracle DBA

Responsibilities:

• Installed and maintained multiple Oracle Databases for Data Warehouse systems.
• Employed data modeling concepts to define entity relationships and data elements in star and snowflakes schemas.
• Performed Oracle backup and recovery, and tuning.
• Developed PL/SQL packages, functions, procedures and triggers.
• Configured Oracle Grid control systems and Enterprise Manager for database diagnostics and monitoring.
• Configured Oracle Flashback procedures for fast recovery.
• Implemented and maintained large partitioned tables and partitioned indexes.
• Implementedvirtual partitions,interval partitions, system partitions, and extended composite partitions.
• Reorganized critical applications at the table space level and schema level.
• Implemented data pump Exports/Imports for mission critical schemas.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Upgraded Oracle servers with Oracle supplied patches.
• Improved the Application performance utilizing advanced SQL query result cache and PL/SQL Function result cache.
• Tuned applications and Oracle systems.
• Developed database standards for developers.
• Upgraded Oracle Server with Oracle supplied patches.
• Performed database migration from SQL server to Oracle.
• Analyzed, Designed, Created and Maintained Oracle DW and Data Mart systems.
• Maintained and Managed Quality Center and Clear Quest applications on Oracle databases.

Environment: Oracle 9i, Solaris 10, RHEL Linux 3.4, Windows NT, Crystal Reports/Crystal Enterprise XI R1, R2, HP-Quality Center 9.