SUMMARY

• An Oracle Certified Professional with 12+ years of experience as Oracle DBA and 5+ years of experience as a Software Configuration Management Analyst/Lead. Worked extensively on Oracle 8i, 9i, 10g, 11g versions involving Performance tuning, backup and recovery, migration, monitoring and capacity planning, RAC architecture, load balancing, and security.
• Highly experienced Software Configuration/Release Manager with 5+ years of SCM, Build and Release processes
• Strong skills in Oracle development with Performance tuning to configuring hardware and implementing High Availability solutions.
• Worked in Production, Test and Development databases and provided (24 x 7) production support for database and applications.
• Planned and Implemented Disaster Recovery using standby databases.
• Worked extensively on Query Level Performance tuning using Explain Plan, SQL Trace and TKPROF utilities to find out the root cause of the issue and resolve it.
• Used Staspack, AWR and ADDM for diagnosing and monitoring Database Performance.
• Experience in drawing ER diagrams, Data Flow Diagrams/Process Diagrams.
• Configured RMAN Backup/Recovery strategies, Optimizing Query Plan and Performance Tuning.
• Worked on various wait events and performed wait analysis for tuning Instances
• Involved in Backup and Recovery policy formulation and implementations.
• Involved in Disaster Recovery and Implementation. Used Data Guard for Mission Critical Database environments.
• Used UNIX /AIX Shell Scripts to automate day - to-day operations.
• Strong work experience with tools like Toad, Foglight and SQL Developer.
• Working Knowledge of Java, JDBC and web based technologies.
• Working knowledge of IBM MQ Messenger
• Worked across domains including Insurance, Education, Finance and Telecom.
• Experience in Release and Change Management including ClearCase managing streams/branches and merging code
• Extensive experience in ClearQuest administration
• Excellent communication and interpersonal skills.
• Excellent documentation skills including preparing Release notes, Change documents, Technical documents etc.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux 4.x, 5.x, Solaris 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Windows Server 95, 98, NT, 2003.

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, Oracle 10g RAC, SQL Server 2005, 2008 R2

Languages: SQL, PL/SQL, HTML, Java

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

Middleware: IBM MQ

Version Management: Rational Clear Case, Microsoft VSS

Change Management: Rational Clear Quest, BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. Oracle DBA Consultant

Responsibilities:

• Monitored Oracle databases on 11g RAC in Linux using ASM
• Manage High Availability Architecture (ORACLE RAC)
• Design and implement Application aware ORACLE RAC Active/Active Service based infrastructure
• Install and Configure OEM 12c
• Install OEM Agents across PROD and DEV Instances and setup monitoring and jobs
• Created custom and dynamic reports using Oracle BI Publisher
• Worked with Oracle support to resolve issues out of BI Publisher
• Created CRQ’s using BMC Remedy
• Worked with users at various levels to understand the requirements for the reporting
• Created new framework to be in place which will be used by the BI Publisher
• Designed, created new tables, scripts for data extraction
• Created and modified shell scripts used for reporting
• Created database metric charting reports in BI Publisher

Environment: SUSE Linux, Red Hat Linux 5, Oracle 10g/11g, Real Application Clusters, SQL Developer, BMC Remedy, OEM 12c, Oracle BI Publisher 11.1.xx.

Confidential, Edison, NJ

Sr. Oracle DBA Consultant, Configuration Management Analyst/Lead

Responsibilities:

• Maintaining Oracle software(RAC and standalone) by upgrades, Apply PSU patches
• Manage High Availability Architecture (ORACLE RAC and ORACLE Data guard)
• Design and implement Application aware ORACLE RAC Active/Active Service based infrastructure
• Installed 5 node 11g RAC database using a specific setup of 4 SCAN listeners.
• Troubleshooting ORACLE RAC issues using ORACLE clusterware and Database logs.
• Installed 2 Node RAC Cluster with ASM file System, Linux Device Mapper-Multipath (DM-Multipath) technology on EMC array
• Configured RMAN for back up.
• Configured Imperva Securesphere for databases security monitoring and apply security patches if required.
• Proficient in troubleshooting node reboots in Oracle RAC Environment.
• Configured SQL Server for ClearQuest ticketing system.
• Database Capacity Management (Working with Storage teams for ASM Disks) using Automated scripts/processes and Reports.
• Optimized the Build process by implementing standard automated procedures to reduce Infrastructure Delivery time.
• 24*7 Production Support with on call rotation on a weekly rotation model.
• Installed and configured OEM 12C.
• Dynamic Change management Environment - Critical production changes are planned and implemented on daily basis with thorough review process in place.
• Perform Database cutovers using ORACLE Dataguard switchover.
• Work closely with various vendors (ORACLE /Quest etc.) and teamed in resolving LIVE site issues.
• Migrated business code migration between various versions using ClearCase
• Tracked defects using ClearQuest change management tool.

Environment: Solaris 10, Red Hat Linux 5, Oracle 10g/11g, Real Application Clusters, SQL Developer, Windows Server 2003, Clear Case, VSS, OEM 12c.

Confidential

Oracle/SQL DBA, Configuration Management Lead

Responsibilities:

• Monitored Oracle databases on 11g RAC in Solaris 10 using ASM.
• Involved in the installation of Oracle 11g RAC on RHEL 5 and the setup of monitoring scripts for monitoring RAC Cluster Interconnect Performance and workloads.
• Involved in adding a Node to a 3 node RAC on a LINUX Server and did support the issues after post implementation.
• Performed clusterware upgrade from 11.1.0.6 to 11.1.0.7.
• Configured 11g Active Dataguard, Monitor and maintained Data guard Switchover Primary to Standby.
• Monitored CPU, concurrency etc. during load tests and batch activities.
• Configured Targets, alerts through OEM.
• Managed Blackouts during maintenance windows.
• Backup and Restore SQL Server databases.
• Added new columns to existing tables, dropped and modified columns to existing tables.
• Created scripts to automate scheduled jobs.
• Involved in Critical migration project of migrating a Single Instance database to a 3 Node RAC cluster and supported the application related issues.
• Used Custer file system snapshots feature to resolve Cluster level issues on Linux servers.
• Upgraded 3 Node RAC Database from 10.2.0.4 to 11.2.0.2 and applying patches whenever required.
• Configured Database entries, Monitoring and Maintained user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used SAS and SQL to implement source to target ETL modules for loading into Oracle database.
• Database refreshes from Production to Test and Development environments using RMAN Duplicate Database and also used Oracle Datapump utilities.
• Restored and Recovered, Cloned and Duplicated databases using scripts as well as with RMAN.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Analyzing tables and indexes for performance tuning.
• Involved in sizing and planning of large VERITAS Net backup environments.
• Backup to virtual tape using VERITAS Net Backup and shared storage Option.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools like Explain Plan, SQL Trace, Tkprof, TOAD and Oracle Enterprise Manager.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with Business Analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: AIX, RedHat Linux 5, Oracle 9i, 10g RAC, Oracle Enterprise Manager (OEM) 10g/11g, SQL Developer, SQL Server 2005, 2008 R2, ClearCase, ClearQuest, IBM MQ Messenger

Confidential

Oracle Project DBA

Responsibilities:

• Created databases for Testing, Development and Production.
• Installed Oracle 10g R2 64 Bit on Solaris 10 and HP-UX 11.
• Installed 2 node RAC on Oracle 10g R2 database and configured the monitoring setup
• Involved in 24x7 support for800GB 2 Nodeproduction RAC database.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Data Refresh from Production to Test and Development environments using Export dump.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using Export/Import & Move procedures.
• Upgraded and Migrated databases from 9i R2 to 10g R2 and applied patches as required.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
• Automation of Startup Shutdown on all Production and Development Database.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.
• Upgraded Oracle Application Express (APEX) from 3.1 to 3.2 along with custom patches.
• Resolved issues arising from Portal applications using APEX.
• Provided technical direction to system administrators.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.

Environment: Solaris, Oracle 9iR2, 10g R2, Dataguard, TOAD 7.0, Database Tools/Utilities, Oracle Enterprise Manager (OEM) 10g, Oracle Application Express 3.1, 3.2

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 9i, 10g databases on Sun Solaris 9.
• Involved in Oracle 10g RAC installation, configuration and supporting 4 node cluster environment on LINUX.
• Worked with RAT in order to capture the workload and replayed for testing and benchmarking purposes.
• Recovered huge Database (2 Terabyte) when UNDO tablespace got corrupted in RA.
• Installed CRS, ASM lib on oracle 10g Databases and added nodes to existing RAC Databases.
• Migrated databases from Sun Solaris (oracle 9i) to RedHat Linux (Oracle 10g R2).
• Tuned the databases using AWR/ADDM, STATSPACK, ESTIMATE, ANALYSE, INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Schema level backup and restores.
• Proactively identified issues/bottlenecks that are potential problems. Involved necessary support teams Application, UNIX, Network, Storage etc. and took a corrective action to rectify the issues.
• Performed Schema Management, Index rebuilding, analyzing the tables and removing the row chaining and row migration.
• RMAN & SQLBACKTRACK configuration for scheduling backups.
• Database refreshes from Production to development databases.
• Performed database cloning to create Test and Development environments from Production.
• Design and Implement database security, auditing and user management for supporting developers in tuning and optimal performance.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Involved in designing of disaster recovery using Data Guard, High Availability using 10gRAC.
• Schemas refresh using Export/Import. Created the database, table spaces, tables, indexes, settings privileges and user logins for Prod, Dev and Test databases.
• Creating Database Monitoring scripts and batch files for schedule jobs.