SUMMARY:

• An Oracle DBA with almost 8 years IT experience in Oracle (11gR2, 10g, 9i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, data guard etc. spanning various industries like insurance, banking, financial, telecom, pharmaceutical and retail marketing etc. in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.
• Worked as Oracle DBA for clients in field of Heath care, Finance, Insurance, Telecom and Banking.
• Experience in installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
• Expertise working on oracle 10g &11gR2 RAC environment.
• Installed oracle database server on HP - UX, Solaris, IBM AIX, Red Hat Linux environment.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Experience in Real Application Cluster environment (RAC) with ASM and OCFS2 file systems.
• Continuous research in leveraging new features of oracle and bringing them under day to day DBA activities
• Expertise in scheduling the jobs using Grid control.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.
• Installation, maintenance and tuning of RAC applications.
• Experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration.
• Experience in installation, configuration and administration of Oracle Databases.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience in applying security patches to the databases
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Experienced in Oracle Support processes for technical requests through Oracle and other Support

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,5.5 and Windows 95/98/ME/NT/2000/XP.

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

Languages: SQL, PL/SQL, UNIX Shell ScriptingTools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and productionSupport of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• Performed migration activities from 10g to 11g R2 for large databases.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
• Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point) .
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Automated routine DBA tasks like backup’s and stats by using Grid control job’s
• Provided Assistance to application team at the time of SQL tuning in applications.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Additionally, part of rotation oncall DBA to support databases 24X7

Environment: Oracle 10gR2/11gR2, AIX, RMAN, Datapump, OEM Grid Control

Confidential, Paramus NJ

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration oracle databases from windows to linux.
• Database patching using Opatch.
• Proactive database monitoring using 11g grid monitoring tool.
• SQL tunning using statspack and explain plan, tkprof, AWR, ADDM.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of RAC, Stand by database
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• 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.
• Perform other regular DBA activities including space management and performance monitoring.
• Oracle Database monitoring, troubleshoot and resolve the issues.

Environment: Sun Solaris 5.10, Oracle 9i, 10G, and 11G, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Oracle Replication, Hot Standby.

Confidential, Sandiego, CA

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for both production and development databases with on-call pager.
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation of Oracle version 10.2 on Solaris 10 and HP-UX11
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• 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 OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Developing and Implementing Disaster Recovery (DR) Plan using Data guard .
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Daily Health Check Up of the Database using statspack, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Monitoring and Troubleshooting of Database Replication issues.
• 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.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup
• Written shell scripts for digitization the process.
• Handling Database storage.
• Scheduling jobs through Oracle Job Scheduler.
• SQL Tunings for Performance of Objects.
• OS level activities like space monitoring of Mount point.
• 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.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.
• Write SQL scripts to monitor tablespace and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Space Management which includes table space creation, adding new datafiles.

Environment: Oracle 10g R2 RAC, Sun Solaris 5.10, ASM, ERWIN, GRID, AWR, ADDM, OEM, Data Guard

Confidential, Lincolnshire, IL

Oracle DBA

Responsibilities:

• Worked on a 24x7 basis as a production support DBA on a primary/ secondary pager rotation and supported on holidays, weekends and beyond regular working hours
• Extensive experience in RMAN recovery testing, RAC and stand alone database.
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in RAC.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands forRAC Databases.
• Restructured the File system where we had to migrate the Data files from one File system to many file systems as per Oracle standard in Production.
• Done PIT Database recovery for Testing purpose and again recovered back to the current state for Database Of size 1 Terabyte.
• Worked on Migrating BLOB Columns of tables to separate Table space which increases Performed tuning the queries using OEM and also set up base lines from OEM.
• Worked on Streams Database where Schema level Replication is done.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Performed SAN analysis to determine how long the SAN sustain in all Production environment we support Wrote shell scripts for purging trace files, alert log and network log files in Sun Solaris boxes which is uses as standard script across all the databases.
• Supported 6 applications at the same time and coordinated with application team for any changes.
• Installed the Oracle software using silent feature and also created databases.
• Supported & maintained the Production/Development databases on various servers.
• Extensively worked on setting up auditing in many databases we supported.

Environment: Windows NT / 2000, HPUX, AIX and Linux, MS SQL Server, Oracle 8i/9i and 10g, TOAD 7.5.0.0/7.6 Database Tools/Utilities, Enterprise Manager, Aqua Data Studio 3.7, Query Analyzer, Oracle Fail Safe.

Confidential, Reston, VA

Oracle DBA

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 of all flavors on Oracle Database (8i, 9i, 10gR1)
• Also provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem Experience with building, installation, upgrade, and patching of Oracle.
• 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.
• 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.
• 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, table space, tables, indexes, set privileges and user logins.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Managed VERITAS Cluster for HA, I2 Implementation.
• Provided OS (RAM, I/O, CPU) tuning for Oracle Database.
• 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.
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• 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.
• Performed scheduling Control-m for scheduling jobs.
• 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: Solaris 8.0/9.0/10.0,OAS 10g HP-UX, AIX, Linux Red Hat, Windows 2000/2003 Oracle 8i (8.1.6/8.1.7), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, ERWIN 3.6.

Confidential

Jr. DataBaseAdministrator&Developer

Responsibilities:

• Installation and configuration of Oracle database 8i (8.1.7), 9i (9.0.2) on various OS platforms like HP-UX, Linux, and Windows NT, 2000.
• Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database.
• Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks.
• Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.
• 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.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks.
• Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing Reorganized data files, identification and elimination of contention factors like I/O, buffers.

Environment: Oracle 8i, SQL, PL/SQL, SQL plus, Oracle Enterprise Manager, Windows.