Loading...
Share this Job

MES Database Analyst

Location: 

Knottingley Head Office/CTS, West Yorkshire, GB

Job ID:  14123
Estimated Travel:  0 - 25%
Contract Type:  Permanent
Talent Area:  IT

Ardagh Group is a global leader in glass and metal packaging solutions, producing packaging for the world’s leading food, beverage, and consumer care brands. Ardagh Group has a truly global presence. We operate more than 100 glass and metal manufacturing facilities in more than 20 countries across 5 continents, employing more than 23,000 people and have global sales of approximately €8.6bn.

We believe that the success of our business depends on the success of our people. We strive to create working environments where our employees feel valued, can work to their full potential, and where their achievements are celebrated. We are creating an exciting future for Ardagh that is built on our core values of trust, teamwork and excellence and we have opportunities in a wide variety of disciplines across our organisation.

 


 

MES Database Analyst

 

Role Description

The Data Base Analyst’s role is to design, install, administer, and optimize company data base servers Instances and related components to achieve high performance of the various business applications supported by tuning the data base (SQL Packages, SQL Functions, SQL Triggers as necessary. This includes ensuring the availability of Microsoft Data Bases, configuring all new implementations, and developing processes and procedures for ongoing management of the Data Base (instances) / Server environment.

 

Key Responsibilities

  • Deploy and maintain pro-actively the introduced solution for managing data and application servers across the infrastructure estate.
  • Backups, disk and database capacity management, server and database instance configurations, event and server logs analysis
  • Proactive and reactive administration and maintenance of the group SQL server Infrastructure

Application of patches, backups and verification and backup restores, high availability solutions – Failover clustering, log shipping, replication, failover availability groups. Agent job failures, events and logs, CPU, RAM and Disk IO issues

  • Consolidation and migration of server and database instances across an array of environments within the estate to reduce licensing and administrative overhead

and reduce business risk by maintaining supportability

  • Deploy and configure new server and database instances or consolidate unto an existing standalone or highly available environment.
  • Architecting, deployment and support of standalone and highly available data and application solutions across an array of critical business environments.
  • Risk and performance assessment of data and application solutions, including performance analysis, design architecture, server configurations and DR strategies
  • Remediation and performance optimization of data and applications servers - performance tuning, query, index, CPU, RAM, and disk subsystem IO optimisation

 

 

Requirements

  • Microsoft SQL Server administration
  • Microsoft Visual Studio 2017 (or newer) and how to work with Team Foundation Server
  • Measure Performance of Software (i.e. using Redgate SQL tools, MS Visual Studio)
  • ITSM Helpdesk
  • SharePoint Wikipedia system
  • Microsoft Office applications

Kanban and Scrum (i.e. use of Target Process)

  • At least five years’ equivalent work experience in a data base administration position responsible for managing Database environments.
  • Professional development skills in MS SQL (Packages, Functions, Triggers)
  • Experience with MS Data Base performance tuning and monitoring tools.
  • Proven knowledge of systems development life cycle methodologies

 

What we offer

Competitive Salary

Ardagh DC Pension Scheme

 

Our Vision and Values
The people that make up Ardagh Group share much more than a strong brand and an excellent reputation. We each share a common vision: to be the preferred packaging partner to the world’s leading brands. We will achieve our vision by delivering customer innovation, providing an inspirational environment for our people and creating sustainable value for our business through its growth and development.

For more information on Ardagh Group, visit www.ardaghgroup.com.