EXPERIENCE SUMMARY:

• A professionally qualified Oracle Certified Professional (OCP) having 8+ years of professional experience.
• My area of expertise is on Oracle and HADOOP Administration including Oracle RAC, Data Guard, GoldenGate,
• Exadata and expertise in configuration of HADOOP technologies HDFS, Zookeeper, Flume, Pig, Hive, Oozie, Sqoop, Impala and implementation of SAP HANA.
• Installing and Administration of Hadoop Distribution and its Eco System
• Administration of Map Reduce Jobs - Pig, Hive, Oozie, Sqoop.
• Installing and Administration Namenode and Jobtracker High Availability
• Building HBASE Infrastructure
• Monitoring Tool - Ganglia
• Monitor Hadoop cluster job performance and capacity planning
• HDFS support and maintenance
• Adding/Removing a Node in the cluster & Data Rebalancing.
• Maintaining backups for name node
• Experience with ETL processes.
• Expertise in shell scripting
• Installation and configuration of database.
• RAC Installation and configuration
• Backup & recovery of database.
• Active Data guard configuration.
• Experience in fixing issues of oracle database 8i/9i/10g/11g.
• Migrating databases from file systems to ASM.
• Upgrading databases from one version of oracle to higher version.
• Experience in various scenarios of Database Recovery.
• Cloning of production databases for creation of DEV/UAT environments.
• Database performance monitoring, database parameters tuning.
• Performance Tuning of the databases/SQL/AWR Report analysis.
• EXADATA installation and configuration
• Oracle GoldenGate:
• Installation of GoldenGate.
• Design and configuration of GoldenGate.
• Bi-directional and Multi master setup.
• GoldenGate flat file writer configuration.
• Conflict resolution handling.
• Upgrades and Patching of GoldenGate.
• Installation and configuration of HANA.
• Standalone and cluster setup.
• Configuration changes to global.ini
• Troubleshooting OOM and MVCC issues.
• ITIL V3 Certified

TECHNICAL SKILLS

Software Products: HADOOP CDH4.x, HDFS, MapReduce, Hbase, Pig, Hive, Oozie, Impala, Oracle 8i/9i/10g/11g, Oracle Golden Gate, Oracle EXADATA, SAP HANA SP7/SP8

High Availability: 11g,10g RAC, ASM, Data Guard, Replication, Oracle Golden Gate, Oracle streams, 11g/12c Grid Control, SRVCTL, CRSCTL, ASM

Oracle Tools: SQL*PLUS, SQL*Loader, Export/Import, Data pump, RMAN, TKPROF, AWR / STATSPACK, ADDM, ASH, RMAN, Listener & Service Configuration, OEM

Operating System: UNIX, Red Hat Linux 3x/4x/5x, AIX 5.1/5.2/5.3/6.1 , Sun Solaris 2.5/ 2.6/ 8/ 9/ 10 , Windows 95/98/NT/2000/2003/XP, HP-UX 11.x/10.x

Language: UNIX Shell Scripting, SQL, PL/SQL, Java, C/C++

Protocols: FTP, PSFTP, WINSCP, Telnet, TCP/IP

Others: Perforce, BMC Remedy, HP Service Manager, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, C

Sr. Database/Hadoop Administrator

Responsibilities:

• Responsible for maintaining Confidential - S4, Buyer and Confidential Network (AN) databases.
• 24*7 production Support for mission critical production systems
• Installing and Administration of Hadoop Distribution and its Eco System
• Administration of Map Reduce Jobs - Pig, Hive, Oozie, Sqoop.
• Installing and Administration Namenode and Jobtracker High Availability
• Building HBASE Infrastructure
• Monitoring Tool - Ganglia
• Monitor Hadoop cluster job performance and capacity planning
• HDFS support and maintenance
• Adding/Removing a Node, Data Rebalancing.
• Maintaining backups for name node
• Expertise in shell scripting
• Experience with ETL processes.
• Monitoring space, wait events, locks and long operations running on the database
• Tuning the SQL statement by analysing the explain plan and ADDM reports
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Configuring alerts using shell script for critical database issues and scheduling them using crontab.
• Day to day troubleshooting of problems faced by end users.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Design and development of backup/recovery strategies using Oracle RMAN, Expdp and HP-3PAR Tape backup.
• Involved in monitoring daily Jobs for RMAN Backups, Data guard Standby validation, LOG Shipping, CRS Processes, Listeners and Sessions.
• SAP HANA Database installation and configuration

Solution Env: HADOOP, Oracle 9i/10g/11g, SAP-HANA Database, JAVA, JIRA, Perforce.

Confidential

Sr. Database/Hadoop Administrator

Responsibilities:

• Responsible for maintaining Confidential - Legal Dept databases. We support mission critical databases
• Migrating data from one database to the other using Export and Import Utilities
• Upgrade of the databases from 10g to 11g
• Installing and Administration of Hadoop Distribution and its Eco System
• Administration of Map Reduce Jobs - Pig, Hive, Oozie, Sqoop.
• Installing and Administration Namenode and Jobtracker High Availability
• Building HBASE Infrastructure
• Monitoring Tool - Ganglia
• Monitor Hadoop cluster job performance and capacity planning
• HDFS support and maintenance
• Adding/Removing a Node, Data Rebalancing.
• Maintaining backups for name node
• Backup and Recovery of databases using Recovery Manager
• Work with Oracle support by creating SR’s for any seeded application/database functionality.
• Monitor and tune the performance for the production instance
• Expert in configuring and monitoring DATAGUARD for physical standby databases with real time apply, data guard broker and active data guard
• Implementing Huge pages configuration on Linux for bigger memory databases.
• Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM)
• Database and Clusterware upgrade from 11.2.0.2 / 11.2.0.3 to 11.2.0.4 applied the latest PSU’s
• Converting GoldenGate Classic Capture to Integrated Extract
• Performed a Rolling forward on Standby database using RMAN Incremental Backup for un-resolvable large archive gap
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Managing Oracle full, half Exadata systems for performance, patching, hardware issues and consolidation of databases
• Solid understanding of key Exadata features including Hybrid Columnar Compression, ExadataSmart Flash Cache, Exadata Storage Index and Exadata Storage Management & Administration
• Experience in Software and firmware maintenance of Exadata Storage Cells including upgrades andpatching
• Assisted in consolidation, integration and migration of Oracle database to Exadata with Golden Gate, dataguard

Solution Env: Oracle 9i/10g/11g, GoldenGate, Exadata, HADOOP, JAVA, Shell Script

Confidential

Sr. Software Engineer

Responsibilities:

• Support GoldenGate product for the global customers which include handling of SR’s for various issues faced by the customers.
• Understanding the existing environment and daily interaction with customers as part of trouble shooting the issues and providing best in class solutions.
• Trouble shooting and providing the best in-class solutions.
• Expertise in design and developing architectural solutions using Oracle Golden Gate with customized data transformations.
• Solid Knowledge in configuring Golden Gate, implementing initial loads, Uni-directional and bi-directional replications and troubleshooting extract/replicate process.
• Leads the diagnosis of database and Golden Gate replication issues.
• Golden Gate trails encryption according to data security standards.
• Expertise in implementing, configuring Golden Gate for Oracle database migration.
• Test initial Data Load option of Golden Gate during environment build and Investigate Replication failures using Log Dump utility.
• Troubleshooting Golden gate issues like data sync issues, trail file corruptions, network issues, ETROLLOVER and writing exceptions.

Solution Env: Oracle 9i/10g/11g, GoldenGate 10.4, 11.1.x

Confidential

Oracle Database Administrator

Responsibilities:

• 24*7 production Support for SONY production systems - Sony PS3 databases.
• RMAN backup configuration to Tape backup for TSM.
• Using BRBACKUP tool for backup of Oracle databases(For SAP related applications)
• Understanding the existing environment and preparation of Document of Understanding.
• Identifying the risks and projecting to the management.
• Client coordination in implementing the agreed SLA’s.
• Configuration of Active Data Guard and Data guard Broker.
• Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery
• Analysing the database performance and proactively monitoring the alerts.
• Database refreshing from production to testing using Exp/Imp
• Provided maintenance of user accounts, privileges, profiles and roles

Solution Env: Oracle 8i/9i/10g/11g, RMAN, RAC, DGMGRL

Confidential

Oracle Database Administrator

Responsibilities:

• 24*7 production Support for production systems
• Installing and configuring CRS on all cluster nodes with ASM, Configuring public, private, virtual ip addresses for the servers, shared storage for Voting disk and OCR on raw volumes
• Installation and Maintenance of Oracle 9i, 10g on IBM-AIX, LINUX and Windows platforms
• Upgrade Oracle 9i to 10g on Sun Solaris, AIX, HP-UX, Redhat4.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability
• Implemented the Oracle 10g Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases
• Applied Patches on RAC, Standalone, Standby databases based on the requirements
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base
• Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities
• Planned and configured disk layout, mount points and capacity requirements for servers
• Conducting DR Drills / Restoration Drills
• Generating the necessary convert and transport scripts required for cross platform migration from Sun Solaris to HP-UX
• Using RMAN CONVERT DATABASE, migrated the database into ASM enabled 2 node RAC
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the session waits for the database performance and resolving the performance issues
• Monitoring the database for growth and added space to the table spaces as per demand.
• Generating AWR/statspack reports on regular basis to identify the database performance at peak load
• Movement of data from Production to History database using transportable tablespace method
• Tuning the SQL statement by analyzing the explain plan and ADDM reports