Cloud Data Engineer

We are recruiting a Cloud Data Engineer for our Core Services team to support database services in Azure and working alongside the UK and India based product specialists. Acting as first line support for incidents, maintenance, and enhancements, you will provide the team with expertise to provide resolutions to problems and advice on improving and updating existing systems. Databases are hosted in Microsoft Azure and are primarily based on SQL Server (VM, PAAS, managed instance) with other associated services such as Data Factory. Overnight and weekend work will on occasion be required for maintenance and development work, which can only be performed during periods of low usage.

25 July 2022

Overview

Acting as first line support for incidents, maintenance, and enhancements, you will provide the team with expertise to provide resolutions to problems and advice on improving and updating existing systems.

Databases are hosted in Microsoft Azure and are primarily based on SQL Server (VM, PAAS, managed instance) with other associated services such as Data Factory.

Overnight and weekend work will on occasion be required for maintenance and development work, which can only be performed during periods of low usage.

 

Key Responsibilities:

 SQL Development/Data Factory (50%)

  • Develop, debug, and improve T-SQL stored procs that are used with Data Factory for ETL/ELT processes
  • Develop, debug, and improve T-SQL stored procs that are used for automation
  • Support, maintain and improve Azure Data Factory jobs

DBA Responsibilities (50%)

  • Support Mission critical databases running on Azure Managed Instance and Azure SQL Database and SQL VMs
  • Advanced troubleshooting skills for performance and tuning
  • Install, configures, maintain and patch SQL instances
  • Perform monitoring, troubleshooting, and optimizing performance of the databases
  • Transactional replication support

Required Qualification

  • B.E. Degree or equivalent experience (5+ Years)
  • Minimum 3 years All Supported SQL Servers Versions - Installation, configuration, customization, Security, maintenance, and performance tuning
  • Minimum 2 years T-SQL, stored procedures (Development experience)
  • Minimum 2 years Data Factory pipelines with dynamic content (expressions)
  • Experience with Power Shell Scripting              

Beneficial Skills

  • PowerShell
  • Prometheus/Grafana monitoring system
  • SQL encryption – TDE, column-level encryption
  • Working knowledge of windows server 2016 onwards
  • Experience of working with Git repositories
  • Financial system background or a strong interest in finance

What Will Help You Be Successful?

  • Microsoft development and technical skills
  • Ability to work independently, set priorities, handle multiple tasks with concentration, agility, and accuracy to meet deadlines
  • Ability to adapt to rapidly changing technology and apply to business needs
  • Strong written and verbal skills

How to apply?

If you are interested in applying, please send an email with an up-to-date Resume with Cloud Data Engineer in the Subject line to [email protected] 

 

Tags