SUMMARY:

• To execute challenging assignment as Oracle Database Administrator that would provide me scope to utilize core strength in RAC/Performance Tuning & Golden Gate and provide opportunity to enhance my knowledge & skills in Oracle Database infrastructure management.
• 12+ years’ experience as an Oracle RAC Database Administrator on multiple UNIX operating systems with good skill set for performance and troubleshooting of RAC Databases
• Extensively worked on Oracle 12c, 11g, 10g, 9i RAC, on AIX/Sun/Linux UNIX systems administration, Shell programming, ASM, OEM Grid Control, RMAN, Data Guard Standby Database, Designing Database, Database Tuning, Database Security, Assigning the Roles, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining HOT and COLD BACKUP and RECOVERY.
• Supported 24/7 Production databases of 1 TB to 12TB+ RAC databases and responsible for round - the-clock database operations.
• Installed and configured 150+ RAC servers and 100 + Data Guard / Active Data guard (ADG) setups.
• Ensuring High Availability for applications and Database.
• Solution designing for deploying Multiple Oracle RAC databases.
• Extensively worked on latest security patches CPU/PSU across all the oracle environments including RAC and Standalone database servers.
• Change of Physical, Virtual, SCAN and DNS IPs in Oracle 11g RAC environments.
• Implementation of Maximum Availability/High Availability Architecture (MAA/HA) by setting up RAC standby Data Guard for RAC primary database.
• Identifying the needs for Hardware improvements in reference to the customer requirements
• Keeping the product life cycle active making sure we are on the latest versions and/or technologies meeting the industry standards.
• Involved in preparing IDD (Infrastructure Design Documents) for the new requirements.
• Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache, GRID DISK, CELL DISK, INFIBAND, ETHERNET & KVM SWITCH.
• 12+ years’ experience as an Oracle RAC database Administrator on multiple UNIX operating systems with good skill set for performance and troubleshooting of RAC Databases and having knowledge of EXADATA architecture
• Extensively worked on Oracle 11g, 10g, 9i RAC, on AIX/Sun/Linux UNIX systems administration, Shell programming, ASM, OEM Grid Control, RMAN, Data Guard Standby Database, Designing Database, Database Tuning, Database Security, Assigning the Roles, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining HOT and COLD BACKUP and RECOVERY.
• Supported 24/7 Production databases of 1 TB to 12TB+ RAC databases and responsible for round-the-clock database operations.
• Installed and configured 150+ RAC servers and 100 + Data Guard / Active Data guard (ADG) setups.
• Ensuring High Availability for applications and Database.
• Solution designing for deploying Multiple Oracle RAC databases.
• Extensively worked on latest security patches CPU/PSU across all the oracle environments including RAC and Standalone database servers.
• Change of Physical, Virtual, SCAN and DNS IPs in Oracle 11g RAC environments.
• Implementation of Maximum Availability/High Availability Architecture (MAA/HA) by setting up RAC standby Data Guard for RAC primary database.
• Identifying the needs for Hardware improvements in reference to the customer requirements
• Keeping the product life cycle active making sure we are on the latest versions and/or technologies meeting the industry standards.
• Involved in preparing IDD (Infrastructure Design Documents) for the new requirements.
• Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache, GRID DISK, CELL DISK, INFIBAND, ETHERNET & KVM SWITCH.
• Golden Gate installation Classic and Integrated mode, configuration and troubleshooting various GG issues
• Experience with oracle Golden Gate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration, Downstream ALO mode
• Initial load - direct load, direct bulk load, file to replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate
• Writing Macros for CDR/Exception tables to use in Extract/Replicate PARAM files to simplify the parameter file management, User Tokens, Event Marker System
• Configuration options: BATCHSQL, GROUPTRANSOPS, MAXTRANSOPS, compression, Compression of trail files, network communication, and passwords, ENCKEYS file, Command security: CMDSEC, Handling TCP/IP Errors - TCPERRS file
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution for different scenarios in co-ordination with the App Team
• Golden Gate performance tuning and troubleshooting production issues and preparing the Best practices documents in the area of Golden Gate Practice
• Experience with various Golden Gate tools/utilities like Logdump, Defgen, Reverse, Convchk etc. Trouble shooting different data discrepancy issues by using Log dump to analyze the issues in conjunction with Log mining
• Implementing necessary monitoring scripts for Golden Gate in Unix Shell
• Implementing Golden Gate on Active Passive OS cluster using shell scripting
• Configuring GG-VIP for Golden Gate manager failover as part of node crash for GG High availability
• SQL Query tuning using Explain Plan / SQL Tuning Package / SQLT Package
• Optimize OS and Network parameters to run database smoothly. Tuning of Materialized views execution.
• Implementing of Huge Pages on Linux system to optimize database performance and minimize swapping
• Optimize gather statistics and index rebuild process for quick SQL query response
• Use of Flash cache with disk based storage to get better output from database
• Inspecting AWR/ ASH/ ADDM report and identify database bottlenecks and tune the queries, parameters etc.
• Use of SQL Profile and SQL Baseline to fix better execution plan for queries rather than using more expensive plans
• Use of global and partitioned index as required to tune the execution plan
• Use of proper indexes so that queries can be executed in minimal IO operations on OLTP environment
• Identify the dead lock /row lock issue and help developers to resolve the issue
• Perform load test and identify database bottlenecks

WORK EXPERIENCE:

Confidential, FL & NJ

Responsibilities:

• Golden Gate cascade architecture installation, configuration and troubleshooting various GG issues.
• Oracle Golden Gate Design, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate
• Oracle GG Architecture Primary and DR with Replication path PR1 PR2, PR1 DR1, DR1 DR2
• Writing Macros for CDR/Exception tables to use in Extract/Replicate PARAM files to simplify the parameter file management, User Tokens, Event Marker System.
• Oracle database 12c on Linux OS Active Passive Cluster
• GG Configuration options: BATCHSQL, GROUPTRANSOPS, MAXTRANSOPS, Compression of trail files, network communication, and passwords, ENCKEYS file, Command security: CMDSEC, Handling TCP/IP Errors - TCPERRS file.
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution for different scenarios in co-ordination with the App Team.

Environment: Oracle 12c, RMAN, Data Pump, RHEL Active/Passive OS Cluster, HP Storage, Oracle GG 12c Classic Extract and CaptureOracle GG cascade replication for DR and Reporting purposes.

Confidential

SME (Oracle Database & GG)

Responsibilities:

• Golden Gate installation, configuration and troubleshooting various GG issues.
• Oracle database 11gR2 RAC on Sun OS and Implementation of all DB related activities
• Oracle Golden Gate Design, installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate.
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution for different scenarios in co-ordination with the App Team.

Environment: Oracle 11gR2, RMAN, Data Pump, Oracle RAC, EMC Storage, Oracle GG 12c Classic Extract and Capture

Confidential

SME (Oracle Database & GG)

Responsibilities:

• Golden Gate 12c architecture installation, configuration and troubleshooting various GG issues.
• Oracle Golden Gate Design, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate
• Oracle GG Architecture Primary and DR with Replication
• Writing Macros for CDR/Exception tables to use in Extract/Replicate PARAM files to simplify the parameter file management, User Tokens, Event Marker System.
• Oracle database 11gR2 RAC on Solaris and 11gR2 on OS Active Passive Cluster
• GG Configuration options: BATCHSQL, GROUPTRANSOPS, MAXTRANSOPS, Compression of trail files, network communication, and passwords, ENCKEYS file, Command security: CMDSEC, Handling TCP/IP Errors - TCPERRS file.
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution for different scenarios in co-ordination with the App Team.

Environment: Oracle 12c, Oracle 11gR2, Oracle RAC, RMAN, Data Pump, RHEL and SUN Active/Passive OS Cluster, HP/EMC Storage, Oracle GG 12c Classic Extract and Capture, Oracle GG cascade replication for DR and Reporting purposes.

Confidential

SME (Oracle Database)

Responsibilities:

• 5 RAC database Installation, Configuration each of 2 nodes on Sun Sparc architecture. Reporting database ADG and DR database configuration
• Performed Oracle database performance tuning, and patch administration
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases
• Responsible for creating and managing Data guard instances and administration for disaster recovery
• Database tuning methodologies and monitoring techniques
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Real-Time SQL Monitoring to identify run-time performance problems with resource intensive long-running and parallel SQL statements
• Generated AWR/ADDMR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries. Use of SQL Baseline and SQL Profile.
• Worked on different production issues which includes DB restore, Performance tuning, Session hung issues…etc.
• Performed load test with new application version and SQL tuning of problematic SQL queries
• Created RMAN backup scripts and optimally scheduled RMAN backups across databases
• Integration of DB nodes for COMVAULT tape library backup tool
• Support for administering database including (DBMS JOB), CRON Jobs backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Support for Management of Table spaces such as dropping/creation and modification of storage parameters
• Performed benchmarking databases for performance and created best plans to collect performance statistics to improve the response times
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to oracle and grid instance and cluster ware
• Provide support for critical RAC issues e.g. application connection pooling, ONS configuration etc.
• ASM data migration from existing storage to new storage
• Application version upgrade using sequence of SQL scripts and monitors the system
• Perform DR Drill using Data Guard Broker DGMGRL tool
• Resolved node eviction issues, Implemented ETL to decrease transaction table size to minimal.

Environment: Oracle 11g, RMAN, Data Pump, Sun Solaris, Sun T5 Servers, Oracle RAC, EMC Storage, ASM environment, SQL Tuning Advisor, COMVAULT tape library tool.

Confidential

SME (Oracle Database & GG)

Responsibilities:

• Installed and configured 2 node and 1 node ADG 11g RAC and 2 node Active Passive Reporting using Golden Gate on Sun platform
• Trouble shooting of Various RAC issues including node eviction, HAIP configuration, OCR, Voting disk recoveries.
• Implemented downstream GG extract process from ADG database archive logs. Mintenance of ADG database, troubleshooting of various ADG issues.
• Oracle GoldenGate installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Environment and Database preparation for GoldenGate installation and setup.
• Oracle GoldenGate replication setup in: unidirectional for query offloading.
• Initial load - direct load, direct bulk load, file to replicate, file to database utility; avoiding and handling Collisions during initial load Configure and build GoldenGateExtracts/ replicate.
• Data selection, filtering, transformation and Built-in functions in Golden Gate.
• Implemented and configured Golden Gate on a 2-node RAC cluster
• Commit change number (CSN), checkpoint file and checkpoint table.
• GoldenGate performance tuning and troubleshooting production issues.
• Implementing necessary monitoring scripts for Golden gate in UNIX shell scripting.
• Designed and implemented RMAN backup policies with automation
• Migrated databases from NON-ASM to ASM.
• Migration of databases from standalone to RAC.
• Created and upgraded 11g databases, enabled monitoring, registered databases with RMAN.
• Implemented PSU patches on quarterly basis following organization security standards.
• Created Disaster Recovery Documentation and participated exercises.
• DB server space management by defragmentation, index rebuilding, table reorganization etc.
• Maintenance of ASM instance, Creating Disk groups, Configuration ACFS file system and checking disk header, ASM rules files(udev rules) before adding/creating disk groups to avoid storage issues.
• Optimized memory parameters, Cursors, Processes and init parameters to improve the database performance.
• Troubleshoot performance issues by identifying bottle necks, wait events generating AWR reports.
• Downloaded latest opatch available from metalink and applied, rollback, and resolved patch conflicts using Opatch
• Created Change Requests, Service Requests and Incidents to strictly follow Organization standards for implementing any changes.
• Immediately responding to incidents as they arise, providing 24x7 support also worked in various shifts.
• Active participation in client meetings.

Environment: Oracle 11g, RAC 11g, ASM, RMAN, OEM 11g, OEM11g, Data Pump, Golden Gate 12c Classical Extract from ADG Server Archive log, Sun OS, OEM, Sun T4 server, Sun M5000 Server, Veritas NetBackup.

Confidential

Technical Lead (DBA)

Responsibilities:

• Performed Oracle database configuration, monitoring, performance tuning, and patch administration with 4 node RAC on ASM environment.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Database tuning methodologies and monitoring techniques.
• Created RMAN backup scripts and optimally scheduled RMAN backupsacross databases.
• Administering database including (DBMS JOB), Cron Jobs backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of tablespaces such as dropping/creation and modification of storage parameters.
• Performed benchmarking databases for performance and created best plans to collect performance statistics to improve the response times.
• Generated and analyzed STATSPACK reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to oracle and grid instance and clusterware.
• Migration of database from existing Sun Active Passive OS Cluster environment to Oracle RAC environment.

Environment: Oracle 11gR2 with patchset PSU 11.2.0.3.5 , RMAN, Data Pump, Sun V890, M8000 Server, EMC storage, Oracle RAC

Confidential

Technical Lead (DBA)

Responsibilities:

• Installed and configured 3 nodes Production and 3 node Reporting 11g RAC on Linux platform on ASM environment.
• Performed Oracle database configuration, monitoring, performance tuning, and patch administration.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Responsible for creating and managing Data guard instances, and Performed database installation, maintenance and administration for Disaster recovery.
• Database tuning methodologies and monitoring techniques.
• Created RMAN backup scripts and optimally scheduled RMAN backups across databases.
• Administering database including (DBMS JOB), CRON Jobs backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of table spaces such as dropping/creation and modification of storage parameters.
• Performed benchmarking databases for performance and created best plans to collect performance statistics to improve the response times.
• Generated and analyzed STATSPACK/AWR reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to oracle and grid instance and cluster ware.
• Implemented ADG to offload huge reports pointing to production database instances.
• Migrate database from existing HPUX Service Guard environment to Oracle RAC environment.
• Performed DR drill successfully using DGMGRL (Data Guard Broker) tool.

Environment: Oracle 11g, RMAN, Data Pump, RHEL, HP x86 Server, EMC storage, Oracle RAC, Oracle Active Data Guard, DGMGRL, Grid Control.

Confidential

Technical Lead (DBA)

Responsibilities:

• Performed Oracle database configuration, monitoring, performance tuning, and patch administration with two node RAC on ASM environment.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Responsible for creating and managing Data guard instances, and Performed database installation, maintenance and administration for disaster recovery.
• Database tuning methodologies and monitoring techniques.
• Created RMAN backup scripts and optimally scheduled RMAN backup across databases.
• Administering database including (DBMS JOB), CRON Jobs backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of table spaces such as dropping/creation and modification of storage parameters.
• Performed benchmarking databases for performance and created best plans to collect performance statistics to improve the response times.
• Generated and analyzed STATSPACK reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Implemented ADG to offload huge reports pointing to production database instances.

Environment: Oracle 11g, RMAN, Data Pump, RHEL, HP x86 Server, NetApp Storage, Oracle RAC, Oracle Active Data Guard.

Confidential

Lead DBA

Responsibilities:

• Install Oracle Database binaries on new platform on SUN Active Passive Cluster.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Responsible for creating and managing Data guard instances, and Performed database installation, maintenance and administration for disaster recovery.
• Database tuning methodologies and monitoring techniques.
• Created RMAN backup scripts and optimally scheduled RMAN backups for Veritas Netbackup.
• Database job scheduling (DBMS JOB), CRON jobs backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of table spaces such as dropping/creation and modification of storage parameters.
• Generated and analyzed STATSPACK/AWR reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to Standard Oracle Applications Security.
• Implemented Oracle Data Guard using RMAN backup without downtime and optimized database performance.
• Performed DR Switchover.
• Implemented Reporting database using EMC BCV (Business Continuity Volume) Snapshot technology.
• Configured different Netbackup jobs.

Environment: Oracle 10g, RMAN, Data Pump, AIX, Sun M4000, EMC Storage, Sun Active Passive Cluster, Oracle Data Guard, EMC BCV for Reporting.

Confidential

Senior Database Administrator

Responsibilities:

• Installed and configured RHEL on Database Servers and Application Servers.
• Prepared and maintained customer, infrastructure, disaster recovery documentation and created DBA checklist for daily tasks.
• Migrated Oracle Databases to ASM using RMAN.
• Database Backup and Recovery operations ensuring 100% recoverability.
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.
• Created shell scripts and automated daily activities like RMAN backups, Archive log maintenance, Password changes and alert log monitoring etc.
• Monitored and optimized performance of the database, plan for backup and recovery of the database and allocate system storage and plan future storage requirements.
• Performed UAT with customer and educated customer regarding new setup.
• Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Environment: Oracle 10g, RMAN, Data Pump, HP x86 Server, HP Storage, HP DLT Tape.

Confidential

Senior Database Administrator

Responsibilities:

• Install Oracle Database on new platform and prepare it for migration and provide database support afterwards.
• Performed Oracle database configuration, monitoring, performance tuning, and patch administration with two nodes Active Passive Sun Cluster.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Database tuning methodologies and monitoring techniques.
• Created RMAN backup scripts and optimally scheduled RMAN backups across databases to relieve load on Netbackup server.
• Experience required administering database including job scheduling (DBMS JOB), backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of table spaces such as dropping/creation and modification of storage parameters.
• Generated and analyzed STATSPACK/AWR reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to Standard Oracle Applications Security

Environment: Oracle 10g, RMAN, Data Pump, SUN Active Passive Cluster, RHEL, SUN M5000, EMC Storage,.

Confidential

Database Administrator

Responsibilities:

• Install Oracle and Times Ten Database on new platform and prepare it for migration and provide database support afterwards.
• Development support for Database Maintenance jobs, application issues and Database recoveries using RMAN backup.
• Oracle installation, configuration and managing database security. Providing technical support to the application team.
• Managing datafiles, control files, online redo log files and tablespace. Performing export/import utility for logical backup and created schemas.
• Oracle 10g Architectural Components, Managing Redo log file, Managing Users, Managing Privileges, Managing Roles.
• Daily health check of Active Passive Sun OS cluster.
• Performed Oracle database configuration, monitoring, performance tuning, and patch administration.
• Optimized Oracle 10g database during Load Test with simulator and IN.
• Performed UAT test cases with customer.
• Migration with exp/imp tool to new platform.
• Working in Production environment with 24X7 Support when required for Oracle Databases.

Environment: Oracle 10g, RMAN, Data Pump, SUN Active Passive Cluster, SUN E2900, EMC Clarion Storage, Veritas Netbackup.