EXPERIENCE SUMMARY

• 12+ Years of experience in IT Industry, with an experience in Oracle Apps database administration on Redhat,Linux,HP Unix, Solaris and Windows platforms, installations, configuration and managing Oracle 8i,9i,10g,11g, 12c,18c,19c and 20c Databases.
• 5+Yrs Gloden Gate experience of installation, upgradation, maintenance, troubleshooting and monitoring.
• Ensure bi directional replication across all regions and daily resolving gloden gate abends.
• Patch Management: Extensively involved in analyzing the patches for bugs/security vulnerabilities reported and applying the patches on databases.
• Database Cloning/Migration: Extensively involved in database cloning and migration of the databases from one platform to others.
• Server Migration/Server consolidation: Migrating application across the servers in different locations and reducing server maintenance cost by consolidating non critical applications
• Data guard: Extensively involved in configuration and managing of Physical/logical Standby Databases for Disaster Recovery (DR) site
• Data transfer technologies: Well versed with data transfer technologies export/ import, data pump and SQL*Loader
• Backup and recovery procedures: Strong basics in backup, restore and recovery principals, offline/online backups and recovery matrix. Expertise in configuring RMAN and restoring the databases in different recovery scenarios. Including using FLASH BACK methods for logical recoveries.
• Advanced/New concepts in Oracle 10g/11g: Good noledge about partitioning, ASM, ASSM, AWR, ADDM, SQL tuning Advisor, Database replay and SQL Performance Analyzer.
• Real Application Clusters: Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• Installation and Configuration of Oracle Data base Server 11gr2 (Both RAC and Non RAC), 11gr1(Both RAC and Non RAC) and 10g in different operating systems.
• Hands On experience on logical standby databases configuration and maintenance.
• Hands on experience in implementation of maintenance & error reporting and successfully gained exposure in ORACLE administration by configuring & maintaining backup policies & procedures including HOT and COLD backup, cloning, Replication, Database Tuning, managing database architecture.
• Replication and Extracting data and applying on production using GlodenGate.
• Performing the oracle up gradation & applying the oracle patches.
• Involved Effectively in Physical and Logical Design of Backup and Recovery planning of Databases.
• Having a very good experience in configuring & trouble shooting the Physical Standby database (Data guard) & DG broker configuration.
• Manage No SQL and SQL Server databases.
• Experience on Postgress database.
• Knowledge of AZURE cloud computing basics.
• Hands on experience in cloning database in Standalone and RAC environment using traditional backup and restore method and RMAN duplication

TECHNICAL SKILLS

HARDWARE: Intel Pentium III, IV, DEL POWER system.

OPERATING SYSTEM: SSolaris 10, Linux RHEL6/7, Windows 10

LANGUA: GESSQL, PL/SQL, Unix Shell Scripting, Perl, Oracle Utilities

DATABASES: Oracle10g, Oracle11g, Oracle RAC, Oracle 12c,Postgress

TOOLS & UTILITIES: Enterprise Manager, SQL*Plus, Import/Export,Datapump, Pgadmin, RMAN,SRVCTL,CRSCTL Grid Control, Control - M,Toad,Putty,F-secure,VNC Server,Gloden Gate,OS watcher

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

Responsibilities:

• Planning/Implementation/troubleshooting Oracle RAC, DR, Standby HA database.
• Install, configure and maintain Oracle 11g/12c Software on Red Hat Linux platform and Sun Solaris Platform.
• Install, configure and maintain Oracle 11g/12c RAC software on Red Hat Linux platform.
• Managing more TEMPthan 400 production/test/dev business critical databases of AT&T hosted across US datacenter. Production database size range from 500G to 5+TB.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Managing Oracle 10g/11g releases RAC(3-6 Nodes) database in production and development environment
• Gloden Gate database replication setup and troubleshooting.
• Closely work with Dev and testing team to fix the performance issue.
• Upgradation of database from 10g to 11gR2 and 11gR2 to 12C.
• Refresh UAT/DEV Database with development to perform periodic testing.
• Working on backup strategy for production and UAT database
• Extensively use O/S commands, Oracle system tables TKPROF, AWR, ADDM reports and other 10 & 11i features to identify and fix performance/locking issues.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning
• Work with the application team to ensure dat backout scripts and procedures are in place before releasing changes into production.
• Installation of RAC on 4 node, 6 node cluster and standalone server.
• Analyzing the AWR report for DB Performance issues.
• UNIX Shell scripting and SQL scripting
• Worked on OEM and Grid control for regular database maintenance
• Setup of High Availability of the database using RAC, Standby, Data guard.
• Raising SR with ORACLE for any issue.
• Solution EnvironmentOperating system: Windows 2008, AIX, Red hat Linux
• Database: Oracle 12c/10g/11g

Confidential, FL

Oracle DBA

Responsibilities:

• Glodengate bidirectional replication between NAM,LATAM, EMEA, APAC and unidirectional replication between APAC to KR,APAC to IDN,LATAM to MX.
• Experience in replication using gloden gate, materialized views.
• GG standadization and heart beat monitoring implemetation.
• Replication and Extracting data and applying on production using GlodenGate.
• Migrated physical standard files to ORAAS files and Implemented ORAAS databases.
• Hands on experience in implementation of maintenance & error reporting and successfully gained exposure in ORACLE administration by configuring & maintaining backup policies & procedures including HOT and COLD backup, cloning, Replication, Database Tuning, managing database architecture.
• Performing the oracle up gradation & applying the oracle patches.
• Involved Effectively in Physical and Logical Design of Backup and Recovery planning of Databases.
• Having a very good experience in configuring & trouble shooting the Physical Standby database ( Data guard) & DG broker configuration.
• Hands on experience in cloning database in Standalone and RAC environment using traditional backup and restore method and RMAN duplication
• Solution EnvironmentOperating system: Windows 2008, AIX, Red hat Linux
• Database: Oracle 12c/10g/11g

Confidential

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle Data base Server 11gr2 (Both RAC and Non RAC), 11gr1(Both RAC and Non RAC) and 10g in different operating systems.
• Experience in replication using gloden gate, materialized views.
• Replication and Extracting data and applying on production using GlodenGate.
• Hands on experience in implementation of maintenance & error reporting and successfully gained exposure in ORACLE administration by configuring & maintaining backup policies & procedures including HOT and COLD backup, cloning, Replication, Database Tuning, managing database architecture.
• Performing the oracle up gradation & applying the oracle patches.
• Involved Effectively in Physical and Logical Design of Backup and Recovery planning of Databases.
• Having a very good experience in configuring & trouble shooting the Physical Standby database ( Data guard) & DG broker configuration.
• Hands on experience in cloning database in Standalone and RAC environment using traditional backup and restore method and RMAN duplication
• Solution EnvironmentOperating system: Windows 2008, AIX, Red hat Linux
• Database: Oracle 10g/11g

Confidential

Responsibilities:

• Installation and Configuration of Oracle Data base Server 11gr2 (Both RAC and Non RAC), 11gr1(Both RAC and Non RAC) and 10g in different operating systems.
• Implemented Gloden Gate technology for optimized results to customer.
• Hands On experience on logical standby databases configuration and maintenance.
• Hands on experience in implementation of maintenance & error reporting and successfully gained exposure in ORACLE administration by configuring & maintaining backup policies & procedures including HOT and COLD backup, cloning, Replication, Database Tuning, managing database architecture.
• Performing the oracle up gradation & applying the oracle patches.
• Involved Effectively in Physical and Logical Design of Backup and Recovery planning of Databases.
• Having a very good experience in configuring & trouble shooting the Physical Standby database ( Data guard) & DG broker configuration.
• Hands on experience in cloning database in Standalone and RAC environment using traditional backup and restore method and RMAN duplication
• Solution EnvironmentOperating system: Sun Solaris,Windows
• Database: Oracle 10g/11g/12c

Confidential

RoleOracle DBA

Responsibilities:

• Creation and maintenance of oracle databases
• Experience in Oracle HA (highly available) database environments & solutions such as RAC & Gloden Gate database replication (active/passive & active/active).
• Privileges, Roles and Users Management
• RMAN backup and restore
• Export & Import of tables, schema and database using logical and datapump
• Troubleshooting with problems regarding the databases and applications
• Tuning of the database instances.
• ADDM and AWR reports generation
• Performing Health check of Oracle databases
• Solution EnvironmentOperating system: Windows 2008, AIX, Red hat Linux
• Database: Oracle 10g/11g

Confidential

Oracle Apps DBA

Responsibilities:

• Oracle RAC installation
• Creation and maintenance of oracle databases
• Dataguard implementation and maintenance.
• Privileges, Roles and Users Management
• RMAN backup and restore
• Export & Import of tables, schema and database using logical and datapump
• Troubleshooting with problems regarding the databases and applications
• Tuning of the database instances.
• Statspack, ADDM and AWR reports generation
• Pre-patch analysis for the patches and document preparation with pre and post installation steps
• Performing Health check of Oracle databases
• Database Migration(HPUX to Windows) and upgrade
• Solution EnvironmentOperating system: Windows 2000,HP-UX,Solaris,RedHatLinux
• Database: Oracle 10g/11g
• ToolsSQL *Plus, OEM, TOAD, RMAN, Exp / Imp, SQLDR.

Confidential

Responsibilities:

• Creating and maintaining all Databases required for development, testing, staging and production usage
• Performing RMAN backup and Restore in different instances
• Supporting issues as per SLA
• Privileges, Roles and Users Management
• Segment Space & Extent management
• Export & Import tables, schema & database
• Preparing Known Error Database ( KEDB )
• Weekly once Production bounce
• Solution EnvironmentOperating system: Windows XP/2000,HP Unix, Solaris
• Languages: Unix, SQL
• Database: Oracle 10g / 9i
• ToolsTOAD, Developer 2000(D2K)