SQL SERVER DEVELOPER

Job type:
on-site
Start date:
ASAP
Duration:
12 MONTHS
From:
LA International Computer Consultants Ltd
Location:
Surrey
Published at:
02/23/2021
Country:
flag_no United Kingdom
Project ID:
2056083

Warning
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

SQL SERVER DEVELOPER
WORKING FROM HOME
ASAP START DATE
12 MONTH CONTRACT
INSIDE IR35
* SECURITY CLEARANCE REQUIRED.*

SQL Server Developer Role Definition

About the role
The role will involve:
*Onboarding an existing ASP.NET 2.0 Visual Basic application from an external supplier. The SQLServer developer will be responsible for managing the database components of the application. The application is written in VB.NET, runs on an IIS server and connects to a SQLServer database. This onboarding will involve:

oDoing Knowledge Transfer with the current supplier to ensure that all relevant information is captured and retained, specifically around the database, the database schema, any database routines that are run and ensuring that the database is appropriately configured.

oWorking with the rest of the team documenting the system thoroughly. This documentation will include the application itself as well as appropriate support processes.

*Once the application is onboarded you will work with the other developers, Principle Engineer, DevOps, business analysts and the business unit to refine the business requirements and further develop the application. You will be involved in designing, running and improving software that meets user needs.

*Assisting the testers through the test life cycle into production. Once the system is in production, proving Early Life Support until the system is accepted into life. At this point the developer will be involved in Level 3 Support as well as further development of the application.

*Working within the Azure cloud.

The work will be done as part of an Agile team and other team members will include Scrum Master, Business Analysts, Testers, Windows Dev Ops & Principle engineers.

You will work to our technical standards writing clean, secure code following a test-driven approach, ensuring the code is open as far as possible and can be re-used.

Main responsibilities
Your main day to day responsibilities will be:
*managing all MS SQLServer application database development.
*delivering secure, reliable and scalable software in your team; undertaking a breadth of development tasks
*designing new software using appropriate tools and in line with standards, proving designs through prototyping
*reporting on system performance and supporting test activities; keeping documentation up to date
*supporting services you have delivered through regular maintenance activities, balancing your work with your leadership
*working with other engineers to deliver new capability, for instance improved CI/CD pipelines or test approaches

Other day to day activities
All our engineers will be expected to embody an open and positive approach, supporting
*progressing the Profession, understanding all roles and helping to build our community
*working and assessing to appropriate standards: for instance, accessibility, the GDS service standard and our own community practices
*improving our skills and approaches as well as keeping up to speed with the technology landscape

Skills and experience
Essential Skills
You'll have a demonstrable experience in:

*significant SQL development in various versions of MS SQLServer.
*Working with ASP.NET developers and an understanding of how data would be transferred between the various components in an ASP.NET system.
*Ability to work with existing code and to maintain it, manage it and update it to work in later versions of SQLServer.
*Experience of linking SQLServer to Outlook to generate mail.
*Experience of Crystal Reports would be an advantage.

The skills listed above are reflective of the Profession Skills and Competency Model (based on the industry standard SFIA framework). Please see below for the relevant skills for your role, with overall SFIA 3 level required:

Strategy and Architecture

*Technical Strategy and Planning
oData Management (DATM)

Development and Implementation

*Systems Development
oSoftware Design (SWDN)
oProgramming/Software Development (PROG)
oTesting (TEST)

*Installation and Integration
oSystems Integration and Build (SINT)

Delivery and Operation

*Service Operation
oApplication Support (ASUP)

Desirable Skills
Ideally you will also have the following skills or experience in:
*Ability to work with Legacy software and to provide clear guidance on updating the code.
*Work closely with ASP developers.

LA International Computer Consultants Ltd is an HMG Approved Consultancy and operates as an IT & Engineering Consultancy or as an Employment Business & Agency, depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, we welcome applications from all sections of the community and from people with diverse experience and backgrounds.

Award Winning LA International Computer Consultants Ltd (Recruiter Awards for Excellence - Best IT, Best Public Sector & Gold Awards) and the most prestigious award that any business can receive The Queens Award for Enterprise: International Trade 2015.