SQL Developer - Manchester
- Recruiter
- BCT Resourcing
- Location
- Manchester, Greater Manchester
- Salary
- £35,000 - £45,000 per annum
- Posted
- 17 May 2017
- Closes
- 14 Jun 2017
- Ref
- 1416963
- Sectors
- IT, Programming
- Contract Type
- Permanent
- Hours
- Full Time
Job Title: IT SQL Developer
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server 2008 - 2016 (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation.
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server 2008 - 2016 (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation.