SQL Developer


Premium Job From Experis IT

Recruiter

Experis IT

Listed on

22nd February 2019

Location

Erskine

Salary/Rate

£300 - £325

Type

Contract

Start Date

asap

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

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.

Job title: SQL Developer

Rate: £325.00 per day

Duration: 6 months

Location: Erskine, Scotland

Key responsibilities:

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.

Essential Skills:

* SQL 2014 cluster

* Database Development

* Windows/ SQL Server

* 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

* SSIS experience and development skills required

* Strong interpersonal skills

* Focused, disciplined and organized

* Able to work well under pressure

* Strong communication, documentation and meeting skills

* Problem solving

* Perform root cause analysis and problem solve in complex situations

* Analytical skills

* Methodical approach, pragmatic

Expected 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

You are currently using an outdated browser.

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