Database Developer jobs in Canada

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.