Silver Fox Dynamics builds ERP, SaaS and business-automation software for clients across industries, and Oracle APEX is at the heart of several of our production systems, including our cloud Restaurant ERP. We are hiring a Senior Oracle APEX Developer to take technical ownership of a long-term, client-based engagement in Lahore. You will sit at our client's premises near Bahria Town, Lahore, and report to our head office in Islamabad.
This is a hands-on senior role. You will design the solution, build the hardest parts yourself, review the work of others, and be the person clients trust to get complex requirements delivered properly.
Responsibilities
- Design, build and maintain end-to-end Oracle APEX applications: interactive reports and grids, forms, dashboards, charts and approval workflows.
- Write, optimise and troubleshoot advanced SQL and PL/SQL (packages, procedures, functions, triggers, views) on Oracle Database.
- Model relational schemas and own data-integrity, indexing and performance decisions.
- Build and consume REST services with Oracle REST Data Services (ORDS) and integrate third-party APIs and payment, messaging or accounting systems.
- Implement authentication, authorisation schemes and role-based access, and apply secure-coding practice (SQL injection, XSS, session handling).
- Translate client requirements into technical designs, estimates and delivery plans, and take part in client meetings, demos and UAT.
- Review code, set APEX and PL/SQL standards, and mentor junior developers.
- Manage environments and releases (development, testing, production) using version control and repeatable deployment practice.
- Provide go-live and post-launch support, and keep technical documentation current.
Requirements
- 9–10 years of hands-on professional experience building and delivering Oracle APEX applications to production.
- Strong command of SQL and PL/SQL, including query tuning with execution plans.
- Deep working knowledge of APEX: Page Designer, Interactive Grid / Report, Dynamic Actions, Universal Theme, template components, plug-ins and shared components.
- Practical experience with ORDS and REST web services (JSON).
- Solid JavaScript, HTML5 and CSS for customising APEX UI.
- Experience with Git or equivalent version control.
- Strong analytical and problem-solving skills, and clear written and spoken communication for client-facing work.
- Bachelor's degree in Computer Science, Information Technology or a related field.
Nice to have
- Oracle Cloud / Autonomous Database experience.
- Oracle certifications (APEX Developer Professional, SQL / PL/SQL).
- BI Publisher or other PDF/report generation experience.
- Background in ERP, POS, inventory or finance applications.
- Experience leading or mentoring a small development team.
What we offer
- Salary: PKR 220,000 – 250,000 per month (gross), based on experience and interview performance.
- Long-term engagement on real client projects and live production systems.
- Technical ownership and a genuine voice in how we build.
- Based in Lahore, near Bahria Town, at the client's premises, reporting to our Islamabad head office. Candidates living near Bahria Town will be preferred.
#J-18808-Ljbffr
