Database Administrator

1 month ago


Littlewick Green, United Kingdom Kensington Mortgage Company Full time

When we started Kensington we were the first specialist lender to offer mortgages to people the high street turned down. Over 25 years later, we're the UK's leading specialist mortgage lender still blazing a trail offering people the chance to get a mortgage.Where high street lenders see black and white, we've 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, it'san approach that can make a real difference to people who want to own a property.

It's what we call the Kensington Difference.

**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 (2K5 through to 2019).

These databases are a mixture of in house and supplier developed environments.

Work with all other areas of IT to 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.

**Key Accountabilities**
- Must have strong coding skills in PowerShell and TSQL, and experience setting on custom monitoring and reporting.
- 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.
- 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**
- Microsoft Certified IT Professional: Database Administrator (2005/2008/2012) - desirable but not essential



  • Littlewick Green, United Kingdom Kensington Mortgage Company Full time

    When we started Kensington we were the first specialist lender to offer mortgages to people the high street turned down. Nearly 25 years later, we're the UK's leading residential specialist mortgage lender still blazing a trail offering people the chanceto get a mortgage. Where high street lenders see black and white, we've always used our expertise and...


  • Brook Green, Greater London, United Kingdom CTS Recruitment Full time

    Data and Systems Administrator - Education Sector £35,000 - Multi-site 80% in Hammersmith and 20% Ashford Surrey - Hours 8am to 4.30pm Monday to Friday. We would like to appoint an experienced Data and Systems Administrator to join this education institute. Data/systems Administrator will support the Head of IT and be responsible for managing the...


  • Brook Green, Greater London, United Kingdom CTS Recruitment Full time

    Data and Systems Administrator - Education Sector £35,000 - Multi-site 80% in Hammersmith and 20% Ashford Surrey - Hours 8am to 4.30pm Monday to Friday. We would like to appoint an experienced Data and Systems Administrator to join this education institute. Data/systems Administrator will support the Head of IT and be responsible for managing the...


  • Woodford Green, Greater London, United Kingdom The Graduate Project Full time

    Company And Role Overview - Our client is a well established financial services organisation, who are looking to recruit for an Administrator to join their dynamic team to provide crucial administrative support to their company Work hand in hand with their Administration Manager and Assistant Administration Manager to guarantee the delivery of exceptional...

  • HR Administrator

    6 days ago


    Marston Green, United Kingdom The Recruitment Group Full time

    **HR Administrator - 12 Months FTC - Covering Maternity Leave** **Location: Birmingham B37 (Near Airport)** **Hours of work: 8.30am - 5.00pm - Mon - Fri** **Salary: £11.00ph - £12,00ph (D.O.E.) (£21,450pa - £23,400pa)** **What you will have** - **Minimum 2 years’ experience working in an HR department, ideally within manufacturing.**: - Microsoft...

  • Administrator

    4 weeks ago


    Woodford Green, United Kingdom Carlton Mays Full time

    Administrator / Junior Administrator (Hybrid role) | Woodford | c £20K - £30K Neg / DOE We are seeking an Administrator / Junior Administrator to join our client at their office in Woodford, East London. A background in Financial Services is desirable but not essential as full training can be provided for the right applicant. You will be supporting the...


  • Woodford Green, United Kingdom Haven House Children’s Hospice Full time

    **Family & Administration Support Co-ordinator Job title**: Family & Administration Support Co-ordinator Reports to: Family & Administration Support Lead Salary: Band 2 £24,000 PURPOSE OF THE ROLE The Family Administration Support Team (FAST) provides day to day administration to the Care directorate. FAST acts as the first point of contact for families,...

  • HR Administrator

    4 weeks ago


    Edmonton Green, United Kingdom AuB Talent Full time

    The Role: HR AdministratorLocation: London ( North - N18)Salary Circa £30k-£35k + short term FTCThe CompanyOur client is a successful operator in the environmental energy sector, they are in need of an accomplished HR Administrator to join them on an short term contract to spring clean their HR files.The Role * Joining our HR team on a short term contract...


  • Golders Green, United Kingdom Pro People Full time

    **Property Administrator** KEY BENEFITS: - **£25,000 £30,000 per annum**: - **Well established local property business with over 30 years history and a great reputation**: - **Great company atmosphere** KEY REQUIREMENTS: - **Must be degree educated**: - **Looking for a career in property**: - **Well spoken and presented** PROPERTY ADMINISTRATOR...


  • Wood Green, United Kingdom RDE Consultants Full time

    Training regarding the construction industry will be provided. **Responsibilities**: - Input figures and other data into database. - Be able to communicate with other departments. - Organise and disseminate documents. - Organise financial documents for archiving. - Filing and general office administration. **Skills**: - Comfortable using Microsoft...


  • Woodford Green, United Kingdom A1 Personnel Employment Agency Ltd Full time

    A1 Personnel are looking for an Administrator on behalf of our client based in Woodford Green Duties - Answering telephones - Data inputting - Booking appointments with clients - Preparing source documentation needed for new clients. - Responding to routine queries and requests from Clients, managers, employees and colleagues - To ensure that new referrals...


  • Green Street Green, United Kingdom PDR Solutions Ltd Full time

    Are you organised and attentive with an eye for detail? Do you have a bookkeeping, accounts or finance background? Do thrive in a busy, robust environment? My Client are looking for an experienced Accounts Administrator to become an integral part of their growing business, ensuring all financial transactions are processed accurately and on time. In this...


  • Tottenham Green, United Kingdom TMR Group Full time

    **Data Analytical Administrator** **Tottenham** **Up to £35,000** **The company** An award winning environmental services business that has built a solid reputation within their marketplace. Recent investment has allowed for expansion plans. **What will you do?** - Typing, compiling, and preparing reports, presentations, and correspondences - Running...


  • Wood Green, United Kingdom Specsavers Full time

    **Role: Hearcare Administrator.** **Location: North Finchley Hearcare, London.** **Hours: Full time only.** **Salary: DOE** **What we can offer you** - Competitive pay rate - Excellent benefits - A progressive working environment - A place of work where you’ll see peoples lives get changed - A supportive and caring tight-knit team **About the...


  • Avonmore and Brook Green, United Kingdom CTS Recruitment Full time

    Data and Systems Administrator – Education Sector £35,000 – Multi-site 80% in Hammersmith and 20% Ashford Surrey - Hours 8am to 4.30pm Monday to Friday.We would like to appoint an experienced Data and Systems Administrator to join this education institute.Duties will include: * Data/systems Administrator will support the Head of IT and be responsible...


  • Golders Green, United Kingdom Kasmir Associates Full time

    Are you good with numbers? are you a recent graduate eager to kickstart your career as an Administrator within the financial services/lending industry, looking for career progression? Are you someone with exceptional organisational skills, ready to take on a dynamic role in loan management? If so, we have the perfect opportunity for you!Due to an internal...


  • Woodford Green, United Kingdom Solasta Wealth Management Full time

    Solasta Wealth Management is a well-established and highly successful Wealth Management practice providing bespoke face-to-face financial advice to individuals and businesses throughout the UK. As an appointed representative of St. James's Place Wealth Management, we pride ourselves on delivering exceptional service and tailored solutions to meet our...


  • Brook Green, Greater London, United Kingdom CTS Recruitment Full time

    Data and Systems Administrator – Education Sector £35,000 – Multi-site 80% in Hammersmith and 20% Ashford Surrey - Hours 8am to 4.30pm Monday to Friday. We would like to appoint an experienced Data and Systems Administrator to join this education institute. Duties will include: Data/systems Administrator will support the Head of IT and be responsible...


  • Brook Green, Greater London, United Kingdom CTS Recruitment Full time

    Data and Systems Administrator – Education Sector £35,000 – Multi-site 80% in Hammersmith and 20% Ashford Surrey - Hours 8am to 4.30pm Monday to Friday. We would like to appoint an experienced Data and Systems Administrator to join this education institute. Duties will include: Data/systems Administrator will support the Head of IT and be responsible...

  • Admin Support

    3 days ago


    Borough Green, United Kingdom Stanmore Quality Surfacing Ltd Full time

    **SQS is now looking for an Admin Support to join the Transport Team in our Scratchwood, Brentwood or Borough Green Depot.** **Overall purpose of the job**: To work with our Plant, Vehicle and Transport team to manage the administration of our Company's vehicles and Plant. **Key Responsibilities**: Accurate inputting, record keeping and maintenance of...