SQL Database Administrator
-
Location
Cardiff
-
Sector:
-
Job type:
-
Salary:
£60000 per annum
-
Contact:
Jeffrey Barr
-
Email:
jeffrey.barr@yolkrecruitment.com
-
Contact phone:
02920 220078
-
Job ref:
BH-29113
-
Published:
almost 2 years ago
-
Expiry date:
2022-07-09
-
Start date:
2022-06-08
-
Consultant:
ConsultantDrop
Yolk Recruitment are recruiting for a SQL Database Administrator for one of the UK’s leading insurance companies.
This is an exciting opportunity to build your skills in all areas of database management from overall design to optimisation.
You will be required to participate in an on-call rota. This role offers excellent benefits, progression opportunities and the company is highly rated in staff satisfaction.
Responsibilities:
- Day to Day administration ensuring that the database platforms are fully supported at all times.
- Conduct database performance, capacity, and security management.
- Maintaining a high level of availability of services, and minimising the risk of exposure to system downtime, through continual monitoring of key systems.
- Maintaining ER diagrams describing the application data model
- Improving monitoring of production databases to include metrics such as CPU, memory usage and IOPS
- Provide dashboards to management to illustrate monitored metrics.
- Analysing systems proactively to identify problems and trends, proposing technical solutions, and recommending changes to optimise system performance and usability.
- Conducting incident management, including post-incident reviews.
Core Skills:
- High level experience in database tools such as Microsoft SQL Server 2016 and MySQL.
- Broad experience in database development and support
- High level experience in MySQL or SQL Server database management
- High level Transact-SQL skills.
- Practical experience in query performance tuning including indexing and statistics.
- Knowledge of High Availability and SQL replication.
- In-Depth understanding and practical experience of Always on Availability Groups.
- Experience administering SQL Server Reporting Services.
- Experienced in Disaster Recovery techniques and solutions (Backup and Recovery).
Desirable Skills:
- Insight of SQL Integration Services and Analysis Services.
- Experience of Microsoft PowerBI.
- Experience with Microsoft SSIS and SSRS.
- Knowledge of Cloud technologies
- Experience working within ITIL framework (Incident Management, Problem Management, Change Control).
- Exposure working within a DevOps environment.
