Responsibilities

Lead the end-to-end design, development, and implementation of database applications using Oracle PL/SQL and Oracle APEX.
Architect, design, and optimize complex database schemas, stored procedures, triggers, functions, and views for high-performance applications.
Develop and maintain custom extensions on Oracle PaaS integrated with Oracle Cloud ERP, leveraging Exadata Cloud Service.
Build and support integrations with Oracle Cloud ERP using FBDI, REST APIs, and other Oracle integration tools.
Collaborate with cross-functional teams including business analysts, project managers, and ERP functional consultants to translate business requirements into scalable technical solutions.
Conduct code reviews and enforce best practices in PL/SQL and APEX development, ensuring high standards of code quality, performance, and security.
Troubleshoot and resolve performance bottlenecks in PL/SQL and database operations.
Develop and maintain Unix shell scripts to support automation and integration workflows.
Work with Kafka streams for real-time data processing and integration scenarios.
Ensure all solutions comply with company policies, security standards, and data governance requirements.

Required Skills





8+ years of experience in Oracle database development with solid proficiency in PL/SQL, Oracle APEX, Oracle BI Publisher, and OCI.
Deep understanding of relational database design, optimization, and advanced PL/SQL features (cursors, bulk collections, exception handling, etc.).
Hands-on experience with Oracle Cloud ERP, particularly in the Accounts Receivable (AR) module and its underlying table structures.
Proven experience building inbound and outbound interfaces with Oracle Cloud ERP using FBDI and REST APIs.
Strong SQL tuning, query optimization, and database performance troubleshooting skills.
Experience with Web Services, APIs, and integrating external systems with Oracle databases.
Exposure to Oracle PaaS, Exadata Cloud Service, and Oracle Autonomous Database.
Proficiency in Unix/Linux environments and scripting.
Exposure to Kafka or similar streaming platforms is a strong plus.

Preferred Skills:

Oracle Cloud certifications in ERP or related technologies.
Experience with Agile/Scrum methodologies.
Familiarity with other Oracle ERP modules is a plus.

📌 Oracle PL/SQL Developer (Hyderabad)
🏢 Ingrain Systems
📍 Hyderabad