SC Lead Oracle Developer & Architect

  • Location

    London, England

  • Sector:


  • Job type:


  • Salary:


  • Contact:

    Madaleine Sadler

  • Contact email:

  • Job ref:


  • Published:

    7 months ago

  • Duration:

    3-6 months

  • Expiry date:


  • Start date:


Lead Oracle Developer & Architect


3-6 months

Due to the nature of the project, candidates must hold SC clearance.

The Lead Developer & Architect role that we are seeking to fill is the main link with the business and works closely with the other team members and networking team. This role will require a breadth and depth of experience in assessing and analysing user needs, and translating them into work-packages for development using the specific technologies required. The role encompasses software development as well as business analysis and design, and effectively manages the ongoing development of the RECAP product in accordance with business needs, and technology upgrades etc.

Key Responsibilities

  • The ideal candidate will have experience of working in a small Agile, business-centric environment and participating in all Software Development Life Cycle phases for an Oracle Forms and Reports 10g application that we are in process of migration to 12c.
  • An understanding and practical experience of the configuration and administration of an Oracle Application/Middleware Server for Forms and Reports is also essential while experience in client-side windows OS integration of Forms via Webutil and the use and development of bespoke Forms extensions in Java and C++ would be mandatory.
  • The ability to quickly learn new languages and frameworks and willingness to pick the right tool for the job
  • Proficient in migrating the existing Oracle Application Server 10g to an equivalent 12c environment (WLS, Forms and Reports).
  • Perform Data Modelling tasks plus create high and low level design documents for business to represent the entire migration/remediation process, code structures, impacts, risk and other analysis.

Technical Essentials

Operating Systems

HP UNIX, Win XP, Windows 10


Oracle 11g (currently worked on)


SQL, PL/SQL, Shell Scripting, Visual Basic, VB.Net, Java Script Electronic Programming Language - C, C++

Database Tools

· Development - include all object type creation and manipulation (Table, Index, View, Function/Procedure, Package, Trigger, Job, Object, Collection, Table Function, Sequence, Directory, User, Schema etc.)

· ETL: Bulk data loading having used SQL Loader, multi table inserts, merge and external tables and Pipelined Functions.

· Implement Fine Grained Auditing (FGA) based on audit policies for different user group

· XML: Reading and processing XML from CLOB using XMLTYPE

· Advance Queuing, used packages DBMS_AQADM and DBMS_AQ

· Implement hints, indexes, bulk collect, partition tables and external tables for data loads

· Competent in performing basic DBA housekeeping duties like Import and export, performance tuning using ADDM, STATSPACK, TKPROF and EXPLAIN PLAN, design and management of tablespaces and other objects

Oracle Forms

· Oracle Forms & Reports - 6i, 10g, 12c including WEBUTIL use for client-side integration.

· Developing new and existing Oracle Forms, PL/SQL Libraries, Menu modules, and Oracle Reports.

· Debugging, tracing, tuning, optimising and refactoring PL/SQL programs stored in Oracle Forms (fmb), Library (pll) and Menu (mmb) modules

· Oracle Web Reports - using Java Script

Microsoft Office

Office 365: Apart from using MS -Office, you should be proficient in the following:

· Word with Mailmerge and COM Add-In

· Outlook with COM Add-In

· Excel - with capability to write Code within sheets to pull data from Databases and generate Graphs and other statistical reports