Skip to main content

This job has expired

SQL Developer

Employer
Tech Mahindra
Location
Erskine
Salary
350 GBP /Day
Closing date
26 Mar 2019

View more

Clearance Level
DV, SC
Sector
Information Technology
Job Type
Contract

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

Desirable Skills

  • SSIS experience and development skills required

 

Personal Competencies

o Strong interpersonal skills

·          Focused, disciplined and organized

·          Able to work well under pressure

 o Strong communication, documentation and meeting skills

 o Problem solving  

·          Perform root cause analysis and problem solve in complex situations

 o Analytical skills   

 o Methodical approach, pragmatic

   

Security Level                         Q1

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert