Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9nb2xklwdyb3vwl2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

SQL DBA

Location: Redhill, Surrey Salary: £50000 - £55000 per annum + Benefits
Sector: IT & Telecoms Type: Permanent
Contact: Sam Francis Job Published: 24 days ago

Job title: SQL DBA

Based: Redhill, Surrey

Salary: £50,000-£55,000 + benefits and Bonus

Job Purpose

Primarily to maintain all company SQL databases & SQL environments, manage all policy data import, audit and reporting processes. To ensure robust retrieval and load processes are in place and that all business critical data is available, accurate and consistent. Provide a supporting role to the DW Developer to maintain the data warehouse ETL processes, design and build new solutions where required. This is a Senior DBA role.

Key responsibilities of the Senior SQL DBA

  • Design, build and maintain SQL to load data from various sources including external clients and internal systems.
  • Design, build and maintain processes that monitor the status of automated SQL jobs.
  • Design, build and maintain SQL and other processes to load data from various source systems into the Data Warehouse SQL environment
  • Identify opportunities to improve processes and performance.
  • Ensure the requisite levels of security are in place to restrict access to those individuals and rocesses that require it. This included database encryption where required.
  • Work with Operational and Commercial colleagues to understand the business information requirements.
  • Work with Business Intelligence and other IT colleagues to meet the demands of the business and to promote enhanced solutions.
  • Ensure the line manager is informed of any potentially serious issues in a timely manner.
  • Always follow industry recognised best practices when designing and implementing solutions where realistically possible.
  • Provide technical support to colleagues in the IT department.
  • Any other duties that may reasonably be required from time to time including ad hoc work at other offices where work necessitates being on location.

Essential Tech Skills:

  • Highly skilled in Microsoft SQL including an in depth knowledge of Transact-SQL, Query Analyser, DTS and Scheduler , store procedures, views, SSIS
  • Able to design, build and maintain automated SSIS packages.
  • Knowledge of transactional database designs & modelling
  • DBA responsibilities, including backups, security (SQL, AD, NTFS), performance tuning and database maintenance.
  • Familiarity with database encryption such as TDE ( Transparent Data Encryption)
  • Skilled in Business Analysis & demonstrate an ability to understand clearly what the business information need is behind any request and shape the solution accordingly.
  • Experience of working with clients or third party technical departments
  • At least 3 years experience in a corporate environment.

Desirable:

  • A relevant SQL Server accreditation\certification
  • Knowledge of various versions of SQLServer 2008 & 2012 ideally.
  • Skilled in building and maintaining data warehouses (Enterprise Model and Star Schema data marts) in SQLServer.
  • Familiarity with the full Business Intelligence project lifecycle and data warehousing concepts or exposure to other reporting suites. Msoft, Crystal, Cognos..
  • Familiarity of other development languages (XML, .net, vb)
  • Previous experience at an assistance company regulated by the FCA

Services advertised by Gold Group are those of an Agency and/or an Employment Business.
We will contact you within the next 14 days if you are selected for interview. Privacy Policy. Equal Opportunity and Diversity Policy.

Similar Jobs

SQL Server DBA

Newbury, Berkshire £50000 - £55000 per annum

SQL Server Database Administrator My client is looking for a SQL Server Database Administrator to join their software company. The Successful SQL DBA will manage the SQL Server systems. Maintaining day to day operations of the systems, managing user requests, and wor...

Apply

Data Consultant

Horsham, West Sussex £400 - £500 per day

Data Consultant 3 month contract- immediate starter £400-£500/day Role Description: Someone enthusiastic about modelling and transforming data as well as using data visualisations to tell a story. A background in data consultancy focusing on analytics and BI would be...

Apply

Full Stack Developer - C# / .NET - Software Engineer

Crawley, West Sussex £45000 - £55000 per annum

Full Stack Platform Developer - Software Engineer - Crawley - £45,000-£55,000 Full Stack Platform Developer required for a multinational client, within the manufacturing sector, based in the Crawley area. Our client has a number of positions available, and is open to...

Apply

Data Scientist- Current SC clearance

Portsmouth, Hampshire £400 - £500 per day

Data Scientist- Current SC clearance Portsmouth £400-£500/day Clearance: SC - UK National, please only apply if you have current SC clearance Job Description: Working within the client Project to develop the Data Science modules required for Initial Operating Capabil...

Apply