Database Engineer (SQL / MySQL)

Giacom; Hessle; On-site; GBP 45,000 - 62,000; Full time

Benefits offered by this job

Flexible working

Learning & development

Casual dress

Birthday off

Pension plan

Office refreshments

Job summary

Giacom is seeking an experienced Database Administrator to manage and administer our database server environments. You will oversee day-to-day operations, monitor environments, and remediate legacy SQL databases to stay on a supported version.

You will collaborate with the Infrastructure team and development groups to translate requirements, improve database stability, performance, and data integrity, while maintaining documentation and best practices.

Qualifications

• Proven database administration experience, 3+ years in a DBA role.
• Strong proficiency with MySQL and SQL Server databases.
• Linux and shell scripting competence.

Responsibilities

• Install and configure MySQL and SQL Server instances.
• Provide 2nd/3rd line support for infrastructure tickets.
• Collaborate with development teams on database design and performance.
• Document processes and maintain up-to-date runbooks.
• Backup and recovery planning and execution.

Skills

MySQL 5.7/8+

SQL Server 2016+

Linux

Shell scripting

HA solutions

SQL optimization

Storage engines

Documentation

Tools

PostgreSQL

AWS

Azure

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.

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.

Infrastructure

What you'll be doing

• 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.

Support

• 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.

Development

• 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

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's in it for you?

• 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.

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.