Developer / DBA - Azue, SSMS, Python, SQL, Postgres


Premium Job From Experis IT

Recruiter

Experis IT

Listed on

1st April 2019

Location

London

Salary/Rate

£400 - £550

Type

Contract

Start Date

ASAP

This job has now expired please search on the home page to find live IT Jobs.

Developer / DBA - Azue, SSMS, Python, SQL, Postgres, Powershell, Scripting, PowerBI, Tableau, IaaS, PaaS, ETL, Data Modelling, Agile, Scrum, Git, Bash, Jira, Server, Database Administrator, Warehousing, Warehouse, Public Sector, Government, NHS, Health, Education, Cloud, Developing Development,An experienced developer is needed to:Work on the continuous development of a National Data Warehouse (SQL server 2016, which is deployed on Azure)Onboard 100+ datasets into the National Data Warehouse and refine these to meet user needs.Our client's Data Programme has been established with the aim of providing the business with 'a single source of the truth' via the National Data Warehouse.

The Data Warehouse is SQL server 2016 based service and consists of a number of database servers deployed in the Azure cloud environment.

Our current requirements framework has identified over 100 datasets that need to be onboarded to meet user needs.You'll be expected to work with the following:

Scrum Master, Service Manager (Product Owner) and wider Team (incl. data analysts, other developers and senior management)

Stakeholders such as:

- Business Managers and subject experts

- Others involved in the education and training of the multi professional healthcare workforceKey Skills / Experience:Have Microsoft Azure, particularly with reference to data warehouse architecture (IaaS and PaaS)Have database development using SSMS 2014 or higher experienceHave ETL development / deployment using SSIS 2014 or higher experienceHave data modelling / validation experiencesHave DBA skills (server management, SQL jobs management, scheduling, scaling, backup / restore, security, account management / permissions, server objects, replication)Have process automation experienceHave BI tools (particularly Tableau / PowerBI) experienceHave experience of different flavours of SQL (MySQL, Postgres etc)Have experience of Python, PowerShell, BashHave experience of source control (preferably Git)Have experience of orchestration optionsHave experience of collaboration tools (e.g. MS Teams / Slack / JIRA)Have experience of Agile working methodsCommunicate effectively, with a friendly approachable mannerCollaborate with / challenge / assist staff to identify, develop and deploy best practice approaches to data warehousingWork using our own agile project management approach, taking independent responsibility for significant workWork with analysts to assist with data set specifications and the formulation of data models for data set representation in the data warehouse.Assess analysts' abilities to conduct their own on-boarding activities, configuring jobs and automation, identifying suitable data sets and providing training as appropriateSupport process design and maintain documentation, including training manuals / user guidanceWork within a healthcare domain with awareness of maintaining confidentiality and implementing data protection legislation / information governance requirementsIdentify and manage / report risks

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: