SUMMARY:

• Lead/Architect database design and implementation role since 1998
• 13 years of Software industry experience in various business industry like finance, insurance & retail
• Expert database dba engineer; noSQL and relational data modeling, object - relational integration (ORM), physical design/tuning/backup & recovery with proven ability at Server side & Client side responsibilities. Specialized with Oracle, Cassandra, Hadoop
• Expertise in handling 24X7 mission critical production databases
• Successfully implemented the offshore model for production databases via cross-.
• Specializes in Oracle Parallel Server (OPS), Real Application Clusters (RAC) and Transparent Application Failover (TAF). Also, tuning of massively parallel Oracle databases.
• Worked extensively in designing and implementation of Oracle Goldengate data replication in a high performance, highly available production environment. Used the tool for bi-directional & heterogeneous replication. Ongoing support and problem determination of Goldengate data Replication issues, including identifying database lag and resolving data inconsistencies.
• Implemented Oracle Exadata in production environment.
• Specializing in creating database architectures Physical/Logical model using Erwin.
• Advanced skills with Quest Confidential 4.5/5.3 used in many project as an replication tool used for bi-directional replication
• Demonstrated and proven skills as a Project Manager/Lead in large scale projects.
• Running knowledge of Oracle Streams which can be used for replication, message queuing, loading data in data warehouse, event notification & data protection.
• Knowledge of SOX/PCI compliance.
• Flexible to adopt new environment and willing to learn new technology.
• Specializing in Oracle Application, people soft, data-warehouse migrating Oracle apps from 11.0.3 to 11.5.9 .Cloning and Patching of Oracle Applications.
• Experience includes very good analytical, technical, interpersonal and communication skills, coupled with effective management of work, team spirit and client interaction.
• Experience with Postgres Database .Converted an Oracle database to Postgres using ora2pg.
• Specializing in design, implementation, and support of solutions in Cassandra 1.6/1.7 supporting up to 50 node cluster, Apache Hadoop CDH4.3 Gen 1/Gen2 supporting up to 200 cluster nodes using CQL, JCONSOLE & OpsCenter.
• Experience in supporting Apache Hadoop CDH4.4 using HIVE/PIG/OOZIE/HBASE/HUE. Configuring flume agent for data collector & Oozie for scheduling jobs .
• Experience with Sqoop for migrating unstructured data from Oracle to Cassandra.
• Installation/Configuration of Cloudera Manager .

PROFESSIONAL EXPERIENCE:

Database Architect Engineer

Confidential, San Carlos, CA

Responsibilities:

• Designed and implemented a Cassandra noSQL based database and associated RESTful web service that persists high-volume user profile data for vertical teams. Migrated high-volume OLTP transactions from Oracle to Cassandra in order to reduce Oracle licensing footprint. Created architecture stack blueprint for data access with NoSQL; used as the technical basis for new Cassandra projects. Lead role in NoSQL column family design, client access software, Cassandra tuning; during migration from Oracle based data stores.
• Providing Database support by building strategies/plan for migrating production databases. Involved in building/monitoring entire Hadoop CDH 4.3 100 data node cluster using cloudera Manager.
• Performed manual upgrade of hadoop cluster from CDH4.2 to 4.3. Installed/setup different aspects of hadoop like HIVE/HUE.
• Involved in building entire Cassandra cluster ring of 50 nodes & monitored using OpsCenter.
• Involved in Performance issues facing Cassandra & Hadoop cluster. Responsible of taking routines backup & restoring in case of emergency
• Confidential have variety of products deployed on phone to optimize wireless network traffic. It comprise of a client component and a server component. The client extends carrier control over mobile data traffic to the source - the mobile handset. The server provides a centralized platform for defining the policies that govern mobile traffic management and optimization.
• Customers who have chosen for deployment model at Confidential . The Seven clients reside on phone as one of the application. The relay server receives request from the client & pass it to server component (web server). Flume agent resides on web/application server start collecting data and integrates to Hadoop using flume data collector on server side. Web/application server do provide data to Oracle & Cassandra cluster for optimization depending upon kind of activity performed by the phone.

Database DBA/Architect Engineer

Confidential, Sanjose, CA

Responsibilities:

• Confidential /PayPal is highly transaction based with 10,000 transaction per second & around 200 payment per second & databases ranges from 5TB to 80 TB. There latest POS project total rollout to home depot had 500 payment per second challenges. Accepting that challenge worked on deploying a full bloom test RAC using infiniBand was setup & with using software like SLAMD extensive testing was done before deploying in production.
• Confidential /PayPal IDI environment which extensively involves OLTP & OLAP workloads. Working as a chief consultant in designing/implementing there Exadata pilot . Deploying to production is currently in process.
• Perform data replication using Goldengate via setting up extracts in production databases which generates trail files at the target & using replicates setup real time replication at datawarehouse database.
• Used Oracle Goldengate for data center migration
• Consultant to data center move from Phoenix to Salt lake. Build entire SLC datacenter using oracle standby technology & used switchover/failover command for data center move .Tested Disaster Recovery process during this move.
• Worked with PayPal Application support team which precisely go through each & every DML/DDL going through via properly analyzing its explain plan in detail meeting with production architect, storage team & implementing these bundled changes from pushes & urgent changes with ISO.
• PayPal is moving for Big Data solutions(petabytes of storage) so currently analyzing Apache Hadoop and Cassandra, a framework that allows for the distributed processing of large data sets using a simple programming model & other Mongo DB an open source NoSQL scalable, distributed database. Attended an in house on both solutions.
• I am involved extensively in design, implementation, and support of solutions in Cassandra 1.6/1.7 DSC 3.2, Hadoop CDH 4.4 Gen1/Gen2.

Sr Pr inc IT Infrastructure Specialist

Confidential, Mountain View, CA

Responsibilities:

Providing database support for Datawarehouse databases .Also working as a Confidential administrator, responsibilities includes setting up and maintaining data replication between databases . Worked on projects like SYMC BO. Providing 24/7 production support to consumer system, Datawarehouse system, marketing external/internal

Sr Pr inc IT Infrastructure Specialist

Confidential, Mountain View, CA

Responsibilities:

Providing database support for databases .Also working as a Confidential administrator, responsibilities includes setting up and maintaining data replication between databases . Worked on projects like Atlantis, payment reporting, my-Symantec, billing reporting and syslog, Customer Portal, Fusion Infrastructure, Providing 24/7 production support to consumer system, marketing external/internal

Sr Oracle DBA

Confidential, Sacramento, CA

Responsibilities:

• Confidential / Confidential system has 2 AIX Server Clustered with Raw devices on EMC Storage (HACMP Software running between the cluster)also an non clustered AIX machine with Confidential running on it for entire cluster crash
• Basic objective is to test Oracle High Availability using RAC with Confidential on top of it.
• Hardware was multiple AIX platforms in both production and DR sites with EMC SAN technology providing on-line storage.
• System was implemented to allow complete failover with no downtime and to allow company to access provider related information and facilitate business reporting.
• PINS system (Provider Information and Negotiation System) has 5 servers ( 2 on VMS and 3 on Ingres II). Currently this system maintains provider related information.

Oracle DBA

Confidential, Minneapolis, MN

Responsibilities:

• Confidential + system, originally developed by ITDS (AMDOX), is a telephonic recording Information system distributed across multiple machines and configured in a heterogeneous computing environment. It consists of all functionality of a telephonic recording system. There are 12 Interfaces which runs on it I am basically involved in the interface called Data warehouse
• My role is to maintain Data warehouse box on which Oracle 8.0.5 was installed. All the 12 interface runs on a backend Oracle 8.0.5
• As they have 15 markets each market runs on a separate Oracle 8.0.5 Server.
• All these 15 identical databases go to a single database box (Data warehouse).

Oracle DBA

Confidential, Dallas, TX

Responsibilities:

• Confidential order entry, originally developed by Confidential (RSA), is an application distributed across multiple machines and configured in a heterogeneous computing environment.
• It consists of all functionality of a retail system starting from sales quotes/sales order generation to actual shipping of material from warehouse.
• Interfaces are run at predefined intervals for smooth transfer of both file and transactional data between heterogeneous environment while supporting queuing, reprocessing of transactions, transaction logging and error recovery and administrative control.Status: US Citizen Willingness to travel: Up to 10% travel

Professional

• Oracle 9i/10g/11g RAC, Oracle Data Guard, Oracle Streams, Installing & patching of Oracle Applications from Oracle Corporation, Redwood Shores.
• in Oracle12C from Oracle,Apache Hadoop from Cloudera & Cassandra from Datastax .
• Confidential from Quest Inc, Datawarehouse Database Design and Development from Oracle Corporation.
• Oracle Financials from Radiant Computer, Dallas TX
• ed twice by Confidential (Software Consultancy ) as a as TOP 10 on Programming Skills, Team Work and Adherence to Keep Schedule