SUMMARY

• Over 6 years of experience as an Oracle Database Administrator having hands - on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security, implementing TDE, writing stored procedures and providing 24*7 support for multiple OLTP database and data warehousing environments on various platforms Experience on high volume databases with sizes varying from 50 GB to 200+ TBs of data on various version of ORACLE 12c/11g/10g/9i.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Performed the 12c Upgrade of RAC cluster ware from 11g.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Configure high availability systems like Data Guard and RAC environments.
• Installed and Administered Oracle 12c, 11g ASM & 10g RAC with ASM & Oracle Clusterware File System (OCFS2).
• Installation, Configuration, and Maintenance of Logical/Physical standby databases in Data guard.
• Configured multiple database instances using a single ASM instance.
• Providing DBA support to multiple Cluster, Non-Cluster, and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid).
• Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Configured Oracle Golden Gate for bi-directional replication and migrated databases with ZERO downtime.
• Extensive troubleshooting of typical Oracle Golden gate technical issues: such as differences in the rows countfrom source to target, column mismatch errors, unique key violation by using ggsci / log dump/discardfile & ggserr.log analysis.
• Minimized downtime, installation errors, and ensured standards of conformity by performing DBA consultation and tasks for software installation, upgrades, and production support for applications like Banner, ProSam into Oracle RDBMS databases.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, Erwin Data modeling, OLAP, Oracle Data Dictionary - metadata, Logical and Physical Database Design.
• Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Responsible 24x7 production operations (incident break/fix, change, service requests, management) and On-Call rotation.

TECHNICAL SKILLS

ERP: Oracle Re12/11.5.10

Operating Systems: Windows, UNIX flavors (Solaris, AIX 4.3.3, Linux)

Languages: SQL, SQL*PLUS, PL/SQL, C

RDBMS: Oracle 12C- 7.1, SQL Server, Ms-Access

GUI Front end tools: Developer9i/6i Forms 9i/6i, Reports 9i/6i

BRTools: Developer/2000 Forms 4.5, Reports 2.5, VB 5.0

Other Software: SQL*Loader, Office2000, TOAD

PROFESSIONAL EXPERIENCE

Confidential - New York

Oracle DBA

Responsibilities:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Cluster ware, Oracle 12c two node RAC for the database tier.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Data guard.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High Availability, Golden Gate Technologies.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Installed Oracle Enterprise Manager Grid control 12c/13c for monitoring databases.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c and 13c.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Performance tuning of Oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Upgraded Oracle RAC databases from 10g to 11g.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
• Provided L2 and L3 production support depending upon the ticket assigned to meet the corresponding SLA's.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with an on-call pager.
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: s: Oracle 12c,11g R1,11g R2, OEM 12c/11g, RHEL6, AIX6, GG 12c/11g, SQLPLUS, TOAD, SQL DEVELOPER,Banner8.2,Banner8.2to9.0,Putty,SecureCRT,ASM,PL/SQL.

Confidential, Greenwood Village - CO

Oracle DBA

Responsibilities:

• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.
• Expertise in moving databases to Exadata and Involved in migration strategies.
• Implemented several new features in Exadata concepts like Hybrid Columnar Compression (HCC), Smart Cache, Storage indexes and cell offload processing.
• Familiarity with Cell CLI tool to manage the Exadata storage cells.
• Involvement in space management, rectification of lock problems, managed quotas.
• The configuration of Listener and Net Service names using NETCA.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Strong Exposure in creation on an Oracle 12c Multi-tenant RAC database with 2 node cluster and instances using ASM storage.
• Performed Database Performance and Tuning on the DB2 LUW versions 9.7, 10.1, 10.5. The upgraded database from DB2 LUW 9.7.4 to DB2 LUW 10.1.3.
• Worked on Multiple RAC clustered, converting single node instance to RAC and adding an instance to the existing 5 Node RAC.
• Configured Data Guard for disaster recovery purposes.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Failover and Switchover cases.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
• Cloned schemas, objects and data on the new server using Data pump.
• Responsible for capacity planning, recovery planning and installing patches.
• Performed cloning and refresh of Database from the production environment to test environment using RMAN Duplicate database and Data pump import-export.
• Migrated OLAP databases close to 8TB with minimal downtime using Golden Gate and verified data integrity using Golden gate Veridata tool for Linux 3 Node RAC.
• Configured and implemented Oracle Golden Gate replication.
• Resolving the conflicts between the target and source database in Oracle Golden Gate.
• Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
• Implemented Oracle Advanced Security to provide the most cost-effective solution for comprehensive data protection.
• Used TOAD as third-party software for analyzing the database issues and generating results sets in xls formats.

Environment: s: Oracle 10g/11gR2, OEM, Data guard, SQL Loader, RMAN, Data pump, MS*SQL, Netapp, Oracle 12c RAC LINUX, ASM, PL/SQL, GOLDEN GATE.

Confidential, Texas

Oracle DBA

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle server.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
• Creating databases, Objects, Roles, and privileges.
• Partitioned large tables to increase the performance.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Use TOAD tool to access the database.
• Testing PL/SQL procedures against the test cases.
• Involved in checking the status of the listener and restarting the listener.
• Performed auditing on user activities on request and per organization policies.
• Created and managed database objects like tablespaces and increase the size of the tablespace by resizing and adding the data files.

Environment: s: Used: Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g and 11g databases on OEL.
• Involved in the construction of DR sites for all the Production databases.
• Involved in installation and maintenance of Oracle RAC for high availability.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date and associated with RMS.
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Scheduling the databases backup using Crontab and VERITAS net backup.
• Installation, migration, upgrade, patching and administration of Oracle and SQL server databases.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Involved in implementing load balancing and testing failover on RAC database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.
• Involvement in space management, rectification of lock problems, managed quotas.
• The configuration of Listener and Net Service names using NETCA.
• Working Knowledge of installation and configuration of GOLDENGATE in UNIX environment.
• Done Installation and configuration of the golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in the golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients
• Cloned schemas, objects and data on the new server using Data pump.
• Worked extensively on monitoring 10G Grid Control database, the configuration of error notifications, installing listeners, and adding them to the grid control.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: s: Oracle 11g/10g, OEL, HP-Unix 11.11, Red Hat Enterprise Linux, RAC, ASM, SQL*Plus, OEM, PL/SQL, SQL Developer, Data Pump, TOAD.

Confidential

Oracle DBA

Responsibilities:

• Install, configure and upgrade the server to suit the database needs
• Installation of Oracle 10g on Linux and Windows
• Installation, configuration and maintenance of Oracle 10g and 11g databases on AIX.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative and scheduling the databases backup using Crontab.
• Design automated systems to mine information and make reports
• Include objects in a database like tables, views, functions, triggers, etc.
• Control the access for the database by giving security password and permission.
• Set up and administer user and groups accounts, setting permissions for users.
• Creation and administration of Virtual Machines using VMware and virtual box.
• OS upgrades and installation of third-party software, packages, and patches as per requirement.
• Maintaining the Linux Firewall for network and implement to the network security.
• Troubleshooting the network with the help of netstat, ping, nslookup and traceroute tools.
• Package development and performed SQL & data migration for SQL 2000 to SQL 2008. Extremely familiar with SDLC and ETL processes.
• Design the schemes, permissions, and tables for the database as appropriate for its use
• Managing Instances, Data-dictionary views, control files, redo log files, Tablespaces, Data files, storage structures, rollback segments, Temporary segments, Indexes.
• Data file locations, Redo Logs locations, and Control files locations; check Tablespace, data files free space.
• Check shell scripts, and PL/SQL scripts if any is used.

Environment: s: Oracle 11g/10g, OEL, HP-Unix 11.11, Red Hat Enterprise Linux, RAC, ASM, SQL*Plus, OEM, PL/SQL, SQL Developer, Data Pump, TOAD.