Oracle PL/SQL Developer with ATP and ORDS
On-siteChennai, Tamil Nadu, India
Job Summary
Design, develop, and maintain complex PL/SQL procedures, functions, triggers, and packages while optimizing database performance through efficient query design and tuning. Implement database solutions that align with business requirements and develop RESTful APIs using ORDS for seamless data exchange between applications. Ensure secure, reliable communication between APIs and database systems by troubleshooting integration issues and handling JSON data structures effectively. Validate and process JSON payloads to guarantee accurate data flow, providing technical support and training to team members and end-users. This role requires 5+ years of experience in Oracle PL/SQL, REST API integration, and JSON processing within a consultancy specializing in data-driven projects and finance transformations.
Required Qualifications
- 5+ years of experience
- expertise in REST API integration
- JSON-based web services
- hands-on experience in developing, implementing, and optimizing database solutions
- seamless integration with web services
- deep understanding of PL/SQL programming
- ATP
- ORDS data handling
- Design, develop, and maintain complex PL/SQL procedures, functions, triggers, and packages
- Optimize database performance through efficient query design and tuning
- Implement database solutions that align with business requirements
- Develop and maintain RESTful APIs (ORDS) for seamless data exchange between applications
- Ensure secure, reliable, and efficient communication between APIs and database systems
- Troubleshoot and resolve issues related to API integration
- Handle JSON data structures effectively within PL/SQL and APIs
- Validate and process JSON payloads to ensure accurate data flow
- Provide technical support and training to team members and end-users
- Strong expertise in Oracle PL/SQL programming, including stored procedures, functions, and triggers
- Proficiency in REST API development and integration
- Hands-on experience with JSON data parsing and processing
- Familiarity with web services standards (SOAP/REST) and protocols
- Understanding of Oracle Database architecture and performance tuning
Desired Qualifications
- Experience with Oracle Apex or similar tools
- Knowledge of version control tools like Git or SVN
- Familiarity with Agile/Scrum development methodologies
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.