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:
Essential
- Relevant degree or equivalent experience
- 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.
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.