SUMMARY

• Over 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 on SUN Solaris, Linux, AIX, HP - UX and Windows operating systems.
• Experience in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM) on oracle 11g & 10g.
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts.
• Experience in implementing ORACLE STREAMS (Uni-directional) 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.
• Installed, Configured, Administration, Monitoring & Support Oracle GRID for maintaining Oracle Databases supporting multiple applications.
• Experience in applying PSU/CPU, 1-OFF patches.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database.
• Worked extensively on various backup and recovery methods like PITR, TSPITR and FLASHBACK technologies.
• Expertise in Performance tuning of the database - SQL Tuning, Used Tuning utilities like AWR, ADDM, ASH, ASMM, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AUTO TRACE, Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Good knowledge in Oracle 11g features.
• Good experience in Data Migration using traditional export/import, data pump, SQL*LOADER from flat files.
• Implemented automated backup strategy and database monitoring scripts using UNIX shell script and scheduled in CRON.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Materialized Views, Cursors and Triggers etc.
• Management of schemas, Data modeling, objects & partitioning the tables & indexes.
• Security user Management, Privileges, Roles, Auditing, Profiling and Authentication.
• 24*7 production database support with Support to developers & end-users.
• Experience in using the oracle support (Metalink) for technical assistance requests (TAR) by uploading the system activity reports (SAR) and database log files related to performance issues.
• Scheduled jobs in the database using DBMS JOBS.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.
• Excellent personal time management, organizing, problem solving skills, team player and ability to learn.
• Strong ability to understand new concepts and applications. Good communication skills to work independently and in a team environment.

TECHNICAL SKILLS

Programming Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting, HTML, XML, JavaScript

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

RDBMS: Oracle 8i/9i/10g/11g, Oracle 10g(RAC, Data Guard & Streams), Microsoft Access

Database Tools: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Data Guard, SQL TRACE

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

Other: Ms Office, Ms Visio

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Oracle DBA

Responsibilities:

• Installed configured, maintained and tuned Oracle 10g and 11g on RHEL 5.0.
• Successfully upgraded Oracle 10g to Oracle 11g.
• Involved in Installation and configuration of Oracle 10g RAC using Clusterware and ASM.
• Involved in Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Configured Uni-directional streams to achieve table level replication using oracle streams.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Involved in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g RAC environment for the Production databases.
• Writing and modifying UNIX shell scripts, to manage Oracle environments and for Backend Oracle Processes.
• Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Applied security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.

Environment: Red Hat Linux, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, DataGuard, ASM, SCP/SFTP, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential, NY

Oracle DBA

Responsibilities:

• Installed and created Oracle 9i and 10g databases in development, Production and QA environment including configuration, backup & performance tuning.
• RDBMS patchset upgrade.
• Cloning of the database is done from Production to the Test, Development environments.
• Planned and implemented Backup & Recovery using RMAN.
• Maintained Database Security by creating Roles, Privileges, Quotas, and Passwords.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Worked with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Refreshed development and test databases from production using logical backups (export and import).
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption).
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Implemented cold backup and hot backup depending on the requirement.
• Having good experience in SQL, PL/SQL and UNIX Shell Scripting.
• Database migration from production to test and development environments is done through cloning, export and import.
• Daily Health Check Up of the Database using AWR, ADDM.
• Wrote SQL scripts to monitor tablespace and extent growth. Space Management, which includes tablespace creation, adding new data files.

Environment: Oracle 9i/10g, RHEL, HP UX, SQL, PLSQL, UNIX Shell Scripting.

Confidential, MI

Oracle DBA

Responsibilities:

• Installed and maintained Oracle 9i/10g databases.
• Upgraded databases from lower version to higher version.
• Served as a member of 24-hour on call support staff.
• Refreshed development and test databases from production using logical backups (export and import).
• Performed database administration and user/security management. Resolved issues related to client/server connections.
• Implemented Cold backup, Hot backup in manual methods using scripts and Using RMAN and recovered various development and critical Production databases.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Very high transfer of data from one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp ( Data pump Import).
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Scheduled jobs in the database using cron job and DBMS JOBS.
• Participated in the Installation of Oracle 10gRAC.
• Generated performance reports using utilities like AWR, STATSPACK to gather performance statistics.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.
• Analyzed SQL statements and reorganized database objects and designed indexes to improve response of queries.
• Monitored Overall system Performance and Database growth.
• Created users and allocated appropriate tablespace quotas with necessary privileges and roles for all databases.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Designed, documented and implemented backup and recovery Procedures. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Automated shell scripts and scheduled batch jobs.

Environment:, Oracle 9i/10g, 10g RAC, RHEL, HP UX, SQL, PLSQL, Unix Shell Scripting.

Confidential

Oracle Developer/DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• 24x7 remote support and on call database support for developers & end-users.
• Responsible for administering, supporting production and development of Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Loaded data from flat file to Oracle database using SQL*Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management in database with Grid control. Performed Troubleshooting and system maintenance.
• Involved in user creation and user access control. Involved in Schema creation and management. And Developed stored procedures, stand alone functions and PL/SQL packages to comply with the requirements.
• In depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
• Develop, implement and test Backup and recovery strategies for development databases.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule the code.
• Maintained the RMAN repository and customized recovery catalog and also involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Environment: ORACLE 9i, MS-SQL, SQL, PL/SQL, SQL* Loader, RMAN, UNIX AIX 5.1, UNIX Shell Scripting, export/import utilities.