Role Overview & Mandate
Executive Summary
Company Description As our Senior Database Administrator, you will be responsible for the management of production and non-...
Reviewed by Compensation & Visa Analysts •
Sources: USCIS E-Verify & Home Office CoS
As our Senior Database Administrator, you will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases.
Join us at Greene King the country's leading pub company and brewer, where our mission is to pour happiness into lives and become the pride of great British hospitality. We have something special, deeply rooted in our 220-year brewing and pub history, creating the business we are proudly known for today. Still today our 39,000 strong team are the guardians of what’s wholly British, the pub experience.
Additional Information
We’re all about rewarding our teams hard work, that’s why…
You’ll receive a competitive salary, pension contribution as well as:
- The chance to further your career across our well-known brands – as one of the industry's top apprenticeship providers, we can provide training and development at each level of your career.
- Discount of 33% for you and 15% for your loved ones on all of our brands – so you enjoy your favourite food and drink at a discount.
- Free employee assistance program – mental health, well-being, financial, and legal support because you matter!
- Discount of 50% for you and 25% for your loved ones at our Greene King Inns and hotels. – so you can enjoy a weekend away without breaking the bank.
- Refer a friend – who do you know who could be interested in a new role? When they are placed, you could earn up to £1,000 for referring them!
- Wage Stream – access your wage before payday for when life happens.
- Retail discounts – receive up to 30% off at Superdrug, exclusive discounts with three mobile along with many more…
Job Description
In your role as Senior Database Administrator you will….
Be accountable for the following within Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server and other related products as applicable and necessary…
- Install/Configure/Setup/Administer and maintain production and non-production environment, Setup High-Availability and Disaster Recovery, Plan and test high availability and disaster recovery, create users, resolve database integrity, performance, blocking, connectivity, and replication issues
- Detect and resolve database-related issues. perform and manage Database backup/recovery/restore and capacity monitoring
- Identify and setup alerts and logging in Azure
- Maintain databases – Statistics, Indexes, fragmentation
- Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)
- Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
- Coordinate removal and/or archiving of data that is no longer required to be available in the production databases
What you’ll bring…
- Hard working with the ability to work under pressure and unsupervised, persistent/tenacious/diligent with keen attention to detail
- Good customer communication skills
- Microsoft Azure Cloud Database Services, Azure SQL Database, Azure SQL Managed Instance, Azure Cosmos DB, Azure Database Migration Service
- SQL Server Database Administration
- Windows Server administration & support
- Investigating/Troubleshooting database related incidents
- You will need experience of SQL, basic coding, windows OS Environments, log analysis, building and using testing plans
Knowledge of:
- VMWare administration
- VEEAM administration
- NetApp administration
#LI-AC1
