Oracle PL SQL Developer ERP Domain

Projense Systems; Nagpur District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Projense Systems is seeking a skilled Oracle PL/SQL Developer with 2-8 years of ERP development experience in Nagpur. You will design and optimize database solutions, implement PL/SQL procedures, and integrate Java APIs with Oracle-based ERP systems.

You will work with AI-assisted development tools to speed up coding, debugging and documentation, collaborate with Java/UI teams, and ensure adherence to coding standards and performance tuning best practices.

Qualifications

• Strong knowledge of Oracle SQL & PL/SQL.
• Hands-on experience with Stored Procedures, Functions, Packages, Triggers, Cursors and Collections.
• Good understanding of Oracle performance tuning and query optimization.
• Experience with ERP application/database architecture.
• Knowledge of MM / SD / PP business processes.
• Strong experience in Java API / REST API integration.
• Ability to troubleshoot existing enterprise applications.
• Good analytical and problem-solving skills.

Responsibilities

• Develop Oracle PL/SQL procedures, functions, packages, triggers, views and queries.
• Design and develop database solutions for ERP business processes.
• Understand and work with ERP modules such as MM Material Management, SD – Sales & Distribution, PP – Production Planning.
• Develop complex SQL queries, reports, validations and business rules.
• Perform SQL/PLSQL performance tuning and troubleshoot database-related issues.
• Develop and integrate Java APIs / REST APIs with Oracle-based ERP applications.
• Work closely with Java/UI developers for end-to-end feature implementation.
• Understand existing ERP architecture, database relationships and transaction flows.
• Participate in requirement analysis, technical design, development, testing and production support.
• Use AI tools effectively for faster development, debugging, code optimization, documentation and test-case generation.
• Analyze production issues and provide permanent technical solutions.
• Follow coding standards, database design standards and version-control practices.

Skills

Oracle SQL & PL/SQL

Stored Procedures, Functions, Packages

Performance tuning

ERP architecture

ERP business processes (MM/SD/PP)

Java API / REST API integration

AI-assisted development tools

Git or version-control

Tools

Git

ChatGPT

GitHub Copilot

Job description

We are looking for a skilled Oracle PL/SQL Developer with 2-8 years of experience in ERP application development. The candidate should have strong expertise in Oracle Database, PL/SQL programming, ERP business processes, and Java API integration.

The ideal candidate should be comfortable using AI-assisted development tools to improve development speed, code quality, troubleshooting, documentation, and overall productivity.

Key Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL procedures, functions, packages, triggers, views and queries.
• Design and develop database solutions for ERP business processes.
• Understand and work with ERP modules such as:
• MM Material Management
• SD - Sales & Distribution
• PP - Production Planning
• Develop complex SQL queries, reports, validations and business rules.
• Perform SQL/PLSQL performance tuning and troubleshoot database-related issues.
• Develop and integrate Java APIs / REST APIs with Oracle-based ERP applications.
• Work closely with Java/UI developers for end-to-end feature implementation.
• Understand existing ERP architecture, database relationships and transaction flows.
• Participate in requirement analysis, technical design, development, testing and production support.
• Use AI tools effectively for faster development, debugging, code optimization, documentation and test-case generation.
• Analyze production issues and provide permanent technical solutions.
• Follow coding standards, database design standards and version-control practices.

Required Technical Skills

Must Have:

• Strong knowledge of Oracle SQL & PL/SQL.
• Hands-on experience with Stored Procedures, Functions, Packages, Triggers, Cursors and Collections.
• Good understanding of Oracle performance tuning and query optimization.
• Experience with ERP application/database architecture.
• Knowledge of MM / SD / PP business processes.
• Strong experience in Java API / REST API integration.
• Ability to understand and troubleshoot existing enterprise applications.
• Good analytical and problem-solving skills.

Good to Have:

• Oracle 19c or higher.
• Java / Spring Boot knowledge.
• REST / JSON / XML integration.
• Experience with ERP interfaces and third-party system integration.
• Knowledge of Git or other version-control systems.
• Experience working with AI-assisted development tools such as ChatGPT, GitHub Copilot or equivalent.

Preferred Candidate Profile

• 2-8 years of relevant experience in Oracle PL/SQL development.
• Experience in ERP product/application development will be preferred.
• Candidates who have worked across Database + API + ERP business logic will have an advantage.
• Strong understanding of business requirements and ability to convert them into technical solutions.
• Willingness to continuously adopt AI-driven development practices to improve productivity.
• Good communication and teamwork skills.