Overview Job Description:

You will be analysing, developing (T-SQL, SSIS, SSAS), deploying, maintaining, and supporting databases including data-management, planning, administration, and performance tuning/ optimisation.

Main Duties and Responsibilities:

• Ensuring related control procedure, working mechanism and standards compliance including change definition, review, and control of production deployment. Providing input to associated Change Boards.
• Documenting purpose and apply source control across the database estate closing any gaps identified.
• Recommending and delivering database solutions acting as the technical focal point for team members, endorsing standards and best practice.
• Delivering high-quality database change, for example in the context of ERP updates, producing associated test plans and evidence in a change-controlled environment.
• Providing related database support and execute frequency-based activities
• Implementing, maintaining and supporting:

• Databases in Microsoft SQL Server including SSIS packages and SSAS tabular models.
• T-SQL objects including queries, tables, views, functions, triggers, stored procedures, and SQL Agent jobs.
• The database logic underpinning ERP, reporting and applications.
• Work with the business ensuring all database needs are met.

Frequency-based

• Database administration including data growth management, ETL, backups, indexing, performance tuning and creation of test/staging environments.
• Execution of month end database activities.
• Database-related support including issue diagnosis and resolution.

Applicants to this role require:

Essential

• Relevant degree or equivalent experience
• Significant experience developing and administering database solutions using Microfost SQL Server technologies.
• Experience working in a database environment with applied standards and control mechanisms including associated ownership and accountability.
• Maintenance of data warehouses.
• Delivery of database solutions in an ERP environment.
• Microsoft SQL Server database development & administration (SSAS tabular models, SSIS, SQL Server Agent Jobs, maintenance, and performance tuning).
• Strong T-SQL development skills including schema, query and table design, views, functions, indexes, triggers, and stored procedures.
• Strong interpersonal, written, and verbal communication with the ability to convey appropriate technical detail at all levels and build rapport.
• SQL development best-practices, coding standards, and source/version control including monitoring and ensuring compliance.
• Change control including documentation/definition, proposal, review, and deployment to production.

Desirable

• Relevant certification (desirable).
• Experience of manufacturing, distribution, and sales databases.
• Supporting co-workers on the use of database technologies and solutions including T-SQL.
• Implementation of data warehouses.
• Knowledge of SSRS, Crystal Reports and Excel reporting in the context of providing underlying database logic.

TMM Recruitment INDIT