Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Sagar Devkar
Full Name
ACE Associate
Top Level Details
Job Role
Lead Database Developer
Company
Jio Platforms Ltd.
Country
India
Top Expertise
Oracle SQL
Focus Area
Database
About Sagar
OCP-certified Lead Database Developer with 9+ years of jam-packed, in-depth experience in Database Development and Product Engineering. Designed and developed scalable, efficient and secure database systems for the banking and insurance domain. Adept in Agile methodology to build and enhance products, ensuring faster delivery and continuous improvement. Skilled at understanding complex data and transforming it into actionable business value. Automated key processes, freeing up 150+ hours per month at Herald Logic and Jio Platforms Ltd.
Expertises
Oracle SQL
Oracle PL/SQL
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
Part 2 - Oracle Query Performance Tips
Nov 29, 2025 - Blog post -
Structured Query Language (SQL)
Oracle SQL
MySQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Part 1 - Oracle Query Performance Tips
Nov 24, 2025 - Blog post -
Structured Query Language (SQL)
Oracle SQL
MySQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Wrong Datatype = Silent Killer of Database Performance
Aug 26, 2025 - Blog post -
Oracle SQL
SQL Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
157x faster. Same query. Same table. Just one change: Materialized Virtual Columns instead of Virtual Columns.
Aug 24, 2025 - Blog post -
Oracle SQL
SQL Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
What if a single change could make your inserts run 10X faster?
Aug 23, 2025 - Blog post -
Oracle SQL
SQL Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
If you’ve ever written a trigger just to simulate AUTO INCREMENT, this post is for you.
Aug 22, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
User-Friendly Error Messages: A New Era in Oracle 23ai
Aug 21, 2025 - Blog post -
Oracle SQL
Oracle PL/SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
The For Loop evolution in #Oracle PL/SQL — from frustration to freedom
Aug 20, 2025 - Blog post -
Oracle PL/SQL
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Defaults in Oracle were broken for decades. 12c tried, but only 23ai nailed it.
Aug 19, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 18c: Introduction to Private Temporary Table (PTT)
Aug 18, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
What if I told you that most SQL developers handle constraints the wrong way?
Aug 17, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Imagine inserting data into multiple tables in a single statement — no loops, no cursors, no repetitive coding.
Aug 16, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Sequence Cache — The Hidden Performance Lever
Aug 15, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Hot index blocks slowing you down? Oracle has a fix you probably haven’t tried. Did you know that in Oracle 12c, sequences are no longer limited to just one behaviour?
Aug 14, 2025 - Blog post -
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 23ai: The Long-Awaited Table Value Constructor (TVC) Revolution
Aug 13, 2025 - Blog post -
Oracle SQL
#ACTIONS#
1 - 15
Next