Information (SQL) Developer


Premium Job From TechnoRecruit

Recruiter

TechnoRecruit

Listed on

25th February 2019

Location

Erskine

Salary/Rate

Upto £300

Type

Permanent

Start Date

March 2019 - September 2019 (6 month contract)

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

SC Cleared

Role overview

Part of the Software Engineering Team responsible for the design and development of the Client project. This will require experience throughout the entire software lifecycle and a drive to achieve excellent results.  This role is pure database development and not infrastructure linked however interaction with the infrastructure team is part of the role. The role will be someone that performs tasks set-up by the project manager and or tech lead set out in the project schedule. Ensure database behave as designed and expected in a complex environment

Day to Day Responsibilities

The project is to migrate existing SQL database and content from a legacy Windows platform to an up to date platform.  Some functional changes are required to the database. Security aspects of the applications need to be reassessed. 

The ability to define and elicit detailed software requirements is an essential part of the role and knowledge of use case modeling would also be desirable. The role will require close liaison with the requirements analysts and business analysts so strong communication and the ability to articulate design linkage to requirements is required. The ability to provide reasoned detailed estimates will be a key aspect of the role and working with both project management and other technical personnel will be on a daily basis.

Working knowledge of, and a proven ability, to specify and conduct detailed unit and system integration testing is essential (and derivatives) being strongly desired. Interfacing with test professionals is a required element of the role and the ability to review test collateral will be expected as part of the software engineering team. 

The ability to conduct code reviews and inspections and provide constructive comments will be expected. A proven ability in problem determination will also need to be demonstrated with an understanding of debugging and fault finding essential.

The ability to express the database's requirements of the infrastructure to the project infrastructure team.  Ability to diagnose issues with database integration with infrastructure.

Assumed Skills:

Requirements analysis

Able to take direction

Can follow direction

Modular Design

Unit Testing

Integration Testing

Functional enhancements

Experience of Configuration Management & source control tools

Build tool chain experience (e.g. make, Visual Studio)

Troubleshooting and fault finding

Able to commit to and meet to deadlines

Essential Skills

o SQL 2014 cluster

o Database Development

o Windows/ SQL Server

o Strong understanding of end to end software lifecycle

Develop, optimize and implement stored procedures & functions

Look at existing applications and review where improvements can be made.

Analyst SQL queries - look to implement new queries and solutions

To follow processes across change and release management - including testing processes

Reviewing query performance and optimizing code

Writing queries used for front-end applications (websites, desktop applications, or cloud apps)

Working with application developers to create optimized queries

Creating database triggers for automation, e.g., automatic email notifications

Programming views, stored procedures, and functions

Specify database tables to meet application needs

Specify database table indexes to ensure that application queries to database run efficiently

You are currently using an outdated browser.

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