Database Developer


Premium Job From British Trust for Ornitholgy

Recruiter

British Trust for Ornitholgy

Listed on

30th July 2018

Location

Norfolk

Salary/Rate

£26280 - £29201

Type

Permanent

Start Date

ASAP

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

'A WORLD INSPIRED BY BIRDS AND INFORMED BY SCIENCE’

BTO harnesses the skills and passion of birdwatchers to advance our understanding of ornithology and produce impartial science, communicated so that it can be of benefit to everyone.

OUR GOALS

BTO increases knowledge of birds and other wildlife, and their relationships with the environment and people, by:

-Enabling more people to learn about birds and science and grow through participation in environmental discovery.

-Delivering impartial, impactful and relevant science.

-Inspiring and empowering people with an understanding of birds and the importance of knowledge.

OUR PRIORITIES

We will reach our goals by:

-Providing more and better opportunities for people to contribute to our work.

-Monitoring the status of species, researching their ecology and understanding how they respond to change.

-Communicating great stories that bring to life the long-term data, information and knowledge that we hold.

OUR IMPACT

Our surveys, monitoring schemes and research programmes are designed by expert scientists to answer some of the most pressing questions affecting birds and their habitats. Because of our independence we are able to share our data, expertise and knowledge to inform decision-makers, educate the public and support conservation action. Our long-term datasets provide a measure of change and enable us to look for impacts and test solutions. Our vibrant volunteer network makes us highly effective and ensures that our work reflects the interests of those for whom birds and wildlife are important.

OUR FOUNDATIONS AND VALUES

The success of BTO is based on firm foundations that include: motivated and skilled staff and volunteers; a strong reputation; a robust business model and effective governance systems and processes.

We are:

-Inclusive and supportive

-Impartial

-Passionate

-Collaborative and open to new ideas

The post-holder will be expected to play a key role in the technical development of the BTO’s database systems. These databases underpin the scientific and engagement work of the BTO as well as its internal business processes. The principal focus will be on development within an Oracle environment and the role will involve working closely with a wide range of staff across the BTO.

WHAT YOU WILL DELIVER

The successful applicant will:

-To develop and maintain high quality Oracle SQL and PL/SQL database software applications for the entry, management and reporting of ornithological data collected from the web and other sources. To use considerable personal initiative in undertaking these tasks, while working closely with survey organizers and other members of the IS team as appropriate.

-To build data warehouse functionality using PostgreSQL to improve efficient access to the Trust’s ornithological datasets.

-To undertake the maintenance and development of links between the in-house CiviCRM membership database (based on MariaDB) and the online Oracle database to ensure integrity and synchronization.

-To make a significant contribution to the technical administration of the BTO’s databases.

-To write high quality comprehensive specifications and technical documentation for the applications under development, in collaboration with survey organisers and users. This will cover both user instructions and technical information required for software maintenance and further development.

-To organise user testing of software applications, to evaluate the results of tests and to make necessary corrections to the software.

-To maintain and develop a good level of expertise in relevant aspects of ORACLE database operation.

-To contribute to the systems administration of the Trust’s computers and websites, including monitoring users, security, backups and resource use, and to provide advice to staff at all levels on a wide variety of computing topics.

-To undertake occasional weekend monitoring of the online database and web applications on a rota system.

WHAT YOU WILL BRING TO THE IS TEAM

Essential:

-A very good knowledge of the principles of building, maintaining and interrogating SQL databases within an Oracle environment. Good expertise in ensuring database integrity in a complex multi project database.

-Knowledge and experience of designing database objects for efficiency of storage and performance.

-Expertise in creating properly tuned PL/SQL stored procedures and SQL statements for efficient DML statements and reports.

-Expertise in the use of multi-user database systems to manage complex data, and the ability to communicate well with users to identify requirements and translate them into database structures.

-Excellent organisational and documentation skills, and experience of coding in a team using version control.

-The ability to write clear and well-presented requirement and specification documents.

-A good understanding of secure coding principles and recognised standards

-A working knowledge of Linux in a server environment, together with the use of Windows and Macs to perform development work.

-A good general knowledge of computing and a willingness and aptitude to investigate and use new and more efficient techniques as they evolve.

-Ability to work effectively on own initiative, individually and within a small team.

-The ability to communicate well with individuals within the Trust, members, volunteers and the public with a wide range of expertise and to be able to explain or discuss technical issues in understandable terms.

Desirable:

-Expertise in PostgreSQL

-Expertise in MariaDB / MySQL

-A basic knowledge of web applications, particularly using web forms to collect, store and retrieve data.

-An interest or active engagement in wildlife, conservation or science generally.

FIND OUT MORE ABOUT THE ROLE

For an informal chat about the position please contact Andrew Joys, Senior Database Officer.

SALARY AND BENEFITS

A starting salary of £26,280 rising to £29,201 over two years (including a 7% MFS).

A 37-hour working week.

The post will be based at BTO, The Nunnery, Thetford, Norfolk, IP24 2PU.

Annual leave entitlement on starting is 25 days plus bank holidays. The post holder will qualify for life assurance (four times salary) and be automatically enrolled in the BTO group personal pension scheme, benefitting from an 11% employer contribution.

MAKING AN APPLICATION

If you have what it takes then we look forward to hearing from you - send your completed application form with a CV to Sian Knott stating the job title in the subject line. Click the APPLY button.

Closing date for receipt of applications is 1pm on Monday 27 August.

It is anticipated that interviews will be held on Tuesday 4 September in Thetford, at the BTO, IP24 2PU.

If you have a disability or long-term illness that otherwise prevents you from meeting any of the essential criteria, please contact us to discuss whether a reasonable adjustment could be made.

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: