Aug 2019 – Aug 2020 · 1 yr · Bengaluru, Karnataka, India

• Built from Scratch - A Cloud Agnostic Data Platform using thoughtfully chosen Open Source and Horizontally Scalable Tech Stack.
• Key Features:
• Easy and Quick Onboarding: Smooth ways to get onboarded using different Pull and Push hooks.
• Data Storage: Support heterogeneous data storage solution in analytics friendly file formats on highly scalable and Distributed Storage Engine.
• Compute: Support for different compute framework available for querying and running analytical jobs.
• Data Catalog:Design and Manage schema and it's definition with Lineage and Version control.
• Workflow Management: Adhoc and Scheduled Jobs through DAG’s
• Data Access: Easily integrable with any JDBC based clients.
• Integrated with Genpact’s CORA PharmacoVigilance Product.

Aug 2018 – May 2019 · 9 mos · Bengaluru Area, India

• Built from Scratch - Data Platform using Open Source and Horizontally Scalable Tech Stack to support 100M Jio Phones.
• Key usecases catered by the platform for 100M Jio Phones :
• Push Messaging System
• FOTA [Firmware over the air]
• Appstore

Jul 2017 – Aug 2018 · 1 yr 1 mo · Bengaluru Area, India

• Architect, Design and support solution for one of World's trend setting telecom business!!
• Responsible for Modelling and Designing Solutions to cater to Million of Read & Writes per sec with latency < 10ms.
• Design solutions to provide high availability and disaster recovery thereby increasing availability above four 9s.
• Based on the use-case , evaluating & designing solution on Public Cloud/ Private cloud / Bare-Metal servers.
• Driving towards world class technological solutions using:
• Big data Framework : Hadoop , Spark Framework
• NoSQL DB: Cassandra,MongoDB,Hbase
• RDBMS : Oracle 9i/10g/11g , MySQL, PostgreSQL 9.1
• Caching : Redis with Sentinel
• Languages : SQL, PL/SQL,Shell Scripting
• Cloud : AWS
• Certifications: AWS / Oracle / Cassandra / MongoDB

May 2016 – Jun 2017 · 1 yr 1 mo · Bengaluru Area, India

• Database Design & Data Modelling for Production Cassandra DB’s
• Capacity / Sizing recommendation to the App team during Design phase
• Designed Cassandra Backup and Recovery Tool which provides solution for DB/Keyspace/ColFamily Backup & recoveries , DB Cloning and Point in time recoveries
• Tuning Cassandra DB’s for latencies to 3-5 ms with load of 200k reads/sec and 100k writes/sec.
• DSE 3.* , 4.* Migration to Apache Cassandra 2.1.16.
• Cassandra implementation and Administration on Private cloud/ Bare-Metal / Dockers
• DSE Cassandra upgrade from 3.* to 4.8.* / 5.*
• Cassandra Opscenter Installation . upgradation , Migration.
• Cassandra Performance tuning by tweaking Cassandra.yaml / Cassandra-env.sh
• Node addition/removal & Data Center addition/removal
• Cassandra utilities like Nodetool, cqlsh, dsetool sstablemetadata sstable2json
• Database Migration : MySQL to Cassandra
• Troubleshoot read/write latency and timeout issues
• Configure backup, alerts, repairs and monitoring of Cassandra clusters using Sensu
• G1GC Implementation & Tuning
• Azul Zing Implementation & Tuning
• Implementing Kafka for real-time data pipelines and streaming applications.
• TimeSeries Data Modelling

Aug 2014 – May 2016 · 1 yr 9 mos · Bengaluru Area, India

• Designing and Implementing OLTP usecases on Oracle
• Managing Oracle database administration functions involving Installation and configuration of Oracle server and client software
• Creation and maintenance of standby databases (logical/physical).
• Implementing Dataguard broker using DGMGRL with fast start failover setup.
• Implementing Database Backup strategies using RMAN and performing Database recovery.
• Upgradation of Databases (9i to 11g, 9i to 10g, 10g to 11g) and cross-platform migration of oracle databases using Transportable Tablespace.
• Application of Oracle security (CPU and PSU) patches, bug fix patches.
• Supporting Oracle RAC installation and maintenance.
• Performance Tuning tuning using STATSPACK, EXPLAIN PLANS, SQL TRACE, TKPROF, AWR, ASH and ADDM reports.
• Coordinating in smooth implementation of the projects; extending post-implementation and database maintenance support to the client.

Feb 2011 – Jun 2014 · 3 yrs 4 mos

• Part of Customer Support Oraganization
• Handle critical service requests
• Deliver and document issues that are not document in the Oracle Knowledge base, Creation/Review of Knowledge Articles
• troubleshoot highly complex problems (Oracle Database) requiring high level of technical expertise
• Participate in initiatives that improve overall product and documentation quality, Consults with Customers on complex use of Oracle products
• Contribute significantly towards the “My Oracle Support” Database communities.
• Analyzes work load, determines best practices and implements changes to improve productivity
• Consult customers for their queries related to RAC setup.
• Troubleshoot Installation issues of RAC on various flavors of UNIX and Windows.
• Handle upgrade issues for RAC from various Oracle versions to latest version ( 11gR2)
• Consult customers regarding patching issues on RAC environment
• Resolve RAC one and Oracle restart related issues.
• New Features queries related to RAC (11.2.0.2 & 11.2.0.3)
• Work with developer community as we provide feedback related to service request we handle

Oct 2008 – Feb 2011 · 2 yrs 4 mos · Bengaluru, Karnataka, India

• Database upgradation from 9i to 11gR1.
• Maintenance and Troubleshooting of Oracle Applications and Database
• Applying and Troubleshooting Database Patches and Application Patches
• Cloning of Oracle Application (Manual as well as Rapid)
• Tuning of Oracle Application and Database
• Planning Backup Strategy
• Database Cloning
• Maintenance of Standby Database
• Advising client about database growth trends
• Creating and managing database objects
• Schema refresh as per request
• Backup, restore & recovering database using Exp/Imp Utility

Oct 2006 – Oct 2008 · 2 yrs

• Creation and Maintenance of database for Production, Testing, Development
• Creating users and managing privileges
• Resolving user’s day-to-day issues.
• Performed different file recoveries in the database
• Configure or aid in the configuration of the computer network
• Tracing the alert.log file for “ORA” messages, Monitoring database growth to ensure smooth functioning of database
• Writing and running scripts for creating tablespaces , tables , indexes etc
• Planning , Implementing Oracle Database Installations
• SQL Analysis and optimization
• Generating statspack report
• Checking backup status to ensure backup validity.
• Reorganization of tables and indexes