SUMMARY

• Overall 9.5 years of experience with 7+ years as an Oracle DBA and Oracle RAC DBA and have good Knowledge on Oracle Exadata
• Administering and maintaining Oracle databases, 24X7 Production Database Support
• Expertise in Installation and configuration of Oracle 12c/11g/10g/9i on Windows and Linux platform
• Experience in Oracle version Upgrades and Patching Oracle (10g/11g/12c) databases
• Backup strategy for Non - RAC and RAC databases using RMAN and Storage snapshots
• Planned and Implemented DR & High Availability oracle solutions using Data Guard
• Implementation and Configuration of oracle RAC databases
• Developed database monitoring/health check alert shell scripts for uptime/downtime status and sizing issues using grid control(OEM)
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold (Netapp snapshot) and hot backup, full back up, incremental and cumulative backups
• Implementation Oracle Golden Gate and troubleshooting Replication issues
• Implemented data transfer using Import/Export Data Pump Utilities
• Experience in Database hardening and maintain database security
• Worked Extensively on Cloning and refresh of Database
• Space Management which includes table space creation, adding new data files
• Experience in migrating database from normal file system to ASM file system
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention by using Explain Plan, SQL Trace, SPM, SQL Advisor, ASH, AWR and ADDM
• Analysis of ADDM report to identify the root cause and implement performance solution
• Analysis of AWR, ASH & SQLT report to troubleshoot and identify database contention and Query performance, 10046 and 10053 trace analysis for Query optimization
• Install and Configure OEM12c. Configuring different types of report using Cloud CONTROL which help to ease DBA’s day to day tasks. Ex: - Backup report, File system report, CPU/Memory/Disk IO report
• Knowledge of data replication using Golden Gate (including initial Load and Bi-directional replication)
• Working with Oracle Support for resolving critical database issue
• Excellent communication skills, with strong troubleshooting, and problem-solving ability
• Worked as a team member to provide 24x7 on call support production database support

TECHNICAL SKILLS

Operating systems: Red hat Linux, Windows, AIX

Tools: /Utilities RMAN, exp/imp, data pump, Oracle Enterprise Manager Grid Control, SQL Loader, Toad, SQL Developer, tkprof, oratop, AWR, ADDM, ASH, SQLT SQL Tuning Advisor, Oracle Golden Gate, SSMS

RDBMS: oracle 9I, 10g, 11g, 12c

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA & RAC DBA

Environment: Oracle 10g, 11g, 12c on RHEL 5 & RHEL 6

Responsibilities:

• Plan, Install, configure and maintain Oracle RDBMS
• Patching of databases with latest security patch or latest version
• Upgrade of Oracle 11g database to 12c Database
• Creation and maintenance of both manual standby and physical DR on both Standalone and RAC
• Implementation of Oracle Active Data guard on production database server
• Implementation and Configuration of Oracle OEM 12C
• Setup OEM Software library, database provisioning and patching using OEM 12c
• Backup & Recovery of database in an emergency situation
• Participate in Application Upgrades and provide support
• Created and implemented RMAN backup and recovery scripts and several other monitoring scripts
• Develop and maintain technical & process documentation
• Worked with AWS consultant to move on premise databases to AWS Cloud
• Worked with AWS Schema Conversion tool to migrated Oracle and SQL databases to PostgreSQL
• Performance tuning of databases including instance tuning, query tuning of bad SQL queries using EXPLAIN PLAN and other utilities
• Provided instance level performance monitoring and tuning for Wait Events, latches, Sessions, Physical and Logical IO and Memory Usage using ADDM, AWR, ASH, SQLT
• Worked with Oracle support for improving regressed queries, interpret 10046 trace files. Understanding the 10053 trace to find the bad queries in upgraded databases
• Worked with Oracle support to troubleshoot and fix Wrong result issues due to internal bug in upgraded databases
• Performance and regression solutions by recommending SQL profiles, outlines, new indexes and Materialized Views . Experience of SQL plan management (SPM), SQL Plan Baseline and advisor tools such as SQL Tuning Advisor , SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Set and Advisors to generate tuning recommendations; reviewing, analyzing and providing solutions
• Responsible to create, maintain and monitor database instances in a distributed environment utilizing multiple versions of Oracle Server. Perform database health checks. Table and index management
• Provide support through daily operations of Oracle Databases
• Working closely with Application team for application upgrade and enhancement activity
• Maintain security and integrity controls for hardening of database
• Maintain Confidential policies, procedures and standards during all database activities
• Perform day-to-day troubleshooting of issues related to Oracle client/server technologies
• Troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions

Confidential

Oracle DBA, SAP & RAC DBA

Environment: Oracle 9i, 10g, 11g on Red-Hat Enterprise Linux, AIX

Responsibilities:

• Experienced in maintaining large Production, UAT, QA, SANDBOX, TEST and DEV environments
• Monitoring CRS status and Administration of RAC Instances using SRVCTL Utility
• Applied database PSU and SAP Bundle patches on RAC and NONRAC Databases
• Implemented Oracle Database 11g two node Real Application Cluster (RAC) on a Linux system
• Configuring Oracle Golden gate for schema and Table level replication, have knowledge of Bi-Directional replication
• Troubleshooting Golden gate replication and hang issues
• Cloning from Cluster database to Standalone database for test environment
• Managing of Tablespace for different User by Granting Quota on Default & Temporary Tablespace
• Written Stored procedure for monthly table partitioning activities
• Installed and setup 11g Oracle Enterprise Manager Grid Control (11.2.0.1) and Mass Agent Deployment on several hosts
• Developed database monitoring/ health check / Alert Monitoring/ Tablespace scripts, and sizing issues using grid control ( OEM
• Performed manual recovery using archived logs, RMAN - managed backup, operating system backup, cold and hot backup, full backup, incremental and cumulative backups
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Configuration and Maintenance of physical standby databases with DG BROKER
• Monitored tablespace & their growth and took proper actions like resizing datafiles, adding new data files
• Backup and recoveries using RMAN
• Recommending indexes and other performance benefits for SQL query which helps for query optimization on production databases
• Performed table reorganization using dbms redefinition package
• Performed Schema/Database Refresh from Production to QA, UAT and Development databases
• Working on real time production database for performance issues on the database
• Implemented data transfer using Export/Import utilities and Data Pump
• Configuring database backup report, File system threshold report, CPU Memory, Disk I/O report using GRID CONTROL
• Created Database Links and Materialized views
• Managing user accounts, user privileges and profiles

Confidential

Application Support, DBA

Environment: Sun OS, Universe DB, MS SQL server, Oracle database

Responsibilities:

• Monitoring phantom process of Daily Backup and ensure that Backup is completed properly and the required Business reports are generated
• Monitoring routine process which is crucial for daily business activities
• Restoration of Invoice File from tape for restoring missing Invoices
• Performing Backups (Cold and Hot) Oracle RMAN & Export/Import Tools and utilities
• Creation of database objects like Tables, Indexes, Views, Users, etc
• Managing tablespaces, user profiles, storage parameters
• Database installation, support and administration
• Important and major contribution in Implementation & Support activity of Sales, Purchase & Inventory Modules at “ Confidential Private Limited” for New Zealand (Primary) and Australia (Secondary) User’s
• Monitoring the record locks and clearing the locks if record is locked by inactive sessions
• Handle’s the Technical operations and provides support for the various ERP modules
• Preparation of Requirement documents, User manuals of different ERP Modules for reference
• Managing database login credentials for E-commerce Website Login’s and Temporary Website Login’s for End Users and Customer’s, so that they can place online orders
• Uploading database of E-commerce Website using SQL server 2000 Import/Export Utility in case of technical failure

Confidential

Application Support, DBA

Environment: ITM40 ERP System, DB2, Oracle database 10g

Responsibilities:

• Creating Table, Table Partitions for Inventory Data
• Creating Table Indexes and Views
• Performed different method of backups like COLD, HOT using RMAN and OS
• Monitoring tablespace & their growth and took appropriate actions
• Mapping RF Gun with online Database for proper capturing of Inventory information
• Testing real time data with different types of transactions for proper data mapping
• Mapping with current ERP system for proper flow of transaction
• Preparation of Error Reports & Test Cases

Confidential

Application Support, DBA

Environment: ITM40 ERP System, DB2, Oracle DB

Responsibilities:

• Training and implementation of Sales, Purchase & Manufacturing Modules of ERP - ITM 40 (Integrated Trading and Manufacturing) at various Plants & Corporate offices of “The Confidential Industry Limited” across INDIA for streamlining the operations of various functional areas viz., Sales, Purchase & Manufacturing
• Managing Tablespace for Different User by Granting Quota on default & temporary tablespace
• Monitoring alert log files and fixing critical errors
• Granting and revoking Permissions to/from the users as per request
• Space management which includes tablespace creation, adding and resizing datafiles
• Cloning & Refresh of Database using RMAN tools
• Creating Table Partitions and Archiving Old data (Ex. Invoice Table purging)
• Handling Database activities like Table creation, updating and alteration
• Managing Database by providing access to New User’s, along with required Access rights as per mentioned by their Head of Department
• Achieved substantial reduction in rate of mistakes through monitoring and analyzing the accuracy and the mistakes done by the users
• Streamline the needs of various reports for MIS Generation by maximum utilization of Business Intelligence Tools i.e. BI-TOOLS