Oracle PL/SQL Developer
Ingrain Systems Inc
- Location
- Hyderabad, Telangana, India
- Job type
- Full-time
Required skills
- accounts receivable
- Agile
- Apex
- cross-functional
- database
- end-to-end
- Kafka
- Linux
- Oracle
- PaaS
- Unix Shell
- SQL
- Unix
- web services
- ERP
- REST APIs
About the role
Ingrain Systems Inc
Website:
ingrain.us
Job details:
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 strong 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.
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.
