Job description
SQL DBA
Winchester, Hampshire
Hybrid Remote Working (Office visit once a week)
£40,000 - £50,000
We are seeking a SQL DBA to work with a fast growing technology company based in Central Winchester.
Our client, a successful marketing specialist is looking to recruit a SQL DBA to take ownership of the organisations Microsoft SQL servers, databases and data processes.
If you are keen to be part of a dynamic and fast growing company and have a real impact on the success of the business, this could be the ideal opportunity.
Key Responsibilities:
- Providing day to day support and administration of SQL and data warehousing environments.
- Maintaining a high level of availability of services, and minimising the risk of exposure to system downtime, through continual monitoring of key systems.
- Analyse systems proactively to identify problems and trends, propose technical solutions, and recommend changes to optimise system performance and usability.
- Liaise with developers and third parties to ensure standards and architectural principles are applied as appropriate.
- Create database environment support, maintenance and DR documentation.
- Provide training and mentoring to junior members of the team.
- Perform ad-hoc SQL tasks and automating repetitive jobs.
Essential Skills:
- Experience in database development and support in MSSQL environments
- Experience of supporting and maintaining MSSQL 2016/2019.
- Experience managing data warehouses in SQL Server.
- Proven ability in designing complex queries in SQL Server, with experience using large databases.
- Experience in troubleshooting and resolving MSSQL integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Knowledge of database backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
If you are looking for a role that will create the opportunity to make a real impact, whilst having the opportunity to generate a career with a passionate team then please send your CV to danielsumpter@spectrumit.co.uk or call 02380 765280.