Database Administrator DBA

Job Description

When we started Kensington we were the first specialist lender to offer mortgages to people the high street turned down. Over 25 years later, were the UKs leading specialist mortgage lender still blazing a trail offering people the chance to get a mortgage.Where high street lenders see black and white, weve always used our expertise and manual underwriting capability to see the shades in between. In a market where changing lifestyles mean more people are falling outside the traditional mortgage criteria, itsan approach that can make a real difference to people who want to own a property.Its what we call the Kensington Difference.Kensington Mortgage Company is a wholly owned subsidiary of Barclays Bank UK PLC from 1 March 2023, and the principal activity of the Company is the origination and servicing of mortgage assets. The Company is authorised by the Financial Conduct Authorityfor regulated activities. Overall Purpose of Job As a member of the database team, the DBA should demonstrate a strong technical ability across the Microsoft SQL stack, as well as the ability to work with other DBAs and wider teams. This role will focus heavily on monitoring, reporting, performance tuning,ETL, High Availability, disaster recovery and release management.Support, maintenance, and administration of the on-prem SQL Server estate deployed at Kensington, whilst participating in design, planning and migration to off-prem, cloud-based solutions.The estate covers multiple environments (PROD, DR, UAT, Test and Development) and multiple SQL versions (2012 through to 2019).These databases are a mixture of in house and supplier developed environments.Work with other IT functions and areas of the business where needed, to ensure requests are met and fixed in a timely manner.Work on further monitoring using PowerShell, SQL Agent Jobs and TSQL.Work on DR and HA solutions and help to create a DR plan for all PROD systems.They should have a strong customer service focus and be accustomed to working with best practices frameworks for change management and release management.They will provide analysis and development support to the BI, application and project teams where required.Key Accountabilities

• Must have strong coding skills in PowerShell and TSQL, and experience with custom monitoring and reporting technologies.
• Monitor databases for errors, perform problem determination and apply appropriate remediation when necessary.
• Providing database usage and performance reports, setting up SQL Server Agent jobs, operators and alerts.
• Understanding and management of database backup and recovery techniques.
• Understanding and creation of disaster recovery solutions for SQL.
• Design and implement database migration and upgrade strategies.
• Maintain SQL Server security via regular auditing.
• Maintain database changes from Development through to Production following agreed release management processes.
• Patching of the SQL estate to keep SQL servers secure and in a supportable state.
• Design and implement highly available production systems (Clustering, replication, DB Mirroring).
• Understanding of ETL, and batch processes, using replication and SSIS.
• Maximum attention for details is essential for this role.
• Understand DNS and DFS.
• Ability to provide overnight on-call support for batch processes.

Experience, Knowledge, Skills

• Bringing strong DBA skill set to the team
• Ensure that all databases are maintained in a professional and cost effective manner and are available for the business (including IT) according to published SLAs.
• Interact with teams on both an application level and a technical level to bring issues to resolution
• Have worked in an ETL driven environment
• Have worked extensively with PowerShell to create custom scripts
• To have set up a full DR environment
• Understanding of a release best practice
• Have pride in ensuring best practice is kept to
• Created custom reports using Power BI and SSRS
• Have used Redgate tools

Qualifications The following certifications are desirable but not required:

• Microsoft Certified IT Professional: Database Administrator
• Microsoft Technology Associate
• Microsoft Certified: Azure Database Administrator Associate

Your Opportunity Our employees are critical to our success. We work hard to ensure that Kensington Mortgages is a great place to work. We recognise the difference it makes to our business when people challenge themselves and take advantage of the development opportunitiesavailable so we try and support everyone however we can.We also recognise the fact that people seek work life balance and continuously develop our benefits offering to create an inclusive and supportive culture where differences that exist between us all are recognised, understood and valued.If you want to make a Difference, apply now.

Keyskills :
sql DBA powershell tsql azure etl Database administrator full stack