SUMMARY

• 9+ Years’ Experience in the Industry’s Most Competitive Oracle Database Firms
• Excellent experience in Installation and configuration of Oracle Database 9i, 10g RAC, 11g RAC on RHEL, Solaris, IBM AIX, HP - UX, Oracle Enterprise Linux, Windows environment and migration of Oracle Database from 9i to 10g, 10g to 11g and 11g to 12c and applied Oracle Patches.
• Significantly performed development and DBA work in MySQL and SQL Server Database
• Proficient in setting up, upgrading, designing, implementing and administering RAC 10g/11g with ASM and good knowledge in oracle Exadata.
• Expertise in ASMStorage andOracle11g Cluster-ware and Installation and Configuration of Oracle Cloud Control 12c.
• Extensive knowledge of Oracle Architecture, Data Models, Database design, Normalization & System study
• Significantly used Database Administrative tools like Oracle Enterprise Manager Grid Control (OEM), DBA Studio, SQL*PLUS, TOAD 12.1, ISQL*PLUS.
• Experience in fulfilling DBA daily activities, including schema management, user management
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Extensive experience with OEM 11g and Enterprise Manager Cloud Control 12c
• Spearheaded Database migration from MS SQL server database to Oracle Database
• 3 Plus years of Data modeling for both OLTP and OLAP environments using ERWin Data Modeler r7.
• Handled cross platform migration from AIX to RHEL 5 for a database of size 9 TB
• Extensively used Data pump Export/Import and RMAN Duplicate for Database Refresh.
• Planned, built and maintained standby database using Data Guard as both Physical Standby and Active Data Guard for High Availability and Data Recovery.
• Performance tuning of the database using 11g new features - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM,SPA and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes
• Experience inDatabaserefreshes and cloning usingZFSsnapshot. Utilized various volume managers like SAN, NAS for storing various Oracle objects.
• Implementation of RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database.
• Extensive knowledge in creating and tuning SQL queries and PL/SQL procedures and functions for optimum performance.
• 24*7 production database support with Support to developers & end-users.

TECHNICAL SKILLS

Operating System: Redhat Linux 5/6, Solaris 11/10, AIX 6, Oracle Enterprise Linux 5/6

RDBMS: ORACLE 12c/11g/10.x/9.x, MS SQL Server 2012/2008/2005 , MySQL 5.

Oracle Tools/Utilities: RMAN, EXP/IMP, Data Pump, WinScp, GoldenGate, SQL * Loader, DBVerify, TKPROF, STATSPACK, AWR, ADDM, OEM and CA

Backup Tools: Erwin DataModeler r7, VERITAS Netback up 5.3/6.0, BCV Snapshots, Legato, Volume Managers - SAN, NAS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, N.C

Sr. Oracle DBA

Environment: Oracle 12c, Oracle 11g/10g, Oracle 11i/R12, Exadata X3-8 (Quarter, Half &Full architecture), RHEL 5.x, MS Windows Server 2008-R2, OEM 12c, Data Guard, DB Artisan, VERITAS Net Backup, ZFS, Oracle Streams, VMWare VSphere ESXI, IBM WebSphere, FileNet, PeopleSoft Financials, Oracle SOA, SQL Server

Responsibilities:

• Performed Installation, Configuration and Monitoring of Oracle 10g/11gR2, 12c on Linux, UNIX and Windows environments.
• Migrated data from 3 node RAC Cluster 11gR2 db to Exadata Machine on RHEL
• Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary - Managed Tablespaces, and Temporary Tablespaces.
• Performed RMAN Backups to Disk, Tape and ZFS Storage
• Worked on configuring SQL Server with minimum privileged access.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases
• Configured and used the Oracle Enterprise Manager in 10g and 11c for Performance, Maintenance and Administration tasks
• Used Data pump / Exp-Imp Export and import of tables, schemas and Full DB as per development/Application team requirement
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery. .
• Maintained database security, create, modify and manage user s accounts, grant privilege and restrict access to database objects.
• Configured RMAN backups for databases and schedule them through Crontab
• Used Materialize views to copy data from one database to another via a db link
• Created Indexes, rebuilt indexes, analyzed indexes to improve the performance of query.
• Improved the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor in Oracle 10g
• Worked on setting up Physical Standby Data Guard environment for Prod & non-prod database
• Performed data migration using Data Pump export/import utilities
• Resolved common database issues like Locking, Free Space, and connectivity issues etc.
• Performed database maintenance by applying required patches to GI/RDBMS/Cat bundles and also used Patch Automation tool in 12c
• Tuned long running queries and improved the performance
• Supported production Databases and was responsible for other duties/projects as assigned.
• Provided 24*7 on call database support and maintenance including remote database support

Confidential, Columbus, OH

Sr. Oracle DBA

Environment: Oracle 11g/10g, Oracle 11i/R12, Exadata X3-8 (Quarter, Half &Full architecture), RHEL 5.x, MS Windows Server 2008-R2, Data Guard, DB Artisan, VERITAS Net Backup, VMWare VSphere ESXI, IBM WebSphere, FileNet, PeopleSoft Financials, Oracle SOA

Responsibilities:

• Migrated schemas from 10.2.0.4 database to 11.2.0.3.9 databases.
• Installed and configured a 5 node RAC Oracle Database 11.2.0.4.
• Planned and Implemented Disaster Recovery (DR) and High Availability (HA) using RAC, Golden gate and Data Guard.
• Analyzed control file retention time and RMAN recovery window and fixed ‘not connected to oracle’ issue with RMAN in 11.2.0.4.
• Handled cross-platform migration of Oracle Database 11g of size 9 TB from AIX 6 to RHEL 5 successfully.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Supported Lifecycle projects for multiple databases
• Enabled Flashback and perform restore operations for highly volatile TEST environments.
• Used SQL performance Analyzer (SPA) for testing the performance of critical SQL in new environment.
• Monitored the Top Activity on OEM 12c Performance page actively.
• Reviewed the SQL metrics and schedule the Tuning Advisor using OEM 12c.
• Configured Data Guard as DR solution for certain databases.
• Built Fresh environments of Oracle E-Business R12.
• Implemented Data Guard with high performance configuration and participated in Data Guard Fail over tests
• Troubleshot Data Guard errors/lags and monitored Flash Recovery Area(FRA)
• Enabled Flashback and perform restore operations for highly volatile TEST environments.
• Monitored the disk group usage using ASM (asmcmd) actively.
• Installed and Integrated OBIEE 11g and configure Informatica against Oracle R12 application on Exadata X3-8.
• Performed RMAN duplicate and export/import for lower environment refresh.
• Configured Unidirectional and bidirectional Oracle GoldenGate replication.
• Added new tables for replication in Golden Gate.
• Added error handler to ignore unwanted or false transaction during the Replication.
• Monitored database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Used TKPROF, EXPLAIN PLAN to increase the performance
• 24x7 production support for several missions critical systems which utilize multiple Oracle 10g, 11g databases.

Confidential, Bloomington, IL

Sr. Oracle DBA

Environment: Oracle Database 10.2.0.5, 11.1.0.7, 11.2.0.2, RHEL 5, AIX 5, Oracle ASM, OEM 11g, Toad for Oracle, Secure CRT

Responsibilities:

• Involved in the projects supporting 5-node Production RAC databases on Oracle 10g/11g on RHEL.
• Created users, roles and profiles with different security levels.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Cloned or refreshed the databases from production to development and test environments.
• Configured Physical Standby Database using Data Guard.
• Scheduled custom ksh scripts to monitor the LAG in Archive Log Shipping and Apply on the Standby.
• Performed Schema Refresh in all environments.
• Used SQL Profiles plan stabilization.
• Experience in analyzing AWR and ADDM reports in troubleshooting the contention and concurrency in the database.
• Performed DR Test for high availability.
• Involved in enabling trace to capture bind variables and troubleshoot performance issues.
• Involved in planning and scripting to collect DB metrics and configure it with alert systems.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Monitoring Operating System level processes for CPU utilization, Load average and Memory utilization.
• Performing regular backup validations using RMAN.
• Involved in monitoring daily Autosys/Crontab Jobs for RMAN Backups, Data guard Standby validation, LOG Shipping, CRS Processes, Listeners and Sessions.
• Planned Golden Gate setup to achieve unidirectional replication.
• Investigated Replication failures using Log Dump utility.
• Created huge table partitioning (Range, Hash, and Interval).
• Tested initial Data Load option of Golden Gate during environment build.
• Developed custom utilities to automate manually intensive tasks such as mass schema changes.
• Involved in writing backend procedures, functions, packages and triggers using PL/SQL and also Kshell scripts.

Confidential, New York City, NY

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, RMAN, RAC, ASM, Data Guard, Toad, HP-UX 11i, Sun OS 8/9/10, RHEL 4/5, Toad, Reflection, Putty, Shell Scripting, PL/SQL, SQL*LOADER, SQL*PLUS.

Responsibilities:

• Installed, configured and maintained Oracle 11g databases on Linux, UNIX, HP-UX and Windows Platforms.
• Worked in migration of databases from HP-UX platform to Solaris platform.
• Worked in migration of database from Solaris to Linux platforms
• Configured shareplex replication for most of the databases across four data centers.
• Performed application Query tuning using Utilities AWR, Stats Pack, explain Plan, TK Prof, SQL Tuning Advisor and SPM
• Involved in designing new structures/procedures/views/functions/triggers for development and data migration from production to reports using PL/SQL.
• Created and maintained databases for business applications on various platforms in shared and dedicated environment.
• Use of Oracle FLASHBACK technology to restore/recover databases and perform DR Drill (mock disaster)
• Disaster recovery implementation using physical standby databases for high availability.
• Performed Databases Refresh and Schema level refresh as per the user request from Production to UAT and DEV Environments for testing Purposes.
• Implemented Active Data Guard to leverage the standby environment for reporting purposes.
• Created DEV and Prod environment Oracle 10g/11g databases of huge Size (10Tb) for Applications to support the reporting needs for the outside retailers.
• Worked on Oracle 9i to 11g migration projects with low maintenance window and applied patches to various databases.
• Monitored the Performance of the migrated databases using grid Control and features like AWR, ADDM, and ASH also generated the reports for metric collection and health check of the databases.
• Worked in tuning OS, Shared Pool, Buffer Cache and Redo Log Buffer.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Configured RMAN tape backups for the newly created databases.
• 24X7 production support and on call rotation
• Created users, roles and granted privileges according to the business requirements.
• Performed database auditing in regular intervals.
• Automated the replication process using materialized views for reporting databases.
• Applied latest patches as per evaluation requirement.

Confidential

Oracle DBA

Environment: Windows 98/NT/2000, HP-UX, Oracle 8i/9i, Toad V8.0, Net8, Database Tools/Utilities.

Responsibilities:

• Administered all facets of multiple mission-critical Oracle 9i and 10g databases operating in both Single-node and high availability 24x7 Real Application Clusters (RAC) configurations.
• Served as Subject Matter Expert in a variety of areas including Oracle Streams, database security and auditing, backup and recovery, performance tuning and UNIX shell scripting.
• Provided primary on-call support for a large, dynamic database environment encompassing approximately 200 Oracle instances running on over 50 IBM midrange servers.
• Mentored Business Analysts and Software Engineers in areas such as database modeling, structure design, SQL tuning and development of PL/SQL stored objects.
• Developed UNIX shell scripts to monitor databases for potential problems, capture pertinent diagnostic information, alert appropriate support staff and generate related incident reporting.
• Maintained database security for all development, QA, training, support and production instances and User management.
• Evaluated new products and features and provide related assessment and implementation strategies.
• Assessed and recommend alternative processes, procedures and tools to streamline operations and provide a more efficient and cost effective database environment.
• Utilized a variety of tools including EMC Time Finder, RMAN, UNIX shell scripts and in-depth for Oracle to backup, duplicate, refresh and tune databases across multiple servers.