Senior Developer - Database Management and Analysis - Reading

This job has now expired please search on the home page to find live IT Jobs.

The Rural Payments Agency has a unique role within the UK economy and rural landscape. We pay farmers and land owners over £2 billion each year to support a thriving farming and food sector.

We also administer over 40 different schemes that to help ensure a sustainable rural economy and communities.

You can be part of the work that is keeping our rural economy strong and have the opportunity work at the leading edge of the new digital government agenda.

Behind the scenes here, our in-house IT experts keep things running smoothly - ensuring everyday essential technology is in place and effective, as well as introducing innovative and bespoke solutions to improve the service we deliver to our customers.

Your role will be essential in this.

A career in the Rural Payments Agency offers on the job learning, exciting career development opportunities and comprehensive Civil Service benefits package, including:

- A generous annual leave allowance

- Membership of the Civil Service Sports and Social network and enjoyment of a range of associated benefits and discounts.

- Discounts for computing hardware and software.

- Civil Service Pension

- Flexible working arrangements to support a positive work/life balance

- Childcare vouchers

- Eyecare vouchers

- Cycle to work scheme

- Support with season ticket purchase

- Support with parking arrangements

As part of the internal development function within RPA's I&T development team you will act as a lead developer, developing and maintaining reporting / data warehouse solutions.

The role will cover:

- Development and support of reporting / data warehouse solutions using Oracle DB, Informatica and Business Objects.

- Development and support activities will encompass:

- Project Management of small IT developments

- Impact assessment of new requirements from business areas.

- Producing technical designs and data models

- Development - coding and unit testing of the application / reporting solution as specified in the design specification

- System testing - creation and execution of test plans to test the complete system

- Resolution of incident and problems reported against production systems.

- Analysing and quality checking developments prior to implementation.

- Implementation of developments to live.

- Admin of SQL end users and potentially Informatica

Assessment Information:

Candidates should apply by uploading a current CV. Your CV will be assessed on the lead competency ' SFIA: Programming and Software Development (PROG) (please see attachment for information).

Successful candidates will be assessed at interview on the following criteria (and should therefore come equipped with examples as detailed within the competency guidance links):

-SFIA: Programming and Software Development (PROG)

-Changing and Improving

-Delivering at Pace

-SFIA: Database / Repository Design (DBDS)

Person specification

The role requires proven experience in:

1. Experience and expertise using advanced features of Oracle SQL / PLSQLL, including analysing large datasets, developing ETL routines, automating and applying optimisation techniques.

2. Design and building of a reporting / data warehouse solutions including hands on experience of ETL development using Informatica Power Centre.

3. Development of Kimball based data warehouse multi dimensional / Star Schema data structures.

And some or all of the following technologies

(a) Reporting tools such as Business Objects

(b) Oracle Application Express (Apex)

(d) MS SQL Server Management Studio, SSIS & SSRS

(e) MS Visual Studio

(f) Oracle 12c

To apply please click the APPLY button.