SQL Developer
Recruiter
Listed on
Location
Salary/Rate
Type
Start Date
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: £400.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