Feb 2019 – Jan 2022 · 2 yrs 11 mos · Greater Bengaluru Area

Nov 2016 – Jan 2019 · 2 yrs 2 mos · Bengaluru, Karnataka, India

• DB Management team in Oracle Management Cloud (OMC)
• Developed DB Management Service from the scratch for the on-cloud enterprise manager product OMC. Deployed on Oracle’s WebLogic server, deployment had front-end and back-end as independent microservices.
• a. Java based RESTful backend: designed data-collector factory for different DB types, caching mechanism for frequently used data, and inter-service communication interfaces. Designed diagnostics and recovery protocols for service failures at microservice, authentication, and individual DB levels. Designed and wrote the upgrade protocols for microservices.
• In addition, wrote synchronised multithreaded code to connect with DBs using JDBC engine (J2EE), creating a DB connection pool, communication with front-end using REST calls, and PL/SQL queries to fetch data from DBs. Wrote standardised APIs to define/update/delete computable metrics to identify anomalous behaviour and alert users.
• b. knockout.js, jQuery for front-end, with an actionability-oriented page design highlighting problem areas, allowing user to create a customised view to preserve for review, monitor and manage databases. Menus and views were data-driven.
• Wrote the communications between front-end and backend using async jQuery REST calls, formatting of received data, and presentation in charts and tables.
• Wrote code for routing between different webpages, JavaScript miniaturising, expansion and collapse of selected UI components, maintenance of browser context and NLS support.
• In-memory Database Advisor for Oracle Enterprise Manager (OEM)
• Wrote a PL/SQL plugin to install an advisor for in-memory database
• Designed a UI page to install the plugin, and generate recommendations based on user inputs. The plugin retrieved frequently accessed DB objects suitable for placement in In-memory DB for better performance.
• Wrote code to move the data from DB to in-memory, providing compatibility for different types of DBs (Container, SI and Cluster DBs)

Jul 2014 – Nov 2016 · 2 yrs 4 mos · Bengaluru, Karnataka, India

• In-memory Database Advisor for Oracle Enterprise Manager (OEM)
• Wrote a PL/SQL plugin to install an advisor for in-memory database
• Designed a UI page to install the plugin, and generate recommendations based on user inputs. The plugin retrieved frequently accessed DB objects suitablefor placement in In-memory DB for better performance.
• Wrote code to move the data from DB to in-memory, providing compatibility for different types of DBs (Container, SI and Cluster DBs)
• Languages: Java 7, JavaScript (node.js), PL/SQL, JSP, JEE Spring Framework.

May 2013 – Jul 2013 · 2 mos · Bengaluru, Karnataka, India

• Developed a Windows mobile app to extract graphical components from Microsoft Office file dump, and display them on a mobile/tablet app, to present a quick graphical summary on mobile or other hand-held devices using Windows Phone OS.

May 2012 – Jul 2012 · 2 mos · Greater Chennai Area

• Providing High Availability to Infosys iQuRE, a video and text chat software being developed by Infosys. Our task was to establish proof-of-concept for the same by replicating sessions data so that in case of a failure, an idle server can quickly pick up the existing requests.