Description
SQL Server DBA - Full package Circa £45,000 - LeedsCurrently looking for a SQL Server DBA for an expanding manufacturing company based just outside of Leeds.
For the successful applicant this is a great opportunity to use the newest technologies from a DBA perspective as the company is currently working on SQL Server 2012 with a view of moving over to 2014 in the near future. With staff development a focus within the organisation, the successful applicant will be versatile and agile with a thirst for knowledge in IT.
Day to Day responsibility and Skills required
- Support /administer all production SQL Server databases (MSCS)
- Strong understanding of DTS, Triggers, Stored procedures, views and replication etc.
- Strong understanding of SQL replication (articles ,publications ,subscriptions)
- T-SQL scripting
- T-SQL performance tuning
- Responsible for database security, ssecurity hardening
- Database Design
- Reporting Services
- SSIS development and support
- Analysis Services
- Assist the Development /Business Intelligence Teams with database analysis and expertise.
- Monitor capacity, integrity and performance of production database(s).
- Monitor and tune database(s) for maximum performance
- Database troubleshooting
- Identify, investigate and rectify issues within the environment
- Provide monthly performance and growth statistics
- Provide monthly downtime statistics
- Responsible for database security
- Backup and Recovery (perform regular backup & recovery testing)
- Failover (perform regular failover testing)
- Document Backup & Recovery procedures
- Document Failover procedures
- Experience with general Microsoft HA including NLB and Clustering
Apply with an updated CV and I will contact to discuss times for interview with successful candidates in the coming days.