SQL Developer

Who you are

• You’ll combine hands-on AI-assisted development skills with substantial SQL Server experience. You’ll be curious and adaptable, communicate clearly, and use good judgement to assess AI-generated output rather than accepting it uncritically
• Demonstrable experience using AI coding tools and writing effective prompts, with practical examples of workflows or agents you have built
• Substantial SQL programming experience and strong knowledge of the techniques and capabilities of Microsoft SQL Server 2017 or later
• A strong grounding in data modelling, data management and data manipulation, alongside Git, version control and attention to detail
• The ability to investigate problems independently, collaborate with colleagues and communicate clearly in writing and in person
• Practical experience with AI coding assistants and strong prompting skills, supported by examples
• Strong SQL Server T-SQL development and performance tuning, including experience supporting SQL Server in a large-scale environment
• Experience with Git and version control
• Excellent teamwork, communication and documentation skills
• Experience building agents or multi-agent workflows using Claude Code, MCP or similar frameworks
• Familiarity with LLM APIs, evaluation approaches and prompt testing
• Scripting or programming experience in Python or a similar language
• Awareness of AI data protection and security considerations
• A reasonable understanding of operating systems, infrastructure and networking

What the job involves

• This is a dual role, split between approximately 60% AI-assisted development and agent orchestration, and 40% SQL Server development supporting large-scale data migration. You’ll work within the development team and report to the Software Manager, combining practical AI skills with strong SQL expertise to deliver reliable, efficient solutions
• Use AI coding assistants, such as Claude Code or GitHub Copilot, across the development lifecycle, including code generation, refactoring, testing, documentation and review
• Build and maintain effective prompts, system instructions, reusable skills and context to produce consistent, reliable AI outputs
• Design and orchestrate agents and multi-agent workflows, including task decomposition, tool use, agent hand-offs and human-in-the-loop checkpoints
• Connect agents to internal systems, databases and APIs, for example through MCP or function calling
• Evaluate AI output for accuracy, regression, cost and latency, and refine workflows based on results
• Apply appropriate safeguards for data privacy, security and hallucination risk, particularly when customer or school data is involved
• Identify and prototype opportunities to apply AI to development and data migration, and share best practice by supporting and coaching colleagues
• Design, develop and maintain scalable SQL Server T-SQL solutions and related tools for data cleansing, migration and reconciliation
• Provide database performance-tuning expertise for internal and third-party systems, using AI tooling where appropriate
• Define technical requirements with non-technical colleagues in the Data Migration Team, and work with third parties to understand their software and support migration projects
• Manage SQL Server database environments used for data migration, including backup and recovery in test environments
• Prepare and expose data safely for agents and AI workflows, using AI to support SQL query generation, code review and optimisation
• Plan and prioritise work independently, managing tasks against project timelines and requirements

Benefits

• Competitive salary package with uncapped commission
• Pension contribution
• 24 days annual leave (plus Bank Holidays), increasing to 28 after 5 years service
• Birthday off (fully paid)
• Employee Assistance Programme and Wellbeing service
• Hybrid / Remote working (depending on location)
• Training and Development
• Social Events - Bromcom has a number of social events throughout the year to help us keep connected, from our Summer BBQ, to our Christmas meal to name but a few!