Database Analyst - SQL

Employer
Brewster Partners
Location
Goole, UK
Salary
Competitive
Closing date
8 Nov 2020

View more

Sector
Technology & New Media
Contract Type
Permanent
You need to sign in or create an account to save a job.
THE COMPANY:

Brewster Partners are working with a large successful business in the Goole area who want to add to their team with a Database Analyst with expertise in mySQL.

THE JOB:

The job involves joining a growing support team in order to provide administration, support and strategic guidance on the company's MySQL databases for an enterprise grade, online e-commerce platform.

Duties will include:

Working on both project and operational tasks to support the business
Building internal and external relationships
Understanding complex requirements, communicating effectively at all times
Reviewing and suggesting DDL for new features in line with SQL coding standards and best database performance for the development team
Optimising any slow and inefficient queries which are identified and suggesting improvements to the development team
Ensuring service availability through 24/7 on-call
Advising development teams on possible implementations for new features at the planning stage
Configuring database credentials in dev, staging and production platforms for applications and providing database credentials

THE PERSON:

Oracle Certified Professional (MySQL 5.7 Database Administrator) or equivalent
Ability to optimise and suggest alternatives to MySQL queries (data, table and index assessment, explain plan, knowledge of covering indexes, hash indexes, derived tables, factors affecting temporary table requirements, query hints, index hints)
Ability to manage own workloads and priorities well
Ability to engage with a variety of stakeholders, maintaining a professional "can do" approach at all timesDesirable Competencies/skills and experiences for the role:

Maintenance of supporting in-house scripts and data feeds for database monitoring and binary log housekeeping purposes
Experience of working with Business Intelligence Platforms such as PowerBI and Business Objects
Experience of supporting Financial Reporting and Reconciliation activity
Experience of working in an Ecommerce environment
Good understanding of GDPR and other data protection regulations THE BENEFITS:

20 days holiday + 8 bank holidays, rising with service
Secure free on site parking
Pension scheme
On site gym facilities
Staff discount schemeBrewster Partners Office Support & Technical Recruitment is a division of the Brewster Partners Recruitment Group focusing on the recruitment of talent in administration, business support, HR, sales, marketing and purchasing in South Yorkshire, West Yorkshire, East Yorkshire, North Yorkshire, Lincolnshire, Nottinghamshire and the Midlands. If you are interested in discussing this job in more detail or any other aspect of office support and technical recruitment we would really like to hear from you. Please visit our website at for more information
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert