PROFESSIONAL SUMMARY:

• Over 7 years of experience in Oracle databases (8i/9i/10g/11g) administration, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, Unix, HP - UX, AIX, LINUX and Windows 2000/NT.
• Expertise in Installation, Maintenance, Upgradation, Administration, Backup and Recovery of Oracle RAC Databases.
• Experience in managing very large multi TB OLTP and Datawarehouse databases
• Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
• Extensively worked on migrating databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing and Snapshot physical standby.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Experience on installation and configuration of Golden Gate.
• Experience in installing and managing Oracle Enterprise Manager Grid Control.
• Expertise in Performance Tuning by using tools/utilities like Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, sql tuning Advisor, Autotrace, TKPROF and Statspack.
• Successfully configured and managed Physical Standby Database using Oracle DATAGUARD for High availability.
• Experience in basic and advance replication usingOracle Streams.
• Performed capacity planning to create and manage database environments.
• Excellent experience in cloning/refreshing oracle databases for development and testing.
• Expertise in data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Extensive experience on Partitioning tables and creation of the Indexes on large tables to improve the Performance.
• Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers to implement business logics of oracle database.
• Experience in automating day to day operations using Shell.
• Experienced in heavy data loading from flat files to oracle tables using SQL* loader.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, capacity planning and documentation.
• Experience in debugging deadlocks and other database inefficiencies using SQL Profiler.
• Expertise in maintaining Database Security and auditing.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Project Documentation, creation and adhering to standards of Implementation and Project management
• Excellent interpersonal skills, team player, aggressive, hard working and result oriented.
• Supported the system 24x7, Ability to work beyond regular hours.

TECHNICAL SKILLS

DBMS &RDBMS: Oracle 8i, Oracle 9i, Oracle 10gR2, 11g R2 and SQL server.

High Availability, Tuning: Oracle 10gRAC with ASM, Streams, DataGuard, OEM 9i, 10g, 11gand Monitoring Product LogMiner, Tkprof, Statspack Reports, AWR, ADDM and ASSM:

Operating Systems: Solaris (8/9/10), AIX (5.1, 5.2, 5.3), Linux RHEL (3x, 4x, 5x),HP-UX (10.x, 11.x) and Windows98/NT/2000/XP

Tools &Utilities: Toad, RMAN, EXP/IMP, EXPDP/IMPDP and SQL Loader

Data Modeling Tools: Erwin and ODI

ETL & Reporting tools: INFORMATICA

Backup Tools: VERITAS, NetBackup and HP OmniBack

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, c, HTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Wallingford, CT

Oracle DBA

Responsibilities:

• Administering more than 50+ Production databases of size ranging from 100GB to 7 TB on RHEL and Solaris
• Provided 24x7 on call DBA support for over 250 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, IBM-AIX.
• Involved in the installation, configuration of multi node 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Upgraded production, Development databases from Oracle 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when lupgrading, DR switchover testing.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Developed, modified and optimized very complex queries to data retrieval usingExplain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, Iostat, Sar, glance, Vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, Cumulative and differential Incremental Backups.
• Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
• Monitored performance of queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor
• Performed Database backups and recovery using RMAN, Import/Export, Hot/ColdBackups, and Data Pump tools.
• Managed Oracle inHigh Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Tuned database parameter, PL/SQL scripts and query received from the STATSPACK report, AWR, ADDM or through the end users. Used Materialized Views when possible to reduce network load.
• Handled complete and incomplete recovery in case of database failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Managed schemas, user privileges, suggested and implemented external tables instead of SQL* Loader to reduce time and resources.
• Enabled database audit on entities to monitor certain ambiguities observed in the process flow.

Environment: Solaris 5.X, Windows NT, Oracle11g R1/10g R2, 7x HP UX 10.2/11.X, IBM AIX, RAC, AWR, ADDM, SQL trace, TKPROF, Goldengate

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Involved in administering more than 50+ Production databases of size ranging from 200GB to 10 TB on RHEL.
• Provided 12x7 on call support for mission critical databases.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 16 nodes per cluster.
• Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 RAC databases on ASM and NFS file systems.
• Migrated oracle RAC databases from 10.2.0.4 to 11.2.0.2.
• Responsible for Migrating a 4TB 3 node RAC database from 10.2.0.4 to 11.2.0.2 on NFS storage
• Performed capacity planning to create and maintain the database environments.
• Installed and configured Data Guard 10g, 11g using physical and logical standby for high availability databases.
• Migrated oracle 9.2.0.8 databases to 10.2.0.4 from windows to Linux
• Migrated 4TB 10.2.0.4 standalone database to 2 node RAC
• Responsible for adding a node to a 4 node Cluster.
• As part of BCP certification did switchover and switchback
• Installed 11g (11.1.0.1) Grid control on RHEL 5U3
• Installed agents on database servers and configured enterprise manager.
• Configured UDM’s for monitoring the databases.
• Involved in administering Oracle Streams bi-directional replication at table level.
• Configured Oracle Streams bi-directional replication at schema level between databases located in different colo’s.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30+ production databases.
• Migrated database from ASM to Non-ASM using RMAN.
• Recovered datafiles from block corruption using RMAN.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Proficient in troubleshooting node reboots in Oracle RAC Environment
• Presented White paper on upgrading 10.2.0.4 RAC databases to 11.2.0.1 to Confidential DBA team
• Responsible for refreshing Non-prod environment from production and later automated the process through a script.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Responsible for rebuilding and re organization of tables and Indexes for better performance.
• Installed and configured of Golden Gate.

Environment: Oracle 10g RAC, 11g RAC, 9i, SQL server 2005,2008, SUN SOLARIS 9,10 and RHEL 5.x, HP-UX 11

Confidential

Omaha, NE. Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Senior DBA, Primary point of contact for client for database and configuration management related issues.
• Installed and Configured Oracle 10gR2 two node RAC.
• Installed, configured and administered Automatic Storage Management (ASM).
• Database cloning from Production to Test and Development environments.
• Administered and managed Production, Test, and Stage and Development databases involving more than 100 applications.
• Installed and configured Goldengate.
• Dealt with Web based OLTP systems.
• Review database environments, such as database settings, monitoring oracle user processes.
• Installed and configured Data Guard 10g using physical and logical standby for high availability databases.
• Adding and deleting nodes using Oracle Universal Installer (OUI).
• Created Physical standby database from hot backup of primary database and wrote shell scripts for backup and cloning.
• Worked with a team for replicating databases using Quest Shareplex.
• Used Oracle Streams for data replication between oracle databases.
• Responsible for Migrating Oracle database from 9.2.0.7 to 10.2.0.4
• Daily database administration tasks including backup and recovery.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Developed Backup & Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Provided all kinds of Production DBA support as well as development team support to various tasks.

Environment: Oracle 11g, Oracle 10g RAC, Oracle 9i, RHEL 4.x, IBM AIX 5.3, HP-UX 11, Goldengate.

Confidential

Oracle DBA

Responsibilities:

• 24x7 production database and applications support.
• Upgraded multi terabyte databases from 9i to 10g, Configured disaster recovery site with physical standby database for high availability.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning. Used data pump technology to take the backups.
• Configured Enterprise manager for centralized database monitoring and maintenance.
• Cloning of databases from production to Dev& QA Databases using RMAN utility.
• Partitioning of the large tables to reduce the access time and easier management.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Developed shell scripts and automated nightly jobs using CRON to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Performed data loads using SQL*Loader.
• Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for table replication.
• Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Installation of SQL Server 2005.
• Troubleshooting oracle errors fine-tune database parameters and analyze STATPACK reports.

Environment:Oracle 10g, 9i, 8i, IBM AIX, and HP-UX.

Confidential

Jr.Oracle DBA/ Developer

Responsibilities:

• Installation and creation of 9i and 8i databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Applied High priority, security patches downloaded from Metalink
• Performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
• Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAINPLAN.
• Administered all database objects, including tables, clusters, indexes, views, sequences, functions, packages, triggers and procedures (with PL/SQL hands on experience).
• Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Enabled security in creation of Database users, roles, privileges, profiles.
• Creating primary database storage structures (tablespaces) once developers have designed an application.
• Perform other regular DBA activities including schema management, space management and performance monitoring.
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrievaland processing of queries used for retrieving the data.
• Monitoring the database daily activities.
• Database maintaining including backups, recovery, imports/exports.
• Created materialized views, table partition for Tuned databases.
• Involved In query optimization and using rule based optimizers and cost based optimizers.

Environment: IBM-AIX, Sun Solaris, Oracle 8i, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.