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