Share this Job
Apply now »

Oracle APEX Specialist

Job category:  Information Technology
Work location:  Office Based
Office location: 

Hyderabad, IN

Contract type:  Permanent
Job type:  Employee





Oracle APEX Specialist

Reporting To

Data Architect Manager


Overall objective of the Role

  • Contribute in development and enhancement of the Enterprise Application(s) developed using APEX.
  • Understand Business Requirements and create Dashboards and Reports using Oracle APEX
  • Create Apex pages, Master Detail Forms, Tabular forms, Apex Collections, Interactive reports, Charts etc.
  • Write SQL queries and create PL/SQL functions/procedures/packages that are optimized for APEX.


Main Responsibilities


Delivery Key responsibilities:

  • Gather requirements, translate into detailed design documents
  • Develop & Deliver the Business Apps as per requirements
  • Accountable to deliver projects end to end as per the plan (especially on Time, Scope & Quality)
  • Follow Agile methodologies to deliver in a phased/staggered manner
  • Maintain & enhance existing Apps
  • A self-starter who can work with minimum guidance & oversight
  • Excellent analytical, and business requirement gathering skills 
  • Strong verbal and written communication skills 


Main Accountabilities


  1. To ensure that compliance to NGA standards is adhered to across the projects being delivered and take action as required to ensure compliance is enforced
  2. Take decisions as needed and ensure that issues are escalated through the appropriate channels for support in resolution and to raise senior management awareness
  3. To share best practice and key learnings to support continuous improvement and foster a learning culture and environment
  4. To deliver project reporting and maintain systems of information in accordance with NGA standards
  5. Build relationships at both a transactional and strategic level to support the achievement of key outcomes and joint goals
  6. Develop innovative approaches and solutions as part of a continuous improvement cycle.

Key Criteria to monitor performance

  1. Completion of mandatory training,
  2. Adoption of NGA standard methodology
  3. Quality review and lessons learned process
  4. Customer Satisfaction outcomes
  5. Programme Delivery Outcomes (Budget, Timeline, Quality Standards)


NGA Core Competencies

  • Building Effective Teams - Open up the World of Opportunity, develop networks and blend people into teams where needed. Ensure effective communication, foster open dialogue, encourage people to act responsibly & take accountability for their work, defines success in terms of ‘One Team’. Creates strong morale and spirit in the team.
  • Drive Innovation - Be a problem solver. Enable & drive innovation by working with teams to develop new approaches and solutions to problems that have not been previously done. Embrace & support change and suggest implementation strategies. Seek, develop and test unique opportunities for business improvement and/or growth.
  • Develop Others - Delegates responsibility allowing employees freedom to decide how they will accomplish their goals and resolve issues. Applies sound people management practices, to enable others to deliver, whilst actively provides feedback and coaching to maximise their full potential.
  • Grow Client Relationships - Establish and develop effective relationships with clients and gains the trust and respect in developing ideas, proposals, projects and solutions that are mutually & financially beneficial.
  • Be Results Oriented - Maintain and apply a broad understanding of the business vision and the NGA Way of working. Understand financial management principles to ensure decisions are based on this. Establish & embed quality processes, that are repeatable and scalable, to create discipline, accountability & focus whilst driving others to deliver results.












Professional /

Job Experience


  • A minimum of 8-10 years of development experience using Oracle APEX
  • Development experience with Oracle 10g/11g/12c and APEX 4.x/5.x
  • Experience working on Oracle with SQL, PL/SQL, Performance Tuning, Materialized Views, Data Dictionary, Indexing, Cursors, Constraints, Job Scheduling, External Tables
  • Knowledge of the Datawarehouse concepts and design
  • Experience working on APEX themes, templates, data upload tools, page/application items and processes, forms, reports
  • Demonstrated experience / strong knowledge of Web/UI design involving HTML, JavaScript, JQuery, CSS and AJAX
  • Experience with Business Requirements capture, Analysis and Documentation
  • Experience in managing web page layouts with APEX templates and themes
  • Relational Data modelling
  • Problem Solving: Ability to analyze and resolve complex infrastructure resource and application deployment issues.
  • Experience collaborating effectively with team members and partners in a distributed project environment





  • Oracle Database performance and tuning.
  • Knowledge of Linux / Unix / Windows environments
  • APEX 5 Universal Theme.
  • APEX Plug-in development.
  • Experience integrating REST APIs into APEX applications.
  • Web application security / Data security.


Academic Degree

Education and Training


  • Bachelor's degree or equivalent combination of education with technical experience.



  • Oracle Certified Professional
  • Oracle development related courses
  • HR/Payroll Functional knowledge




Apply now »