SUMMARY

• Around 7+ years of experience as Database Administrator, providing 24/7 support of both development and production Oracle 9.x, Oracle 10g and Oracle 11g on Various Platforms.
• Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.
• Over 2 years of experience working with Oracle Streams with complete end-to-end support for Oracle Streams Configure, Setup, Install, & support.
• Over 4 years of experience working with Oracle Data Guard– Implement & support.
• Planned, installed, configured and performed upgrades of Oracle DBMS software on various platforms.
• Working Experience of setup and configuration, implementation of ASM/Grid Control/Automation/RMAN
• Extensive Knowledge of Automatic Workload Repository (AWR), Oracle Data Pump,ASM,DataGaurd
• Generating statistics of database using ADDM and tuning the database accordingly.
• Experience working on SQL Trace, TKPROF, Explain Plan.
• Experience in creating different kinds of partitions on tables and indexes for managing large tables.
• Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics (performance tuning) using Dbms_Stats.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN and Verities Netback up.
• Hands on experience in using dbms packages like DBMS_JOB,DBMS_SCHEDULAR,DBMS_SQL.
• Analyzed Tables, Indexes periodically to optimize the SQL queries and assigning proper indexes such as BIT map or B-Tree Index according to requirements.
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Experience in using OEM, TOAD, Data Migrations using export/import
• Performed complete multi-master replication with updateable materialized views.
• Strong knowledge in SQL,PL/SQL
• Expert experience in Hot and Cold Backup of databases
• Experience in Extracting, Transforming and Loading (ETL) data using SQLloader utility.
• Managed Undo Segments in order to avoid "Snapshot too old".
• Experience in Tablespace management both local and dictionary.
• Experience in ORACLE11g installations
• Created roles, profiles and privileges and assigned roles to users.
• Automated many common tasks with Scripts by scheduling jobs (crontab) including: Backups, exports and imports, archiving old records and verification of such processes.
• Have applied oracle patches for DST, Upgradation and migration of databases.
• Experience in working high transacted OLTP systems.
• Experience in working with Reporting tools such as Crystal Reports.
• Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Raise_Application_Error, Parameterized Cursors.
• Experience in working with different FTP clients like Smart FTP, cute FTP, SFTP and SCP.
• Performed 24x7 production system problem analysis and recommend corrective measures in a timely manner.

EDUCATION

Bachelor of Technology

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 and Windows 95/98/ME/NT/2000/XP
RDBMS : Oracle (8i - 10G,11g), 10g RAC, SQL Server 2005
Languages : SQL, PL/SQL, C, C++, PERL, UNIX Shell Scripting.
Tools : RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDM
Database Modeling : Erwin 4.0, Rational rose
Other : EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack

EXPERIENCE

Company : Confidential, Minneapolis, MN
Role : Senior Database Administrator
Period : Dec 2008 – Present

Responsibilities:

• Migrated oracle database from oracle 9.2.0.4 to 11.1.0.7 on Solaris to RHEL.
• Configured, Setup, maintaining Oracle10g RAC two-node environment on ASM
• Upgraded Oracle database from 10.2.0.5 to 11.1.0.6. And applied oracle patches from 11.1.0.6 to 11.1.0.7.
• Writing shell scripts for various database activities like space cleanup, snapshot refresh, file transfer.
• Migrating data using import/export, oracle datapump, transport tablespaces and standby databases.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Involved in upgrading application database from Oracle8i to Oracle9i/10g.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.
• Created/Altered Partitioned tables for large customer related data.
• Used DBMS_STATS to gather the statistics along with analyze command.
• Actively involved in group meeting and user interaction to get feed back from users and to meet business requirements.
• Tested many backup and crash recovery scenarios on test environment (10g), using RMAN tool.
• Detected locks and resolving in-doubt transactions manually.
• Managed complex Standby databases and Data Guard for disaster recovery.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Performed logical backup using export and import utilities.
• Performed database performance tuning, stats pack reports automation, stress test on production copy for scalability, resolving production performance issues.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Database performance tuning using (v$ tables, STATSPACK, TKPROF, OEM).
• Tuned oracle SQL statement by tracing.
• Migrating Data from Legacy Databases (9i/10g) to target databases.
• Maintaining data integrity and tune database for optimum performance and availability.

Company : Confidential, Dallas TX
Role : Senior Database Administrator
Period : Aug 2007 – Nov 2008

Responsibilities:

• Involved in 24x7 support for 800GB 2 Node production RAC database with on-call pager
• Supporting both production and development activities
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation of Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11
• Performed database cloning to setup test and development database.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK, AWR, ADDM
• Upgrading of Database from 9.2.0.6 and to 10.2.0.5
• Using supported backup softwares like EMC, HP OmniBack, Veritas NetBackup, IBM TSM, NetApp
• Used Oracle Streams for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Configuration and Maintenance of RAC, Standby database.
• Implemented Data Guard/Standby for high availability/disaster recovery purpose.
• Data refresh from production to test and development
• Was involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise.
• SQL tuning with Extensive SQL and PL/SQL experience
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Monitoring and Troubleshooting of Database Replication issues.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth.
• Configured Oracle Data Guard for Disaster Recovery.
• Supporting custom application development team including database objects deployment, migration and troubleshooting.
• Setting up new Development & Production environments.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Established a dblink between two Oracle Servers.
• Using SQL*Loader and External tables to load data from flat files.
• Providing Solutions to the Problem Faced by end Users

Company : Confidential, Richmond, VA
Role : Database Administrator
Period : Sep 2006 –Jul 2007

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager
• Installed Oracle Streams for Basic and Advanced Data Replication between Oracle Databases and other databases.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Cloned/Refreshed Oracle Databases for development and testing
• Partitioned large tables to increase the performance.
• Performance tuning of Oracle Database Objects by fixing row chaining
• Installed and Configured Oracle Dataguard for Oracle 10g & 9i for the maintenance of Stand by database
• Extensive use of Oracle Dataguard for protection of critical production data & provide data / disaster recovery support.
• Optimization and tuning SQL queries using TRACE FILE,TKPROF,EXPLAIN PLAN
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Tuning heavy data loads, monitoring and Performance tuning
• Setup backup and recovery procedures using RMAN.Performed hot and cold backups using RMAN
• Performed block recovery using RMAN.Performed backup validations using RMAN
• Oracle Database monitoring,troubleshoot and resolve the issues
• 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
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required
• Writing scripts for the system and database for effective functionality and report generation
• Applied High priority, security patches downloaded from Metalink.
• Involved in Logical and Physical database design.

Company : Confidential, Bangalore, India.
Role : Database Administrator
Period : Aug 2004 – Aug 2006

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installation and Maintenance of Stand by database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgraded production and development databases to Oracle 9i.
• Applied patches to Oracle Databases and Oracle Applications.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Involved in taking Backups using Oracle RMAN (Recovery Manager) and TSM (Tivoli Storage Manager).Defined Data Storage policies like number of backup versions to keep, the retention period for inactive copies etc. Installed and configured TDP using dsm.opt, tdpo.opt files.
• 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.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Application Clusters, Oracle Standby.