PROFESSIONAL SUMMARY:

• Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration with mainly production support experience and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Experience in Installation of Oracle 10g/11g Real Application Cluster with ASM and manage Confidential instances using Confidential and Confidential Utility.
• Configured multiple database instances using ASM instance.
• Troubleshoot performance issues for the Confidential instances.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 Confidential to 11g R2 Confidential
• Add or Remove Node from Confidential .
• Implemented & configuring replication technology using Data Guard & Oracle Golden Gate installation.
• Implemented Uni - Directional & Bi-Directional replication in Golden Gate.
• Implemented Golden Gate Director with EM plugin
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data Guard.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Database replication using snapshots, materialized views, import/export and advanced replication methods like Oracle Golden Gate.
• Resolving the issues in conflicts between the target and source database in Golden Gate.
• Good experience in performance tuning for production databases
• Experience in 10 & 11g Confidential and Grid/Cloud control setup installation and patching
• Experience in Database Migration and Upgrade Activity across data centers under Heterogeneous and homogeneous environments
• Experience in Data Guard build and Participated in the DR Exercises with various backup/restore strategies and configurations
• Configured and replicated databases using in Golden Gate
• Configured Golden Gate Director with EM Plugin
• Good knowledge in administering databases in EXADATA environment
• Extensive experience in analyzing AWR, ASH, ADDM, Explain Plans and trace files with 10046 & 10053 events.
• Experience in SQL Tuning Advisor, SQL Profiles, SQL Plan Management and SQL Tuning using hints & indexes
• Experience in Clustered servers environment
• Experience in New Server builds for Production - installation of Oracle, creating databases and configuring backup & monitoring scripts
• Experience in Database upgrades to 10g/11g
• Experience in migrating databases from RMAN to ASM and cloning databases using RMAN
• Applied Quarterly patches- CPU, PSU and bug fix patches for databases in all environments (QA/Dev/Prod)
• Experience in Periodic Database maintenance activity like database re-org, index rebuilds, growth track analysis and House keeping
• Participated in Application deployments along with the App team
• Planning backup and recovery strategy for various database environments and good knowledge of exports/imports, RMAN
• Good troubleshooting skills for various issues and Performance tuning
• Good knowledge of Unix and knowledge of shell scripting

TECHNICAL SKILLS:

Data base: Oracle 9i, 10g, 11g & 12c on Linux/Solaris/AIX/Win

Oracle Products: With Confidential /Grid/Cloud/Database control setup, Golden Gate Installation & Configuration.

Data Guard, RMAN, OEM: 12C/11g, SQL*Loader, Import and Export (EXPDP/IMPDP)ASM, TKPROF, Confidential, SQL*Loader and SQL*Net

Operating Systems: Linux, Solaris, AIX & Windows

Programming Languages: C, C++ & Shell Scripting

Other Tools: TOAD, Putty, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle DBA

Environment: Production/UAT/QA/TEST Support with Oracle 11g with Real Application Clusters ( Confidential ), Enterprise Manager 12c cloud control, 11g Grid control, NetApp storage and snap backups

Responsibilities:

• We tune/solve database performance issues for e-Commerce and PeopleSoft applications along with regular database support.
• Supporting nearly 50+ Databases which includes Prod/UAT/QA/Test databases
• Good experience in analyzing AWR & ADDM reports to find out performance bottlenecks
• Extensively used AWR SQL Report to find out the execution plan changes, the plan performance and identifying the better execution plan for SQLs
• Tuned many SQLs and brought down run times of SQLs from hours to minutes/seconds
• Extensively used SQL Tuning Advisor to find out the possible recommendations and fixes for bad execution plan, better indexes, and any other additional recommendations for SQLs
• Used SQL Plan Management feature to keep better execution plan available for any particular SQL
• Used SQL profiles to pin the better execution plan or to pin the tuned SQL with hints as part of SQL tuning
• Good skills in analyzing Explain plans and using hints for tuning the Queries
• Extensively used the 10046 & 10053 trace files to analyze the SQL execution with wait events and used tkprof to analyze the traces
• Tuned nVision & Crystal reports
• Built 11g Confidential environments with ASM/NFS as storage options and used ASMlib to manage ASM disks
• Good experience on identifying the performance bottlenecks and troubleshoot performance issues in Confidential databases environments
• Managed ASM storage disk groups like adding/dropping/managing disk groups
• Configured and replicated databases using in Golden Gate for e-Commerce applications
• Configured Golden Gate Director with EM Plugin
• Extensively used Unidirectional replication in Golden Gate
• Configured 11g new feature Active Data guard on 11g and maintained standby databases
• Configured Oracle Wallet and used Transparent Database Encryption (TDE) to encrypt tablespaces to meet client’s data security norms.
• Configured and monitored database Auditing and implemented cleanup procedures for audit data
• Suggested and implemented to use Flashback database feature instead of complete database backup/restore during minor application upgrade works to save lot of time
• Applied CPU and PSU patches for Oracle databases
• Performed and automated Net App snap backup refreshes for clients demanding everyday refresh of QA environments with minimal downtime
• Configured scripts to report and mail to client to find out the bad performing queries along with the SQL Tuning advisor reports.

Confidential, Albany, NY

Oracle DBA

Environment: Production/UAT/QA/TEST Support

Responsibilities:

• Worked on the server builds for all the production & dev environments - Configuring OS for Oracle, installed oracle rdbms software, created databases as per the requirements and configured backups & monitoring scripts
• Used various Oracle configuration assistants like Database configuration Assistant (DBCA), Database Upgrade assistant (DBUA) and Network Configuration Assistant (NetCA)
• Migrated databases from windows to Linux environment
• Built two node 10g Confidential setup on RHEL 5
• Configured Data Guard setup with Maximum performance mode and performed switch over during DR exercises without disturbing the primary sites
• Tuned database memory parameters and configuration for maximum performance
• Performed growth track analysis and kept space utilization under control by doing periodic database reorg activity.
• Used AWR, ADDM and ASH reports to analyze performance issues and fixed them accordingly.
• Performed SQL tuning without altering the application code with help of Indexes and Table level portioning.
• Performed database block recovery using RMAN
• Participated in client meetings in application upgrades and provided many inputs related database related tasks to cut down the overall timelines.
• Participated in annual DR exercise which happens once in a year and very critical for the client. This happens for many of the client applications each with different strategies - Data guard, BCV synch, export and imports
• Implemented different backups like regular exports & RMAN backups as per the client standards
• Based on client requirement automated database refresh process which needs to be done every night using exports & imports to refresh the DEV databases
• Implemented DR setup with regular export/imports as per client’s request
• Scheduled various jobs like index rebuilds, daily backup reports, monthly space reports etc through crontab/autosys
• Performed RMAN duplicate database procedure to clone the production database
• Provided application go-live support and solved the last minute surprise performance issues on the fly

Confidential, Palo Alto, CA

Oracle DBA, Incident team technical Lead

Environment: Production/UAT/QA/TEST Support

Responsibilities:

• Supported nearly 600+ Databases and I was primary contact for some clients.
• Maintained good track of SLAs under control for the incidents by guiding the team to resolve them in a timely manner
• Worked on the server builds for production & dev environments and configured backups & monitoring scripts
• Installed and configured two node 10g and 11g Confidential setup on RHEL 4/5
• Participated in the DR exercise which happens twice in a year for many of the applications each with different strategies - Data guard, RMAN restores & Schema refresh
• Configured data guard setup with data guard broker configuration
• Implemented different backups like regular exports & RMAN backups as per the client standards
• Implemented the Advanced Compression feature to benefit Giga bytes of space from the archived data tables
• Automated database refresh process using exports & imports to refresh the DEV databases
• Automated Data Guard incremental refresh as temporary solution while working to fix a Cisco firewall bug which lead to archive logs corruption
• Implemented DR setup with regular export/imports as per client’s request
• Scheduled various jobs like index rebuilds, daily backup reports, monthly space reports etc through crontab/autosys
• Automated the RMAN refresh process which happens weekly once from prod to QA by using shell scripting
• Performed Tablespace point in time recovery using RMAN
• Performed RMAN duplicate database procedure to clone the production database
• Provided application go-live support along with application team and suggested tuning steps
• Good experience on ITIL process and change control process
• Presented many demos about the new features in the new releases to the teams