Our client is a leading technology solutions provider based in Newport Pagnell. They deliver cutting-edge software and data solutions to a diverse range of clients.
What you'll do
- Manage and maintain SQL Server databases.
- Design, develop, and implement stored procedures and functions.
- Optimise database performance through indexing and performance tuning.
- Ensure data integrity and implement security measures.
- Perform regular database backups and recovery procedures.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- Collaborate with developers to improve applications and establish best practices.
- Generate reports and provide data analysis using Power BI.
- Troubleshoot database-related issues and provide timely resolutions.
- Document database changes and provide training to team members as needed.
What you need
- Proven experience as a SQL Database Administrator.
- Strong proficiency in SQL and database management.
- Expertise in creating and managing stored procedures.
- In-depth knowledge of indexing and performance tuning.
- Experience with database backup, recovery, and security practices.
- Hands-on experience with Power BI for reporting and data visualisation.
- Proficiency in SQL development and scripting tools, with a strong understanding of Microsoft SQL Server Stack (SSMS, SSAS, SSIS & SSRS).
Desirable Skills:
- Knowledge of Azure SQL Database or other cloud-based database services.
- Experience with database replication and clustering.
- Familiarity with other BI tools and data visualisation software.
- Experience with the Fabric suite