This Job Vacancy has Expired!

Midweight SQL Database Administrator

Posted on Aug 1, 2019 by CV-Library

Dorset, United Kingdom
Wholesale Trade
Immediate Start
Annual Salary
Full-Time
Job Title: Midweight SQL Database Administrator

Location: Bournemouth, Dorset

Salary: Competitive

Hours: Full Time, Permanent, 40 hours per week

Our fun and award winning client are currently on the lookout for a Database Administrator. This is a stimulating role that is extremely rewarding for the right candidate and offers great career progression opportunities.

Overview:

The DBA will be part of the development team and share responsibility for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. The role is demanding, but will be hugely rewarding for the right candidate.

Key Areas of Responsibility:

* Create and manage multiple databases and assist in capacity planning

* Monitor, maintain database systems and troubleshoot problems that may arise

* Maintain data integrity and security (manage roles and permissions of database users)

* Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them

* Develop strategies and implement solutions for managing back-ups, restoration and replication

* Create and manage constraints and indexes

* Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures

* Proactive housekeeping/archiving and shrinking of databases

* Manage production, QA and development database environments

* Create detailed documentation including diagrams of database infrastructure

* Learn relevant business processes and understand the data flow, criticality and dependencies

* Effectively coordinate and communicate with all the stakeholders (internal teams and clients)

* Set up and maintain database infrastructure for the company’s Business Intelligence needs

Candidate Specification:

* Bachelors or Master’s degree in computer science or equivalent education and experience

* Commercial experience in administering Microsoft SQL server databases (SQL Server 2012 or above), ideally 2 years experience and above

* 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)

* Knowledge of RDBMS concepts, database architecture and SQL/T-SQL

* Experience of SQL server profiler for monitoring and troubleshooting database activity and performance

* Ability to develop procedure documents and maintain detailed database related documents

* Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies

Benefits:

Competitive basic salary

Annual salary review

Up to 25* days a year holiday entitlement (plus bank holidays)

Flexi-time (subject to completion of training

Access to Perkbox e.g. high street discounts, cycle to work scheme etc. (after 6 months)

Buy & Sell Holiday Scheme (after 12 months)

Get your birthday as a paid day off (after 12months)

Childcare Vouchers (after 12 months)

Private Medical Insurance or £500 towards Gym Membership (after 24 months)

£300 towards a training program or course of your choice (after 24 months)

Free access to online training platform - covering multiple subjects including hobbies.

Regular Team Incentives

Excellent Training Program to help increase your knowledge and skillset

Ref: 8987

It is important that you include a covering letter with your CV, detailing why you feel you are suitable for this position and highlighting all relevant experience.

By applying for the role, you agree that Fresh Recruits may contact you under GDPR Article 6(1)(b) in connection with your application by email and/or telephone and you consent to receiving information by email and/or telephone in relation to Fresh Recruits providing you with work finding services, you may withdraw your consent at any time.

If you do not hear from us within 3 working days please assume your application has not been taken forward on this occasion. We may contact you in the future about other suitable positions

Reference: 210419851