SUMMARY

• About 7+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, space management, database security, cloning, migration, shell scripting and documentation.
• Excellent experience in Installing, Configuring, Up - gradation, Patches Oracle 8.1.x/9.x/10g/11g on Operating Systems such as Sun Solaris, AIX, HP-UX, Red Hat, Linux, and Windows.
• Expertise in RMAN database backup and recovery to tapes and disk in catalog and no catlog mode.
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Strong Knowledge of 10g advanced features like ASM, AWR, ADDM and FLASHBACK.
• Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.
• Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader .
• Experience in Oracle 10g/11g RAC databases in installations, configurations and Maintenance.
• Experience in migrating Standalone Database to High Availability Oracle RAC Environment in ASM.
• Excellent experience of data migration, data archiving and data access techniques
• Experience in using OEM (Oracle Enterprise Manager) and OEM agents for Managing and Monitoring Databases.
• Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to higher Versions and Different Platforms.
• Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.
• Experienced in Advanced Replication for transferring data between two or more Master sites.
• Strong knowledge of PL/ SQL, SQL, Unix shell scripting.
• Strong in writing shell scripts to setup cron jobs for checking Adaptive server’s availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.
• Good at monitoring server performance, database transaction log growth and error logs.
• Strong experience of Oracle Application Express (HTML DB)
• Excellent Communication Skills and written skills.
• Ability to work independently and as part of a team. Adaptable to a fast growing and changing environment.
• Flexible and have excellent trouble shooting and problem resolution skills.
• Worked with Oracle Support TAR/SR, and 24X7 support Environment

TECHNICAL SKILLS

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

Operating Systems: UNIX, Solaris 5.8/5.9/5.10, IBM AIX 5.2/5.3, HP-UX 10.2/11.10/11.20, LINUX, Windows NT/95/98/2000/XP

Languages: PL/SQL, Shell Programming, C, C++, C#, PHP, HTML, XML, JavaScript, Batch Programming.

Utilities: SQL*Plus, SQL* Loader, EXPDP/IMPDP, RMAN, Export /Import, TKPROF,STATSPACK, OPATCH

Tools: SQL Developer, Oracle Enterprise Manager, Toad, Putty, Hummingbird 10, Erwin, Oracle Database Upgrade Assistant.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Implemented Oracle database 11g Two node Real Application Cluster(RAC) using Oracle Clusterware for achieving high Availability.
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.
• Migration of databases to Oracle 11g from Oracle 9i on Linux to AIX.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Worked on upgrading 10g R2 RAC to 11g R2 RAC on Oracle Enterprise Linux 5 (64 bit) Platform
• Worked on STREAMS for table level and Advance Queuing. Managing source-target database and check for any objects which fail in replication configuration. Worked on CDC for data capture.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.
• Upgrade database from 9i/10g to 11g. Performed a data conversations.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
• Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components.
• Involved in full/ partial logical backup using DataPump.
• Create and review Documentation of implementation plan and queries for structural changes in db.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Created Materialized views to make query response faster
• Utilized SQL*Loader and Data Pump import to load data in to tables.
• Created db link for inserting large tables directly without taking export.
• Troubleshooting on various problem and generic errors in daily routine.
• Collaborated with project managers, application developers, and system quality assurance to ensure the database integrity, high availability and security.
• Documented backup and recovery plans and tuning procedures.
• Participation in Logical Design discussions and designing physical database.
• Prepared documentation for ongoing maintenance and support.
• Key role in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR, ADDM etc.
• Provided 24x7 support for Production/Development databases.

Environment: ORACLE 9i,10/11g, SQL SERVER, AIX 5, HP-UX 11, RHEL (Red Hat Enterprise Linux) v4.5, ANSI SQL, PLSQL, RMAN, TOAD, OEM GRID, DATAGUARD, STREAMS

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Supported as 24X7 production/development DBA to 25+ databases on 10 different servers with 2 TB in size.
• Installation and configuration of Oracle Database Software 11g.
• Involved in the project implementing and configuring Real Application Clusters (RAC) on Oracle 11g on different nodes using ASM.
• Setting up new environments (Development, Production etc).
• Performed Cloning for Oracle 10g databases to transport it to different machine, from development to testing environment applied patches using Opatch when required.
• Upgrading database from Oracle version 9i and 10g to 11g and migration of data.
• Involved in logical backup using and full/ partial export/import and DataPump.
• Developed and maintained logical schema, physical records, and SQL queries for Oracle applications 9i databases.
• Executed compound based and deterministic based masking using Oracle Data Masking Pack for transferring the data from production databases to less secured test and development databases.
• Data Migration (from 9.2.0.5 to 11.2.0.3) on AIX 4.3, which is made on a Unix platform.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
• Installation and configuration of Statspack and analysis of Statspack.
• Installed and Configured OEM, OEM Grid Control and OEM agents for 10g and 11g databases.
• Performance report and subsequent tuning, monitoring of production database.
• Setting up Physical Standby Database environment using Dataguard in 9i/10g/11g in No-Data-Divergence mode.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Prepared documentation for ongoing support, Documented backup and recovery plans and tuning procedures.
• Worked on scheduling DB down times for maintenance and promoting new builds, monitoring the batch loads and provided 24x7 support. Moved data from production to test & development environments.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.

Environment: Oracle 11g/10g/9i, AIX 6.1, HP-UX 11i v2, HP 9000, Windows NT 4.0, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v4.5.

Confidential, Providence, RI

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
• Implementation of 10g Data Guard and Bi-directional streams implementation.
• Handling large database environments 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.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrading development and production databases to Oracle 10g.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• 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, and granting required privileges to users.
• Performed other DBA activities like including space management and performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Modified Korn shell scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.