Blog

How MongoDB choose optimal path for $OR operator?

As Technical Services Engineers, we often encounter a common question: Why isn’t MongoDB selecting the correct index? In this blog post, I’ll delve into how MongoDB determines the most efficient plan for a query that includes the $OR operator. A general rule of thumb to create an efficient compound index is to arrange the index…

Oracle EBS Patching Automation

Throughout my experience working with the Oracle EBusiness Suite, I’ve consistently encountered a challenge – the absence of a comprehensive tool for automating patching tasks. This prompted me to embark on a quest for suitable scripts within the vast realm of the internet and the Oracle community. Although I didn’t stumble upon a fully functional…

Troubleshooting Email Alerts in Oracle Enterprise Manager

Introduction: In this blog post, I’ll discuss the challenges faced when trying to set up email alerts in Oracle Enterprise Manager (OEM) and the solutions found during the troubleshooting process. Setting Up Alerts in OEM: There was a recent production issue due to TEMP getting filled up. While we have OEM set up, we received…

Are your ETL jobs failing after upgrading to E-Business Suite R12.2?

This may be due to missing Materialized Views (MV) or table structures being changed without your knowledge. Don’t worry,  I’ve got you covered with a real-life example of how I resolved a similar issue. Imagine having OLTP transactions and ETL reporting jobs all pointing to the same E-Business Suite database, and during an upgrade, a…

Something went wrong. Please refresh the page and/or try again.

About Me

I’m Neil. I’ve dedicated a significant portion of my professional journey to both India and the United States before relocating to Toronto during the pandemic.

I’m a member of MongoDB’s esteemed Technical Services team. Before joining this exceptional group, I held the role of Senior Apps DBA at the Government of Ontario. Prior to that, I spent many years honing my technical(DBA/Cloud) and soft skills with TCS, KBACE Technologies(which later got acquired by Cognizant Technology Solutions) and Oracle Corporation. Throughout my career, I was deeply immersed in day-to-day operations and spearheaded significant projects, including the modernization of platforms, Oracle application and database upgrades. In my last stint at the Government of Ontario, I was also responsible for overseeing various automation initiatives including out-of-place patching, automated EBS Application patching.

Outside of my professional life, I have a strong passion for reading, blogging, spending quality time with my family, and my feline buddies, Smokey & Louis. I also relish solitary walks and jogging as personal interests.

As a proponent of open source technologies, I’m looking forward to sharing my knowledge and expertise as well as contribute as much as possible to the success of the IT fraternity thereby perpetually expanding my skillset.

Subscribe to My Blog

Get new content delivered directly to your inbox.

Leave a comment