SQL Database Analyst

Recruiter
Focus Resourcing Group
Location
Derby
Salary
£45000 - £50000 per annum + Career progression
Posted
15 Apr 2017
Closes
14 May 2017
Contract Type
Permanent
Hours
Full Time

Our client based in Derby is looking for an SQL Database Analyst to join their team. The role will involve maintaining the company's database systems including back-up, performance tuning, capacity planning, monitoring critical events and documentation. You will ideally possess an innovative mindset and be proactive and thorough in your approach.


Responsibilities:

  • To create and manage multiple databases and assist in capacity planning
  • To monitor, maintain database systems and troubleshoot problems that may arise
  • To maintain data integrity and security (manage roles and permissions of database users)
  • To use tools like SQL profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • To develop strategies and implement solutions for managing back-ups, restoration and replication
  • To support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures
  • To create detailed documentation including diagrams of database infrastructure
  • To learn relevant business processes and understand the data flow, criticality and dependencies

Essential Attributes:

  • Bachelors or Master's degree in computer science or equivalent education and experience
  • Advanced experience in administering Microsoft SQL server databases (SQL Server 2012)
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
  • Experienced in ETL (Extract-Transform-Load) development / data integration
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage

Company offer an excellent working environment and benefit package. Ongoing career progression