Oracle APEX ERP Developer - TJ / 1925233

Our client, Dekalb Trade Voice, is seeking an experienced Oracle APEX ERP Developer based in Sialkot. The ideal candidate will be responsible for designing, developing, and maintaining customized ERP applications specifically tailored for the textile, leather, and garment manufacturing sectors. This role involves working extensively with Oracle APEX, Oracle Database, SQL, PL/SQL, and ORDS technologies to improve business processes and operational control. The developer will collaborate closely with management, functional users, and external consultants to ensure successful ERP implementation and ongoing enhancements while maintaining data accuracy and security.

Key Responsibilities

- Design, develop, customize, and maintain efficient, user-friendly ERP applications using Oracle APEX.
- Create forms, interactive grids, reports, dashboards, and approval workflows aligned with business requirements.
- Develop reusable application components and implement secure authentication and authorization mechanisms.
- Maintain and enhance PL/SQL code including packages, procedures, functions, triggers, and views to support application functionality.
- Work with Oracle Database 19c or newer versions, optimizing database design, indexing, and query performance.
- Write efficient SQL queries and assist with database administration tasks such as backup, restoration, and security patching in coordination with DBAs.
- Support database version upgrades, performance tuning, and ensure application compatibility with database changes.
- Implement enhancements based on detailed Business Requirement Documents (BRDs) and Functional Requirement Specifications (FRSs).
- Troubleshoot and resolve software defects, application errors, and performance bottlenecks promptly.
- Support development, integration, and maintenance of multiple core ERP modules including Customer Relationship Management (CRM), Supply Chain Management (SCM), Production Management, Human Resource Management (HRM), Payroll, Accounts Management, and specialized manufacturing systems like Leather and Sewing Machines Management.
- Ensure integrity of database relationships, transaction processing, and security across ERP modules, facilitating smooth inter-module integration.
- Develop integrations with external systems such as WhatsApp and AI engines using REST and SOAP APIs.
- Document development activities, maintain version-controlled deployment scripts, and produce technical documentation to support maintenance and audits.

Required Qualifications

- Proven experience in Oracle APEX application development and Oracle Database management (preferably 19c or newer).
- Strong proficiency in SQL, PL/SQL programming, and database optimization techniques.
- Experience with REST and SOAP API integration.
- Solid understanding of ERP systems and business workflows, particularly in manufacturing environments.
- Ability to interpret and implement business and functional requirement documents.
- Strong problem-solving skills with the ability to troubleshoot and resolve application and database issues.
- Familiarity with secure authentication and authorization mechanisms.
- Excellent communication skills to collaborate effectively with cross-functional teams and external consultants.
- Experience working in a non-managerial role with a focus on technical delivery and continuous improvement.

Preferred Qualifications and Benefits

While not explicitly stated, candidates with experience in textile, leather, or garment manufacturing ERP systems will have an advantage. Exposure to integrating AI engines and messaging platforms like WhatsApp is also desirable. The role offers an opportunity to work on diverse ERP modules and contribute to the digital transformation of manufacturing operations, providing a challenging yet rewarding environment for professional growth.

This position is ideal for a technically strong Oracle developer who is passionate about leveraging technology to optimize business processes and enhance operational efficiency within a specialized manufacturing context.