SUMMARY

• 7+ years of experience as a Certified Oracle Database Administrator having hands on experience in Database Administration, Installation, Patching, Migration, Configuration, Upgrades, Performance tuning, Backup and Recovery, Space Management, Cloning, Database Security, Auditing, RAC, Data Guard, Golden Gate,Exadata, Oracle Enterprise Manager 12c Cloud Control,.
• Proficient in installation, administering and managing Oracle 12c,11g,10g,9ion SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS and REDHAT-LINUX.
• Excellent track record in providing 24/7 on-call support for both production and development databases in result-oriented, time-critical environments.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using AWR, ASH, ADDM and Oracle Enterprise Manager.
• Extensive experience in High Availability SolutionsReal Application Clusters (RAC)Implementation, configuration, administration and troubleshooting.
• Expertise in building Standby databases, configuring disaster recovery site using Datagaurd. Also proficient with Active Datagaurd and Snapshot standby database.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution and Defrag scenarios across diverse environments.
• Experienced in applying patches including Patchsets and CPU/PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility, upgraded databases from 9i/10g to 11gR2 and 11gR2 to 12c.
• Experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full, incremental backup and implementing backup and recovery strategies.
• Experienced in using 11g features Data pump, Flash-Back Recovery.
• Performing database reorganizations, statistics and other applicable utilities to ensure proper database function and performance based on Oracle best practice methodology.
• Proficient in working with Data guard for production system in case of disaster recovery, maintained primary and standby databases with Dataguard Broker.
• Experienced in using OracleTransportableTablespaces with Cross Platform Incremental Backupfeatureallowsmigrating databases with minimal downtime.
• Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cron job and implemented VERITAS NetBackup to perform daily backups.
• Strong experience in using SQL developer, SQL*Loader, Exp, Imp, Data pump (Expdp, Impdp), Putty, TOAD, Oracle Enterprise Manager (OEM), SQL*Plus tools.
• Strong oral and written communication skills. Ability to communicate effectively with support peers, end users, and all levels of corporate management. Manage vendor communication and create/host presentations.
• Experience on Data Replication using Goldengate and Oracle Streams. Hands on experience on setting up the environment for unidirectional, bidirectional replicationusingGoldengate.
• Worked on ExadataMachine X4/X5. Good understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression,and Flash Cache.
• Scheduling jobs through Oracle Job Scheduler, Crontab (UNIX) and Scheduled Tasks (Windows).
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and ability to function successfully in a highly stressful environment.
• Hands on experience and Good Knowledge on Hadoop Admin HDFS,Sqoop, Pig, Hive, HBase, Map Reduce, Core java and Oozie.
• Experience on Installing & Configuring Clusters (Cloudera, Hattenworks and MAPR) on Redhat Linux.
• Experience on Hadoop (1x,2x) Storage, processing layer and its ecosystem tools like (Sqoop, Hive, Pig, HBase).
• Experience on Hive and HBase for Data Manipulation in Hadoop.
• Experience on developing application on Map Reduce programming model of Hadoop in java.

TECHNICAL SKILLS

Database: Oracle 12c/11gR2/11gR1/10g,9i.

Oracle Products: Real Application Cluster(RAC), Automatic Storage Management(ASM), Data guard, EXADATA, Import and Export, Data pumps, Recovery Manager(RMAN), TDE, Data Masking, Golden gate, Oracle Enterprise Manager(OEM) Cloud Control 10g,11g and 12c, Oracle Virtual Machine 3.x

Operating System: Oracle Linux (OEL) 6.3, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x 5.x, Sun Solaris 9, 10, Microsoft Windows sever, IBM-AIX 6.1.

Languages: SQL, PL/SQL, Unix shell scripting

Tools & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, SQL * LOADER, ADDM, DBCA, VERITAS, Log Miner, TKPROF, Explain Plan, AWR, ASH, Toad, Putty, ERWIN, ETL tool, Net Manager

Ticketing tools: Remidy,Maximo,SAP CRM,IRIS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA and Hadoop Admin

Responsibilities:

• Installation, configuration and upgrading of Oracle software and related products (Oracle 12c/ 11g ).
• Manages more than 300 databases (Development, QA and Production).
• Establish and maintain backup and recovery policies and procedures.
• Upgrade / Migration of databases.
• Implemented advanced RMAN concepts as the backup strategy for the production databases. Have scheduled these backups in the CRON to run at scheduled timings.
• Configured data guardon RAC databases for disaster recovery and setup the dataguard broker.
• Worked with different utilities like dataguard broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.
• Perform monitoringdatabase performance and tuning.
• Upgraded Oracle Grid Infrastructure from 11gR2 to 12cR1.
• Upgraded database from 11gR2 to 12cR1.
• Installing and configuring Oracle Enterprise Manger 12c and agents.
• Configuring and monitoring the targets in OEM 12c Cloud control.
• Installed 4-Node RAC databases in 11G.
• Switchover and Switch back the database in 11g/12c RAC.
• Providing technical support and give recommendations to development team.
• Setup and maintain documentation and standards for database administration.
• Preparation of DR policy & implementation of Oracle Data Guard.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Handling release management, problem management and change management calls.
• Coordinating and handling multiple teams for the Code releases.
• Developed shell scripting for dataguardmonitoring, purge alert logs, trace files.
• Implemented Oracle advanced security across various database levels.
• Development of PL/SQL stored procedures.
• Proficient in Oracle Materialized view replications.
• Developing shell scripts for monitoring database servers.
• Maintained L3 production on call databases timely.
• Used Data guard for data migration from various database’s.
• Installation and maintenance of Oracle 11gR2 database.
• Optimization and tuning SQL queries using AWR, ADDM, ASH, EXPLAIN PLAN and OEM.
• Maintained L3 Production, Development, Quality assurance database (QA) and Test databases.
• Worked on cross site (active-active) data replication using Golden gate.
• Installed Goldengatefor replication.
• Replicated databases using Oracle Goldengate for reporting purposes in OLTP environment with minimum lag.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup.
• Applied Patch in Exadata machines like StorageServer,DatabaseServer,Infiniband Switches Patch.and its features like smart scan, flash cache and Hybrid column compression.
• Developed and implemented Data Encryption techniques in various platforms.
• Moving data from development to production through transportable tablespace exports.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing standby database and database replication to provide high availability of database.
• Monitoring Cluster Health and Troubleshooting.
• Involved in building the new cluster in Cloudera distribution.
• Commissioning and decommissioning of nodes from Clusters in (Cloudera distribution).
• Moving data efficiently between clusters using Distributed Copy
• Responsible for Data Purging based on retention policy.
• Restore in case of physical data loss (e.g. block corruptions).
• Rebalancing of the HDFS.
• Moving/shifting nodes/roles/services to other nodes.
• Handling Failed, Job Waiting, Job Failed alerts.
• Maintaining cluster health and HDFS space for better performance.
• Handling Ganglia &Nagios alerts to handle CPU, Memory, Storage and Network.
• Developing Automation scripts for process improvements.
• Root Cause Analysis for all the failures (Systems, Ingestions, Jobs, Sync & Subscriptions) in production cluster
• Verifying log files whenever requires.
• Performing cluster/node migrations and upgrade (new hardware and/or new OS version
• And/or new Hadoop version) with OS or Hadoop tools or manually.

ENVIRONMENT: Oracle 12c, 11g / 10g / 9i, Grid Control, TOAD, UNIX HP, Red Hat Linux, Unix Sun Solaris 8 & 9 (Sun Fire 6800/6900),Microsoft Windows server 2008,Exadata,Goldengate,Hadoop Admin 2.6.5.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle versions 10gR1/R2, 11gR1/R2 on environments Solaris, Aix, Linux.
• Migrated databases from Oracle Versions 9i, 10gR1/R2 to 11gR1/R2.
• Handling Release management, Change management and Incident management calls.
• Performed various migrations from Solaris, Aix, Windows, Linux platforms to AIX.
• Performed various migration methodologies like RMAN convert, Export/Import, Expdp/Impdp, Transportable tablespaces, Cold backups and restore.
• Installed OEM cloud control 12c on AIX platform and agents on various AIX servers.
• Involved in conducting DR (Disaster Recovery) environments.
• Documented various migration methodologies.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and Exadata servers.
• Manages more than 4000 instances (Development, QA and Production).
• Automated tasks by using Shell/Perl Scripts.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, Sql Tuning Advisor.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Setup and monitoredmulti node RAC to RACData guardwith real time applyfor DR and offload backups including switchover and switchback using DGMGRL.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Worked on several databases across development, QA, UAT and PROD environments via use of command line and Oracle tools Oracle Enterprise Manager Cloud 12c.
• 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.
• RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Developed hot, cold and logical backup scripts to automate the backup procedures.
• Hands on experience in Data Vault, Advance Security (ASO), Data Encryption.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Implemented Disaster Recovery activity.

Environment: HP-UX 11.31, Linux, Oracle 11G/10G/9i(Oracle:10.2.0.4, RHEL 5.3)(Oracle 11.2.0.2,RHEL 5.4), Data Guard 10g Physical/Logical, Data Guard 11G Active Dataguard, Oracle Enterprise Manager(OEM), SQL*Loader, OEM Grid Control 12C, RMAN, Windows XP/2000.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle versions 10gR2, 11gR2 on environments Solaris, Aix, Linux.
• Schema Refresh from prod to nonprod environment.
• Setup and monitoredmulti node RAC to RACData guardwith real time applyfor DR and offload backups including switchover and switchback using DGMGRL.
• Database Capacity planning.
• Network ACL configuration.
• Applied patching on standard alone and RAC databases.
• User management.

ENVIRONMENT: Oracle 11g / 10g / 9i, Grid Control, TOAD, UNIX HP, Red Hat Linux, Unix Sun Solaris 8 & 9 (Sun Fire 6800/6900),Microsoft Windows server 2008.

Confidential

Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Installed 2-Node and 4-NodeRAC databases in 10G.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Hands on experience working and managing VLDB’s up to 5TB.
• Performed cross platform migrations from Oracle 10g to Oracle 11g ( Solaris-Linux)
• Installed OEM agents and monitored them timely.
• Replicated databases using Oracle Streams and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Experience in Oracle Clustering services, VERITAS Cluster Services VCS (Quick I/O file systems) and High Availability features.
• Hands on experience in shell scripting for dataguard monitoring, purge alert logs, trace files,
• Proficient in migrating data base from 9i/10g to 11g R2 by applying latest patch sets.
• Replicated certain columns from a table and also certain values from columns by using Oracle Streams.
• Used Oracle streams for data migration and data distribution.
• Involved in administration of over 150 Oracle 11g R1/10g R2 instances.
• Implemented Oracle advanced security across various database levels.
• Developed Oracle Forms and Reports for the user interface data load using PL/SQL and SQL*Loader and Unix scripts to download and manipulate files
• Developed and performed the quality assurance activities and unit testing.
• Proficient in Oracle Materialized view replications.
• Decommission the oracle databases which are no longer required.

Environment: IBM AIX, Linux, Windows, Solaris, Oracle 10G/9i, RAC, ASM, SAN, NAS, Data Guard, SQL*Loader, OEM Grid Control 10G, RMAN.