Database Engineer - VR/28735
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 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
Job Alerts
Straight to
your inbox
Receive information on the latest job opportunities by email. Subscribing to our job alert service is convenient and easy.
Sign Up NowOUR TEAM
Recruitment Specialists
Great recruitment is all about the people you work with. We take the work we do for you, not ourselves, really seriously.
Our Team