Job Description
Job Title: Database Developer
Location: Guildford (onsite)
Salary: £50,000 - £60,000 DOE (Great benefits)
Job Summary:
The Database Developer will play a critical role in designing, developing, and maintaining robust, scalable, and secure databases that support business operations and legal systems. The ideal candidate will have a strong background in database modelling, administration, performance tuning, and experience working with both cloud (Azure) and on-premises databases.
Key Responsibilities:
* Design, model, and implement efficient database structures to support new and existing applications.
* Develop, optimize, and maintain complex SQL queries, stored procedures, functions, and triggers.
* Administer, monitor, and troubleshoot databases to ensure optimal performance, reliability, and security.
* Implement and manage data replication, backups, and disaster recovery solutions.
* Work closely with software developers, data engineers, and business stakeholders to understand data requirements and translate them into effective database solutions.
* Optimize database performance through indexing, query tuning, and resource management.
* Manage database security, user permissions, and compliance with legal and regulatory requirements.
* Support both on-premises SQL Server environments and Azure SQL databases.
* Contribute to the development and implementation of data governance and best practices.
Essential Skills & Experience:
* Proven experience as a Database Developer, Database Administrator, or similar role.
* Strong expertise in database design, data modelling (both relational and dimensional), and normalization techniques.
* Extensive experience with Microsoft SQL Server (on-prem) and Azure SQL databases.
* Proficiency in T-SQL, including complex queries, stored procedures, functions, views, and triggers.
* Experience with performance tuning and query optimization techniques.
* Strong knowledge of database administration, including backup/restore strategies, high availability, disaster recovery, and replication.
* Familiarity with security best practices, encryption, and compliance requirements in data management.
* Experience with database monitoring tools and performance diagnostics.
* Hands-on experience with Azure data services, such as Azure SQL Database, Azure Data Factory, and Azure Storage.
* Strong understanding of SDLC, version control (e.g., Git), and DevOps practices related to database development.
Desirable Skills:
* Experience working with legal systems and understanding the data requirements within the legal industry.
* Knowledge of data warehousing concepts and ETL processes.
* Experience with automation and scripting (e.g., PowerShell) for database management tasks.
Qualifications:
* Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
* Relevant Microsoft certifications, such as:
* Microsoft Certified: Azure Database Administrator Associate
* Microsoft Certified: Azure Data Engineer Associate
* Microsoft Certified: SQL Server Database Development/Administration
Personal Attributes:
* Strong problem-solving and analytical skills.
* Excellent attention to detail with a focus on data accuracy and security.
* Strong communication skills, with the ability to explain technical concepts to non-technical stakeholders.
* Ability to work independently and as part of a collaborative team in a fast-paced environment.
Benefits:
* Early joiner of a fast-growing tech team with big ambitions and exciting projects
* On-site gym with personal trainer
* Bistro serving both breakfast and lunch by a chef
* A company that places a lot of value on its culture and people.