@santoshpanigrahi
Experienced Database Developer | Oracle SQL, PL/SQL, Performance Tuning, APEX, ORDS, Unix Shell Scripting, Python
Database Developer with over 10 years of experience in designing, developing, and delivering optimized solutions across diverse business functions. Proficient in Oracle SQL, PL/SQL, Performance Tuning, Oracle APEX, ORDS, Unix Shell Scripting, and Python Fundamentals. With extensive expertise in development, maintenance, and optimization, I possess strong skills in coding, debugging, testing, and troubleshooting complex systems. I have worked across domains such as Finance and Risk, Ratings, Wealth Management, SOX Compliance, and Fleet - Fuel Management. Passionate about leveraging my technical expertise and domain knowledge to deliver efficient, data-driven solutions that enhance business performance and foster growth.
Oracle SQL | PLSQL | Unix Shell Scripting | Performance Tuning | APEX | Oracle REST Data Services (ORDS) | DBaaS | Python | ETL | Dat Warehouse | Data Modelling
Mar 20, 2025 · 8 min read · Introduction Oracle REST Data Services (ORDS) allows you to expose database objects as RESTful web services. In this guide, we will enable RESTful services for the HR schema and create a fully functional REST API that supports GET, POST, PUT, PATCH, ...
Join discussion
Mar 18, 2025 · 37 min read · This is a beginner's app designed to help understand how an app works, not a fully developed Apex app for production, with non-normalized tables, sample data, and suboptimal relationships, intended solely for learning purposes on what, when, and how ...
Join discussion
Dec 18, 2024 · 1 min read · Learn Oracle APEX – 15+ sources to speed up your learning process https://oracle-base.com/articles/misc/apex-tips-basic-apex-management https://www.rebellionrider.com/how-to-uninstall-oracle-database-19c/ https://www.rebellionrider.com/how-to-install...
Join discussion
Feb 6, 2024 · 9 min read · In this guide, I'll walk you through the installation process of Oracle Application Express (APEX), Oracle REST Data Services (ORDS), and Tomcat in Windows. Following a step-by-step approach, we'll ensure a clean setup for all components. Prerequisit...
OFrankfurt commented
Feb 3, 2024 · 4 min read · In this guide, I will walk you through the process of setting up Oracle 23ai Free Database, Oracle APEX (Application Express), ORDS (Oracle REST Data Services) and oracle sqlCL in a Docker container. The VM Appliance comes preloaded with these tools,...
IIbrahim commented