Azure / SQL Database Developer

Azure / SQL Database Developer As an Azure Database Developer some of your key duties will include managing, administering and securing SQL Server databases on-premise, at our clients data centre, and in Azure. You will ensure database performance and make recommendations with regards scaling (up vs. out vs. db sharding) and implement high availability and disaster recovery with Azure SQL Database. Other responsibilities may include: Deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof Provide technical expertise on data storage structures, data mining, and data cleansing Manage, administer, and secure SQL Server databases on-premise, at our data centre, and in Azure Design and provision new Azure SQL databases for our operational data stores and coordinate data migration Ensure database performance and make recommendations with regards scaling (up vs. out vs. db sharding) Manage data access and ensure that all data is secured and protected appropriately. Use automatic database backups and temporal tables to restore a database or row version to a point in time when necessary. Implement high availability and disaster recovery with Azure SQL Database Automate common management tasks with suitable tools, such as PowerShell Monitor and tune database and data pipeline performance and make recommendations when appropriate (query and data flow optimisation, index creation and maintenance) Monitor space usage and data transfer rates in Azure Implement data archiving strategy in accordance with agreed business expectations. Deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof. Design, code, test, correct, and document programs and scripts. Maintain system and application documentation. Ensure that data ingestion/ETL processes are scheduled at optimal times so as not to conflict with other batch processes. Evaluate changes and updates to source production systems and advise team members of their impact on the data warehouse, analytics models, and reporting systems. Provide technical expertise on data storage structures, data mining, and data cleansing. Support 3rd parties to deliver DBA tasks and provide hands-on support when required. General Provide guidance to other members of the team. Comply with any training requests identified as necessary to meet the requirements of the post and such other duties as are deemed necessary to meet departmental requirements. Take pride in own work and that of the team. Take ownership and responsibility for accomplishing objectives. Conscientiously follow through on commitments. Demonstrate resilience under demanding pressures and circumstances. The post-holder will be required to undertake such tasks as may be reasonably expected within the scope and grading of the post. Additional Key Duties Recommend ways to improve data efficiency and reliability Identify new opportunities for process improvement You will be expected to provide ad-hoc out of hours additional support during a major incident (Severity 1 or 2) where the business need demands it. In business areas where regular issues will occur, you may be expected to form part of an out of hours rota system. At the time of a major incident, you may be asked to perform an emergency job role away from your regular role. This will be led and managed by the incident manager at the time of the incident until such a time where the incident is deemed by the incident manager to be over. You will not be expected to do both duties during that time, however, the new role may be significantly different from your regular role. Strong experience in the majority of the following will be essential: Detailed understanding of designing, building, maintaining, and optimising structured database systems, including MS SQL Server (essential) and MySQL (desirable). Experience using Azure technologies: Data Factory v1 & v2, Data Lake, Azure Synapse Analytics, Stream Analytics, PolyBase, and u-SQL Experience of following tools: SSMS, SSIS, Visual Studio, Azure portal, Azure Data Studio, Azure CLI. Advanced knowledge of SQL queries, stored procedures and triggers. Ability to tune and optimise query performance, recommend indexes. Basic understanding of unstructured, NoSQL database systems Knowledge of PowerShell, ADO.Net, REST API, OData Desirable Skills and Experience: Understanding of project management methodologies (Agile, Prince 2). Knowledge of applicable data privacy practices and laws. Understanding of the ITIL and Service Desk process.