Job Title: Oracle APEX / PL/SQL / Forms & Reports DeveloperExperience
2–5 Years
Qualification
- B.Tech / M.Tech / B.Sc. / M.Sc. in Computer Science, Information Technology, or a related field.
Job Summary
We are seeking a skilled Oracle Developer with strong hands-on experience in Oracle APEX, Oracle PL/SQL, Oracle Forms, and Oracle Reports. The ideal candidate should have experience in designing, developing, testing, deploying, and maintaining enterprise Oracle applications. The candidate should possess strong database development skills and be capable of delivering high-quality Oracle-based solutions throughout the Software Development Life Cycle (SDLC).
Key Responsibilities
- Design, develop, test, deploy, and maintain enterprise applications using Oracle APEX.
- Develop and maintain Oracle Forms and Oracle Reports applications.
- Design and implement database objects including tables, views, materialized views, indexes, sequences, and constraints.
- Develop efficient PL/SQL code including procedures, functions, packages, triggers, cursors, collections, and dynamic SQL.
- Write complex SQL queries and optimize database performance.
- Debug, troubleshoot, and enhance existing PL/SQL programs and Oracle applications.
- Perform database performance tuning and query optimization.
- Participate in requirement analysis, application design, development, testing, deployment, and production support.
- Integrate Oracle applications with REST APIs and external systems using XML and JSON.
- Maintain code quality using version control and follow enterprise code promotion and release management practices.
- Work closely with business users to understand requirements and provide technical solutions.
- Prepare technical documentation and support end users in resolving application-related issues.
Required Technical Skills
- Strong hands-on experience in Oracle APEX application development.
- Strong experience in Oracle Database development.
- Excellent knowledge of SQL and PL/SQL.
- Experience with:
- Procedures
- Functions
- Packages
- Triggers
- Cursors (Explicit, Implicit, Ref Cursor)
- Cursor Variables
- Collections
- Dynamic SQL
- Exception Handling
- Experience in Oracle Forms and Oracle Reports development.
- Strong understanding of logical and physical database design.
- Experience with Views, Materialized Views, Indexes, and Performance Tuning.
- Good understanding of REST APIs, XML, and JSON.
- Familiarity with Git or other version control systems.
- Knowledge of Software Development Life Cycle (SDLC), Agile, and deployment methodologies.
Desired Skills
- Strong analytical and problem-solving abilities.
- Excellent verbal and written communication skills.
- Ability to work independently as well as in a collaborative team environment.
- Ability to manage multiple assignments and meet project deadlines.
- Experience in production support, debugging, and application maintenance.
- Immediate joiners will be highly preferred.
- willing to relocate to raipur must.
Preferred Experience
- Minimum 2–3 years of hands-on experience in Oracle APEX, Oracle PL/SQL, Oracle Forms, and Oracle Reports.
- Experience in enterprise Oracle application development and database optimization.
- Experience integrating Oracle applications with external services using REST APIs, XML, and JSON.
Work Location: In person