SQL Server DBA


London - London

£50,000 - £60,000   10% Bonus + Generous

Senior SQL Server DBA - Cool new Azure environment - Financial Services

Senior SQL Server DBA and the chance to join a really progressive boutique financial services organisation that are going through a huge Azure transformation - so a very modern and future-proof data environment. Our client have been an established brand within their niche sector in the FS market for over 40 years now and continue to thrive in this ever-evolving space. With offices across the world and over 500 employees in the business, they are a truly global and recognised brand in the financial sphere.

In this role you will maintain and support the database server estates and assist with their migration to Azure. The production database server estate supports our client's business-critical transactional websites as well as its internal line-of-business and BI/reporting applications. The non-production estate supports development and testing by the internal application development and BI/reporting teams. The current database platform is SQL Server virtualised on VMWare, with the majority of the production estate running SQL Server 2012 /2016 Enterprise. Other platforms in use include Oracle 12c, PostgreSQL and MySQL. As part of the MAJOR cloud transformation project, database workloads are being migrated to Azure cloud platform as a mix of IaaS or PaaS solutions with future modernisation to PaaS Azure SQL Managed Instance and Azure SQL Database. This *is* the modern data environment to working in.

Core skills needed:

  • All SQL Server editions 2012 / 2014 / 2016 / 2017/ 2019 and database administration, including HA and DR technologies
  • T-SQL and PowerShell scripting
  • Maintaining and securing SQL servers, in physical, virtualized and Microsoft Azure environments.
  • Solid experience of supporting backup and recovery solution for a SQL estate
  • Proven experience of migrating SQL services to Azure IaaS and PaaS
  • Experience with Azure SQL Managed Instances and Azure SQL Database PaaS solutions - Elastic Pools
  • Automating database deployments using CI/CD pipelines
  • Troubleshooting and performance tuning
  • Database Replication
  • Microsoft SQL Server SSIS and SSRS administration
  • Windows Server 2012, 2016 and 2019, including basic Active Directory and networking

Desirable Skills:

  • Terraform experience
  • Oracle, PostgreSQL and MySQL administration
  • Quest Spotlight for SQL Server Enterprise (or similar database monitoring tools)

Key tasks:

  • Pro-actively monitor the production and non-production database environments, ensuring optimum performance, reliability and availability
  • Help maintain the database by performing backups and restores, database sizing/capacity planning and security reviews
  • Make recommendations for improvements
  • Maintain and update documentation
  • Migration of database systems to Microsoft Azure on IaaS or PaaS solutions
  • Modernise existing Azure SQL Server IaaS solutions to Azure Managed Instance or Azure SQL Database.

Benefits:

  • 26 days holiday per year, plus the normal public holidays
  • 10% bonus (discretionary)
  • Life Assurance
  • Free breakfast when working in the office
  • Private medical insurance once probation period passed
  • 4% pension company contribution
  • Plus, much more!

This a brilliant opportunity to join a company that's on a really exciting technology transformation with multiple big, innovative projects at an international business with a well-known name in the financial space. If this sounds like the role for you, please apply and I'll be in touch!

Senior SQL Server DBA - Cool new Azure environment - Financial Services

SQL Server DBA Azure SQL




Updated: Tue May 04 2021 16:04:31 GMT+0000 (Coordinated Universal Time)