MS SQL/DBA Developer

Pontoon ,
London, Greater London
More Details

Overview

MS SQL Developer - Contract - London - Financial Services MS SQL/DBA Developer Contract until 31 Dec 2020 initially London Financial Services £Competitivepwd Summary: The Data and MI Development team within Portfolio Analytics is responsible for delivering business intelligence solutions, sourcing and maintaining portfolio data that supports database processing and production of analytic and reporting capabilities. We need to ensure robust and reliable delivery, by focusing on infrastructure, databases, reporting tools and reconciliations. We have 4 functions: 1) developing and understanding of robust source feeds 2) architecture of IT hardware and design and build of databases to process the data 3) reporting data to users through web based reports / OLAP engines / database extracts 4) production services around the above. This role requires full software development lifecycle skills and involves business communication and stakeholder management, design and development, requiring advanced development skills in a number of technologies to complement the candidate's experience of managing / participation in an agile development team. Main: Accountabilities: Support the leadership of the data team within Portfolio Analytics Stakeholder management, engagement and feedback Ensure that the end to end process from sourcing data through to availability of reporting runs smoothly, efficiently and is reconcilable Manage / perform the design and build of the database engine and reporting capabilities and assist with ETL as necessary Assist with recommendations of hardware implementation to optimise the usage of current hardware available Maintain documentation of systems architecture, processes and procedures and the code repository is up to date Key Capabilities / Knowledge Experience in designing and building MI systems for finance / risk as part of a team. Preferably Microsoft Certified. Experience in technical project management / technical business analyst and comfortable with stakeholder management. Preferably PRINCE 2 with experience of different development approaches, eg Agile and Waterfall Experience in development of tactical and enterprise level solutions Experience in management and resolution of data quality issues Experience in installing / specifying hardware that is suitable for the short / medium term Experience in a development environment and familiar with setting up and maintaining Active Directory groups, shelling onto servers, starting and stopping windows services, administering IIS, setting up and monitoring SQL Server Agent jobs and configuring database mail / SMTP Experience in personnel management, selection, recruitment and ongoing management Experience with source control software and the processes put in place to release code through the Dev / UAT / Prod chain

People also viewed