SUMMARY

• Around 10+ years of experience in IT industry as an Oracle Database administrator, having exclusive experience in database administration, production support, installation, configuration, upgrades, cloning, space management and database security with Oracle Software 11g/10g on Red Hat Linux, HP - UX and Windows Platform. Possess high competency in advanced DBA skills such as backup, recovery & Migration.
• Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Experience in installing and patching Oracle RAC with ASM on Linux platforms.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Extensive knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Performed periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience with logical backups of the database using Data Pump (Expdp and Impdp).
• Performed backups and tested crash recoveries using conventional Hot and Cold backups.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in Oracle Database Tuning and Performance by using tools/utilities like Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Database health checks (space, parameter, long running queries, Wait events).
• Managing internal databases, from planning and testing stages through implementation and support.
• Experience in Managing Database Structures, Storage, Table/Index segments, Constraints, Database Access and Rollback segments.
• Implemented Database security administration by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Experience in Deployment process in all phases from Development to production.
• Strong working knowledge of database tools like TOAD, SQL Developer, SQL Plus and Rapid SQL.
• Hands on experience in Unix shell scripting and scheduling jobs using CRONTAB
• Provided 24/7 on-call DBA support for Production/Development databases, responding to trouble calls from multiple database sites and offering solutions to database applications.

TECHNICAL SKILLS

Operating systems: Red Hat Linux RHEL 3.x, 4.x, 5, HP-UX 10.x, 11.x and Windows 2003/ Windows Server 2008/XP.

Databases: Oracle 11gR2/11gR1 RAC, Oracle 10g, SQL Server 2005.

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Rapid SQL.

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

Tuning Tools: TKPROF, SQL Loader, EXPLAIN PLAN, STATSPACK, ADDM, AWR, TOAD

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP.

Terminal: Putty, Telnet, SSH Tectia.

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

Technology Lead (DBA)

Responsibilities:

• Installing ASM environment and migrating database from NON-ASM to ASM.
• Worked extensively on RMAN backups and recoveries & database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN backups and user managed backups.
• Managed a 4TB database which hosted Treasury applications
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Installation Configuration and maintenance of Oracle 11gR1/11gR2 on Solaris and Linux.
• Configuration and maintenance of 4-node 11g RAC using Oracle Clusterware.
• Worked on Load balancing and performance tuning on RAC environment.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Exp/Imp) and Data Pump Database backup (Hot & cold).
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Used Maximo for change management and ticket management.
• Co-coordinating with Clients and understanding requirements and providing 24x7on call support for all the production and development databases.

Environment: Oracle 11gR1 with RAC, 10g, Data Guard, SQL, PL/SQL, Data pump, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager. O/S: RHEL 5.4, TOAD, Windows 2003.

Confidential - Woonsocket, RI

Technology Analyst (DBA)

Responsibilities:

• Install, Setup and configured 10g on Red Hat Linux using Automatic Storage Management
• Implemented a number of performance tuning modifications; both with batch jobs and pl/sql procedures
• Created a number of automated utilities, which provide information about, and resolve problems with performance. Intelligence of these utilities is to address issues in terms of elapsed time, parsing, unnecessary sorts and a big picture of SQL area
• Work with shell scripts for RMAN backup . Played a lead role for RMAN backups for client datacenter.
• Constantly monitoring the performance of the databases and viewing alert log files & trace files.
• Actively participated in all the Oracle meetings and provide valuable feedback across different solutions ranging from saving storage costs to reducing backup times, implementing new features of Oracle, etc
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users.

Environment: Oracle 10g, 11gR1 with RAC, Data Guard, SQL, PL/SQL, Data pump, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager Grid control.

Confidential, Bentonville

Senior Software Engineer (DBA)

Responsibilities:

• Configured 2-node Real Application Cluster (RAC) on Oracle Cluster File System (OCFS) and monitored RAC instances.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Migration of non-ASM database to ASM databases.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Exp/Imp) and Data Pump Database backup (Hot & cold).
• Extensive use of monitoring tools like STATSPACK and AWR, ADDM reports, Oracle Enterprise Manager, TOAD for the performance tuning at the SQL and database level.
• Trouble shooting user logins, missing privileges, slow performing sqls.
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact with developers.

Environment: Oracle 10g, Oracle 9i, OEM Grid control, Quest Toad.

Confidential, SFO

Systems Engineer

Responsibilities:

• Database upgrades from 8i to 9i and 9i to 10g, maintenance, and daily performance health check of all the database instances.
• Code migrations, performance tuning of SQL statements, debugging of stored procedures, sql scripting, shell scripting to automate processes.
• Performed database refreshes using hot backup and cold backups and RMAN clones for various instances.
• Providing support to three of Production Databases Running on Real Application Clusters (RAC).Documented all the processes, resources (servers, databases, etc) as part of housekeeping.
• Used AWR reports, ADDM and OEM to monitor database systems performance, capacity and availability.

Confidential

Systems Engineer

Responsibilities:

• Perform daily maintenance tasks on oracle databases such as creating or adding space to Table spaces, users, roles, privileges, synonyms, archive log destination monitoring,
• Performance Tuning at SQL and database level for heavy batch load.
• Migrated schemas from development environment to test environment.
• Created triggers and stored procedures in PL/SQL.
• Have done the GAP analysis for the new enhancements and additional columns.
• Coordinating with on-site counterpart about the requirements and changes.

Environment: Oracle 9i/10g/ SQL*Loader, Windows 2000/XP, SQL, Pl/SQL, Exp/Imp, Putty, SQL Trace.