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.
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:
* Significant experience developing and administering database solutions using Microsoft 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.
* 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.
#J-18808-Ljbffr