PROFESSIONAL SUMMARY:

7+ years of experience as an Oracle (9i/10g/11g) Database Administrator in Design, Development, Maintenance and Documentation of Oracle Databases on different platforms like Sun Solaris, HP-UX, Red Hat Linux, AIX,Windows-NT/2000/2003.

• Expertise in Implementing Oracle Maximum Availability Architecture Oracle RAC databases, Oracle ASM storage, Oracle Data Guard and Flashback technologies.
• Experience in Oracle database Migrations from HP-UX to Linux & Windows, Solaris to AIX.
• Expert in Upgrades by Checking and Applying Patch set, Patch Set Updates (PSU), Critical Patch Updates (CPU) and Interim patches using OPatch utility across all releases, making the database software up-to-date.Upgraded databases from versions 8i,9i to 10g and 10g to 11gR2.
• Experience in Installing, configuring and administering of Oracle Real Application Cluster (RAC 11gR2, 10g and 9i) databases withOCFS, ASM and non-ASMstorages in VLDB environments andupgraded stand alone databases to RAC databases.
• Experience in configuring Standby Databases (Physical/Snapshot, Logical) in Data Guard environment, for complete protection of data loss from site failures and implemented latest features likeFast-Start-Failover, Active Data Guard.
• Experience in Data Replication using Oracle Streams and also a leading replication tool, Oracle Golden Gate in Uni/Bidirectional and over heterogeneousenvironments.
• Experience performing Backup and Recovery of Databases using user managed backups- (Hot, Cold), RMAN backups (Full and Incremental) and Veritas Net Backup. Also performed PITR and TSPITR.
• Expert in Cloning and Refreshing of DB for Development and Testing using RMAN.
• Experience in performing logical backups using Oracle Export/Import & Data Pump.
• Experience in configuring and monitoring of Oracle Enterprise Manager (OEM) Grid Control 11g, 10g by installing the oracle management agents and also TOAD.
• Experience in diagnosing and Performance Tuning (Application Tuning, Instance Tuning and Disk I/O Tuning) the databases using UTLESTAT,STATSPACK, AWR reports and analyzingSQL Trace, EXPLAIN PLAN, ASH, ASMM, Tkprof outputs and by solving ADDM findings.
• Expert in Query Optimization and improving execution plans by Partitioning (range/hash/list) large tables, optimal usage of Indexes and Joins, creating Materialized views (snapshots) and proper settingof Optimizer modes to better perform Cost/Rule Based Optimization.
• Implemented advanced features in Oracle 10g, 11g like Grid computing, TAF, RDA, Flashback technologies, content management, Fine-Grained Access Control, Transportable partitions.
• Knowledge in administering and supporting SQL Server 2000/2005/2008.
• Experience in writing Stored Procedures, Functions, Triggers & packages using PL/SQL.
• Administered Oracle databases of size 7TB on OLTP/OLAP, DWH environments.
• Experience using SQL*Loader, ETL Tools and External Tables for Data Loading.
• Expertise using Log Miner, DBVERIFY, Crontab in scheduling the jobs and developed UNIX Shell Scripts.
• Experience in creating users, roles assigning profiles and granting privileges
• Experience in database Security management using Fine Grained Auditing and Data Encryption.
• Expertize in capacity planning, change management, System design using E-R diagrams, Data Modeling using ERWIN and Normalization for removing data redundancy.
• Excellent communication skills with strong troubleshooting and problem solving ability.
• Effectively handled critical situations during escalation and has good co-ordination with Oracle Corporation for technical support.
• Extensively involved in 24x7 production support of the databases and their operations.

SKILLS SUMMARY:

Operating System:Red Hat Linux 2.1, 3.x, 4.x, 5.x, HP-UX 10.x, 11.x, Sun Solaris 2.6, 8, 9, 10, AIX 5.1,5.2 and windows NT/2000/2003
RDBMS: Oracle11g,10g,9i,8i, Oracle 11g Real Application Cluster (RAC), MySQL,
SQL Server 2000/2005
Tools & Utilities: OEM,TOAD, SQL*PLUS, Database configuration assistant(DBCA), Network Configuration assistant(NETCA), Oracle Management Server, OLTP, OLAP, SQL*Loader, Erwin, Export/Import, Data pump, RMAN, Query builder, Net Backup,MS Access, Data Guard, Data Stage, DBVERIFY
Languages: SQL, PL/SQL, C, C++, C#, VB.NET, JAVA
Scripting: UNIX Bash & Korn Shell Scripting, Perl
Tuning Tools: SQL Trace, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM,
ASH, RDA
Web Technology: HTML, DHTML, XML, PHP, JSP, Servers, JDBC, ODP.NET
Others: Veritas Net Backup, EMC, HP Data Protector

PROFESSIONAL EXPERIENCE:

Confidential,Bartlesville, OK Jan 10 Till date
Role: Senior Oracle DBA

Responsibilities:

• Responsible for setup, configuration and implementation of 3 node Real Application Cluster (RAC) on 11gR2 with ASM(ACFS) & OCFS2 File systems. Implemented SCAN IP a latest feature.
• Used OEM, CVU & SRVCTL, CRSCTL commands extensively to maintain the RAC environment likeadd/remove node, start/stop clusterware app services on nodeand add TAF service.
• Worked on Automatic Storage Management (ASM) Disk groups for simplified database administration in SAN.
• Migrated the Oracle databases from version 10.2.0.2 to 11.2.0.1 on RHEL 5.
• Applied Patch Sets (CPU, PSU, ONE-Off) for quarterly updates and interim patches for bug fixing using Opatch utility.
• Implemented Data Guardby configuring primary and standby databasesandused latest features like Fast-Start-Failover (HA), Active Data Guard for Fast incremental backupsand Snapshot standby Database to synchronize with primary production database for Data protection, High Availability and Disaster Recovery during site failures.
• Maintained Oracle streams and later implemented Golden Gate (Advanced /Simplified Data Replication, Data Integration) by configured manager, extract, replicate processes and performed unidirectional and bidirectional replication.
• Expertize in planning and scheduling the physical(hot/cold) backups, logical (import/ export, data pump) backups and have taken full and partial backups using RMAN in daily, weekly and monthly basis.
• Implemented Media Recovery, Instance and Crash Recovery using RMAN and performed Database point-in-time Recovery and Table space point-in-time Recovery during scenarios likeloss of RLF, system/non-system DBF, Control file, table drop and whole DB Crash.
• Used Flashback technology to recover tables (TSPITR).
• Installed, configured and extensively used Oracle enterprise manager(OEM) Grid Control and TOAD for database monitoring and maintenance.
• Resolved numerous performance issues like Top wait events, Execution plans, outdated Statistics, Missing Indexes, Data Fragmentation Latch contention, CPU constraints, physical & logical I/O, Disk Usage, Query optimization, Hard/Soft parsing by Application tuning, Disk I/O and Memory Tuning with main aim of Database Performance Tuning.
• Implemented performance tuning by using several tools like SQL trace, TKProf, Explain plan and generated STATSPACK, AWR reports both in command-line and OEM. Also used ASH, ASMM.
• Experience in using tuning Advisors like SQL Tuning Advisor, SQL Access Advisor, Memory Advisor, UNDO Advisor, Segment Advisor and MTTR Advisor, ADDM findings.
• Worked withSQL Script Debugger, Query Builder, SQL navigator and segment advisor.
• Designed and developed several SQL, PL/SQL and UNIX Korn Shell Scripts for auto refreshing, performance tuning, backups and several other DBA jobs.
• Created schemas, granted required roles and privileges accordingly.
• Created monitoring database objects like tables, indexes, views, usersand DB links etc.
• Involved in space management, change management, resolved lock issues, managed quotas.
• Created database links, materialized views (Snapshots) manually and using OEM.
• Cloned (Duplicating), Refreshed, production databases on different serversfor testing and development purposes using RMAN.
• Scheduled jobs using Crontab utility and DBMS_JOBS for backups and alerts.
• Used DBVERIFY utility to diagnose the corrupted blocks and Log Miner an audit tool.
• Configured and maintainedlistener, tnsnames, sqlnetusing NETCA & NETMGR.
• Checked alert logs files, background trace files and OEMon daily basis to resolve issues.
• Planned and resolved various installation, management and security related issues,
• Expert in partitioning the tables greater than 2GB to speed up the query executions.
• Supported and administered SQL Server databases 2005/2008.
• Worked on Data Modeling for large complex data using Erwin.
• Extensively involved in maintaining and updating of Software & Database Documentation.
• Experience working in a team providing 24x7 on callproduction database support.
• Co-ordination with Oracle Corporation for technical support during critical situations.

Environment: Oracle 11g/10g/9i, Oracle 11gR2 RAC, ASM, Data Guard, Oracle Streams, Golden Gate, Recovery Manager (RMAN), Export/Import, Data Pump, Flashback Technology, OEM Grid Control, Linux, HP-UX, Solaris, TOAD, VERITAS, ERWIN, SQL, PL/SQL, WebLogic, TKPROF, ADDM, ASH, EXPLAIN PLAN, Database SQL BackTrack, SQL * Loader, Clone /Refresh, Network Files, DBVERIFY, Crontab, Log Miner, Tuning Advisors.

Confidential, DF& A, AR Feb 08 Dec 10
Role: Senior Oracle DBA

Responsibilities:

• Developed and maintained 2 node RAC on Linux from standalone database for minimizing the down time and maximizing the availability and also achieved load balancing by minimizing the interconnect traffic.
• Installed, configured and maintained oracle 10g, 11g database on Linux.
• Migrated databases from non-ASM to ASM disks to reduce database storage administration.
• Migrated RAC Database from 9.2.0.6 to 10.2.0.1 and also applied High priority, security patches keeping the software up-to-date. Later Migrated/Upgraded the Oracle 10g RAC Database to 11g RAC database.
• Implemented Data Guard and constructed remote standby databases for switchover, failover and disaster recovery purposes of primary database for round the clock data availability and data-protection.
• Performed Data Replication using Materialized view (Snapshot) and Oracle Streams for table level, schema level replication and transferred data inunidirectional and bidirectional by checking withData Synchronization and no Latency.
• Used Recovery Manager (RMAN) and created recovery catalog on different servers. Responsible for regular tasks like taking cold backups weekly, Hot backups, full and Incremental backups andRecovery of Data when necessary using RMAN.
• Cloned the databases using RMAN hot/cold backups and Oracle Universal Installer.
• Used Flashback technology for the data recovery purposes in table and schema level.
• Installed and configured Oracle Enterprise Manager(OEM) 10g Grid control.
• Resolved several database performance issues by tuning various Application Level, Disk Usage(Space Management of CRD files) and Instance Level issues by runningUTLESTAT,STATSPACK, AWR reports and analyzing EXPLAIN PLAN, ASH, ASMM, TKProf outputs and by solving ADDM findings.
• Tuning applications by proper scheduling of batch tasks after peak working hours.
• Memory tuning by sizing shared pool, buffer cache and looking to buffer hit ratios.
• Maintaining and troubleshooting of Oracle network files listener, tnsnames & sqlnet.
• Checked Control, Redo log and data files on regular basis and multiplexed when needed.
• Worked for configuring database memory structure, managing storage allocation, Creating user accounts, Auditing users, Granting roles and privileges for database operations andDatabasesecurity maintenance.
• Created tablespaces and partitioned large tablesto increase SQL performance.
• Implemented post installation troubleshooting and provided timely reports on database health check, follow up and recommendations.
• Wrote Cronjobs for scheduling automatic monitoring, backup, recovery and administrative tasks and also in sending Email alerts during threshold level crossing or bottlenecks situations etc.
• Performed Data Loading using export/import, Data Pump, SQL* Loader, and used ETL tools.
• Developed PL/SQL packages, procedures, functions and triggers to support applications.
• Used Database monitoring/administration tools like Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD.
• Worked withUnix Shell Scripts, DBVERIFY, Log Miner and Data Modeling using ERWIN.
• Utilized Oracle Support and Meta Link to troubleshoot the problems and issues.
• Documented database operations, ongoing maintenance and support.
• Involved in 24/7 on call Production support for Oracle databases.
• Excellent communication and self-starter with ability to multitask.

Environment: Oracle 11g/10g/9i, RAC, HP-UX, Data Guard, ASM, Linux , AIX, Oracle Streams, TOAD, CRONTAB, OEM, Datapump, Export/ Import, RMAN, Veritas Netbackup, ERWIN 4, Opatch, PL/SQL, EXPLAIN PLAN, TKPROF, AWR, SQL * Loader.

Confidential, Greensboro, NC Apr 06 - Jan 08
Role: Senior Oracle DBA

Responsibilities:

• Installed, Configured and maintained Oracle 10g RAC Database on AIX6.1 with ASM.
• Migrated databasefrom 9i to 10g. Resolved migration issues and improved performance.
• Implemented Data Guard environment with Primary(Production)and Physical / Logical standby remote Databases and worked with Switchover and Automatic Failover cases during Migrations/ Upgrades, Patching.
• Configured and implemented Oracle Streams (Advanced Replication) for High Availability and enabled the propagation of Data and Events with in a database and from one Database to other bycapture, stage and apply of data.
• Performed full, cumulative and incremental backups using RMAN and also used recovery methods like Database Point in time recovery(DBPITR) and Tablespace point in time recovery(TSPITR) manually using RMAN with catalog and without catalog.
• Periodically Refreshed production databases for testing using Datapump.
• Involved in Performance planning & tuning, using baselines and bottleneck elimination.
• Tuned the databases and applications using STATSPACK, AWR, ADDM, Explain plan, TKPROF & trace events.
• Monitored index usage and removed unused indexes and Rebuilt indexes when needed to avoid fragmentation and improve performance,
• Scheduled database backups and dba jobs using Crontab and VERITAS Netbackups.
• Reorganized database objects (CRD files) by capacity planning for effective space management and optimal performance.
• Diagnosed Oracle bugs and Coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Transported table spaces between production and development databases.
• Created users, roles and granted necessary quotas and privileges and maintained Database Security.
• Developed UNIX shell scripts to perform tasks like moving files, to manage alert log, perform backup efficiently and quickly.
• Created and setup Dev/Test/QA environment from production database.
• Worked closely between managers and development Team to maximize productive output.
• Developed PL/SQL stored procedures, package, triggers, cursors and views
• Documented Backup and Recovery plans and Tuning Procedures

Environment: UNIX(Sun Solaris, HP-UX, IBM-AIX 6.1), Windows2000/2003, Oracle 10g/9i, RAC, OEM, Export/Import, Data Pump, RMAN, TOAD, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Crontab, PeopleSoft Financials, SQL-Backtrack.

Confidential, INDIA Jun 04 Mar 06
Role: Oracle DBA

Responsibilities:

• Involved in installation and configuration of Oracle 9i databases on Linux and Window.
• Applied theOracle security patches and application patches using the Opatch Utility.
• Involved in managing physical/logical standby databases using Data Guard.
• Involved inDatabase replication using Oracle streams inschema level and table level.
• Responsible for cloning and refreshing of databases per customer requirements using RMAN, Data Pump, export/import.
• Implement database backups using RMAN, VERITAS Net Backup.
• Involved in Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views.
• Tuning and diagnosing of database performance by query optimization and trace facility using Utlbstat/Utlestat utilities, Explain plan, STATSPACK, AWR reports, SQL trace and Tkprof.
• Worked on PL/SQL, UNIXKorn Shell scripting, awkscripting and PERL Scripting.
• Developed stored program units in the form of packages, functions, triggers and procedures for implementing the database intensive business rules.
• Created Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages) and granted roles to users.
• Rewrote several SQL and PL/SQL code to improve query optimization and control program flow.
• Scheduled jobs using Crontab Utility at OS level to automate the routine DBA tasks.
• Extensive knowledge in reporting tools like Business Objects, Crystal Reports and ETL Tools.
• Supported SQL Server 2000 Database Administration.
• Worked with senior oracle DBA to understand business and technical requirements.
• Documented the Dataflow and System Design.

Environment: Oracle 9i, Windows NT/2000, RMAN, Data Pump, PL/SQL, PERL, Data Guard, Materialized views, export/ import, hot/cold backups.

EDUCATION:

• Bachelors in Engineering
• Oracle Certified Professional (OCP)