Database & Reporting Engineer - VR/28735

Status: Permanent
Location: Aberdeen
Rate: Available Upon Request

Opportunity for an experienced Database Engineer to make a positive impact within a varied position. Analysis, development, maintenance, and support of SQL databases. Significant experience using Microsoft SQL Server technologies required.

   

Purpose of the Job

  • Analysing, designing, developing, maintaining, administering, and supporting databases and dependent reporting including data-management.
  • Ensuring SQL and reporting standards compliance including change definition, review, and control of production deployment. Input to associated Change Boards.
  • Documenting and applying source control across the SQL and reporting estate addressing any gaps identified.
  • Owning and championing related business systems procedures and working mechanisms continuously improving compliance.
  • Engaging within business systems and the wider organisation to recommend and deliver database and reporting solutions.
  • Coaching business systems team members on SQL and reporting technical aspects, coding standards and best-practice.
  • Deploying and upgrading database and reporting solutions, supporting technology transition.
  • Database planning, administration, and performance tuning/optimisation.
  • Related support and frequency-based activities.

     

Main Duties and Responsibilities

  • Databases in Microsoft SQL Server including OLAP-based reporting.
  • Lifecycle management of SQL objects including queries, views, functions, triggers, and stored procedures.
  • Business reporting in Excel and SSRS.
  • Application databases and associated reporting.
  • Maintaining and developing OLAP reporting and data warehouse and related ETL routines (SSIS / SSAS).
  • Working with the business ensuring all reporting and database needs are met.
  • Database administration including data growth management, backups, indexing, performance tuning etc.
  • Contributing to the execution of month end processing, systems maintenance, and related reporting.
  • Contributing to related support.

     

Applicants to this role require

  • Significant experience delivering database and reporting solutions using MS SQL Server technologies.
  • Experience working within an environment requiring a high level of standards compliance and procedural control including related ownership, accountability, and responsibility.
  • Implementation and maintenance of data warehouses and business reporting / intelligence solutions.
  • Strong interpersonal skills with the ability to build rapport.
  • Ability to convey appropriate technical detail at all levels.
  • Microsoft SQL Server Database development and administration (SSAS, SSIS, SSRS, SQL Server Agent Jobs, maintenance, backup, performance tuning).
  • Advanced T-SQL (schema and query design, views, functions, stored procedures).
  • Excellent written and verbal communication skills.
  • Documentation and issue tracking.

TMM Recruitment INDIT

We're sorry!

Our website has detected that you are using an out of date or unsupported web browser (Internet Explorer Version 11 or below).

Please use a modern browser to access our site and revisit us once you have upgraded, thank you.

Download Google Chrome Browser
Download Chrome
Download Mozilla Firefox Browser
Download Firefox
Download Internet Explorer Edge Browser
Download IE Edge