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

We are looking for a skilled Oracle Developer to design, develop, maintain, and support Oracle database applications and ERP solutions. The role involves creating PL/SQL programs, reports, forms, and database objects while ensuring optimal system performance, data integrity, and smooth integration with business processes. The successful candidate will work closely with functional teams to understand requirements and deliver efficient Oracle-based solutions tailored to business needs.

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.
- Write SQL queries for reporting, data analysis, and business requirements.
- Enhance database performance through query tuning and indexing.

ERP Support & Customization:
- Customize Oracle ERP modules according to business needs.
- Develop reports and interfaces supporting Finance, HR, Sales, Inventory, Procurement, and Production departments.
- Troubleshoot ERP issues and provide timely technical solutions.
- Collaborate 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 using 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 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 new features and system enhancements.

Required Qualifications
Education:
- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or related field.

Experience:
- 3 to 5 years of hands-on experience as an Oracle Developer.
- Experience with Oracle ERP in a manufacturing environment is 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.
- Familiarity with Oracle APEX is an advantage.
- Knowledge of Oracle ERP modules including Finance, HR, Inventory, Procurement, Manufacturing, and Sales.
- Experience in database performance tuning and optimization.
- Understanding 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 deadlines.

Preferred Qualifications and Benefits
- Experience in Oracle ERP implementation or support.
- Knowledge of manufacturing and supply chain business processes.
- Understanding of database security best practices.
- Ability to collaborate effectively with cross-functional teams.
- Continuous learning mindset and adaptability to new technologies.

Compensation:
- Monthly salary range: Rs120,000 to Rs175,000

Additional Information:
- Candidates should reliably commute to or plan to relocate to Lahore before starting work.
- This is an in-person role based at the Lahore Head Office.