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.

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 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

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Senior Database Administrator

Responsibilities:

• Migrated oracle databases from oracle 10.2.0.4 to 11.1.0.7 on AIX 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.

Confidential, Dallas TX

Senior Database Administrator

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

Confidential, Richmond, VA

Database Administrator

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.

Confidential

Database Administrator

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.