Recruiter

Vanquis Bank Don't show me jobs from Vanquis Bank

Salary

From £40,000 to £45,000 per year

Location

Chatham Don't show me jobs in this location

Job term

Permanent

Job hours

Full time

SQL Server Database Developer At Vanquis we offer customers excellent products backed by great people, which is why we were voted Credit Card Provider of the Year in 2009, 2010 and 2011 and have now accepted over 1 million customers. We have a vacancy for a SQL Server Database Developer to help us provide an outstanding service to our customers. 80% of our customers would recommend us to a friend. We've got a great business, fantastic people and ambitious growth plans. By taking advantage of this great opportunity to join us as a SQL Server Database Developer you can become part of a business where people come first and employee engagement is recognised as a major key to company success. Our SQL team of seven are currently working on the launch of new platform supporting International cards and UK Loans, Application system upgrades, Enterprise Data Warehouse and BI development as well as continual improvement of the core Credit Card business. In summary, your key responsibilities will be: *Architect and build new database (T-SQL) and ETL solutions (SSIS/ DTS) for strategic projects and key business initiatives *Provide consultancy to business users where required translating technical terminology and concepts for the understanding of the end user *Design and create Business Intelligence solutions (cubes) *Support SQL Server environments and processes to achieve departmental and company BAU uptime SLAs (including out of hours support as standard) *Ensure the department's adherence to the banks change and release management practises supported by appropriate source control tools (Redgate SQL Source Control and Microsoft Team Foundation Server) More specifically, you'll need to cover the following: *Development and Maintenance of T-SQL Scripting, Stored Procedures, DTS/SSIS and ETL routines *Create and maintain OLAP cubes using SSAS *Develop and maintain reporting using SSRS and other tools *T-SQL query optimisation *Ensure that new data sources are compatible with the data warehouse infrastructure and can be accommodated via ETL techniques *Provide consultancy to business colleagues (departmental and project orientated) regarding application, solution, ETL and database development and design. *As and when required, carry out database administration and maintenance tasks including capacity planning, security and integrity planning, index generation, performance tuning (including ETL and stored procedures) and any other associated administration processes *Support and adherence to Change Management practices *Work with Third Parties to deploy changes to data structures and content *Troubleshoot failures of implemented processes, including those designed and implemented by other Database developers, administrators or external resources *Migration to, and support of, SQL 2008/12 including rewriting of DTS ETL procedures into SSIS You'll need knowledge of the following: *Database development techniques and technologies *Data Warehousing techniques and technologies *SQL 2005/8 (essential) Experience, skills and behaviours: *You also have a proven track record in database design, development and ETL technologies and excellent Transact SQL skills *You are trained and practiced in Data Warehouse technologies and techniques *You have experience of working on large projects *You have experience of SQL Server database administration techniques and processes *A Microsoft Certified Developer qualification would be a distinct advantage *We need someone who is adaptable and able to work as part of a Team using initiative alongside their more analytical skills *You'll need to be a strong communicator who is able to build relationships whilst driving and managing change *You are confident in your decision making and understand the change management process