SQL Developer – AI Prompting & Context Engineering

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. Key Responsibilities AI-Assisted Development & Agent Orchestration (c. 60%) 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. SQL Server & Data Migration (c. 40%) 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. The Ideal Candidate 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. Essential Skills 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. Desirable 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.