27 Sep
|
Ingrain Systems
|
Hyderabad
27 Sep
Ingrain Systems
Hyderabad
nResponsibilities
n
n
n
- Lead the end-to-end design, development, and implementation of database applications using Oracle PL/SQL and Oracle APEX.
n
- Architect, design, and optimize complex database schemas, stored procedures, triggers, functions, and views for high-performance applications.
n
- Develop and maintain custom extensions on Oracle PaaS integrated with Oracle Cloud ERP, leveraging Exadata Cloud Service.
n
- Build and support integrations with Oracle Cloud ERP using FBDI, REST APIs, and other Oracle integration tools.
n
- Collaborate with cross-functional teams including business analysts, project managers, and ERP functional consultants to translate business requirements into scalable technical solutions.
n
- Conduct code reviews and enforce best practices in PL/SQL and APEX development, ensuring high standards of code quality, performance, and security.
n
- Troubleshoot and resolve performance bottlenecks in PL/SQL and database operations.
n
- Develop and maintain Unix shell scripts to support automation and integration workflows.
n
- Work with Kafka streams for real-time data processing and integration scenarios.
n
- Ensure all solutions comply with company policies, security standards, and data governance requirements.
n
n
nRequired Skills
n
n
n
- 8+ years of experience in Oracle database development with strong proficiency in PL/SQL, Oracle APEX, Oracle BI Publisher, and OCI.
n
- Deep understanding of relational database design, optimization, and advanced PL/SQL features (cursors, bulk collections, exception handling, etc.).
n
- Hands-on experience with Oracle Cloud ERP, particularly in the Accounts Receivable (AR) module and its underlying table structures.
n
- Proven experience building inbound and outbound interfaces with Oracle Cloud ERP using FBDI and REST APIs.
n
- Solid SQL tuning, query optimization, and database performance troubleshooting skills.
n
- Experience with Web Services, APIs, and integrating external systems with Oracle databases.
n
- Exposure to Oracle PaaS, Exadata Cloud Service, and Oracle Autonomous Database.
n
- Proficiency in Unix/Linux environments and scripting.
n
- Exposure to Kafka or similar streaming platforms is a strong plus.
n
n
n
nPreferred Skills:
n
n
n
- Oracle Cloud certifications in ERP or related technologies.
n
- Experience with Agile/Scrum methodologies.
n
- Familiarity with other Oracle ERP modules is a plus.
n
n
n
n
📌 Oracle PL/SQL Developer (Hyderabad)
🏢 Ingrain Systems
📍 Hyderabad