SUMMARY

• Over 8+ 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 Clustureware 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.
• Participated in implementation and maintenance of Golden Gate replication and troubleshooting the GG abends.
• 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.
• Attended Developer’s code review meetings and made recommendations to improve Efficiencies.
• 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

Operating System: HP-UX 10.x/11.x, IBM AIX 6.x/7.x, Sun Solaris 8/9/10/11, Linux /5.x/6.x/7.x and Exadata X3-2, X2-2, X3-5

RDBMS: Oracle 9i, 10g, 11g, 12C, oracle 10g/11gR2/12c RAC and MS SQL server

Database Servers: Oracle Application Server 10g, HP 700 Series, HP Superdome, Sun Enterprise 450 &880, Sun 3500, 3800, 6800, Sun fire 4800, V1280, Dell PowerEdge.

Languages: SQL, SQL *Plus, PL/SQL, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Golden gate, Erwin, TOAD, Shareplex, OEM12c/13c

Tuning tools: TK PROF, EXPLAIN PLAIN, STATSPACK, SQL*TRACE, AWR, ADDM.

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn,NYC

Sr. Oracle DBA

Responsibilities:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Clusterware, Oracle 12c two node RAC for the database tier.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• 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.
• As part of the Support team we provided L2/L3 level support to the application teams during high risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments.
• Provided L2 and L3 production support depending upon the ticket assigned to meet the corresponding SLA's.
• Developed scripts to proactively monitor and databases and alter the DBA on events such as running out of extents, disk space and actively involved in shell scripting for various CORN jobs to be run.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: Oracle 12c,11g R1,11g R2, OEM 12c/11g, RHEL6, AIX6, GG 12c/11g, SQLPLUS, TOAD, SQL DEVELOPER, Banner 8.2, Banner 8.2 to 9.0, PuTTy, Secure CRT, ASM, PL/SQL.

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• 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 Cron tab.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, 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 CellCLI tool to manage the Exadata storage cells.
• Involvement in space management, rectification of lock problems, managed quotas.
• 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 data base 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. Upgraded database from DB2 LUW 9.7.4 to DB2 LUW 10.1.3.
• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Expert in performance tuning of database, memory & I/O. used tools such as AWR, ADDM, STATSPACKING, HANG ANALIZE, SYSTEM STATE and analyzing queries using EXPLAIN PLAIN, SQL-TRACE, TKPROOF, OEM.
• Worked on Multiple RAC clustered, converting single node instance to RAC and adding 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 Fail over and Switch over cases.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
• Cloned schemas, objects and data on new server using Data pump.
• Responsible for capacity planning, recovery planning and installing patches.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Installed 12c agents on hosts and discovered targets.
• 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.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• 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.
• Implemented Advanced Security in different database one as Transparent Data Encryption and other as Oracle Data Redaction.
• Used TOAD as third party software for analyzing the database issues and generating results sets in xls formats.
• Handled all daily DBA activities and experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Involved in 24x7 production database maintenance and on-call support.

ENVIRONMENT: Oracle12c/11g/10g/9i,Oracle EXADATA X2-2 HALF RACK, Sun Solaris, Red Hat Linux, RMAN, SQL server, Data Guard, Golden Gate,OEM, Grid Control, Toad 10.X, STATSPACK, AWR, Explain Plan.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle Enterprise Manager Grid Control 12c on RED HAT LINUX.
• Implemented Golden gate for data recovery and data migration for Oracle 11gR2 RAC 2 nodes on RHEL and debugging Golden gate issues such as extract or replicate rebuild and abend.
• Implemented oracle 11g new features like real application testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RACASM.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Created new Groups, Templates, and Incident Rule sets in OEM 12C.
• Performed full and incremental Backup Using RMAN Utility for Production databases.
• Involved in upgrading the databases using Database Upgrade Assistance (DBUA).
• Automated gather stacks as a cloud job in OEM 12c.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Manually created databases in RAC on ASM and configured RMAN and registered databases in catalog server.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC and Data Guard.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database.
• Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design.
• Experience in Design, Creating and maintaining the Oracle Databases 11g from the scratch on UNIX and RHEL.
• Involved in the Migration projects extensively using Data pump and RMAN utilities.
• Developed the Perl and Shell scripts to automate the finance-billing file.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB. Experience in moving the data from one server to another server using SFTP and SCP.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Installed and configured Golden Gate replication and migrated databases with Zero down time using Golden Gate and Data guard.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Used RMAN for backup and recovery and performed backup validations using RMAN, Tivoli storage manager (TSM) and NetBackup.
• Performed Cloning of databases from 10g and 11g databases using RMAN duplication.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Performed Hot backup, cold backup and incremental backup for production database using RMAN.
• Performance Tuning for the SQL queries by scrutinizing the long running Sql queries.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

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

Confidential, Augusta, ME

Sr. Oracle DBA

Responsibilities:

• Install, upgrade, and patch Oracle 10g and 11g database; upgrade Oracle Database Server from 10g to 11g; upgrade Oracle Application Server from 10g to Oracle Fusion Middleware 11g; establish and maintain database integrity; perform disaster recovery, software and database backup.
• Installation, configuration and maintenance of Oracle 10g and 11g databases on OEL.
• Involved in 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.
• 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 backups.
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Scheduling the databases backup using Cron tab 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.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, 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.
• 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 golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in 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 new server using Data pump.
• Worked extensively on monitoring 10G Grid Control database, 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: 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 Developer/DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors and Triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• 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 listener and restarting listener.
• Performed auditing on user activities on request and per organization policies.
• Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.

ENVIRONMENT: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.