SQL Database Administrator

Location
Leeds
Salary
Up to £32,000 D.O.E + 10% annual bonus
Posted
15 Nov 2016
Closes
05 Dec 2016
Ref
4119
Contact
Applicant Services
Sectors
IT
Contract Type
Permanent
Hours
Full Time
SQL Database Administrator
Leeds, LS28
Up to £32,000 D.O.E + 10% annual bonus

Our client has identified an excellent opportunity for an experienced SQL Database Administrator to provide a secure, scalable, performing, compliant database infrastructure to support and further enhance our clients existing systems.
The SQL Database Administrator will be ultimately responsible for delivering any data related requests to the business in accordance with best practice security standards.
Position Summary
As SQL Database Administrator, your role will involve an array of tasks including;
• Troubleshooting SQL Server service outages as they occur, including after-hours and weekends
• Troubleshoot user complaints about system performance
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes or index/query changes
• Conduct SQL Server training sessions for the data team
• Provide coaching and mentoring of the data teams SQL tasks
• Advise the data team on the most efficient database designs (tables, datatypes, stored procedures, functions and views)
• Design tables and assign data types in-line with clients data classification requirements
• Implement and document SQL Database Administrator security ensuring roles and permissions are enforced and managed using best practice
• Be the in house go to person for T-SQL questions
• Ensure all database servers are backed up in a way that meets the clients Recovery Point Objectives (RPO)
• Test backups to ensure we can meet clients Recovery Time Objectives (RTO)
• As new systems, suppliers and sellers are on-boarded, use the relevant technology and best practice DB configurations
• Work with the developers and data team on the most resource-intensive queries on the server and suggest ways to improve performance
• Ensure all DB’s are managed and maintained securely, in-line with all of our clients policies and procedures
• To take responsibility for risk and compliance within the remit of your role.

What do you need?
The successful candidate will hold the required skills and experience to undertake this role, including;
Industry experience;
• 5+ years using SQL Integration Services and Reporting Services
• 2+ years using SQL Analysis Services
• Minimum of 5 years experience in writing and improving SQL Server T-SQL queries
• Minimum of 5 years experience with on-call troubleshooting experience with production SQL Server
Skills;
• Configuration of SQL Server monitoring utilities to proactively manage performance and minimise the risk of failures
• Installation and configuration of new SQL Servers
• Deploying database change scripts provided by third party suppliers
• Full documentation at all levels of database environments
• Must have had the DBA title or responsibilities in your previous job descriptions
• Has been in the position as the one person that the company would call if the SQL Server service stopped working
• Experience using DMV queries to answer questions about server-level performance
• Works at all times within CSA, FCA, ICO & all other regulatory rules & guidelines
• Diagnose server reliability and performance issues using free tools
• Tuning T-SQL queries to improve performance
• Ensure that new database, MI and BI code meets company standards for readability, reliability and performance
• Ensure that new database, MI and BI code is delivered following a rigid change control and management process from approval to sign off
• Works well independently and as part of a team


If you wish to be considered for this SQL Database Administrator role click ‘apply’. You will receive an email shortly after your application - you will need to read and respond to this to complete your application.


You must be eligible to work in the UK.

More jobs like this