RN Personnel Reserves Transformation Programme - Digital Specialist APEX

Tender description

Summary of the work APEX developer support to the RN Personnel Data and Information Exploitation Programme Specialist role Developer Expected Contract Length 1 year Latest start date Monday 4 January 2021 Maximum Day Rate £730 Early Market Engagement This is a new role within an existing team. Who Speclialist Work With Navy, Navy Reserves and Civilian personnel, other contractors and support organisations operating in or contributing to the personnel management environment What Specialists Work On "To lead and undertake application design and development work for the Oracle and related applications to deliver and sustain the RN Personnel Information Exploitation Programme, its derivatives, sub-projects and related support activities with a specific focus on conversion of an existing application set to a new user cohort. " Skills & Experience • Skilled and experienced in front end application design and development using Oracle Application Express • Skilled and experienced designing and building role based custom security components in Apex. • Experience in the use of ORDS 18.3.0 including rest APIs and OAUTH2 • Experienced in Apex architecture, integration and security • Extensive experience of Oracle databases, scripting and security • Data Warehousing architecture and design • Data Integration using extract transform load tools • Skilled in Oracle Business Intelligence tools • In depth understanding of the HR data sets • Multiple full life cycle software project experience from initial design to build, deployment and testing. • Agile methodology adoption in projects • Running user workshops and liaising with business users in requirement gathering. • Skill in translating business objectives and ensuring the implementation is correctly aligned to requirements. • Experienced in the use of Oracle Database 18.0.0.3 • Experienced in the use of Oracle APEX 18.1 • Experienced in Oracle Linux 7 Nice to Haves • To be proficient in installation, architecture and migration of Oracle applications • Experience with Oracle databases, SQL, PL/SQL, XSLT, HTML, JavaScript, Apache 2.4, Tomcat, WebLogic and Oracle DBA skills • Experience in the development and execution of unit tests and automated web browser tests • Experience working in development teams, working with the Product Owner, requirements analysts and testers on an ongoing basis • Experience in sprint planning, daily stand-ups and retrospectives and demonstrating software solutions to stakeholders during sprint reviews • Experience in the production of technical documentation to support the application to the standards specified by the IAS Software Development Standards • Experience in the production of user stories • Experience of the RN and Army data warehouse structures • In depth understanding of the HR data sets for Ministry of Defence Armed Forces (JPA) • Experience in ensuring developed applications successfully transitions through system testing for subsequent deployment into a live hosting environment Work Location Remote where possible; Whale Island, Portsmouth for meetings and some travelling to Land HQ at Andover and other Navy sites as required. Working Arrangments The developer will be working in a team, with outcomes generated by the team to a schedule demanded by the Authority. Security Clearance SC is essential. Navy/MoD cannot sponsor security clearance No. of Specialists to Evaluate 3 Cultural Fit Criteria • Work as a team with our organisation and with other government organisations • Be transparent and collaborative when making decisions • Have a no-blame culture and encourage people to learn from their mistakes • Share knowledge and experience with other team members • Can work with customers with low technical expertise Assessment Method Interview Evaluation Weighting Technical competence 75% Cultural fit 5% Price 20% Questions from Suppliers 1. How will you assess the specialists? A Work History in the form of a CV will be required within 2 working days of being notified that a supplier has been down-selected. 2. Will this be assessed as inside IR35? Off-payroll working rules (IR35) do not apply. 3. Is there a Cyber Risk Assessment? The Cyber Risk Level is N/A. 4. Is there an incumbent supplier in the role? There is an incumbent delivering this portfolio management activity. 5. Would you accept a DV cleared candidate? Yes, we would accept a candidate with a DV for this role. 6. How crucial is it that this individual needs experience in all of the essential fields? This is a single requirement for one specialist and we are therefore looking for an exceptional portfolio with a wide range of expertise to deliver outcomes required. Suppliers/candidates will need to provide one example outlining their experience in each essential area. 7. Please can you confirm if there is an incumbent in this role There is currently no incumbent in this role. This is a new role. Please note the previous answer give at question 4 was incorrect. 8. Would you accept NPPV3? We are unable to accept clearances from non-MoD organisations because we are unable to verify and manage these. Candidates with other government clearances would need to apply through Defence Vetting for an SC which will take up to 3 months making them unable to begin work on the start date. 9. I am active Personal Security Clearance Certificate granted by the Kingdom of Netherlands, classified up to and included Nato Secret. Would you accept me on this project? We are unable to accept clearances from non-MoD organisations because we are unable to verify and manage these. Candidates with other government clearances would need to apply through Defence Vetting for an SC which will take up to 3 months making them unable to begin work on the start date.