Azure Data Engineer: SQL DBA: Global Energy Trading Co

London  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

World Leading Energy Company has an exciting opportunity for an Azure Data Engineer to be a part of their Global Energy Trading team.

The business is continuing to expand investment in data and analytics, with an ambition to share data and decision making capabilities across the organisation. This role is to support the IT delivery team to maintain a large, complex Azure-based data platform and assist teams with day to day data performance challenges.

About the Role:

As an expert in Azure data storage, you will:
Ensure the ongoing performance and reliability of several large data warehouses and Azure data storage solutions, including Synapse, SQL, Cosmos, Redis, blob, ADLS and other storage
Have a deep understanding of most of the storage options in Azure, and are able to provide detailed performance and configuration optimisation on them, including the impact on cost
Support multiple teams with complex problems which others have been unable to solve
Decompose work to a set of concrete steps, and manage delivery against those steps, ensuring progress towards the end goal

Key Skills/Essential Experience:
BS or MS in Computer Science or a related technical discipline. Equivalent practical experience is a reasonable substitute
Azure Storage - Excellent hands on practical experience of Microsoft Azure storage options including Synapse, SQL, Cosmos, blob, ADL, Redis, ELK, queues, tables etc. developed in complex, real world projects, including evaluating cost/performance trade-offs
Highly proficient Azure SQL Database DBA - optimisation of indexes, partitioning tables, queries and execution plans, permissions, performance, encryption, replication etc., including analysing database usage and proactive monitoring
Data warehousing - you'll know your star from your snowflake, when to use each, and when to use neither
Time series data - hands on experience working with this at scale while maintaining performance
Strong Transact SQL skills
CI/CD - hands on experience with automated deployment using GitHub actions and/or Azure DevOps and configuration management of both infrastructure (eg ARM, terraform etc.), and database & schema (eg dacpak, bakpak etc.)
Strong experience with PowerShell

This needs combining with a positive attitude and an ability to work within a large, globally dispersed project team in a multi-cultural environment. You also need to be a self-starter, a logical thinker and a quick learner, with strong initiative and excellent communication, interpersonal and presentation skills, able to write clearly and concisely. We believe in equality of opportunity for all job applicants regardless of gender, marital status, race, colour, nationality, ethnic origin, creed or religion, disability, sexual orientation or age. Specialising within Energy Trading, Oil & Gas, Financial Markets and TV & Entertainment, Eaglecliff Recruitment is ISO accredited, a Member of REC and listed within the top 4% for Financial stability by Dun & Bradstreet. Please telephone for an immediate response or email your CV for a reply within one hour. Eaglecliff Ltd is acting in the capacity of an employment agency for permanent recruitment and an employment business for contractor resourcing
Start date
2021-10-25
Duration
12 months Initially
From
Eaglecliff Recruitment
Published at
21.09.2021
Project ID:
2210863
Contract type
Freelance
To apply to this project you must log in.
Register