Database Engineer (SQL / MySQL)

Giacom; Hessle; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Flexible working

Learning and development opportunities

25 days annual leave plus bank holidays

Pension plan

Complimentary refreshments

Job summary

A tech provider based in the UK is seeking a Database Administrator to manage and administer their database server environments. This role involves handling MySQL and SQL Server installations, resolving technical issues, and contributing to continuous improvements of database architecture. Ideal candidates should have at least 3 years of DBA experience along with proficiency in MySQL and SQL Server. Flexible working options and a supportive work environment are offered as part of the job benefits.

Qualifications

• At least 3 years in a DBA role.
• Experience with SQL standards and best practices.
• Need to maintain up-to-date documentation.

Responsibilities

• Manage and administer database server environments.
• Installation and configuration of MySQL and SQL Server.
• Provide 2nd and 3rd line support for IT tickets.
• Backup and recovery of SQL database servers.
• Make recommendations for database stability improvements.

Skills

Strong proficiency in MySQL 5.7/MySQL 8+ and SQL Server 2016+

Linux and shell scripting competence

Experience with HA technologies

Proficient in writing and optimising SQL statements

Understanding of MySQL’s underlying storage engines

Job description

Giacom is the only provider of Comms, Cloud, Hardware and Billing through one platform. Our platform connects technology resellers and service providers to the best IT, Comms and Cloud products and services so they can create brilliant technology solutions for UK businesses.

Overview

The Database Administrator will manage and administer Giacom’s database server environments. You will be responsible for day-to-day operations and environment monitoring, as well as remediation of legacy SQL database environments to ensure they remain on a supported version. You will troubleshoot and resolve database-related issues and propose continuous improvements to the database architecture. The infrastructure team is an integral part of the IT Services department, responsible for the infrastructure that underpins our services, systems and platforms for both internal and customer use. It is a multi-disciplined team that works closely with the other IT Services teams and departments across the wider business.

Responsibilities

• Installation and configuration of MySQL and SQL Server.
• Providing technical support for escalated issues and tickets.
• Work with development teams to translate requirements into technical specifications; help to identify optimal database design, access strategies, and data integrity constraints.
• Proactively make recommendations and resolve technical system issues to improve database stability and performance.
• Maintain process and standards documentation.
• Backup and recovery of SQL database servers.
• To provide 2nd and 3rd line support for infrastructure-related tickets raised with the IT support desk.
• To work closely with the Support Team to ensure efficient, collaborative working in both project work and business-as-usual (BAU) activities.
• To provide scheduled out-of-hours support (paid) infrequently.
• Continually look for ways to improve the systems and services the department provides.
• Work with vendor support to maintain positive relationships with key suppliers and ensure that infrastructure procurement is managed correctly.
• Work with the knowledge base and communications to ensure work instructions and processes are documented clearly and that all activities that may impact end users are communicated effectively.

Essential Skills, Qualifications, and Experience

• Strong proficiency in MySQL 5.7/MySQL 8+ and SQL Server 2016+ database management, ideally gained from at least 3 years in a DBA role.
• Linux and shell scripting competence.
• Experience with HA technologies such as SQL Server Always On Availability Groups (AG), MySQL replication, ProxySQL and Percona XtraDB Cluster.
• Proficient in writing and optimising SQL statements.
• Understanding of MySQL’s underlying storage engines.
• Knowledge of de facto standards and best practices in MySQL and SQL Server.
• Understand the need to maintain up-to-date documentation.

Desirable Skills

• Experience with PostgreSQL.
• Experience with physical and virtual infrastructure.
• Understanding of other SQL technologies.
• Familiarity with Cloud platforms, specifically AWS and Azure.
• Familiarity with AI tools to help support database management activities.

What afford

• Some flexible working.
• Investment in your future career with a variety of learning and development opportunities.
• No dress code - embrace the freedom to bring your whole self to work.
• 25 days annual leave, plus bank holidays. You\'ll even get your birthday off, too!
• A pension plan for your future.
• Complimentary refreshments in all our offices.
• For a comprehensive list of all our benefits, click here.

Diversity and equality lie at the heart of our values. As an equal opportunities and disability-confident employer, we encourage applications from all eligible candidates, regardless of their backgrounds. We firmly believe that diversity enriches and strengthens our team with a variety of perspectives that drives innovation.