Overview of the role
The management Well’s Data Platform is a key enabler to effective decision making within the business. The DBA role is key to this, helping to exploit the data we have to improve complex data journeys. Ongoing management, development, and optimisation of our data estate. You'll be part of the transformation of our enterprise SQL data platform, implementing solutions, as required.
Main Responsibility
- Capacity planning – Work with the development team to analyse the need of storage and backup space in production servers based on usage
- Support software installation and maintenance – Initial installation and configuration of new SQL Servers based on industry best practice, apply patches and upgrade to SQL Servers as required. Manage data transfers to new platforms and setup replications where needed.
- Database Backup and Recovery - create backup and recovery plans and procedures based on industry best practices. Analyse and recommend database services most suited to project requirements.
- Database tuning - As part of on-going maintenance, proactively tune and optimise the database to operate at maximum efficiency. This could be configurations changes, indexing the DB or help the developers tune their queries to improve performance.
- Troubleshooting – support the operations team in resolving issues with DB, work with Infrastructure team to restore data or connectivity issues. Security monitoring – Identify and analyse potential weaknesses and recommend/implement best practices to minimize risks. Analyse logs for possible damage in case of breach.
- Performance monitoring – Monitor DB performance for any issue and make changes in the configurations and provide recommendation for hardware capacity.
- Automation of routine processes using T-SQL, PowerShell and\or other scripting languages.
- Develop solution/proof of concepts to various data requirements. Good understanding of data privacy rules and data regulations.
Problem Solving & Change:
- Ability to think outside the box and challenge existing processes and practices
- A positive team player that is enthusiastic, energetic and creative
- Good communication skills with an ability to convey technical concepts to a non-technical audience
- Confident self-starter, with strong attention to detail
- Mentor and guide the wider DBA & Master Data teams
Key knowledge and skills required:
- Minimum 5 years of experience working with Microsoft SQL database systems required.
- Experience in migrating databases between different server versions and implementing data retention policies.
- Microsoft SQL DBA experience with HA\DR features like SQL Failover clustering and Always On.
- Experience in Microsoft SQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, T-SQL programming, backup & recovery, monitoring, and database and query tuning.
- Knowledge of database related tech: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SSIS & SSRS. Knowledge of other database systems (MYSQL etc.) is a bonus but not essential
- Version control e.g., VSTS/TFS or GitHub.
The Ideal Candidate
- Good Collaboration and Team Ethic skills.
- Strong Stakeholder Management
- Good business acumen/ Customer Focus
Well are proud to be a diverse and inclusive employer. If you have any specific requirements, we'll do everything we can to support you. Whether it is to find a pharmacy that is accessible, or if it is a part time position you are looking for, we can help find the role that is right for you. If you need us to make any reasonable adjustments to our recruitment process, we will be happy to accommodate you.
Please be aware that due to the high number of applications we receive it may not be possible for us to provide an outcome to all applicants. If you are not contacted within 28 days of your submission unfortunately you will have been unsuccessful.
Closing date 28th August 2022
Package Description
- Competitive salaries
- Excellent training & development opportunities
- Paid Holidays
- Workplace pension scheme
- Staff Discount
- Travel Loans and more…
About the Company
For over 70 years, we’ve been looking after the health and wellbeing of communities across the UK. Well Pharmacy is the third largest pharmacy chain in the UK with c.760 pharmacies and a team of around 7,000 colleagues based across our Community Pharmacies, Online Pharmacy, Healthcare Services Centre, Community Drivers, Bestway Medhub & Wardles team and our Support Centre team.
Our mission is to be here for the wellbeing of our patients and customers, to provide the best community pharmacy experience in the UK for everyone, for our patients, our customers, our people, and our NHS.
The pharmacy of the future will look very different from the one we know today. It will play a huge role in transforming primary healthcare and we will play a central role in bringing it to life.
We will use our clinical expertise and technological ambition to take advantage of the potential this future has to offer us. Making medicines, advice, services and care available in the places and spaces that people need and want it most.
We want to be a great business. To be recognised as delivering a community pharmacy experience that is the best there is. To do this we want our teams to feel proud about the positive impact they make, feel valued as part of a close-knit and expert community, and feel confident in their role in a business that is stable, innovative, and caring.
‘Together we make a difference’
