Database Engineer (SQL / MySQL)
Role details
Job location
Tech stack
Job description
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.
What you'll be doing
Infrastructure:
- 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.
Requirements
Do you have experience in Shell Scripting?, Essential skills:
- 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.
Benefits & conditions
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.
