In this role, you’ll be responsible for supporting and maintaining the SQL Server infrastructure, including databases and servers, as well as designing, developing, and tuning SQL databases and interfaces.
You’ll assist developers with query tuning and schema refinement and support the reporting infrastructure using SSRS and Power BI Server.
Collaboration with key users to document system requirements and working with development groups across the business are essential aspects of the role.
Main Responsibilities:
* Support and maintain the SQL Server infrastructure (databases and servers).
* Design, develop and tune SQL databases and SQL interfaces with databases.
* Assist developers with query tuning and schema refinement.
* Support and maintain the reporting infrastructure (SSRS and Power BI Server).
* Work with key users to document specific system requirements.
* Collaborate with development groups across the business.
* Evaluate alternative design concepts and recommend an optimal approach.
Essential Accountabilities:
* Experience with configuring and administering SQL Server databases and servers.
* Experience with backups, restores and recovery models.
* Proven experience of TSQL scripting and SQL Commands.
* Proven experience of optimising SQL queries for performance.
#J-18808-Ljbffr