SQL Developer – AI Prompting & Context Engineering

Job description

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 ra…