PROFESSIONAL SUMMARY:

• Excellent experience in Installation and configuration of Oracle Database 9i, 10g RAC, 11g RAC, 12c 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.
• Proficient in setting up, upgrading and administering RAC 10g/11g /12c with ASM and good knowledge in oracle Exadata.
• Expertise in ASM Storage and Oracle 11g 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 (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Extensive experience with OEM 12c and Enterprise Manager Cloud Control 13c
• Hands-on experience in implementing, upgrading and configuring the GoldenGate software for 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.
• Expertise in using SQL Performance Analyzer (RAT) for evaluating performance pre-migration.
• 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 in Database refreshes and cloning, using ZFS snapshot and clone
• 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, 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

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, P.A

Sr. Oracle DBA

Environment: Oracle 11g/12c RAC, OEM 13c, Exadata X3-8 (Quarter, Half &Full architecture), RHEL 6.x/7.x, MS Windows Server 2008-R2, Data Guard, DB Artisan, VERITAS Net Backup, ZFS, VMWare VSphere ESXI, IBM WebSphere, FileNet, PeopleSoft Financials, Toad 12.8, RMAN, SQL * Plus, Service Now, Lotus Notes, MS Outlook, Skype for business

Responsibilities:

• Primary tier 3 support for 200+ Oracle databases and their lower tier environments.
• Working on Oracle Standalone, RAC one node, and RAC multi node databases with Grid Infrastructure (GI), configuring Oracle net services and storage supporting ASM, File system and RAW devices on Linux and Solaris operating system.
• Performing data migration of very large databases using zero downtime migration strategies.
• Involve in configuration and maintaining Physical Standby for all production databases with Data Guard and testing for switchover, failover, activating the standby to primary with minimum data loss and making application to use Active Data Guard option for reporting.
• Participated in several Active Dataguard switchovers, snapshot standby databases, maintained, administered and Troubleshot for all Dataguard.
• Extensively implemented Datapump, conventional Export/Import, and Golden Gate for migration and logical backup of database and for data center migration.
• Involved in applying one-off for Oracle bugs and security CPU, PSU patches on Oracle Databases and Grid Infrastructure using oracle utilities.
• DBA on large scale migrations and implementations for backup and recovery upgrades, data center migrations, Enterprise Manager Installations and migrations.
• Analyzing Database and SQL performance tuning based on reports generated by SQL Trace, TKPROF, AWR, ADDM, ASH, SQL-T, and Explain Plan and validating database parameters when slowness issues reported or alerted.
• Closely work with all Applications team, support them with all issues and Performance tuning issues
• Work with users and support groups on a daily basis to communicate system status and offer suggestions to increase productivity and reliability.
• Work closely with Oracle Engineers and work on SRs for issues and get the solved.
• Assist in monthly data center switchovers and disaster recovery testing.
• Providing 24*7 on call database support and maintenance including remote database support
• Manage very large retail, online & web banking databases with HIPAA and SOX compliance.

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.

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 and ZFS Storage
• 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
• Developed and maintained PL/SQL Stored Procedures, Packages and Functions.
• Resolved common database issues like Locking, Free Space, and connectivity issues etc.
• Performed database maintenance by applying required patches and software updates
• 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

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.