Java Development Team-ViSOR, Software Engineering Group - Home Office

Oracle Database Designer and Administrator copy

2 Incomplete applications

2 SME, 0 large

7 SME, 2 large

Specialist role: Designer
Summary of the work: Oracle Database Designer and Administrator able to action the requirement of ViSOR Governance and Change Management Groups and design changes to an Oracle Database to facilitate changes on the application. Engage in their deployment on the Police National Computer. Act on requests for large scale data extracts and FOI requests.
Latest start date: Sunday 1 July 2018
Expected contract length: 2 years
Location: London
Organisation the work is for: Java Development Team-ViSOR, Software Engineering Group - Home Office
Maximum day rate: £800

Early market engagement
Who the specialist will work with: Specialist will be working directly with a Business Design Systems Analyst, 3 Oracle Developers, 2 Oracle Test Analysts, the Product and Service Manager. Plus regular interfaces with Governance members, users and PNC technicians
What the specialist will work on: ViSOR Releases for 2018/19, Support for ViSOR Migration, Static Maintenance Releases, 3rd Line Support on Business Issues, Data Extract Reports, FOI Requests, Input on ITHC issues, Assistance with transition to NLEDS, Support improvements to Business Continuity

Address where the work will take place: 1st Floor, Fry Building, 2 Marsham Street, London,SW1P 4DF. Or, Bernard Weatherill House, 9th Floor, 8 Mint Walk, Croydon, CR0 1EA
Working arrangements: Expectation to be onsite for 5 day working week. However, home working facility being sought for use no more that 2 working days per week. Onsite working to be in a secure area with JDT-ViSOR
Security clearance: SC and NPPV Level 3

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Essential skills and experience: Oracle Database Administration and design on multiple versions of Oracle 7 through to 12.

Advanced Database Design and implementation using various toolsets.

Knowledge of supporting tools such as TOAD, Rational Toolset and Oracle Enterprise Manager.

Knowledge of supporting Oracle toolsets such as Application server.

Knowledge of development design from J2EE and Web Based applications.

Advance Tuning and performance management skills.

Knowledge of Windows, Unix and Linux OS to support development.
Nice-to-have skills and experience: Working knowledge of client tools and good understanding of client practices

Good business knowledge of Offender Management and Intelligence based system including knowledge of current legislation

Excellent ability to deal with users regarding live support and data requests

How many specialists to evaluate

Cultural fit criteria

Flexible, Supportive, Questioning and Calm
Work as a team with our organisation and other stakeholders, including willingness to share information and pass knowledge
Transparent and collaborative when making decisions
Have a no-blame-culture and encourage people to learn from their mistakes

Assessment methods

Evaluation weighting

Technical competence

50%

Cultural fit

20%

Price

30%

1. Would SC clearance be enough for an individual to commence work on the project or is NPPV Level 3 required before one can start onsite?: NPPV Level 3 would be required prior to commencement onsite. ViSOR and NPIRMT standards require this given the sensitivity of the application
2. Will the Home assist with our SC cleared Business and Systems Analyst through NPPV Level 3?: The Home Office can advise on the NPPV Level 3 clearance process but active administrative assistance is not given.
3. Is there an incumbent in the role currently please?: The role is currently fulfilled by an incumbent
4. Please can you confirm the IR35 status of this role? 2) Please can you confirm if there is a current incumbent in the role?: The IR35 status of the current incumbent is ‘exempt’
5. In regard to the below experience required - could you please clarify if you are looking for the successful candidate to have worked on these specifically? Criminal Justice and Immigration Act 2009, Sexual Offences (Scotland) Act 2009, Sexual Offences Act 2003 (Remedial) (Scotland) Order 2011,: That would be preferable, but if a candidate can demonstrate good knowledge of the legislation that would suffice.