Oracle Developer

Job Title: Oracle Developer

Department: Information Technology (IT)
Job Type: Full-Time
Work Location: Lahore Head Office (In Person)
Reporting To: IT Manager / Head of IT

Job Summary

We are seeking a skilled and experienced Oracle Developer to design, develop, maintain, and support Oracle database applications and ERP solutions. The ideal candidate will be responsible for developing PL/SQL programs, reports, forms, and database objects while ensuring system performance, data integrity, and seamless integration with business processes. The role requires close collaboration with functional teams to understand business requirements and deliver efficient Oracle-based solutions.

Key Responsibilities

Oracle Development

• Design, develop, test, and maintain Oracle database applications.
• Develop and optimize PL/SQL packages, procedures, functions, triggers, and views.
• Create and maintain Oracle Forms and Oracle Reports.
• Develop SQL queries for reporting, data analysis, and business requirements.
• Optimize database performance through query tuning and indexing.

ERP Support & Customization

• Customize Oracle ERP modules based on business requirements.
• Develop reports and interfaces to support Finance, HR, Sales, Inventory, Procurement, and Production departments.
• Troubleshoot ERP issues and provide timely technical solutions.
• Coordinate with functional users to gather and document business requirements.

Database Administration Support

• Ensure database integrity, security, and performance.
• Monitor database health and resolve performance bottlenecks.
• Assist with database backup, recovery, and migration activities.
• Support data import/export and migration processes.

System Integration & Reporting

• Develop integrations between Oracle ERP and third-party applications.
• Design dashboards and MIS reports for management.
• Automate business processes through Oracle development tools.
• Ensure data accuracy and consistency across integrated systems.

Testing & Documentation

• Conduct unit testing and support user acceptance testing (UAT).
• Prepare technical documentation, database designs, and user manuals.
• Maintain proper version control and documentation of developed solutions.

User Support

• Provide technical support to end users.
• Diagnose and resolve application and database-related issues.
• Train users on newly developed features and system enhancements.

Qualifications

Education

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.

Experience

• 3–5 years of hands-on experience as an Oracle Developer.
• Experience with Oracle ERP in a manufacturing environment will be preferred.

Technical Skills

• Strong knowledge of Oracle Database (11g, 12c, 19c, or later).
• Expertise in SQL and PL/SQL programming.
• Experience with Oracle Forms and Oracle Reports.
• Knowledge of Oracle APEX is an added advantage.
• Familiarity with Oracle ERP modules (Finance, HR, Inventory, Procurement, Manufacturing, Sales).
• Experience with database performance tuning and optimization.
• Knowledge of REST APIs, web services, and system integrations is desirable.
• Proficiency in Oracle SQL Developer and TOAD.

Required Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and documentation skills.
• Ability to work independently and manage multiple tasks.
• Strong attention to detail and commitment to quality.
• Ability to work under pressure and meet project deadlines.

Key Performance Indicators (KPIs)

• Timely delivery of development projects.
• Application performance and system uptime.
• Resolution time for technical issues.
• Database performance optimization.
• Accuracy and quality of reports and customizations.
• User satisfaction and support effectiveness.
• Compliance with coding standards and documentation.

Preferred Competencies

• Experience in Oracle ERP implementation or support.
• Knowledge of manufacturing and supply chain business processes.
• Understanding of database security and best practices.
• Ability to collaborate effectively with cross-functional teams.

Continuous learning mindset and adaptability to new technologies.

Pay: Rs120,000.00 - Rs175,000.00 per month

Ability to commute/relocate:

• Lahore: Reliably commute or planning to relocate before starting work (Preferred)

Education:

• Bachelor's (Preferred)

Work Location: In person